实验室设备管理系统【GUI/Swing+MySQL】（Java课设）.zip

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 AdminMain extends JFrame { public AdminMain() { this.setTitle("欢迎使用本系统"); this.setBounds(200, 200, 400, 600); this.setDefaultCloseOperation(DISPOSE_ON_CLOSE); this.setVisible(true); JLabel jLabel = new JLabel("欢迎来到实验设备管理系统界面 \n"); this.add(jLabel); FlowLayout layout = new FlowLayout(); this.setLayout(layout); JPanel jPanel = 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 jPanel8 = new JPanel(); JPanel jPanel9 = new JPanel(); JButton jb1 = new JButton("录入实验设备信息"); JButton jb2 = new JButton("删除实验设备信息"); JButton jb3 = new JButton("修改实验设备信息"); JButton jb4 = new JButton("按领用人查询信息"); JButton jb5 = new JButton("按设备状态查询信息"); JButton jb6 = new JButton("按报废状态查询信息"); JButton jb7 = new JButton("批量处理报废设备"); JButton jb8 = new JButton("查询所有实验设备信息"); jPanel.add(jLabel); jPanel2.add(jb1); jPanel3.add(jb2); jPanel4.add(jb3); jPanel5.add(jb4); jPanel6.add(jb5); jPanel7.add(jb6); jPanel8.add(jb7); jPanel9.add(jb8); jLabel.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jb1.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jb2.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jb3.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jb4.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jb5.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jb6.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jb7.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jb8.setFont(new Font("微软雅黑", Font.PLAIN, 20)); jPanel.setBounds(0, 40, 150, 50); jPanel2.setBounds(0, 110, 150, 50); jPanel3.setBounds(0, 180, 150, 50); jPanel4.setBounds(0, 250, 150, 50); jPanel5.setBounds(0, 320, 150, 50); jPanel6.setBounds(0, 390, 150, 50); jPanel7.setBounds(0, 460, 150, 50); jPanel8.setBounds(0, 530, 150, 50); jPanel9.setBounds(0, 600, 150, 50); this.add(jPanel); this.add(jPanel2); this.add(jPanel3); this.add(jPanel4); this.add(jPanel5); this.add(jPanel6); this.add(jPanel7); this.add(jPanel8); this.add(jPanel9); jb1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { new Add(); } }); jb2.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { new Delete(); } }); jb3.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { new Update(); } }); jb4.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { new SelectByName(); } }); jb5.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { new SelectBySBZT(); } }); jb6.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { new SelectByBFZT(); } }); jb7.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { Connection con = null; PreparedStatement stmt = null; ResultSet rs = null; try { con = JDBCUtils.getConnection(); String sql = "delete from sysb where bf='是'"; stmt = con.prepareStatement(sql); stmt.execute(); JOptionPane.showMessageDialog(null, "报废设备处理成功！"); } catch (Exception e2) { // TODO Auto-generated catch block e2.printStackTrace(); }finally { try { JDBCUtils.close(rs, stmt, con); } catch (SQLException throwables) { throwables.printStackTrace(); } } } }); jb8.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { new SelectAll(); } }); } }