基于javaswing的ktv歌曲管理系统

import javax.swing.*; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class Add extends JFrame { public Add() { this.setTitle("录入歌曲信息界面");//设置窗口标题 this.setBounds(100, 100, 500, 750);//设置窗口大小 this.setDefaultCloseOperation(DISPOSE_ON_CLOSE);//设置关闭子窗口但是不关闭父类窗口 this.setLayout(null);//设置布局方式为null，自己控制组件位置 //创建标签和按钮 JLabel jLabel = new JLabel("录入歌曲信息界面"); JLabel jLabel1 = new JLabel("歌曲编号："); JLabel jLabel2 = new JLabel("歌曲名称："); JLabel jLabel3 = new JLabel("歌曲歌手："); JLabel jLabel4 = new JLabel("歌曲时长："); JLabel jLabel5 = new JLabel("专辑名称："); JLabel jLabel6 = new JLabel("歌曲年份："); JLabel jLabel7 = new JLabel("歌曲评价："); JButton jb1 = new JButton("录入"); //创建文本框和面板 JTextField field1 = new JTextField(18); JTextField field2 = new JTextField(18); JTextField field3 = new JTextField(18); JTextField field4 = new JTextField(18); JTextField field5 = new JTextField(18); JTextField field6 = new JTextField(18); JTextField field7 = new JTextField(18); //创建面板 JPanel jPanel = new JPanel(); JPanel jPanel0 = new JPanel(); JPanel jPanel1 = new JPanel(); JPanel jPanel2 = new JPanel(); JPanel jPanel3 = new JPanel(); JPanel jPanel4 = new JPanel(); JPanel jPanel5 = new JPanel(); JPanel jPanel6 = new JPanel(); JPanel jPanel7 = new JPanel(); //将标签和文本框添加到面板中 jPanel.add(jLabel); jPanel1.add(jLabel1); jPanel1.add(field1); jPanel2.add(jLabel2); jPanel2.add(field2); jPanel3.add(jLabel3); jPanel3.add(field3); jPanel4.add(jLabel4); jPanel4.add(field4); jPanel5.add(jLabel5); jPanel5.add(field5); jPanel6.add(jLabel6); jPanel6.add(field6); jPanel7.add(jLabel7); jPanel7.add(field7); jPanel0.add(jb1); //设置面板位置和大小 jPanel.setBounds(0, 40, 450, 50); jPanel1.setBounds(0, 110, 450, 50); jPanel2.setBounds(0, 180, 450, 50); jPanel3.setBounds(0, 250, 450, 50); jPanel4.setBounds(0, 320, 450, 50); jPanel5.setBounds(0, 390, 450, 50); jPanel6.setBounds(0, 460, 450, 50); jPanel7.setBounds(0, 530, 450, 50); jPanel0.setBounds(0, 600, 450, 50); //设置字体大小 jLabel.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jLabel1.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jLabel2.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jLabel3.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jLabel4.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jLabel5.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jLabel6.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jLabel7.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jb1.setFont(new Font("微软雅黑", Font.PLAIN, 20)); //将面板添加到窗口中 this.add(jPanel); this.add(jPanel1); this.add(jPanel2); this.add(jPanel3); this.add(jPanel4); this.add(jPanel5); this.add(jPanel6); this.add(jPanel7); this.add(jPanel0); //设置界面可见 this.setVisible(true); UIManager.put("OptionPane.messageFont", new Font("微软雅黑", Font.PLAIN, 15)); jb1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { if (field1.getText().isEmpty()) { JOptionPane.showMessageDialog(null, "编号不能为空！"); return; } // 检查歌曲编号是否已存在 Connection con = null; PreparedStatement checkStmt = null; ResultSet rs = null; try { con = JDBCUtils.getConnection(); String checkSql = "SELECT * FROM song WHERE id = ?"; checkStmt = con.prepareStatement(checkSql); checkStmt.setString(1, field1.getText()); rs = checkStmt.executeQuery(); if (rs.next()) { // 如果查询结果有数据，说明id已存在 JOptionPane.showMessageDialog(null, "编号已存在，请输入唯一的编号！"); return; } else { // 歌曲编号不存在，执行插入操作 String insertSql = "INSERT INTO song VALUES(?,?,?,?,?,?,?)"; PreparedStatement stmt = con.prepareStatement(insertSql); stmt.setString(1, field1.getText()); stmt.setString(2, field2.getText()); stmt.setString(3, field3.getText()); stmt.setString(4, field4.getText()); stmt.setString(5, field5.getText()); stmt.setString(6, field6.getText()); stmt.setString(7, field7.getText()); stmt.execute(); JOptionPane.showMessageDialog(null, "录入成功！"); } } catch (Exception e2) { e2.printStackTrace(); JOptionPane.showMessageDialog(null, "录入失败：" + e2.getMessage()); } finally { try { JDBCUtils.close(rs, checkStmt, con); // 注意这里关闭的是检查id的资源 } catch (SQLException throwables) { throwables.printStackTrace(); } } } }); } }