实验室设备管理系统实验

实验项目：实验室设备管理系统一、项目管理：二、软件需求分析1 软件系统需求描述：实验室设备管理系统是利用Eclipse 作为开发工具、sqlsetver 作为数据库的系统。

要求实现如下功能：⑴所有工作由专门人员负责完成，其他人不得任意使用； ⑵对于已彻底损坏的作报废处理，同时详细记录有关信息；⑶对于有严重问题（故障）的要即使修理，并记录修理日期、设备名、修理厂家、修理费、责任人等；⑷对于急需但又缺少的设备需以“申请表”的形式送交上级领导请求批准购买。

新设备购入后要立即进行设备登记（包括类别、设备名、型号、规格、单价、数量、购置日期、生产厂家、购买人等），同时更新申请表的内容；⑸随时对现有设备及其修理、报废情况进行统计、查询，要求能够按类别和时间段（某日期之前）查询。

本管理系统通过计算机对实验设备进行自动管理，设备管理员可以直接在计算机实现实验设备的信息管理，并在一定程度上实现自动化，改善了工作运行效率和效果。

2 软件系统数据流图1) 顶层数据流图设备管理员上级领导实验室设备管理系统2) 0层数据流图处理要求2登陆信息处理结果身份验证1审核3无效登陆信息审核结果3)一层数据流图信息表表申请表新设备表表4)总数据流图登陆表设备基本信息表3软件系统数据字典：1、数据流条目①登陆信息输入：设备管理员输出：身份验证1描述：登陆信息=用户名+密码+登陆权限②查询信息输入：合法人员对设备的查询操作输出：设备信息表描述：查询信息=设备名/型号/类别/购置日期③维修信息输入：所需维修设备的信息输出：确定维修设备的记录描述：维修信息=设备名+修理日期+修理厂家+修理费+负责人④新设备输入：购买设备的信息输出：确定购买的新设备的记录描述：新设备=类别+设备名+型号+规格+单价+数量等⑤报废设备输入：所需报废的设备的信息输出：报废的设备记录描述：报废设备=类别+设备名+型号等⑥审核信息输入：审核3输出：上级领导描述：审核信息=报废设备信息/新设备购买记录2、加工条目身份验证1，统计查询2.1，维修2.2，购买2.3，报废2.4，生产报表3.1，审核3.23、文件条目①登陆表输入：身份验证1输出：身份验证1数据结构：用户名+密码+登陆权限②设备基本信息表输入：统计查询2.1数据结构：类别+设备名+型号+规格等③维修记录表输入：统计查询2.1，维修2.2输出：统计查询2.1数据结构：设备名+修理日期+修理厂家+修理费+责任人等④新设备表输入：统计查询2.1，购买2.2输出：统计查询2.1数据结构：类别+设备名+型号+规格+单价+数量+生产厂家+购买人等⑤报废记录表输入：报废2.4，统计查询2.1，生产报表3.1输出：统计查询2.1，生产报表3.1数据结构：类别+设备名+型号等⑥申请表输入：统计查询2.1，生产报表3.1输出：统计查询2.1，生产报表3.1，购买2.3数据结构：设备名+型号+规格+数量+负责人三：软件设计1实验室设备管理系统模块结构图2界面设计3实验室设备管理系统数据设计设备管理员用户名密码登陆权限管理设备设备名设备号类型审核上级领导用户名密码4管理系统其中的3个模块的详细设计①上级领导操作模块②设备管理员操作模块③统功能操作模块5数据库设计①登陆表②设备基本信息表③维修记录表设备型号varchar 10 not null设备名varchar 20 not null维修日期datetime 8 null维修厂家varchar 30 null维修费用float 8 null责任人varchar 10 null④报废记录表列名数据类型长度允许空设备型号varchar 10 not null设备名varchar 20 not null报废日期datetime 8 null责任人varchar 10 null列名数据类型长度允许空设备名varchar 10 not null日期Datatime 8 not null规格varchar 10 not null数量int 4 null申请人Varchar 10 Null四、编码与单元测试1、各模块示意图2、用户登录界面：package shebeiguanli;import java.applet.*;import java.sql.*;import java.awt.*;import java.awt.event.*;import javax.swing.*;import yout.*;/***<p>Title:实验室设备管理系统登录界面</p>*@author gengdexin*@version 1.0*/public class Log extends JFrame {/** 构建显示对象*/JPanel contentPane;XYLayout xYLayout1 = new XYLayout();JPasswordField password = new JPasswordField(); JLabel jLabel1 = new JLabel();JLabel jLabel2 = new JLabel();JLabel jLabel4 = new JLabel();JTextField jTextField1 = new JTextField();JLabel jLabel3 = new JLabel();JLabel jLabel5 = new JLabel();JLabel jLabel6 = new JLabel();public Log() {enableEvents(AWTEvent.WINDOW_EVENT_MASK);try {jbInit();}catch(Exception e) {e.printStackTrace();}}private void jbInit() throws Exception {contentPane = (JPanel) this.getContentPane();password.addActionListener(new Log_password_actionAdapter(this));contentPane.setLayout(xYLayout1);this.setSize(new Dimension(500, 400));this.setTitle("实验室设备管理系统");jLabel1.setFont(new java.awt.Font("SansSerif", 0, 25));jLabel1.setForeground(Color.red);jLabel1.setText("欢迎进入实验室设备管理系统");jLabel2.setFont(new java.awt.Font("SansSerif", 0, 20));jLabel2.setText("姓名");jTextField1.setText("");jLabel3.setFont(new java.awt.Font("SansSerif", 0, 20));jLabel3.setText("密码");jLabel4.setFont(new java.awt.Font("SansSerif", 0, 20));jLabel4.setText("开发人员：耿德新蔺明亮毛冬冬");jLabel5.setFont(new java.awt.Font("SansSerif", 0, 20));jLabel5.setText("李章华吕文强顾海驹");jLabel6.setFont(new java.awt.Font("SansSerif", 0, 15));jLabel6.setForeground(Color.red);jLabel6.setText("交流：gengdxin@");contentPane.add(jLabel1, new XYConstraints(80, 10, 350, 34));contentPane.add(jLabel2, new XYConstraints(92, 142, -1, -1));contentPane.add(jTextField1, new XYConstraints(130, 145, 91, 26));contentPane.add(jLabel3, new XYConstraints(222, 144, -1, -1));contentPane.add(password, new XYConstraints(263, 144, 105, 28));contentPane.add(jLabel4, new XYConstraints(50, 250, -1, -1));contentPane.add(jLabel5, new XYConstraints(150, 280, -1, -1));contentPane.add(jLabel6, new XYConstraints(100, 340, -1, -1));}protected void processWindowEvent(WindowEvent e) {super.processWindowEvent(e);if (e.getID() == WindowEvent.WINDOW_CLOSING) {System.exit(0);}}void password_actionPerformed(ActionEvent e) {try {Frame1 Frame= new Frame1();Frame.show();validID();}catch (Exception ew) {System.out.println(ew.getMessage());}this.setVisible(false);}//连接sqlvoid validID() {try {String str1, str2;str1 = jTextField1.getText();str2 = password.getText();Connection con = null;String url = "jdbc:odbc:shebeiguanli";String user = "";String password = "";Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");con = DriverManager.getConnection(url,user,password);Statement stmt =con.createStatement();//执行动态的sql语句PreparedStatement pstmt = con.prepareStatement(//依据读者的名字查询读者的信息的sql语句"use shebeiguanli select * from 登录 where username=?");//将读者的名字添加到具体的sql语句中pstmt.setString(1, str1);//使用ResultSet中的方法executeQuery()来完成sql语句的执行 ResultSet res = pstmt.executeQuery();//使用getString()来获取sql查询的结果if ((!res.next()) || res.getString("password") == null) { JOptionPane.showMessageDialog(this, "查无此人", "错误",JOptionPane.ERROR_MESSAGE);}else {// if ( !res.getString(2).equals(str2)) {if ( !res.getString(2).equals(str2)) {JOptionPane.showMessageDialog(this, "密码错误", "错误", JOptionPane.ERROR_MESSAGE);}else {System.out.println("正确");do{System.out.println(res.getString(1)+":" + res.getString(2));}while (res.next());loader();}}pstmt.close();con.close();}catch (ClassNotFoundException e) {System.out.println(e.getMessage());}catch (SQLException edd) {edd.printStackTrace() ;System.out.println(edd.getMessage());}}void loader() {try {Frame9 Frame= new Frame9();Frame.show();}catch (Exception ew) {System.out.println(ew.getMessage());}}}class Log_password_actionAdapter implementsjava.awt.event.ActionListener {Log adaptee;Log_password_actionAdapter(Log adaptee) {this.adaptee = adaptee;}public void actionPerformed(ActionEvent e) {adaptee.password_actionPerformed(e);}}3、主界面：package shebeiguanli;import java.awt.*;import java.awt.event.*;import javax.swing.*;import yout.*;//系统主界面public class Frame9 extends JFrame {JPanel contentPane;JMenuBar jMenuBar1 = new JMenuBar();JMenu 设备查询 = new JMenu();JMenuItem 设备信息 = new JMenuItem();JMenu 设备申请 = new JMenu();JMenuItem 申请登记 = new JMenuItem();XYLayout xYLayout1 = new XYLayout();JLabel jLabel1 = new JLabel();JMenu jMenu2 = new JMenu();JMenuItem jMenuItem7 = new JMenuItem(); JMenu jMenu3 = new JMenu();JMenuItem jMenuItem8 = new JMenuItem();JMenuItem jMenuItem1 = new JMenuItem();JMenuItem jMenuItem3 = new JMenuItem();JLabel jLabel2 = new JLabel();JLabel jLabel3 = new JLabel();JLabel jLabel4 = new JLabel();JMenu jMenu5 = new JMenu();JMenuItem jMenuItem2 = new JMenuItem();public Frame9() {enableEvents(AWTEvent.WINDOW_EVENT_MASK);try {jbInit();}catch(Exception e) {e.printStackTrace();}}private void jbInit() throws Exception {contentPane = (JPanel) this.getContentPane();contentPane.setLayout(xYLayout1);this.setSize(new Dimension(600, 500));this.setTitle("实验室管理系统");设备查询.setFont(new java.awt.Font("SansSerif", 0, 20));设备查询.setText("设备查询");设备信息.setFont(new java.awt.Font("SansSerif", 0, 20));设备信息.setText("设备信息查询");设备信息.addActionListener(new Frame9_设备信息_ActionAdapter(this));设备申请.setFont(new java.awt.Font("SansSerif", 0, 20));设备申请.setText("设备申请");设备申请.addActionListener(new Frame9_设备申请_actionAdapter(this));申请登记.setFont(new java.awt.Font("SansSerif", 0, 20));申请登记.setText("申请登记");申请登记.addActionListener(new Frame9_申请登记_ActionAdapter(this));jLabel1.setFont(new java.awt.Font("SansSerif", 0, 40));jLabel1.setForeground(new Color(210, 0, 0));jLabel1.setHorizontalAlignment(SwingConstants.LEADING);jLabel1.setText("实验室管理系统");contentPane.setFont(new java.awt.Font("Dialog", 0, 11));contentPane.setForeground(Color.darkGray);jMenu2.setFont(new java.awt.Font("SansSerif", 0, 20));jMenu2.setFocusPainted(false);jMenu2.setText("维修记录");jMenuItem7.setFont(new java.awt.Font("SansSerif", 0, 20));jMenuItem7.setText("维修记录登记");jMenuItem7.addActionListener(newFrame9_jMenuItem7_actionAdapter(this));jMenu3.setFont(new java.awt.Font("SansSerif", 0, 20));jMenu3.setText("报废记录");jMenuItem8.setFont(new java.awt.Font("SansSerif", 0, 20));jMenuItem8.setText("设备报废登记");jMenuItem8.addActionListener(newFrame9_jMenuItem8_actionAdapter(this));设备查询.addSeparator();jMenuItem1.setFont(new java.awt.Font("SansSerif", 0, 20));jMenuItem1.setText("维修记录查询");jMenuItem1.addActionListener(newFrame9_jMenuItem1_actionAdapter(this));jMenuItem3.setFont(new java.awt.Font("SansSerif", 0, 20));jMenuItem3.setText("设备报废查询");jMenuItem3.addActionListener(newFrame9_jMenuItem3_actionAdapter(this));jLabel2.setFont(new java.awt.Font("SansSerif", 0, 40));jLabel2.setForeground(Color.red);jLabel2.setText("欢迎进入");jLabel3.setFont(new java.awt.Font("SansSerif", 0, 40));jLabel3.setForeground(Color.red);jLabel3.setText("实验室设备管理系统");jLabel4.setFont(new java.awt.Font("SansSerif", 0, 15));jLabel4.setForeground(Color.red);jLabel4.setText("交流：gengdxin@");jMenu5.setFont(new java.awt.Font("SansSerif", 0, 20));jMenu5.setText("退出系统");jMenuItem2.setFont(new java.awt.Font("SansSerif", 0, 20));jMenuItem2.setText("退出");jMenuItem2.addActionListener(newFrame9_jMenuItem2_actionAdapter(this));jMenuItem2.addItemListener(newFrame9_jMenuItem2_itemAdapter(this));设备查询.add(设备信息);设备查询.addSeparator();设备申请.addSeparator();设备申请.add(申请登记);设备申请.addSeparator();jMenuBar1.add(设备查询);jMenuBar1.add(设备申请);jMenuBar1.add(jMenu2);jMenuBar1.add(jMenu3);jMenuBar1.add(jMenu5);jMenu2.addSeparator();jMenu2.add(jMenuItem7);jMenu2.addSeparator();jMenu2.add(jMenuItem1);jMenu2.addSeparator();jMenu3.addSeparator();jMenu3.add(jMenuItem8);jMenu3.addSeparator();jMenu3.add(jMenuItem3);jMenu3.addSeparator();contentPane.add(jLabel1, new XYConstraints(175, 1, -1, -1));contentPane.add(jLabel3, new XYConstraints(150, 200, -1, -1));contentPane.add(jLabel2, new XYConstraints(50, 100, 163, 45));contentPane.add(jLabel4, new XYConstraints(180, 350, -1,-1));jMenu5.addSeparator();jMenu5.add(jMenuItem2);jMenu5.addSeparator();this.setJMenuBar(jMenuBar1);}public void设备信息_actionPerformed(ActionEvent e) {try {Frame2 Frame= new Frame2();Frame.show();}catch (Exception ew) {System.out.println(ew.getMessage());}}public void申请登记_actionPerformed(ActionEvent e) {try {Frame7 Frame= new Frame7();Frame.show();}catch (Exception ew) {System.out.println(ew.getMessage());}}protected void processWindowEvent(WindowEvent e) {super.processWindowEvent(e);if (e.getID() == WindowEvent.WINDOW_CLOSING) {设备信息_actionPerformed(null);}}void shebei_actionPerformed(ActionEvent e) {try {}catch (Exception ew) {System.out.println(ew.getMessage());}}void jMenuItem1_actionPerformed(ActionEvent e) { try { Frame4 Frame= new Frame4();Frame.show();}catch (Exception ew) {System.out.println(ew.getMessage());}}void jMenuItem3_actionPerformed(ActionEvent e) {try {Frame6 Frame= new Frame6();Frame.show();}catch (Exception ew) {System.out.println(ew.getMessage());}}void jMenuItem4_actionPerformed(ActionEvent e) {try {Frame3 Frame= new Frame3();Frame.show();}catch (Exception ew) {System.out.println(ew.getMessage());}}void jMenuItem5_actionPerformed(ActionEvent e) { try {Frame6 Frame= new Frame6();Frame.show();}catch (Exception ew) {System.out.println(ew.getMessage());}}void jMenuItem6_actionPerformed(ActionEvent e) { try {retur Frame= new retur();Frame.show();}catch (Exception ew) {System.out.println(ew.getMessage());}}void jMenuItem7_actionPerformed(ActionEvent e) { try {Frame3 Frame= new Frame3();Frame.show();}catch (Exception ew) {System.out.println(ew.getMessage());}}void jMenuItem8_actionPerformed(ActionEvent e) {try {Frame5 Frame= new Frame5();Frame.show();}catch (Exception ew) {System.out.println(ew.getMessage());}}void jMenuItem2_itemStateChanged(ItemEvent e) {System.exit(0);}void jMenuItem2_actionPerformed(ActionEvent e) {System.exit(0);}void设备申请_actionPerformed(ActionEvent e) {}}class Frame9_设备信息_ActionAdapter implements ActionListener { Frame9 adaptee;Frame9_设备信息_ActionAdapter(Frame9 adaptee) {this.adaptee = adaptee;}public void actionPerformed(ActionEvent e) {adaptee.设备信息_actionPerformed(e);}}class Frame9_申请登记_ActionAdapter implements ActionListener { Frame9 adaptee;Frame9_申请登记_ActionAdapter(Frame9 adaptee) {this.adaptee = adaptee;}public void actionPerformed(ActionEvent e) {adaptee.申请登记_actionPerformed(e);}}class Frame9_jMenuItem5_actionAdapter implements java.awt.event.ActionListener {Frame9 adaptee;Frame9_jMenuItem5_actionAdapter(Frame9 adaptee) { this.adaptee = adaptee;}public void actionPerformed(ActionEvent e) {adaptee.jMenuItem5_actionPerformed(e);}}class Frame9_jMenuItem7_actionAdapter implements java.awt.event.ActionListener {Frame9 adaptee;Frame9_jMenuItem7_actionAdapter(Frame9 adaptee) { this.adaptee = adaptee;}public void actionPerformed(ActionEvent e) {adaptee.jMenuItem7_actionPerformed(e);}}class Frame9_jMenuItem8_actionAdapter implements java.awt.event.ActionListener {Frame9 adaptee;Frame9_jMenuItem8_actionAdapter(Frame9 adaptee) { this.adaptee = adaptee;}public void actionPerformed(ActionEvent e) {adaptee.jMenuItem8_actionPerformed(e);}}class Frame9_jMenuItem1_actionAdapter implements java.awt.event.ActionListener {Frame9 adaptee;Frame9_jMenuItem1_actionAdapter(Frame9 adaptee) { this.adaptee = adaptee;}public void actionPerformed(ActionEvent e) {adaptee.jMenuItem1_actionPerformed(e);}}class Frame9_jMenuItem3_actionAdapter implements java.awt.event.ActionListener {Frame9 adaptee;Frame9_jMenuItem3_actionAdapter(Frame9 adaptee) { this.adaptee = adaptee;}public void actionPerformed(ActionEvent e) {adaptee.jMenuItem3_actionPerformed(e);}}class Frame9_jMenuItem2_itemAdapter implementsjava.awt.event.ItemListener {Frame9 adaptee;Frame9_jMenuItem2_itemAdapter(Frame9 adaptee) { this.adaptee = adaptee;}public void itemStateChanged(ItemEvent e) {adaptee.jMenuItem2_itemStateChanged(e);}}class Frame9_jMenuItem2_actionAdapter implements java.awt.event.ActionListener {Frame9 adaptee;Frame9_jMenuItem2_actionAdapter(Frame9 adaptee) { this.adaptee = adaptee;}public void actionPerformed(ActionEvent e) {adaptee.jMenuItem2_actionPerformed(e);}class Frame9_设备申请_actionAdapter implements java.awt.event.ActionListener {Frame9 adaptee;Frame9_设备申请_actionAdapter(Frame9 adaptee) { this.adaptee = adaptee;}public void actionPerformed(ActionEvent e) {adaptee.设备申请_actionPerformed(e);}}4、设备查询：package shebeiguanli;/** <p>Title实验室设备管理系统查询页面<p>* @author gengdexin*/import java.io.*;import .*;import java.sql.*;import ng.*;import javax.sql.*;import java.awt.*;import java.awt.event.*;import javax.swing.*;import yout.*;import com.borland.dbswing.*;public class Frame2 extends JFrame {JPanel contentPane;JLabel jLabel1 = new JLabel();XYLayout xYLayout1 = new XYLayout();JLabel jLabel2 = new JLabel();JLabel jLabel3 = new JLabel();JTextField jTextField1 = new JTextField();JLabel jLabel4 = new JLabel();JTextField jTextField2 = new JTextField();JPanel jPanel1 = new JPanel();XYLayout xYLayout2 = new XYLayout();JScrollPane jScrollPane1 = new JScrollPane();JLabel jLabel5 = new JLabel();JTextField jTextField3 = new JTextField();public Frame2() {enableEvents(AWTEvent.WINDOW_EVENT_MASK);try {jbInit();}catch(Exception e) {e.printStackTrace();}}private void jbInit() throws Exception {contentPane = (JPanel) this.getContentPane();contentPane.setLayout(xYLayout1);this.setSize(new Dimension(600, 500));this.setTitle("实验室设备管理系统");this.addHierarchyBoundsListener(newFrame2_this_hierarchyBoundsAdapter(this));jLabel1.setFont(new java.awt.Font("SansSerif", 0, 25));jLabel1.setForeground(Color.red);jLabel1.setText("实验室设备管理系统");contentPane.setForeground(Color.black);jLabel2.setFont(new java.awt.Font("SansSerif", 0, 30));jLabel2.setText("设备查询");// statusBar.setFont(new java.awt.Font("SansSerif", 0, 20));jLabel3.setFont(new java.awt.Font("SansSerif", 0, 20));jLabel3.setText("设备名称");jTextField1.setText("");jLabel4.setEnabled(true);jLabel4.setFont(new java.awt.Font("SansSerif", 0, 20));jLabel4.setText("设备型号");jTextField2.setText("");jTextField2.addActionListener(newFrame2_jTextField2_actionAdapter(this));jPanel1.setLayout(xYLayout2);jLabel5.setFont(new java.awt.Font("SansSerif", 0, 25));jLabel5.setForeground(Color.red);jLabel5.setText("该设备详细信息");jTextField3.setText("");contentPane.add(jLabel1, new XYConstraints(200, 0, 300,50));contentPane.add(jLabel2, new XYConstraints(200, 47, 231, 58));contentPane.add(jLabel3, new XYConstraints(47, 102, 101, 42));contentPane.add(jTextField1, new XYConstraints(128, 108, 112, 34));contentPane.add(jTextField2, new XYConstraints(361, 107, 109, 36));contentPane.add(jPanel1, new XYConstraints(75, 166, 453, 277));jPanel1.add(jScrollPane1, new XYConstraints(14, 8, 433, 221));jScrollPane1.getViewport().add(jTextField3, null);jPanel1.add(jLabel5, new XYConstraints(112, 240, -1, -1));contentPane.add(jLabel4, new XYConstraints(278, 111, -1, -1));}protected void processWindowEvent(WindowEvent e) {super.processWindowEvent(e);if (e.getID() == WindowEvent.WINDOW_CLOSING) {System.exit(0);}}void Select() {try {String str1, str2;str1 = jTextField1.getText();str2 = jTextField2.getText();Connection con = null;String url = "jdbc:odbc:shebeiguanli";String user = "";String password = "";Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");con = DriverManager.getConnection(url,user,password);Statement stmt =con.createStatement();PreparedStatement pstmt = con.prepareStatement("use shebeiguanli select * from 设备基本信息 where 设备型号=? and 设备名=? ");pstmt.setString(2, str1);pstmt.setString(1, str2);ResultSet res = pstmt.executeQuery();String id;String name;String guige,danjia,day,changjia,peo,num;String outputarea=" 设备型号 " +" 设备名称 "+" 规格 "+" 单价 "+" 购买日期 "+" 生产厂家 "+" 数量 "+" 责任人 "+'\n';if(res.next()){do{id = res.getString(1);name = res.getString(2);guige = res.getString(3);danjia = res.getString(4);day=res.getString(5);changjia = res.getString(6);peo=res.getString(7);num=res.getString(8);outputarea+=" "+id+" "+name+" "+guige+" "+danjia+" "+day+" "+changjia+" "+peo+" "+num+" "+"\n";jTextField3.setText(outputarea);}while(res.next());}else{jTextField3.setText("不存在");}}catch (ClassNotFoundException e) {System.out.println(e.getMessage());}catch (SQLException edd) {edd.printStackTrace() ;System.out.println(edd.getMessage());}}void this_ancestorMoved(HierarchyEvent e) {}void jTextField2_actionPerformed(ActionEvent e) {Select();}}class Frame2_this_hierarchyBoundsAdapter extendsjava.awt.event.HierarchyBoundsAdapter {Frame2 adaptee;Frame2_this_hierarchyBoundsAdapter(Frame2 adaptee) { this.adaptee = adaptee;}public void ancestorMoved(HierarchyEvent e) {adaptee.this_ancestorMoved(e);}}class Frame2_jTextField2_actionAdapter implementsjava.awt.event.ActionListener {Frame2 adaptee;Frame2_jTextField2_actionAdapter(Frame2 adaptee) { this.adaptee = adaptee;}public void actionPerformed(ActionEvent e) {adaptee.jTextField2_actionPerformed(e);}}5、维修记录：package shebeiguanli;/** <p>title实验室设备管理系统维修记录页面<p> * @author gengdexin*/import java.io.*;import .*;import java.sql.*;import ng.*;import javax.sql.*;import java.awt.*;import java.awt.event.*;import javax.swing.*;import yout.*; public class Frame3 extends JFrame { JPanel contentPane;XYLayout xYLayout1 = new XYLayout(); 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();JLabel jLabel8 = new JLabel();JTextField jTextField1 = new JTextField();JTextField jTextField2 = new JTextField();JTextField jTextField3 = new JTextField();JTextField jTextField4 = new JTextField();JTextField jTextField5 = new JTextField();JTextField jTextField6 = new JTextField();JButton jButton1 = new JButton();public Frame3() {enableEvents(AWTEvent.WINDOW_EVENT_MASK);try {jbInit();}catch(Exception e) {e.printStackTrace();}}private void jbInit() throws Exception {contentPane = (JPanel) this.getContentPane();contentPane.setLayout(xYLayout1);this.setSize(new Dimension(500,500));this.setTitle("实验室设备管理系统");jLabel1.setFont(new java.awt.Font("SansSerif", 0, 25));jLabel1.setForeground(Color.red);jLabel1.setText("实验室设备管理系统");jLabel2.setFont(new java.awt.Font("SansSerif", 0, 30));jLabel2.setRequestFocusEnabled(true);jLabel2.setText("维修记录");jLabel3.setFont(new java.awt.Font("SansSerif", 0, 12));jLabel3.setText("设备型号");jLabel4.setFont(new java.awt.Font("SansSerif", 0, 12));jLabel4.setText("设备名");jLabel5.setFont(new java.awt.Font("SansSerif", 0, 12));jLabel5.setText("维修日期");jLabel6.setFont(new java.awt.Font("SansSerif", 0, 12));jLabel6.setText("维修厂家");jLabel7.setFont(new java.awt.Font("SansSerif", 0, 12));jLabel7.setText("维修费用");jLabel8.setFont(new java.awt.Font("SansSerif", 0, 12));jLabel8.setText("责任人");jTextField1.setText("");jTextField2.setText("");jTextField3.setText("");jTextField4.setText("");jTextField5.setText("");jTextField6.setText("");jButton1.setFont(new java.awt.Font("SansSerif", 0, 25));jButton1.setText("提交");contentPane.add(jLabel1, new XYConstraints(120, 0, 250, 37));contentPane.add(jLabel2, new XYConstraints(166, 27, -1, -1));contentPane.add(jLabel3, new XYConstraints(94, 90, -1, -1));contentPane.add(jLabel4, new XYConstraints(97, 140, -1, -1));contentPane.add(jLabel6, new XYConstraints(94, 240, -1, -1));contentPane.add(jTextField1, new XYConstraints(173, 80, 128, 38));contentPane.add(jTextField2, new XYConstraints(173, 130, 127, 40));contentPane.add(jLabel5, new XYConstraints(94, 190, -1, -1));contentPane.add(jTextField3, new XYConstraints(174, 180, 126, 38));contentPane.add(jTextField4, new XYConstraints(174, 230, 125, 40));contentPane.add(jButton1, new XYConstraints(176, 375, 121, 43));contentPane.add(jLabel7, new XYConstraints(94, 290, -1, -1));contentPane.add(jLabel8, new XYConstraints(94, 340, -1, -1));contentPane.add(jTextField5, new XYConstraints(174, 280, 126, 38));contentPane.add(jTextField6, new XYConstraints(174, 330, 126, 38));}protected void processWindowEvent(WindowEvent e) {super.processWindowEvent(e);if (e.getID() == WindowEvent.WINDOW_CLOSING) {System.exit(0);}}void jTextField1_actionPerformed(ActionEvent e) {}void Insert() {try {//定义显示的字符串String str1;String str2;String str3;String str4;String str5;String str6;str1 = jTextField1.getText();str2 = jTextField2.getText();str3 = jTextField3.getText();str4 = jTextField4.getText();str5 = jTextField5.getText();str6 = jTextField6.getText();Connection con = null;S tring url = "jdbc:odbc:shebeiguanli";S tring user = "";S tring password = "";Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");con = DriverManager.getConnection(url,user,password);Statement stmt =con.createStatement();PreparedStatement pstmt = con.prepareStatement("use shebeiguanli insert into 维修记录(设备型号,设备名,维修日期,维修厂家,维修费用,责任人)VALUES(?,?,?,?,?,?)");pstmt.setString(1, str1);pstmt.setString(2, str2);pstmt.setString(3, str3);pstmt.setString(4, str4);pstmt.setString(5, str5);pstmt.setString(6, str6);ResultSet res = pstmt.executeQuery();pstmt.close();con.close();}catch (ClassNotFoundException e) {System.out.println(e.getMessage());}catch (SQLException edd) {edd.printStackTrace() ;System.out.println(edd.getMessage());}}void jButton1_actionPerformed(ActionEvent e) {Insert();}}6、维修记录查询package shebeiguanli;/** <p>Title实验室设备管理系统维修查询页面<p> * @author gengdexin*/import java.io.*;import .*;import java.sql.*;import ng.*;import javax.sql.*;import java.awt.*;import java.awt.event.*;import javax.swing.*;import yout.*;import com.borland.dbswing.*;public class Frame4 extends JFrame {JPanel contentPane;JLabel jLabel1 = new JLabel();XYLayout xYLayout1 = new XYLayout();JLabel jLabel2 = new JLabel();JLabel jLabel3 = new JLabel();JTextField jTextField1 = new JTextField();JLabel jLabel4 = new JLabel();JTextField jTextField2 = new JTextField();JPanel jPanel1 = new JPanel();XYLayout xYLayout2 = new XYLayout();JScrollPane jScrollPane1 = new JScrollPane();JLabel jLabel5 = new JLabel();JTextField jTextField3 = new JTextField();public Frame4() {enableEvents(AWTEvent.WINDOW_EVENT_MASK);try {jbInit();}catch(Exception e) {e.printStackTrace();}}private void jbInit() throws Exception {contentPane = (JPanel) this.getContentPane();contentPane.setLayout(xYLayout1);this.setSize(new Dimension(600, 500));this.setTitle("实验室设备管理系统");this.addHierarchyBoundsListener(newFrame4_this_hierarchyBoundsAdapter(this));jLabel1.setFont(new java.awt.Font("SansSerif", 0, 25));jLabel1.setForeground(Color.red);jLabel1.setText("实验室设备管理系统");contentPane.setForeground(Color.black);jLabel2.setFont(new java.awt.Font("SansSerif", 0, 30));jLabel2.setText("设备维修记录查询");jLabel3.setFont(new java.awt.Font("SansSerif", 0, 20));jLabel3.setText("设备名称");jTextField1.setText("");。