面向對象課程設計報告-－－實驗室設備管理系統(tǒng)

面向對象課程設計報告－－實驗室設備管理系統(tǒng)任務分配及完成情況姓名承擔任務自評成績鄭雄風代碼部分、調試測試。優(yōu)湯晨煜整體框架、報告撰寫優(yōu)實驗室設備管理系統(tǒng)設計報告1課程設計任務概述目的：完成一份管理實驗室設備的軟件。主要完成的任務：對實驗室設備進行系統(tǒng)化管理。功能模塊：用戶管理，合法用戶許可訪問；信息錄入，包括記錄的追加和插入；信息刪除；信息修改；信息排序和查詢；數據的導入/導出；簡單的幫助。2系統(tǒng)分析與建模2.1系統(tǒng)功能分析1主界面，包含所有功能的集合2用戶等陸，分為兩個功能。用戶登錄和用戶查詢，其中用戶登陸是通過輸入用戶名和密碼進行登陸，用戶注冊是自己設定用戶和密碼。3查詢，直接進行查詢信息，但是無法進行修改和刪除等功能。4設備管理，分為管理和添加兩個功能。其中添加包括設備編號，設備名稱，設備狀態(tài)，制造商，購買狀態(tài)。管理分為查詢和刪除兩個功能，可以通過設備編號和設備名稱來查找。5系統(tǒng)管理，分為保存，導入，導出。退出功能。保存是將信息錄入，導入是導入文件，導出是導出文件，退出是直接退出主界面。5幫助是關于系統(tǒng)和聯(lián)系作者。2.2用例圖及用例說明2.1.1管理員登陸用例（1）管理員登陸用例描述UseCase名稱登陸執(zhí)行者管理員事件流A輸入用戶名B輸入密碼C若密碼不正確無法登陸D若無用戶名新增管理員后置條件若新增用戶正確，則增加管理員新的用戶及密碼管理員登陸用例圖2.1.2管理員對實驗設備添加用例（1）管理員對實驗設備添加用例描述UseCase名稱設備添加執(zhí)行者管理員事件流A選擇添加功能B添加設備編號C添加設備名稱D設備狀態(tài)E制造商F購買狀態(tài)后置條件系統(tǒng)更新數據庫（2）管理員對實驗設備添加用例圖2.1.3管理員對實驗設備管理用例（1）管理員對實驗設備管理用例描述UseCase名稱設備管理執(zhí)行者管理員事件流A選擇查詢還是刪除B刪除C選擇排序D選擇設備編號還是設備名稱后置條件系統(tǒng)更新數據庫管理員對實驗設備管理用例圖2.1.4管理員對系統(tǒng)管理用例（1）管理員對系統(tǒng)管理用例描述UseCase名稱系統(tǒng)管理執(zhí)行者管理員事件流A選擇功能B保存所有操作C導入文件D導出文件E退出后置條件系統(tǒng)更新數據庫管理員對系統(tǒng)管理用例圖2.1.5整體用例框圖3系統(tǒng)設計3.1系統(tǒng)類圖設備類用戶類數據庫類3.2系統(tǒng)活動圖3.3系統(tǒng)時序圖用戶操作用戶對設備信息修改操作4系統(tǒng)實現(xiàn)/*用戶界面*/packageUI;importjava.awt.BorderLayout;importjava.awt.EventQueue;importjavax.swing.JFrame;importjavax.swing.JPanel;importjavax.swing.border.EmptyBorder;importjavax.swing.JMenuBar;importjavax.swing.JMenu;importjavax.swing.JMenuItem;importjava.awt.event.ActionListener;importjava.awt.event.ActionEvent;publicclassFirstMenuextendsJFrame{ privateJPanelcontentPane; /** *Launchtheapplication. */ publicstaticvoidmain(String[]args){ EventQueue.invokeLater(newRunnable(){ publicvoidrun(){ try{ FirstMenuframe=newFirstMenu(); frame.setVisible(true); }catch(Exceptione){ e.printStackTrace(); } } }); } /** *Createtheframe. */ publicFirstMenu(){ setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setBounds(100,100,800,500); contentPane=newJPanel(); contentPane.setBorder(newEmptyBorder(5,5,5,5)); setContentPane(contentPane); contentPane.setLayout(null); JMenuBarmenuBar=newJMenuBar(); menuBar.setBounds(10,0,844,21); contentPane.add(menuBar); JMenumenu=newJMenu("\u7528\u6237\u9009\u62E9"); menuBar.add(menu); JMenuItemmenuItem=newJMenuItem("\u7528\u6237\u767B\u5F55"); menuItem.addActionListener(newActionListener(){ publicvoidactionPerformed(ActionEvente){ UserLogin(); } }); menu.add(menuItem); JMenuItemmntmNewMenuItem=newJMenuItem("\u7528\u6237\u6CE8\u518C"); mntmNewMenuItem.addActionListener(newActionListener(){ publicvoidactionPerformed(ActionEvente){ AddUser(); } }); menu.add(mntmNewMenuItem); JMenumenu_2=newJMenu("\u8BBE\u5907\u67E5\u8BE2"); menuBar.add(menu_2); JMenuItemmenuItem_1=newJMenuItem("\u67E5\u8BE2"); menuItem_1.addActionListener(newActionListener(){ publicvoidactionPerformed(ActionEvente){ Deviced(); } }); menu_2.add(menuItem_1); } publicvoidUserLogin(){ UserLoginuserlogin=newUserLogin(); userlogin.show(); } publicvoidAddUser(){ UserAdduseradd=newUserAdd(); useradd.show(); } protectedvoidDeviced(){ //TODOAuto-generatedmethodstub Deviceddeviced=null; try{ deviced=newDeviced(); }catch(ClassNotFoundExceptione){ //TODO自動生成的catch塊 e.printStackTrace(); } deviced.show(); }}/*用戶操作界面*/packageUI;importjava.awt.EventQueue;importjava.awt.FileDialog;importjavax.swing.JFrame;importjavax.swing.JPanel;importjavax.swing.JMenuBar;importjavax.swing.JMenu;importjavax.swing.JMenuItem;importjavax.swing.JOptionPane;importjavax.swing.KeyStroke;importservice.DeviceService;importjava.awt.event.*;importjava.util.Vector;importjavax.swing.JTextField;importjava.awt.*;importjava.io.IOException;publicclassMenuextendsJFrameimplementsActionListener{ privateJPanelcontentPane; privateJMenuItemexitsystem; privateJMenuItemreservefile; privateJMenuItemadduser; privateJMenuItemuserin; privateJMenuItemsort; privateJMenuItemsearch; privateJMenuItemaboutsystem; privateJMenuItemcontactworker; privateJMenuhelp; privateJMenuloginuser; privateJMenudeviceinfo; privateJMenudeviceadd; privateJMenudevicedel; privateJMenusystem; privateJMenudevicemanange; privateDeviceServicedeviceservice; Vector<Menu>vector=newVector(); privateJTextFieldusertextField=null; /** *Launchtheapplication. */ publicstaticvoidmain(String[]args){ EventQueue.invokeLater(newRunnable(){ publicvoidrun(){ try{ Menuframe=newMenu(); frame.setVisible(true); }catch(Exceptione){ e.printStackTrace(); } } }); } /** *Createtheframe. */ publicMenu(){ setTitle("\u5B9E\u9A8C\u5BA4\u8BBE\u5907\u7BA1\u7406\u7CFB\u7EDF"); setDefaultCloseOperation(Menu.EXIT_ON_CLOSE); setBounds(100,100,800,500); JMenuBarmenuBar=newJMenuBar(); setJMenuBar(menuBar); JMenusystem=newJMenu("系統(tǒng)管理"); menuBar.add(system); JMenuItemreservefile=newJMenuItem("保存"); reservefile.addActionListener(this); system.add(reservefile); reservefile.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_S,InputEvent.CTRL_MASK)); JMenuItemexitsystem=newJMenuItem("退出"); exitsystem.addActionListener(newActionListener(){ publicvoidactionPerformed(ActionEvente){ dispose(); } }); JMenuItemmenuItem_import=newJMenuItem("\u5BFC\u5165"); menuItem_import.addActionListener(newActionListener(){ publicvoidactionPerformed(ActionEventarg0){ importFromFile(); } }); system.add(menuItem_import); JMenuItemmenuItem_export=newJMenuItem("\u5BFC\u51FA"); menuItem_export.addActionListener(newActionListener(){ publicvoidactionPerformed(ActionEventarg0){ try{ exportToFile(); }catch(IOExceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); } } }); system.add(menuItem_export); system.add(exitsystem); JMenudevicemanange=newJMenu("設備管理"); menuBar.add(devicemanange); JMenuItemmenuItem_manager=newJMenuItem("管理"); menuItem_manager.addActionListener(newActionListener(){ publicvoidactionPerformed(ActionEvente){ DeleteDevice(); } }); devicemanange.add(menuItem_manager); JMenuItemmenuItem=newJMenuItem("添加"); menuItem.addActionListener(newActionListener(){ publicvoidactionPerformed(ActionEvente){ AddDevice(); } }); devicemanange.add(menuItem); JMenuhelp=newJMenu("幫助"); menuBar.add(help); JMenuItemaboutsystem=newJMenuItem("關于系統(tǒng)"); help.add(aboutsystem); aboutsystem.addActionListener(this); JMenuItemcontactworker=newJMenuItem("聯(lián)系作者"); help.add(contactworker); contactworker.addActionListener(this); contentPane=newJPanel(); contentPane.setBorder(null); setContentPane(contentPane); contentPane.setLayout(null); } protectedvoidDeleteDevice(){ //TODOAuto-generatedmethodstub DeviceDetaildevicedelete=null; try{ devicedelete=newDeviceDetail(); }catch(ClassNotFoundExceptione){ //TODO自動生成的catch塊 e.printStackTrace(); } devicedelete.show(); } publicvoidAddDevice(){ //TODOAuto-generatedmethodstub AddDeviceadddevice=newAddDevice(); adddevice.show(); } voidinit(Strings){ setTitle("實驗室設備管理系統(tǒng)"); } @Override publicvoidactionPerformed(ActionEvente){ //TODO自動生成的方法存根 Stringcmd=e.getActionCommand(); if(cmd.equals("保存")){ JOptionPane.showMessageDialog(this,"已保存所有數據"); } if(cmd.equals("關于系統(tǒng)")) { JOptionPane.showMessageDialog(this,"本系統(tǒng)主題為“水墨書鄉(xiāng)”，以墨色為主色調，避免紛繁多雜的視覺沖擊，"+ "其界面整潔有序，更彰顯文化的古韻魅力。\n操作上人性化設計:\n1.本軟件操作效率較高。\n2."+ "實用性強：包含設備管理最核心基礎的功能，反應速度快！適用于一般的個人、學校、企業(yè)的應用。"+ "\n3.本版本為預覽版"); } if(cmd.equals("聯(lián)系作者")) { JOptionPane.showMessageDialog(this,"作者：冷月\n"+"QQ:1014539765"); } } protectedvoidimportFromFile(){ StringfileName=null; //使用文件打開對話框，取得用戶輸入的需保存的文件位置及文件名，見教材“Java2實用教程”P18。 FileDialogfileDialog_open=newFileDialog(this,"打開文件對話框",FileDialog.LOAD); fileDialog_open.setVisible(true); fileName=fileDialog_open.getFile();//如果用戶單擊“取消”按鈕，值為null。 if(fileName!=null){ Stringpath=fileDialog_open.getDirectory()+fileName;//文件的完整路徑 deviceservice.importFromFile(path); } } protectedvoidexportToFile()throwsIOException{ StringfileName=null; //使用文件打開對話框，取得用戶輸入的需保存的文件位置及文件名，見教材“Java2實用教程”P18。 FileDialogfileDialog_save=newFileDialog(this,"保存文件對話框",FileDialog.SAVE); fileDialog_save.setVisible(true); fileName=fileDialog_save.getFile();//如果用戶單擊“取消”按鈕，值為null。 if(fileName!=null){ Stringpath=fileDialog_save.getDirectory()+fileName;//文件的完整路徑 deviceservice.exportToFile(path); } }}/*用戶登錄界面*/packageUI;importjava.awt.BorderLayout;importjava.awt.EventQueue;importjavax.swing.JFrame;importjavax.swing.JPanel;importjavax.swing.border.EmptyBorder;importjavax.swing.JOptionPane;importjavax.swing.JButton;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.awt.event.MouseAdapter;importjava.awt.event.MouseEvent;importjavax.swing.JLabel;importjava.awt.Font;importjavax.swing.JTextField;importservice.DeviceService;importuser.User;importjavax.swing.JPasswordField;@SuppressWarnings("serial")classUserLoginextendsJFrame{ privateJPaneluserlogin; privateJTextFieldusnamefield; privateJPasswordFieldpasswordfield; /** *Launchtheapplication. */ publicstaticvoidmain(String[]args){ EventQueue.invokeLater(newRunnable(){ publicvoidrun(){ try{ UserLoginframe=newUserLogin(); frame.setVisible(true); }catch(Exceptione){ e.printStackTrace(); } } }); } /** *Createtheframe. *@paramtitle *@paramvector */ UserLogin(){ setBounds(100,100,288,228); userlogin=newJPanel(); userlogin.setBorder(newEmptyBorder(5,5,5,5)); setContentPane(userlogin); userlogin.setLayout(null); JLabelusername=newJLabel("\u7528\u6237\u540D"); username.setFont(newFont("隸書",Font.BOLD,14)); username.setBounds(28,29,54,23); userlogin.add(username); JLabelpassword=newJLabel("\u5BC6\u7801"); password.setFont(newFont("隸書",Font.BOLD,14)); password.setBounds(28,72,54,23); userlogin.add(password); usnamefield=newJTextField(); usnamefield.setBounds(107,29,117,23); userlogin.add(usnamefield); usnamefield.setColumns(10); passwordfield=newJPasswordField(); passwordfield.setColumns(10); passwordfield.setBounds(107,72,117,23); userlogin.add(passwordfield); JButtonbutton_ok=newJButton("\u767B\u5F55"); button_ok.addActionListener(newActionListener(){ publicvoidactionPerformed(ActionEvente){ Stringusername=usnamefield.getText().trim(); Stringpassword=passwordfield.getText().trim(); if(usnamefield.getText().equals("")){ JOptionPane.showMessageDialog(null,"用戶名不可為空，請確認！"); return; } if(passwordfield.getText().equals("")){ JOptionPane.showMessageDialog(null,"密碼不可為空！"); return; } Useruser=newUser(username,password); if(DeviceService.Logon(user)!=null){ JOptionPane.showMessageDialog(null,"登陸成功"); setVisible(false); Menumenu=newMenu(); menu.setVisible(true); }else{ JOptionPane.showMessageDialog(null,"密碼或者用戶名出錯！"); setVisible(true); clear(); } } }); button_ok.setBounds(41,132,66,23); userlogin.add(button_ok); JButtonbutton_cancel=newJButton("\u53D6\u6D88"); button_cancel.addMouseListener(newMouseAdapter(){ @Override publicvoidmouseClicked(MouseEvente){ dispose(); } }); button_cancel.setBounds(173,132,66,23); userlogin.add(button_cancel); } protectedvoidclear(){ //TODO自動生成的方法存根 usnamefield.setText(""); passwordfield.setText(""); }}/*管理界面*/packageUI;importjava.awt.EventQueue;importjavax.swing.JFrame;importjavax.swing.JPanel;importjavax.swing.border.EmptyBorder;importjavax.swing.JComboBox;importjavax.swing.DefaultComboBoxModel;importjavax.swing.JOptionPane;importjavax.swing.JTextField;importjavax.swing.JScrollPane;importjavax.swing.JTable;importjavax.swing.table.DefaultTableModel;importjavax.swing.JButton;importjavax.swing.JLabel;importjavax.swing.SwingConstants;importservice.DeviceService;importuser.Device;importjava.awt.event.*;importjava.io.BufferedReader;importjava.io.DataOutputStream;importjava.io.File;importjava.io.FileInputStream;importjava.io.FileOutputStream;importjava.io.FileReader;importjava.io.IOException;importjava.io.ObjectInputStream;importjava.io.ObjectOutputStream;importjava.util.ArrayList;importjava.util.Iterator;importjava.util.LinkedList;importjava.util.List;publicclassDeviceDetailextendsJFrameimplementsItemListener,ActionListener{ privateJPanelcontentPane; privateJScrollPanescrollPane; privateJTableinfo; privateJComboBoxcomboBox; privateJTextFielddnumfield; privateList<Device>devicelist; Object[][]object; Filefile=newFile("devices.txt"); privateJTextFielddnamefield; privateJLabellbinfo; //Vector<Device>vector2; /** *Launchtheapplication. */ publicstaticvoidmain(String[]args){ EventQueue.invokeLater(newRunnable(){ publicvoidrun(){ try{ DeviceDetailframe=newDeviceDetail(); frame.setVisible(true); }catch(Exceptione){ e.printStackTrace(); } } }); } /** *Createtheframe. *@throwsClassNotFoundException */ @SuppressWarnings("unchecked") publicDeviceDetail()throwsClassNotFoundException{ //super(s); setTitle("\u8BBE\u5907\u7BA1\u7406"); setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); setBounds(100,100,692,437); contentPane=newJPanel(); contentPane.setBorder(newEmptyBorder(5,5,5,5)); setContentPane(contentPane); contentPane.setLayout(null); comboBox=newJComboBox(); comboBox.addItemListener(this); comboBox.setModel(newDefaultComboBoxModel(newString[]{"","查詢","刪除"})); comboBox.setBounds(32,46,91,21); contentPane.add(comboBox); lbinfo=newJLabel(""); lbinfo.setLabelFor(this); lbinfo.setEnabled(false); lbinfo.setBounds(32,78,209,26); contentPane.add(lbinfo); scrollPane=newJScrollPane(); scrollPane.setBounds(32,114,618,261); contentPane.add(scrollPane); info=newJTable(); scrollPane.setViewportView(info); info.setModel(newDefaultTableModel( object=newObject[][]{ {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, {null,null,null,null,null}, }, newString[]{ "設備編號","設備名稱","制造商","設備狀態(tài)","購入時間" } )); intp=0; try{ devicelist=newArrayList<Device>(); devicelist=DeviceService.FindAll(); Iterator<Device>iter=devicelist.iterator(); inti=0; while(iter.hasNext()){ Devicedevices=iter.next(); info.setValueAt(object[i][0]=devices.getDnum(),i,0); info.setValueAt(object[i][1]=devices.getDname(),i,1); info.setValueAt(object[i][2]=devices.getIndustry(),i,2); info.setValueAt(object[i][3]=devices.getIndate(),i,3); info.setValueAt(object[i][4]=devices.getDtime(),i,4); i++; } lbinfo.setText("一共有"+i+"臺設備信息"); info.repaint(); }catch(Exceptione1){e1.printStackTrace();} JButtonbtnNewButton=newJButton("確定"); btnNewButton.addActionListener(this); btnNewButton.setBounds(496,45,67,23); contentPane.add(btnNewButton); JButtonButton_cancle=newJButton("取消"); Button_cancle.addActionListener(newActionListener(){ publicvoidactionPerformed(ActionEvente){ dispose(); } }); Button_cancle.setBounds(583,45,67,23); contentPane.add(Button_cancle); JLabellabel=newJLabel("設備信息管理"); label.setEnabled(false); label.setHorizontalAlignment(SwingConstants.CENTER); label.setBounds(148,10,362,21); contentPane.add(label); dnumfield=newJTextField(); dnumfield.setBounds(212,46,67,21); contentPane.add(dnumfield); dnumfield.setColumns(10); JLabeldnumlable=newJLabel("\u8BBE\u5907\u7F16\u53F7"); dnumlable.setBounds(148,49,54,15); contentPane.add(dnumlable); JLabeldnamelable=newJLabel("\u8BBE\u5907\u540D\u79F0"); dnamelable.setBounds(300,49,54,15); contentPane.add(dnamelable); dnamefield=newJTextField(); dnamefield.setBounds(364,46,66,21); contentPane.add(dnamefield); dnamefield.setColumns(10); } @SuppressWarnings("unchecked") @Override publicvoidactionPerformed(ActionEvente){ //TODO自動生成的方法存根 Stringcmd=e.getActionCommand(); if(cmd.equals("確定")){ if(comboBox.getSelectedItem().equals("查詢")){ try{ if(dnumfield.getText().equals("")||dnamefield.getText().equals("")){ JOptionPane.showMessageDialog(null,"請輸入內容"); } else { devicelist=newArrayList<Device>(); devicelist=DeviceService.FindAll(); System.out.println(devicelist.size()); DeviceQuarydd=newDeviceQuary(); Iterator<Device>iter=devicelist.iterator(); inti=0; while(iter.hasNext()) { Devicedevice=iter.next(); if(device.getDnum().equals(dnumfield.getText())&&device.getDname().equals(dnamefield.getText())){ dd.textField_num.setText(device.getDnum()); dd.textField_name.setText(device.getDname()); dd.textField_produce.setText(device.getIndustry()); dd.textField_state.setText(device.getIndate()); dd.textField_time.setText(device.getDtime()); dd.show(); i=1; break; } } if(i==0) JOptionPane.showMessageDialog(null,"查詢不到此設備，請確認后重新輸入信息"); } }catch(Exceptionee){ee.printStackTrace();} } if(comboBox.getSelectedItem().equals("刪除")){ try{ devicelist=newArrayList<Device>(); devicelist=DeviceService.FindAll(); if(dnumfield.getText().equals("")||dnamefield.getText().equals("")){ JOptionPane.showMessageDialog(null,"請輸入內容"); } else { Iterator<Device>iter=devicelist.iterator(); inti=0,m=0,j=0,p=0; while(iter.hasNext()){ Devicedevices=iter.next(); if(devices.getDnum().equals(dnumfield.getText())&&devices.getDname().equals(dnamefield.getText())){ j=i; DeviceService.Delete(devices); p++; } else i++; } JOptionPane.showMessageDialog(null,"共有"+p+"條數據，已刪除！"); this.dispose(); DeviceDetailde=newDeviceDetail(); de.show(); } }catch(Exceptione1){e1.printStackTrace();} } } info.repaint(); } @Override publicvoiditemStateChanged(ItemEvente){ //TODO自動生成的方法存根 // } }}/*后臺數據操作*/packagedao;importjava.sql.*;importjava.util.ArrayList;importjava.util.List;importuser.Device;importuser.User;importdatabase.JDBCUtiles;publicclassDeviceDao{ publicUserLogon(Userus){ //TODOAuto-generatedmethodstub Userexistadmin=null; Connectionconn=null; PreparedStatementstmt=null; ResultSetrs=null; try{ conn=JDBCUtiles.getConnection(); Stringsql="selectusername,passwordfromuserswhereusername=?andpassword=?"; stmt=conn.prepareStatement(sql); stmt.setString(1,us.getUsername()); stmt.setString(2,us.getPassword()); rs=stmt.executeQuery(); while(rs.next()){ existadmin=newUser(rs.getString("username"), rs.getString("password")); } }catch(Exceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); }finally{ JDBCUtiles.release(stmt,rs,conn); } returnexistadmin; } publicstaticbooleanInsert(Devicedevice){ booleanresult=false; Connectionconn=null; PreparedStatementstmt=null; try{ conn=JDBCUtiles.getConnection(); Stringsql="INSERTINTOdevices(dnum,dname,industry,indate,dtime)VALUES(?,?,?,?,?)"; stmt=conn.prepareStatement(sql); stmt.setString(1,device.getDnum()); stmt.setString(2,device.getDname()); stmt.setString(3,device.getIndustry()); stmt.setString(4,device.getIndate()); stmt.setString(5,device.getDtime()); intre=stmt.executeUpdate(); if(re>0) result=true; }catch(SQLExceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); }finally{ JDBCUtiles.release(stmt,conn); } returnresult; } publicstaticbooleanDelete(Devicedevice){ //TODOAuto-generatedmethodstub booleanresult=false; Connectionconn=null; PreparedStatementstmt=null; try{ conn=JDBCUtiles.getConnection(); Stringsql="DELETEfromdeviceswherednum=?anddname=?"; stmt=conn.prepareStatement(sql); stmt.setString(1,device.getDnum()); stmt.setString(2,device.getDname()); intre=stmt.executeUpdate(); if(re>0) result=true; }catch(SQLExceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); } returnresult; } publicstaticList<Device>FindAll(){ //TODOAuto-generatedmethodstub List<Device>devices=newArrayList<Device>(); Connectionconn=null; Statementstmt=null; ResultSetrs=null; try{ conn=JDBCUtiles.getConnection(); stmt=conn.createStatement(); Stringsql="select*fromdevices"; rs=stmt.executeQuery(sql); while(rs.next()){ Devicedev=newDevice(); dev.setDname(rs.getString("dname")); dev.setDnum(rs.getString("dnum")); dev.setIndustry(rs.getString("industry")); dev.setIndate(rs.getString("indate")); dev.setDtime(rs.getString("dtime")); devices.add(dev); } }catch(SQLExceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); }finally{ JDBCUtiles.release(stmt,rs,conn); } returndevices; } publicstaticbooleanUpdate(Devicedevice){ //TODOAuto-generatedmethodstub booleanresult=false; Connectionconn=null; PreparedStatementstmt=null; try{ conn=JDBCUtiles.getConnection(); Stringsql="updatedevicessetdnum=?,dname=?,industry=?,indate=?,dtime=?wherenum=?"; stmt=conn.prepareStatement(sql); stmt.setString(1,device.getDnum()); stmt.setString(2,device.getDname()); stmt.setString(3,device.getIndustry()); stmt.setString(4,device.getIndate()); stmt.setString(5,device.getDtime()); inti=stmt.executeUpdate(); if(i>0) result=true; }catch(SQLExceptione){ //TODOAuto-ge