《數(shù)據(jù)庫應用》課程設計-人事管理系統(tǒng)(java源代碼)

《數(shù)據(jù)庫應用》課程設計——人事管理系統(tǒng)（java源代碼）//用戶登陸類packageclasssource;importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjava.sql.*;publicclassLandextendsJFrame{JFramejf;JTextFieldtextName=newJTextField();JPasswordFieldtextage=newJPasswordField();JLabellabel=newJLabel("員工管理系統(tǒng)");JLabellabelName=newJLabel("用戶名：");JLabellabelage=newJLabel("密碼：");JButtonbuttonEnter=newJButton("登錄");JButtonbuttoncancel=newJButton("清空");publicLand(){jf=this;setTitle("登錄");Fontf=newFont("新宋體",Font.PLAIN,12);Containercon=getContentPane();con.setLayout(null);label.setBounds(95,10,110,20);label.setFont(newFont("新宋體",Font.PLAIN,14));con.add(label);labelName.setBounds(45,40,55,20);labelName.setFont(f);con.add(labelName);textName.setBounds(95,40,120,20);con.add(textName);labelage.setBounds(45,70,45,20);con.add(labelage);labelage.setFont(f);textage.setBounds(95,70,120,20);con.add(textage);buttonEnter.setBounds(90,110,60,20);buttonEnter.setFont(f);con.add(buttonEnter);//登陸的鼠標監(jiān)聽buttonEnter.addMouseListener(newMouseAdapter(){publicvoidmouseClicked(MouseEventme){if(textName.getText().equals("")){newJOptionPane().showMessageDialog(null,"用戶名不能為空!");}elseif(textage.getText().equals("")){newJOptionPane().showMessageDialog(null,"密碼不能為空!");}else{Stringsql="select*fromUserInformationwhereUser_Name='"textName.getText()+"'andPassword='"+textage.getText()+"'";System.out.println(sql);Judge(sql);}}});buttoncancel.setBounds(155,110,60,20);buttoncancel.setFont(f);con.add(buttoncancel);//清空按鈕的鼠標監(jiān)聽方法buttoncancel.addMouseListener(newMouseAdapter(){publicvoidmouseClicked(MouseEventme){textName.setText("");textage.setText("");}});setResizable(false);Imageimg=Toolkit.getDefaultToolkit().getImage("image\\main.gif");setIconImage(img);Toolkitt=Toolkit.getDefaultToolkit();intw=t.getScreenSize().width;inth=t.getScreenSize().height;setBounds(w/2-150,h/2-90,300,180);setVisible(true);}privatevoidJudge(StringsqlString){if(Database.joinDB()){if(Database.query(sqlString))try{if(Database.rs.isBeforeFirst()){System.out.println("密碼正確");jf.setVisible(false);D.close();newMain();}else{System.out.println("錯誤");newJOptionPane().showMessageDialog(null,"誤!","",JOptionPane.ERROR_MESSAGE);}}catch(Exceptionex){System.out.println(ex.getMessage());}}else{System.out.println("連接數(shù)據(jù)庫不成功");}}publicstaticvoidmain(Stringargs[]){newLand();}}//packageclasssource;importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjava.sql.*;publicclassMainextendsJFrameimplementsRunnable{Threadt=newThread(this);JDesktopPanedeskpane=newJDesktopPane();JPanelp=newJPanel();Labellp1=newLabel("歡迎使用員工管理系統(tǒng)!");ImageIconicon1=newImageIcon("imagetjsc.gif");ImageIconicon2=newImageIcon("imagecxdl.gif");ImageIconicon3=newImageIcon("imagexgmm.gif");ImageIconicon4=newImageIcon("imagetcxt.gif");ImageIconicon5=newImageIcon("imagejj.gif");ImageIconicon6=newImageIcon("imagehelp.gif");ImageIconicon7=newImageIcon("imagecx.gif");ImageIconicon8=newImageIcon("imagegl.gif");ImageIconicon9=newImageIcon("imagext.gif");ImageIconicon10=newImageIcon("imagexxgl.gif");ImageIconicon11=newImageIcon("imagexxcx.gif");ImageIconicon12=newImageIcon("imagebz.gif");ImageIconicon13=newImageIcon("imagegy.gif");ImageIconicon14=newImageIcon("imageglxx.gif");ImageIconicon15=newImageIcon("imagecxxx.gif");//完publicMain(){setTitle("員工管理系統(tǒng)");Containercon=getContentPane();con.setLayout(newBorderLayout());con.add(deskpane,BorderLayout.CENTER);Fontf=newFont("新宋體",Font.PLAIN,12);JMenuBarmb=newJMenuBar();JMenusystemM=newJMenu("systemM.setFont(f);JMenumanageM=newJMenu("manageM.setFont(f);JMenuemployeeMM=newJMenu("員工信息管理");employeeMM.setFont(f);JMenuselectM=newJMenu("信息查詢");selectM.setFont(f);JMenuemployeeSM=newJMenu("員工信息查詢");employeeSM.setFont(f);JMenuhelpM=newJMenu("幫助");helpM.setFont(f);JMenuaboutM=newJMenu("關于");aboutM.setFont(f);JMenuItempassword=newJMenuItem("密碼修改");password.setFont(f);JMenuItemland=newJMenuItem("重新登陸");land.setFont(f);JMenuItemaddDelete=newJMenuItem("添加/刪除用戶");addDelete.setFont(f);JMenuItemexit=newJMenuItem("退出系統(tǒng)");exit.setFont(f);systemM.add(password);systemM.add(land);systemM.add(addDelete);systemM.add(exit);//為系統(tǒng)管理菜單加事件password.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.out.println("AmendPassword");deskpane.add(newAmendPassword());}});land.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.out.println("Land");setVisible(false);newLand();}});addDelete.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){deskpane.add(newAddDeleteUser());}});exit.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){//newJOptionPane().showMessageDialog(setVisible(false);}});JMenuItemdepartmentM=newJMenuItem("部門信息管理");departmentM.setFont(f);JMenuItememployeeM=newJMenuItem("基本信息管理");employeeM.setFont(f);JMenuItemtrainM=newJMenuItem("培訓信息管理");trainM.setFont(f);JMenuItemencouragementPunishM=newJMenuItem("獎罰信息管理");encouragementPunishM.setFont(f);JMenuItemwageM=newJMenuItem("薪資信息管理");wageM.setFont(f);employeeMM.add(trainM);employeeMM.add(employeeM);employeeMM.add(encouragementPunishM);employeeMM.add(wageM);manageM.add(employeeMM);manageM.add(departmentM);//為管理菜單加事件departmentM.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.out.println("Departmentmanage");deskpane.add(newDepartmentmanage());}});employeeM.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.out.println("Employeemanage");deskpane.add(newEmployeemanage());}});trainM.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.out.println("Trainmanage");deskpane.add(newTrainmanage());}});encouragementPunishM.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.out.println("EncouragementPunish");deskpane.add(newEncouragementPunish());}});wageM.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.out.println("WageManage");deskpane.add(newWageManage());}});JMenuItemdepartmentS=newJMenuItem("部門信息查詢");departmentS.setFont(f);JMenuItememployeeS=newJMenuItem("基本信息查詢");employeeS.setFont(f);JMenuItemtrainS=newJMenuItem("培訓信息查詢");trainS.setFont(f);JMenuItemencouragementPunishS=newJMenuItem("獎罰信息查詢");encouragementPunishS.setFont(f);JMenuItemwageS=newJMenuItem("薪資信息查詢");wageS.setFont(f);employeeSM.add(trainS);employeeSM.add(employeeS);employeeSM.add(encouragementPunishS);employeeSM.add(wageS);selectM.add(employeeSM);selectM.add(departmentS);//為查詢菜單加事件departmentS.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.out.println("DIQ");deskpane.add(newDIQ());}});employeeS.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.out.println("BIQ");deskpane.add(newBIQ());}});trainS.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.out.println("TIQ");deskpane.add(newTIQ());}});encouragementPunishS.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.out.println("EPIQ");deskpane.add(newEPIQ());}});wageS.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.out.println("SIQ");deskpane.add(newSIQ());}});JMenuItemhelp=newJMenuItem("幫助");help.setFont(f);JMenuItemabout=newJMenuItem("關于");about.setFont(f);helpM.add(help);aboutM.add(about);//為幫助菜單加事件about.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){deskpane.add(newAbout());}});mb.add(systemM);mb.add(manageM);mb.add(selectM);mb.add(helpM);mb.add(aboutM);setJMenuBar(mb);Imageimg=Toolkit.getDefaultToolkit().getImage("imagemain.gif");setIconImage(img);systemM.setIcon(icon9);manageM.setIcon(icon8);selectM.setIcon(icon7);helpM.setIcon(icon6);addDelete.setIcon(icon1);land.setIcon(icon2);password.setIcon(icon3);exit.setIcon(icon4);employeeMM.setIcon(icon5);employeeSM.setIcon(icon5);departmentM.setIcon(icon10);departmentS.setIcon(icon11);help.setIcon(icon6);aboutM.setIcon(icon13);about.setIcon(icon13);employeeM.setIcon(icon14);trainM.setIcon(icon14);encouragementPunishM.setIcon(icon14);wageM.setIcon(icon14);employeeS.setIcon(icon15);trainS.setIcon(icon15);encouragementPunishS.setIcon(icon15);wageS.setIcon(icon15);JToolBarjToolBar1=newJToolBar();jToolBar1.setLayout(newGridLayout(9,1));JButtonjButton1=newJButton();jButton1.setToolTipText("員工基本信息管理");JButtonjButton2=newJButton();jButton2.setToolTipText("員工基本信息查詢");JButtonjButton3=newJButton();jButton3.setToolTipText("修改密碼");JButtonjButton5=newJButton();jButton5.setToolTipText("計算器");JButtonjButton6=newJButton();jButton6.setToolTipText("退出系統(tǒng)");jToolBar1.setMaximumSize(newjava.awt.Dimension(600,jToolBar1.setMinimumSize(newjava.awt.Dimension(600,50));//添加工具欄中按鈕的方法jButton1.setIcon(newImageIcon("image1.png"));jButton1.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.out.println("Employeemanage");deskpane.add(newEmployeemanage());}});jToolBar1.add(jButton1);jButton2.setIcon(newImageIcon("image2.png"));jButton2.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){deskpane.add(newBIQ());}});jToolBar1.add(jButton2);jButton3.setIcon(newImageIcon("image3.png"));jButton3.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){deskpane.add(newAmendPassword());}});jToolBar1.add(jButton3);jButton5.setIcon(newImageIcon("image5.png"));jButton5.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.out.println("Calculator");deskpane.add(newCalculator());}});jToolBar1.add(jButton5);jButton6.setIcon(newjavax.swing.ImageIcon("image6.png"));jButton6.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){System.exit(0);}});jToolBar1.add(jButton6);jToolBar1.setBounds(0,0,30,600);jToolBar1.setEnabled(false);con.add(jToolBar1,BorderLayout.WEST);p.setLayout(newBorderLayout());p.add(lp1,BorderLayout.EAST);t.start();con.add(p,BorderLayout.SOUTH);Toolkitt=Toolkit.getDefaultToolkit();intwidth=t.getScreenSize().width-intheight=t.getScreenSize().height-100;setSize(width,height);setLocation(150,100);setVisible(true);setResizable(false);}//線程的方法publicvoidrun(){System.out.println("線程啟動了!");Toolkitt=Toolkit.getDefaultToolkit();intx=t.getScreenSize().width;System.out.println("x="+x);lp1.setForeground(Color.red);while(true){if(x<-600){x=t.getScreenSize().width;}lp1.setBounds(x,0,700,20);x-=10;try{Thread.sleep(100);}catch(Exceptione){}}}publicstaticvoidmain(String[]args){newMain();}}//數(shù)據(jù)庫聯(lián)接類packageclasssource;importjava.sql.*;publicclassDatabase{publicstaticConnectioncn;publicstaticStatementst;publicstaticResultSetrs;publicstaticbooleanjoinDB(){booleanjoinFlag;try{joinFlag=true;Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");cn=DriverManager.getConnection("jdbc:odbc:EmployeeInformationMS","sa","");cn.setCatalog("EmployeeInformationMS");System.out.println("數(shù)據(jù)庫連接成功");st=cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);returnjoinFlag;}catch(SQLExceptionsqlEx){System.out.println(sqlEx.getMessage());joinFlag=false;returnjoinFlag;}catch(ClassNotFoundExceptionnotfoundEX){System.out.println(notfoundEX.getMessage());joinFlag=false;returnjoinFlag;}}publicstaticbooleanexecuteSQL(StringsqlString){booleanexecuteFlag;try{st.execute(sqlString);executeFlag=true;}catch(Exceptione){executeFlag=false;System.out.println("sqlexception:"+e.getMessage());}returnexecuteFlag;}publicstaticbooleanquery(StringsqlString){try{rs=null;//System.out.println(sqlString);rs=st.executeQuery(sqlString);}catch(ExceptionEx){System.out.println("sqlexception:"+Ex);returnfalse;}returntrue;}}//添加刪除用戶類packageclasssource;importjava.awt.event.*;importjava.awt.*;importjavax.swing.*;importjava.sql.*;publicclassAddDeleteUserextendsjavax.swing.JInternalFrame{privateJButtonbutACancel,butDCancel,butDelete,butOk;privateJComboBoxcbUserName;privateJLabeljLabel1,jLabel2,jLabel3,jLabel4,jLabel5;privateJPasswordFieldpas1,pas2,pas3;privateJTextFieldtxtname;publicAddDeleteUser(){initComponents();this.setVisible(true);this.setClosable(true);this.setSize(268,350);}privatevoidinitComponents()jLabel1=newJLabel();jLabel2=newJLabel();jLabel3=newJLabel();txtname=newJTextField();pas1=newJPasswordField();pas2=newJPasswordField();butOk=newJButton();butACancel=newJButton();jLabel4=newJLabel();cbUserName=newjLabel5=newJLabel();pas3=newJPasswordField();butDelete=newJButton();butDCancel=newJButton();getContentPane().setLayout(null);jLabel1.setText("新用戶名:");getContentPane().add(jLabel1);jLabel1.setBounds(30,30,70,20);jLabel2.setText("輸入密碼:");getContentPane().add(jLabel2);jLabel2.setBounds(30,60,70,18);jLabel3.setText("確認密碼:");getContentPane().add(jLabel3);jLabel3.setBounds(30,90,60,18);getContentPane().add(txtname);txtname.setBounds(100,30,130,24);getContentPane().add(pas1);pas1.setBounds(100,60,130,24);getContentPane().add(pas2);pas2.setBounds(100,90,130,24);butOk.setText("添加");getContentPane().add(butOk);butOk.setBounds(80,130,70,27);butACancel.setText("清空");getContentPane().add(butACancel);butACancel.setBounds(160,130,70,27);jLabel4.setText("已有用戶名:");getContentPane().add(jLabel4);jLabel4.setBounds(30,180,80,18);getContentPane().add(cbUserName);cbUserName.setBounds(100,180,130,24);jLabel5.setText("密碼:");getContentPane().add(jLabel5);jLabel5.setBounds(30,210,60,18);getContentPane().add(pas3);pas3.setBounds(100,216,130,24);butDelete.setText("刪除");getContentPane().add(butDelete);butDelete.setBounds(79,260,70,27);butDCancel.setText("清空");getContentPane().add(butDCancel);butDCancel.setBounds(160,260,70,//將所有用用戶名讀出來Database.joinDB();Stringsql="select*fromUserInformation";try{if(Database.query(sql)){while(Database.rs.next()){Stringname=Database.rs.getString("User_Name");cbUserName.addItem(name);}}}catch(Exceptione){}//為添加和取消按鈕加事件 butOk.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){if(txtname.getText().equals("")){newJOptionPane().showMessageDialog(null,"用戶名不能為空!");}elseif(pas1.getText().equals("")){newJOptionPane().showMessageDialog(null,"密碼不能為空!");}elseif(pas1.getText().equals(pas2.getText())){Stringsql="insertUserInformationvalues('"+txtname.getText()+"','"+pas1.getText()+"','B')";try{if(Database.executeSQL(sql)){newJOptionPane().showMessageDialog(null,"");cbUserName.addItem(txtname.getText());}}catch(Exceptionea){}}}});butACancel.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){txtname.setText("");pas1.setText("");pas2.setText("");}});//為刪除和取消按鈕加事件 butDelete.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){Stringname=""+cbUserName.getSelectedItem();Stringsql="select*fromUserInformationwhereUser_Name='"+name+"'";try{if(Database.query(sql)){Database.rs.next();Stringpas=pas3.getText();Stringpassword=Database.rs.getString("Password");System.out.println(password);if(pas.equals(password)){Stringsdelete="deletefromUserInformationwhereUser_Name='"+name+"'";if(Database.executeSQL(sdelete)){newJOptionPane().showMessageDialog(null,"除成功！");pas3.setText("");cbUserName.removeAllItems();Stringsql1="select*fromUserInformation";if(Database.query(sql1)){while(Database.rs.next()){Stringname1=Database.rs.getString("User_Name");cbUserName.addItem(name1);}}}}else{newJOptionPane().showMessageDialog(null,"");}}}catch(Exceptionel){System.out.println(el);}}});butDCancel.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){pas3.setText("");}});}}//修改密碼類packageclasssource;importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjava.sql.*;publicclassAmendPasswordextendsJInternalFrame{JLabellbe1=newJLabel("修改密碼");JPanelp=newJPanel();publicAmendPassword(){setTitle("修改密碼");p.add(lbe1);AmendPanelpanel=newAmendPanel();ContainercontentPane=getContentPane();contentPane.add(p,"North");contentPane.add(panel,"Center");setBounds(100,100,280,260);this.setClosable(true);setVisible(true);}}classAmendPanelextendsJPanel{JButtonb1,b2;JLabellbe2,lbe3,lbe4,lbe5;JPasswordFieldpas1,pas2,pas3;JComboBoxtf;publicAmendPanel(){lbe2=newJLabel("用戶名:");lbe3=newJLabel("lbe4=newJLabel("lbe5=newJLabel("tf=newJComboBox();pas1=newJPasswordField();pas2=newJPasswordField();pas3=newJPasswordField();b1=newJButton("確定");b2=newJButton("清空");add(lbe2);lbe2.setBounds(16,10,90,25);this.add(tf);tf.setBounds(100,10,120,25);add(lbe3);lbe3.setBounds(16,45,90,25);add(pas1);pas1.setBounds(100,45,120,25);add(lbe4);lbe4.setBounds(16,80,80,25);add(pas2);pas2.setBounds(100,80,120,25);add(lbe5);lbe5.setBounds(16,115,80,25);add(pas3);pas3.setBounds(100,115,120,25);add(b1);b1.setBounds(100,160,60,30);add(b2);b2.setBounds(160,160,60,30);setLayout(null);//將所有用用戶名讀出來Database.joinDB();Stringsql="select*fromUserInformation";try{if(Database.query(sql)){while(Database.rs.next()){Stringname=Database.rs.getString("User_Name");tf.addItem(name);}}}catch(Exceptione){}//為確定取消按鈕加事件b1.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){Stringname=""+tf.getSelectedItem();System.out.println(name);Stringsql="select*fromUserInformationwhereUser_Name='"+name+"'";System.out.println(sql);try{if(Database.query(sql)){Database.rs.next();Stringps1=pas1.getText();Stringpassword=Database.rs.getString("Password");if(ps1.equals(password)){if(pas2.getText().equals(pas3.getText())){Stringsupdate="updateUserInformationsetPassword='"+pas3.getText()+"'whereUser_Name='"+name+"'";Database.executeSQL(supdate);newJOptionPane().showMessageDialog(null,"改成功！");}else{newJOptionPane().showMessageDialog(null,"碼不同！");}}else{newJOptionPane().showMessageDialog(null,"確！");}}}catch(Exceptionel){System.out.println(el);}}});b2.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEventpas1.setText("");pas2.setText("");pas3.setText("");}});}}//關于類packageclasssource;importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;publicclassAboutextendsJInternalFrame{JLabellabel=newJLabel("運行環(huán)境：Windows");JLabellabe2=newJLabel("開發(fā)語言：JAVA");JLabellabe3=newJLabel("數(shù)據(jù)庫類型：SqlServer2000");publicAbout(){setTitle("關于");Containercon=getContentPane();con.setLayout(newGridLayout(4,1));con.add(label);con.add(labe2);con.add(labe3);con.setBackground(Color.white);setResizable(false);setSize(380,220);setVisible(true);setClosable(true);}}//員工信息查詢類packageclasssource;importjava.awt.*;importjavax.swing.*;importjavax.swing.table.*;importjava.awt.event.*;importjava.util.*;importjavax.swing.JScrollPane.*;importjava.sql.*;publicclassBIQextendsJInternalFrame{JLabellbl1=newJLabel("基本信息查詢");JLabellbl2=newJLabel("員工編號：");JLabellbl3=newJLabel("員工姓名：");JTextFieldbtxtid=newJTextField(10);JTextFieldbtxtname=newJTextField(10);JButtonbtn1=newJButton("查詢");JTabletable;DefaultTableModeldtm;Stringcolumns[]={"員工編號","員工姓名","性別","出生日期","婚姻狀況","政治面貌","學歷","進入公司時間","轉(zhuǎn)正時間","部門","職務","員工狀態(tài)","備注"};publicBIQ(){setTitle("基本信息查詢");dtm=newDefaultTableModel();table=newJTable(dtm);JScrollPanesl=newJScrollPane();sl.getViewport().add(table);dtm.setColumnCount(5);dtm.setColumnIdentifiers(columns);getContentPane().setLayout(null);lbl1.setBounds(240,10,300,30);lbl1.setFont(newFont("宋體",Font.BOLD,24));getContentPane().add(lbl1);Fontf=newFont("宋體",Font.PLAIN,12);lbl2.setBounds(10,60,80,25);lbl2.setFont(f);getContentPane().add(lbl2);btxtid.setBounds(80,60,80,23);btxtid.setFont(f);getContentPane().add(btxtid);lbl3.setBounds(10,90,80,25);lbl3.setFont(f);getContentPane().add(lbl3);btxtname.setBounds(80,90,80,23);btxtname.setFont(f);getContentPane().add(btxtname);btn1.setBounds(90,130,60,25);btn1.setFont(f);getContentPane().add(btn1);sl.setBounds(180,60,500,370);getContentPane().add(sl);//設置邊框btxtid.setBorder(BorderFactory.createLineBorder(Color.black));btxtname.setBorder(BorderFactory.createLineBorder(Color.black));btn1.setBorder(BorderFactory.createRaisedBevelBorder());sl.setBorder(BorderFactory.createLineBorder(Color.black));// 連接數(shù)據(jù)庫Database.joinDB();Stringsql="select*fromEmployeeInformation";if(Database.query(sql)){System.out.println(sql);try{while(Database.rs.next()){StringeNumber=(""+Database.rs.getInt("E_Number"));System.out.println(eNumber);StringeName=Database.rs.getString("E_Name");System.out.println(eName);StringeSex=Database.rs.getString("E_Sex");System.out.println(eSex);StringeBornDate=Database.rs.getString("E_BornDate");System.out.println(eBornDate);StringeMarriage=Database.rs.getString("E_Marriage");System.out.println(eMarriage);StringePoliticsVisage=Database.rs.getString("E_PoliticsVisage");System.out.println(ePoliticsVisage);StringeSchoolAge=Database.rs.getString("E_SchoolAge");System.out.println(eSchoolAge);StringeEnterDate=Database.rs.getString("E_EnterDate");System.out.println(eEnterDate);StringeInDueFormDate=Database.rs.getString("E_InDueFormDate");System.out.println(eInDueFormDate);StringeDepartment=Database.rs.getString("E_Department");System.out.println(eDepartment);StringeHeadship=Database.rs.getString("E_Headship");System.out.println(eHeadship);StringeEstate=Database.rs.getString("E_Estate");System.out.println(eEstate);StringeRemark=Database.rs.getString("E_Remark");System.out.println(eRemark);Vectorv=newVector();v.add(eNumber);v.add(eName);v.add(eSex);v.add(eBornDate);v.add(eMarriage);v.add(ePoliticsVisage);v.add(eSchoolAge);v.add(eEnterDate);v.add(eInDueFormDate);v.add(eDepartment);v.add(eHeadship);v.add(eEstate);v.add(eRemark);dtm.addRow(v);}}catch(ExceptioneBIQ){System.out.println("初始化數(shù)據(jù)失??！");}}//為查詢按鈕加事件btn1.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEventeBIQ){System.out.println("按鈕事件");Stringesql;intrc=dtm.getRowCount();for(inti=0;i<rc;i++){dtm.removeRow(0);}if(btxtid.getText().equals("")&&btxtname.getText().equals("")){esql="select*fromEmployeeInformation";}elseif(btxtname.getText().equals("")){esql="select*fromEmployeeInformationwhereE_Number='"+btxtid.getText()+"'";}else{esql="select*fromEmployeeInformationwhereE_Number='"+btxtid.getText()+"'orE_Namelike'%"+btxtname.getText()+"%'";}System.out.println(esql);if(Database.query(esql)){try{while(Database.rs.next()){StringeNumber=(""+Database.rs.getInt("E_Number"));System.out.println(eNumber);StringeName=Database.rs.getString("E_Name");System.out.println(eName);StringeSex=Database.rs.getString("E_Sex");System.out.println(eSex);StringeBornDate=Database.rs.getString("E_BornDate");System.out.println(eBornDate);StringeMarriage=Database.rs.getString("E_Marriage");System.out.println(eMarriage);StringePoliticsVisage=Database.rs.getString("E_PoliticsVisage");System.out.println(ePoliticsVisage);StringeSchoolAge=Database.rs.getString("E_SchoolAge");System.out.println(eSchoolAge);StringeEnterDate=Database.rs.getString("E_EnterDate");System.out.println(eEnterDate);StringeInDueFormDate=Database.rs.getString("E_InDueFormDate");System.out.println(eInDueFormDate);StringeDepartment=Database.rs.getString("E_Department");System.out.println(eDepartment);StringeHeadship=Database.rs.getString("E_Headship");System.out.println(eHeadship);StringeEstate=Database.rs.getString("E_Estate");System.out.println(eEstate);StringeRemark=Database.rs.getString("E_Remark");System.out.println(eRemark);Vectorv=newVector();v.add(eNumber);v.add(eName);v.add(eSex);v.add(eBornDate);v.add(eMarriage);v.add(ePoliticsVisage);v.add(eSchoolAge);v.add(eEnterDate);v.add(eInDueFormDate);v.add(eDepartment);v.add(eHeadship);v.add(eEstate);v.add(eRemark);dtm.addRow(v);}}catch(ExceptioneB){}}}});setSize(700,480);this.setClosable(true);setVisible(true);}}packageclasssource;importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjavax.swing.table.*;importjava.util.*;importjava.sql.*;publicclassDIQextendsJInternalFrame{JLabellb1=newJLabel("部門信息查詢");JLabellb2=newJLabel("部門編號：");JLabellb3=newJLabel("部門名稱：");JTextFieldsetxtid=newJTextField(10);JTextFieldsetxtname=newJTextField(10);JButtonbtn1=newJButton("查詢");JTabletable;DefaultTableModeldtm;Stringcolumns[]={"部門編號","部門名稱","部門人數(shù)"};publicDIQ(){setTitle("部門信息查詢");dtm=newDefaultTableModel();table=newJTable(dtm);JScrollPanesl=newJScrollPane(table);dtm.setColumnCount(3);dtm.setColumnIdentifiers(columns);getContentPane().setLayout(null);lb1.setBounds(200,10,300,30);lb1.setFont(newFont("宋體",Font.BOLD,24));getContentPane().add(lb1);Fontf=newFont("宋體",Font.PLAIN,12);lb2.setBounds(10,60,80,25);lb2.setFont(f);getContentPane().add(lb2);setxtid.setBounds(80,60,80,23);setxtid.setFont(f);getContentPane().add(setxtid);lb3.setBounds(10,90,80,25);lb3.setFont(f);getContentPane().add(lb3);setxtname.setBounds(80,90,80,23);setxtname.setFont(f);getContentPane().add(setxtname);btn1.setBounds(90,130,60,25);btn1.setFont(f);getContentPane().add(btn1);sl.setBounds(180,60,425,290);getContentPane().add(sl);//設置邊框setxtid.setBorder(BorderFactory.createLineBorder(Color.black));setxtname.setBorder(BorderFactory.createLineBorder(Color.black));btn1.setBorder(BorderFactory.createRaisedBevelBorder());sl.setBorder(BorderFactory.createLineBorder(Color.black));//連接數(shù)據(jù)庫Database.joinDB();//為表格初使化數(shù)據(jù)Stringcsf="select*fromDepartmentInformation";if(Database.query(csf)){try{while(Database.rs.next()){Stringnum=(""+Database.rs.getInt("D_Number"));System.out.println(num);Stringname=Database.rs.getString("D_Name");System.out.println(name);Stringcount=Database.rs.getString("D_Count");System.out.println(count);Vectorv=newVector();v.add(num);v.add(name);v.add(count);dtm.addRow(v);}}catch(Exceptionecsf){System.out.println("初使化表格數(shù)據(jù)出錯!");}}//為查詢按鈕加事件btn1.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){Stringsql;intrc=dtm.getRowCount();//System.out.println(dtm.getRowCount());for(inti=0;i<rc;i++){dtm.removeRow(0);}if(setxtid.getText().equals("")&&setxtname.getTex