java開(kāi)發(fā)的畢業(yè)設(shè)計(jì)員工管理系統(tǒng)

文檔塊2012年員工管理系統(tǒng)需求文檔.doc需求文檔軟件名稱(chēng)：?jiǎn)T工管理系統(tǒng)一．概述： 在人才過(guò)剩的今天，企業(yè)對(duì)于有用人才的需求逐步加大，企業(yè)內(nèi)部的人事變動(dòng)和部門(mén)規(guī)劃也開(kāi)始加速，傳統(tǒng)的人事檔案已經(jīng)不能滿(mǎn)足各個(gè)企業(yè)的人員流動(dòng)速度，迫使人們起用新的管理方法來(lái)管理員工的相關(guān)信息?？茖W(xué)技術(shù)日新月異的進(jìn)步，讓人類(lèi)生活發(fā)生了巨大的變化，計(jì)算機(jī)技術(shù)的飛速發(fā)展，使各行各業(yè)在計(jì)算機(jī)技術(shù)應(yīng)用方面得到了廣泛的普及和使用。信息化時(shí)代的到來(lái)成為不可抗拒的潮流，人類(lèi)文明正在進(jìn)入一個(gè)嶄新的時(shí)代。因此，員工管理系統(tǒng)也以方便、快捷、費(fèi)用低、綠色環(huán)保的優(yōu)點(diǎn)正慢慢地進(jìn)入各個(gè)行業(yè)和領(lǐng)域，將傳統(tǒng)的員工管理方式徹底的解脫出來(lái)，提高效率，減輕工人人員以往繁忙的工作，加速信息的更新速度，使企業(yè)管理層第一時(shí)間了解到員工的信息，從而進(jìn)一步的進(jìn)行對(duì)員工的調(diào)配。二．功能需求 詳細(xì)說(shuō)明：—增加— 增加員工的基本信息、培訓(xùn)信息、獎(jiǎng)罰信息、薪資信息—?jiǎng)h除— 可根據(jù)員工的編號(hào)及姓名等資料的刪除—修改— 用戶(hù)可以對(duì)員工的姓名和編號(hào)、進(jìn)行修改。—查詢(xún)— 用戶(hù)可以根據(jù)姓名、編號(hào)，準(zhǔn)確的查到要找的員工，也可以選擇部門(mén)，查看選中的部門(mén)的所有員工。—輔助— 可以調(diào)用單獨(dú)制作的計(jì)算器進(jìn)行數(shù)字計(jì)算，節(jié)省操作時(shí)間三.設(shè)計(jì)操作界面登陸窗口：主窗體：?jiǎn)T工管理系統(tǒng)數(shù)據(jù)字典.doc員工管理系統(tǒng)（數(shù)據(jù)字典）庫(kù)名（EmployeeInformationMS）用戶(hù)信息表（UserInformation）字段類(lèi)型說(shuō)明大小是否為空User_IDInt員工編號(hào)NOTNULLUser_Namevarchar員工姓名20NOTNULLPasswordvarchar密碼20NOTNULLPopedomvarchar權(quán)限20NOTNULL部門(mén)信息管理（DepartmentInformation）字段類(lèi)型說(shuō)明大小是否為空D_Numberint部門(mén)編號(hào)NOTNULLD_Namevarchar部門(mén)名稱(chēng)20NOTNULLD_Countvarchar部門(mén)人數(shù)20NOTNULL員工基本信息表（EmployeeInformation）字段類(lèi)型說(shuō)明大小是否為空E_Numberint--員工編號(hào)NOTNULLE_Namevarchar--姓名20NOTNULLE_Sexvarchar--性別2NOTNULLE_BornDatevarchar--出生日期30NOTNULLE_Marriagevarchar--婚姻狀態(tài)4NOTNULLE_PoliticsVisagevarchar政治面貌20NOTNULLE_SchoolAgevarchar學(xué)歷20NOTNULLE_EnterDatevarchar進(jìn)入公司時(shí)間30NOTNULLE_InDueFormDatevarchar轉(zhuǎn)正時(shí)間30NOTNULLE_Departmentvarchar部門(mén)20NOTNULLE_Headshipvarchar職務(wù)20NOTNULLE_Estatevarchar狀態(tài)20NOTNULLE_Remarkvarchar備注500NOTNULL培訓(xùn)信息表（TrainInformation）字段類(lèi)型說(shuō)明大小是否為空T_Numbervarchar培訓(xùn)編號(hào)20NOTNULLT_Contentvarchar培訓(xùn)內(nèi)容100NOTNULLT_Namevarchar培訓(xùn)員工姓名20NOTNULLT_Dateint培訓(xùn)天數(shù)NOTNULLT_Moneyint培訓(xùn)費(fèi)用NOTNULL獎(jiǎng)罰信息表（EncouragementPunishInformation）字段類(lèi)型說(shuō)明大小是否為空EP_Numberint員工編號(hào)NOTNULLEP_Namevarchar員工姓名30NOTNULLEP_Datevarchar獎(jiǎng)罰時(shí)間30NOTNULLEP_Addressvarchar獎(jiǎng)罰地點(diǎn)50NOTNULLEP_Causationvarchar獎(jiǎng)罰原因200NOTNULLEP_Remarkvarchar備注500NOTNULL薪資信息表（WageInformation）字段類(lèi)型說(shuō)明大小是否為空W_Numberint員工編號(hào)NOTNULLW_Namevarchar員工姓名30NOTNULLW_BasicWageint基本工資NOTNULLW_Boonint福利NOTNULLW_Bonusint獎(jiǎng)金NOTNULLW_CountMethodvarchar計(jì)算方法50NOTNULLW_FactWageint實(shí)發(fā)工資NOTNULL員工管理系統(tǒng).ppt數(shù)據(jù)庫(kù)文件EmployeeInformationMSok.sqlCREATEDATABASEEmployeeInformationMS--DROPDATABASEEmployeeInformationMSgoUSEEmployeeInformationMSgo/*用戶(hù)信息表*/CREATETABLEUserInformation(User_IDINTIDENTITY(1,1),User_NameVARCHAR(20)NOTNULL,PasswordVARCHAR(20)NOTNULL,PopedomVARCHAR(20)DEFAULT'B',--權(quán)限)goINSERTUserInformationVALUES('管理員','123','A')INSERTUserInformation(User_Name,Password)VALUES('admin','123456')--TRUNCATETABLEUserInformation--SELECT*FROMUserInformationgo/*部門(mén)信息表*/CREATETABLEDepartmentInformation(D_NumberINTIDENTITY(1,1),D_NameVARCHAR(20)NOTNULL,D_CountVARCHAR(20)NOTNULL,)goINSERTDepartmentInformationVALUES('市場(chǎng)部','50')INSERTDepartmentInformationVALUES('教學(xué)部','65')INSERTDepartmentInformationVALUES('財(cái)會(huì)部','26')INSERTDepartmentInformationVALUES('培訓(xùn)部','52')INSERTDepartmentInformationVALUES('后勤部','69')INSERTDepartmentInformationVALUES('就業(yè)部','66')INSERTDepartmentInformationVALUES('策劃部','50')INSERTDepartmentInformationVALUES('軟件開(kāi)發(fā)部','67')INSERTDepartmentInformationVALUES('招生部','26')go/*員工基本信息表*/CREATETABLEEmployeeInformation(E_NumberINTIDENTITY(1,1),--員工編號(hào)E_NameVARCHAR(30)NOTNULL,--姓名E_SexVARCHAR(2)NOTNULL,--性別E_BornDateVARCHAR(30)NOTNULL,--出生日期E_MarriageVARCHAR(4)NOTNULL,--婚姻狀態(tài)E_PoliticsVisageVARCHAR(20)NOTNULL,--政治面貌E_SchoolAgeVARCHAR(20)NOTNULL,--學(xué)歷E_EnterDateVARCHAR(30)NOTNULL,--進(jìn)入公司時(shí)間E_InDueFormDateVARCHAR(30)NOTNULL,--轉(zhuǎn)正時(shí)間E_DepartmentVARCHAR(20)NOTNULL,--部門(mén)E_HeadshipVARCHAR(20)NOTNULL,--職務(wù)E_EstateVARCHAR(10)NOTNULL,--狀態(tài)E_RemarkVARCHAR(500),--備注)goINSERTEmployeeInformationVALUES('張三','女','1980年9月29日','未婚','黨員','本科','2004年9月10日','2004年12月10日','教學(xué)部','主管','在職','高級(jí)講師')INSERTEmployeeInformationVALUES('aaa','男','1980年6月24日','未婚','黨員','本科','2004年9月10日','2004年12月10日','軟件開(kāi)發(fā)','主管','在職','高級(jí)工程師')SELECT*FROMEmployeeInformation--DELETEFROMEmployeeInformationwhereE_Name='張三'go/*培訓(xùn)信息表*/CREATETABLETrainInformation(T_NumberVARCHAR(20)NOTNULL,--培訓(xùn)編號(hào)T_ContentVARCHAR(100)NOTNULL,--培訓(xùn)內(nèi)容T_NameVARCHAR(20)NOTNULL,--培訓(xùn)員工姓名T_DateINTNotNULL,--培訓(xùn)天數(shù)T_MoneyINT--培訓(xùn)費(fèi)用)goINSERTTrainInformationVALUES('2007_001','職業(yè)素質(zhì)','張三',30,7000)INSERTTrainInformationVALUES('2007_002','職業(yè)素質(zhì)','姚明',30,7000)INSERTTrainInformationVALUES('2007_003','職業(yè)素質(zhì)','宋成',30,7000)INSERTTrainInformationVALUES('2007_004','職業(yè)素質(zhì)','甘小發(fā)',30,7000)INSERTTrainInformationVALUES('2007_005','職業(yè)素質(zhì)','陳天橋',30,7000)INSERTTrainInformationVALUES('2007_006','職業(yè)素質(zhì)','劉小成',30,7000)INSERTTrainInformationVALUES('2007_007','職業(yè)素質(zhì)','彭煌',30,7000)INSERTTrainInformationVALUES('2007_008','職業(yè)素質(zhì)','劉一發(fā)',30,7000)INSERTTrainInformationVALUES('2007_009','職業(yè)素質(zhì)','胡來(lái)',30,7000)--SELECT*FROMTrainInformationgo/*獎(jiǎng)罰信息表*/CREATETABLEEncouragementPunishInformation(EP_NumberINTIDENTITY(1,1),EP_NameVARCHAR(30)NOTNULL,EP_DateVARCHAR(30)NOTNULL,EP_AddressVARCHAR(50)NOTNULL,EP_CausationVARCHAR(200)NOTNULL,--獎(jiǎng)罰原因EP_RemarkVARCHAR(500),--備注)goINSERTEncouragementPunishInformationVALUES('張三','2006年5月3日','教學(xué)館二樓','演講比賽一等獎(jiǎng)','afa')INSERTEncouragementPunishInformationVALUES('劉一發(fā)','2004年5月3日','教學(xué)館二樓','演講比賽一等獎(jiǎng)','aaaa')--SELECT*FROMEncouragementPunishInformationgo/*薪資信息表*/CREATETABLEWageInformation(W_NumberINTIDENTITY(1,1),W_NameVARCHAR(30)NOTNULL,--員工姓名W_BasicWageINTNOTNULL,--基本工資W_BoonINTNOTNULL,--福利W_BonusINTNOTNULL,--獎(jiǎng)金W_CountMethodVARCHAR(50)NOTNULL,--計(jì)算方法W_FactWageINTNOTNULL,--實(shí)發(fā)工資)--SELECT*FROMWageInformationINSERTWageInformationVALUES('張三','3000','300','200','基本工資+福利+獎(jiǎng)金',3500)INSERTWageInformationVALUES('麻五','3000','300','200','基本工資+福利+獎(jiǎng)金',3500)INSERTWageInformationVALUES('Andy','3000','300','200','基本工資+福利+獎(jiǎng)金',3500)INSERTWageInformationVALUES('陳一邦','3000','300','200','基本工資+福利+獎(jiǎng)金',3500)INSERTWageInformationVALUES('姚明','3000','300','200','基本工資+福利+獎(jiǎng)金',3500)INSERTWageInformationVALUES('胡來(lái)','3000','300','200','基本工資+福利+獎(jiǎng)金',3500)INSERTWageInformationVALUES('秋若','3000','300','200','基本工資+福利+獎(jiǎng)金',3500)INSERTWageInformationVALUES('宋成','3000','300','200','基本工資+福利+獎(jiǎng)金',3500)在數(shù)據(jù)庫(kù)生成的是：源代碼About.java//關(guān)于軟件類(lèi)packageclasssource;importjava.awt.*;//倒包importjava.awt.event.*;//倒包importjavax.swing.*;//倒包publicclassAboutextendsJInternalFrame{ JLabellabel=newJLabel("運(yùn)行環(huán)境：Windows");//創(chuàng)建標(biāo)簽并實(shí)例化 JLabellabe2=newJLabel("開(kāi)發(fā)語(yǔ)言：JAVA");//創(chuàng)建標(biāo)簽并實(shí)例化 JLabellabe3=newJLabel("數(shù)據(jù)庫(kù)類(lèi)型：SqlServer2000");//創(chuàng)建標(biāo)簽并實(shí)例化 JLabellabe4=newJLabel("開(kāi)發(fā)人員：張揚(yáng)、王麗霞、高旭、李?lèi)?ài)全");//創(chuàng)建標(biāo)簽并實(shí)例化 publicAbout(){//構(gòu)造方法 setTitle("關(guān)于");//設(shè)置標(biāo)題 Containercon=getContentPane();con.setLayout(newGridLayout(4,1));//設(shè)置網(wǎng)格布局con.add(label);//添加標(biāo)簽con.add(labe2);//添加標(biāo)簽con.add(labe3);//添加標(biāo)簽con.add(labe4);//添加標(biāo)簽con.setBackground(Color.green);//添加背景顏色 setResizable(false);//不可更改大小 setSize(380,220);//設(shè)置大小 setVisible(true);//可見(jiàn) setClosable(true);//設(shè)置可以關(guān)閉 } }AddDeleteUser.java//添加刪除用戶(hù)類(lèi)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(){//空構(gòu)造initComponents();this.setVisible(true);this.setClosable(true);this.setSize(268,350);}privatevoidinitComponents(){ //實(shí)例化并添加控件jLabel1=newJLabel();jLabel2=newJLabel();jLabel3=newJLabel();txtname=newJTextField();pas1=newJPasswordField();pas2=newJPasswordField();butOk=newJButton();butACancel=newJButton();jLabel4=newJLabel();cbUserName=newJComboBox();jLabel5=newJLabel();pas3=newJPasswordField();butDelete=newJButton();butDCancel=newJButton();//實(shí)例化并添加控件完成getContentPane().setLayout(null);//設(shè)置布局//為空間放置具體位置jLabel1.setText("新用戶(hù)名:");getContentPane().add(jLabel1);jLabel1.setBounds(30,30,70,20);jLabel2.setText("輸入密碼:");getContentPane().add(jLabel2);jLabel2.setBounds(30,60,70,18);jLabel3.setText("確認(rèn)密碼:");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("已有用戶(hù)名:");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,27);//為空間放置具體位置結(jié)束//將所有用用戶(hù)名讀出來(lái)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,"用戶(hù)名不能為空!"); } 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(""); } });//--------------------------------------------------------------}}AmendPassword.java//修改密碼類(lèi)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);//setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);}//publicstaticvoidmain(String[]args){// newAmendPassword();// }}classAmendPanelextendsJPanel{JButtonb1,b2;JLabellbe2,lbe3,lbe4,lbe5;JPasswordFieldpas1,pas2,pas3;JComboBoxtf;publicAmendPanel(){lbe2=newJLabel("用戶(hù)名:");lbe3=newJLabel("輸入舊密碼:");lbe4=newJLabel("輸入新密碼:");lbe5=newJLabel("確定新密碼:");tf=newJComboBox();pas1=newJPasswordField();pas2=newJPasswordField();pas3=newJPasswordField();b1=newJButton("確定");b2=newJButton("清空");//把組件加在內(nèi)容窗格中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);//將所有用用戶(hù)名讀出來(lái)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(ActionEvente){ pas1.setText(""); pas2.setText(""); pas3.setText(""); } });}}BIQ.java//員工信息查詢(xún)類(lèi)packageclasssource;importjava.awt.*;importjavax.swing.*;importjavax.swing.table.*;importjava.awt.event.*;importjava.util.*;importjavax.swing.JScrollPane.*;importjava.sql.*;publicclassBIQextendsJInternalFrame{ JLabellbl1=newJLabel("基本信息查詢(xún)"); JLabellbl2=newJLabel("員工編號(hào)："); JLabellbl3=newJLabel("員工姓名："); JTextFieldbtxtid=newJTextField(10); JTextFieldbtxtname=newJTextField(10); JButtonbtn1=newJButton("查詢(xún)"); JTabletable; DefaultTableModeldtm;Stringcolumns[]={"員工編號(hào)","員工姓名","性別","出生日期","婚姻狀況","政治面貌","學(xué)歷","進(jìn)入公司時(shí)間","轉(zhuǎn)正時(shí)間","部門(mén)","職務(wù)","員工狀態(tài)","備注"}; publicBIQ(){ setTitle("基本信息查詢(xún)"); dtm=newDefaultTableModel(); table=newJTable(dtm); JScrollPanesl=newJScrollPane(); sl.getViewport().add(table); dtm.setColumnCount(5); dtm.setColumnIdentifiers(columns); // sl.getViewport().add(table,null); //sl.setVerticalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS); //sl.setver//// sl.HORIZONTAL_SCROLLBAR_ALWAYS;// sl.VERTICAL_SCROLLBAR_ALWAYS; //newJScrollPane().add(table); //dtm.setColumnCount(columns.length); // dtm.insertRow(0,columns); //sl.setAutoscrolls(true); //設(shè)列頭/* dtm.setColumnIdentifiers(columns); TableColumnModeltcm=table.getColumnModel(); for(inti=0;i<columns.length;i++) { tcm.getColumn(i).setWidth(180); }---------------------------------------------------------------------------------*/ 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); //設(shè)置邊框btxtid.setBorder(BorderFactory.createLineBorder(Color.black)); btxtname.setBorder(BorderFactory.createLineBorder(Color.black)); btn1.setBorder(BorderFactory.createRaisedBevelBorder());sl.setBorder(BorderFactory.createLineBorder(Color.black));//----連接數(shù)據(jù)庫(kù)-------------------------------------------------------------------------- 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ù)失??！"); } }//為查詢(xún)按鈕加事件-------------------------------------------------------- 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); } }Calculator.java//計(jì)算器類(lèi)packageclasssource;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.io.*;importjava.sql.*;publicclassCalculatorextendsJInternalFrameimplementsActionListener{ privateJTextFielddisplayText=newJTextField(); privateJButtonbuttonTag=newJButton(); privateJButtonbuttonBackspace=newJButton("Backspace"); privateJButtonbuttonCe=newJButton("CE"); privateJButtonbuttonc=newJButton("C"); privateJButton[]button=newJButton[24]; privateString[]keys={"MC","7","8","9","/","sqrt","MR","4","5","6","*","%", "MS","1","2","3","-","1/x","M+","0","+/-",".","+","="}; privateStringnumStr1=""; privateStringnumStr2=""; privateStringnumsave=""; privatecharop; privatebooleanfirstInput=true; privatebooleanoperatorTag1=true; privatebooleanoperatorTag2=true;// privateJMenuBarmb=newJMenuBar();// privateJMenueditMenu=newJMenu("編輯");// privateJMenuseeMenu=newJMenu("查看");// privateJMenuhelpMenu=newJMenu("幫助"); publicCalculator(){ setTitle("計(jì)算器"); setSize(345,265); Containerpane=getContentPane(); //displayText.setBackground(Color.blue);// editMenu.add("復(fù)制");// editMenu.add("粘貼");// seeMenu.add("標(biāo)準(zhǔn)型");// seeMenu.add("科學(xué)型");// seeMenu.addSeparator();// seeMenu.add("數(shù)字型");// helpMenu.add("幫助主題");// helpMenu.addSeparator();// helpMenu.add("關(guān)于計(jì)算器");// mb.add(editMenu);// mb.add(seeMenu);// mb.add(helpMenu);// setJMenuBar(mb); pane.setLayout(null);displayText.setHorizontalAlignment(JTextField.RIGHT); displayText.setSize(320,30); displayText.setLocation(10,10); pane.add(displayText); buttonTag.setSize(60,30); buttonTag.setLocation(10,50); pane.add(buttonTag); buttonBackspace.setSize(110,30); buttonBackspace.setLocation(90,50); buttonBackspace.setForeground(Color.red); buttonBackspace.addActionListener(this); pane.add(buttonBackspace); buttonCe.setSize(65,30); buttonCe.setLocation(200,50); buttonCe.setForeground(Color.red); pane.add(buttonCe); buttonc.setSize(65,30); buttonc.setLocation(265,50); buttonc.setForeground(Color.red); buttonc.addActionListener(this); pane.add(buttonc); intx,y; x=10; y=85; for(intind=0;ind<24;ind++){ //button[ind].setFont(newFont("TimesNewRoman",Font.PLAIN,14)); button[ind]=newJButton(keys[ind]); button[ind].addActionListener(this); button[ind].setLocation(x,y); if(ind%6==0||ind%6==5) {button[ind].setSize(60,30); x=x+60;} else {button[ind].setSize(50,30); x=x+50;} if(ind%6==0||ind%6==4||ind%24==23) button[ind].setForeground(Color.red); else button[ind].setForeground(Color.blue); pane.add(button[ind]); if((ind+1)%6==0) { x=10; y=y+30; } }// this.addWindowListener(newWindowAdapter(){// publicvoidwindowClosing(WindowEvente)// {// System.exit(0);// }// }); setVisible(true); this.setClosable(true); } publicvoidactionPerformed(ActionEvente){ StringresultStr=""; Stringstr=String.valueOf(e.getActionCommand()); charch=str.cha