java开发的毕业设计员工管理系统

文档块2012年员工管理系统需求文档.doc需求文档软件名称：员工管理系统一．概述： 在人才过剩的今天，企业对于有用人才的需求逐步加大，企业内部的人事变动和部门规划也开始加速，传统的人事档案已经不能满足各个企业的人员流动速度，迫使人们起用新的管理方法来管理员工的相关信息。科学技术日新月异的进步，让人类生活发生了巨大的变化，计算机技术的飞速发展，使各行各业在计算机技术应用方面得到了广泛的普及和使用。信息化时代的到来成为不可抗拒的潮流，人类文明正在进入一个崭新的时代。因此，员工管理系统也以方便、快捷、费用低、绿色环保的优点正慢慢地进入各个行业和领域，将传统的员工管理方式彻底的解脱出来，提高效率，减轻工人人员以往繁忙的工作，加速信息的更新速度，使企业管理层第一时间了解到员工的信息，从而进一步的进行对员工的调配。二．功能需求 详细说明：—增加— 增加员工的基本信息、培训信息、奖罚信息、薪资信息—删除— 可根据员工的编号及姓名等资料的删除—修改— 用户可以对员工的姓名和编号、进行修改。—查询— 用户可以根据姓名、编号，准确的查到要找的员工，也可以选择部门，查看选中的部门的所有员工。—辅助— 可以调用单独制作的计算器进行数字计算，节省操作时间三.设计操作界面登陆窗口：主窗体：员工管理系统数据字典.doc员工管理系统（数据字典）库名（EmployeeInformationMS）用户信息表（UserInformation）字段类型说明大小是否为空User_IDInt员工编号NOTNULLUser_Namevarchar员工姓名20NOTNULLPasswordvarchar密码20NOTNULLPopedomvarchar权限20NOTNULL部门信息管理（DepartmentInformation）字段类型说明大小是否为空D_Numberint部门编号NOTNULLD_Namevarchar部门名称20NOTNULLD_Countvarchar部门人数20NOTNULL员工基本信息表（EmployeeInformation）字段类型说明大小是否为空E_Numberint--员工编号NOTNULLE_Namevarchar--姓名20NOTNULLE_Sexvarchar--性别2NOTNULLE_BornDatevarchar--出生日期30NOTNULLE_Marriagevarchar--婚姻状态4NOTNULLE_PoliticsVisagevarchar政治面貌20NOTNULLE_SchoolAgevarchar学历20NOTNULLE_EnterDatevarchar进入公司时间30NOTNULLE_InDueFormDatevarchar转正时间30NOTNULLE_Departmentvarchar部门20NOTNULLE_Headshipvarchar职务20NOTNULLE_Estatevarchar状态20NOTNULLE_Remarkvarchar备注500NOTNULL培训信息表（TrainInformation）字段类型说明大小是否为空T_Numbervarchar培训编号20NOTNULLT_Contentvarchar培训内容100NOTNULLT_Namevarchar培训员工姓名20NOTNULLT_Dateint培训天数NOTNULLT_Moneyint培训费用NOTNULL奖罚信息表（EncouragementPunishInformation）字段类型说明大小是否为空EP_Numberint员工编号NOTNULLEP_Namevarchar员工姓名30NOTNULLEP_Datevarchar奖罚时间30NOTNULLEP_Addressvarchar奖罚地点50NOTNULLEP_Causationvarchar奖罚原因200NOTNULLEP_Remarkvarchar备注500NOTNULL薪资信息表（WageInformation）字段类型说明大小是否为空W_Numberint员工编号NOTNULLW_Namevarchar员工姓名30NOTNULLW_BasicWageint基本工资NOTNULLW_Boonint福利NOTNULLW_Bonusint奖金NOTNULLW_CountMethodvarchar计算方法50NOTNULLW_FactWageint实发工资NOTNULL员工管理系统.ppt数据库文件EmployeeInformationMSok.sqlCREATEDATABASEEmployeeInformationMS--DROPDATABASEEmployeeInformationMSgoUSEEmployeeInformationMSgo/*用户信息表*/CREATETABLEUserInformation(User_IDINTIDENTITY(1,1),User_NameVARCHAR(20)NOTNULL,PasswordVARCHAR(20)NOTNULL,PopedomVARCHAR(20)DEFAULT'B',--权限)goINSERTUserInformationVALUES('管理员','123','A')INSERTUserInformation(User_Name,Password)VALUES('admin','123456')--TRUNCATETABLEUserInformation--SELECT*FROMUserInformationgo/*部门信息表*/CREATETABLEDepartmentInformation(D_NumberINTIDENTITY(1,1),D_NameVARCHAR(20)NOTNULL,D_CountVARCHAR(20)NOTNULL,)goINSERTDepartmentInformationVALUES('市场部','50')INSERTDepartmentInformationVALUES('教学部','65')INSERTDepartmentInformationVALUES('财会部','26')INSERTDepartmentInformationVALUES('培训部','52')INSERTDepartmentInformationVALUES('后勤部','69')INSERTDepartmentInformationVALUES('就业部','66')INSERTDepartmentInformationVALUES('策划部','50')INSERTDepartmentInformationVALUES('软件开发部','67')INSERTDepartmentInformationVALUES('招生部','26')go/*员工基本信息表*/CREATETABLEEmployeeInformation(E_NumberINTIDENTITY(1,1),--员工编号E_NameVARCHAR(30)NOTNULL,--姓名E_SexVARCHAR(2)NOTNULL,--性别E_BornDateVARCHAR(30)NOTNULL,--出生日期E_MarriageVARCHAR(4)NOTNULL,--婚姻状态E_PoliticsVisageVARCHAR(20)NOTNULL,--政治面貌E_SchoolAgeVARCHAR(20)NOTNULL,--学历E_EnterDateVARCHAR(30)NOTNULL,--进入公司时间E_InDueFormDateVARCHAR(30)NOTNULL,--转正时间E_DepartmentVARCHAR(20)NOTNULL,--部门E_HeadshipVARCHAR(20)NOTNULL,--职务E_EstateVARCHAR(10)NOTNULL,--状态E_RemarkVARCHAR(500),--备注)goINSERTEmployeeInformationVALUES('张三','女','1980年9月29日','未婚','党员','本科','2004年9月10日','2004年12月10日','教学部','主管','在职','高级讲师')INSERTEmployeeInformationVALUES('aaa','男','1980年6月24日','未婚','党员','本科','2004年9月10日','2004年12月10日','软件开发','主管','在职','高级工程师')SELECT*FROMEmployeeInformation--DELETEFROMEmployeeInformationwhereE_Name='张三'go/*培训信息表*/CREATETABLETrainInformation(T_NumberVARCHAR(20)NOTNULL,--培训编号T_ContentVARCHAR(100)NOTNULL,--培训内容T_NameVARCHAR(20)NOTNULL,--培训员工姓名T_DateINTNotNULL,--培训天数T_MoneyINT--培训费用)goINSERTTrainInformationVALUES('2007_001','职业素质','张三',30,7000)INSERTTrainInformationVALUES('2007_002','职业素质','姚明',30,7000)INSERTTrainInformationVALUES('2007_003','职业素质','宋成',30,7000)INSERTTrainInformationVALUES('2007_004','职业素质','甘小发',30,7000)INSERTTrainInformationVALUES('2007_005','职业素质','陈天桥',30,7000)INSERTTrainInformationVALUES('2007_006','职业素质','刘小成',30,7000)INSERTTrainInformationVALUES('2007_007','职业素质','彭煌',30,7000)INSERTTrainInformationVALUES('2007_008','职业素质','刘一发',30,7000)INSERTTrainInformationVALUES('2007_009','职业素质','胡来',30,7000)--SELECT*FROMTrainInformationgo/*奖罚信息表*/CREATETABLEEncouragementPunishInformation(EP_NumberINTIDENTITY(1,1),EP_NameVARCHAR(30)NOTNULL,EP_DateVARCHAR(30)NOTNULL,EP_AddressVARCHAR(50)NOTNULL,EP_CausationVARCHAR(200)NOTNULL,--奖罚原因EP_RemarkVARCHAR(500),--备注)goINSERTEncouragementPunishInformationVALUES('张三','2006年5月3日','教学馆二楼','演讲比赛一等奖','afa')INSERTEncouragementPunishInformationVALUES('刘一发','2004年5月3日','教学馆二楼','演讲比赛一等奖','aaaa')--SELECT*FROMEncouragementPunishInformationgo/*薪资信息表*/CREATETABLEWageInformation(W_NumberINTIDENTITY(1,1),W_NameVARCHAR(30)NOTNULL,--员工姓名W_BasicWageINTNOTNULL,--基本工资W_BoonINTNOTNULL,--福利W_BonusINTNOTNULL,--奖金W_CountMethodVARCHAR(50)NOTNULL,--计算方法W_FactWageINTNOTNULL,--实发工资)--SELECT*FROMWageInformationINSERTWageInformationVALUES('张三','3000','300','200','基本工资+福利+奖金',3500)INSERTWageInformationVALUES('麻五','3000','300','200','基本工资+福利+奖金',3500)INSERTWageInformationVALUES('Andy','3000','300','200','基本工资+福利+奖金',3500)INSERTWageInformationVALUES('陈一邦','3000','300','200','基本工资+福利+奖金',3500)INSERTWageInformationVALUES('姚明','3000','300','200','基本工资+福利+奖金',3500)INSERTWageInformationVALUES('胡来','3000','300','200','基本工资+福利+奖金',3500)INSERTWageInformationVALUES('秋若','3000','300','200','基本工资+福利+奖金',3500)INSERTWageInformationVALUES('宋成','3000','300','200','基本工资+福利+奖金',3500)在数据库生成的是：源代码About.java//关于软件类packageclasssource;importjava.awt.*;//倒包importjava.awt.event.*;//倒包importjavax.swing.*;//倒包publicclassAboutextendsJInternalFrame{ JLabellabel=newJLabel("运行环境：Windows");//创建标签并实例化 JLabellabe2=newJLabel("开发语言：JAVA");//创建标签并实例化 JLabellabe3=newJLabel("数据库类型：SqlServer2000");//创建标签并实例化 JLabellabe4=newJLabel("开发人员：张扬、王丽霞、高旭、李爱全");//创建标签并实例化 publicAbout(){//构造方法 setTitle("关于");//设置标题 Containercon=getContentPane();con.setLayout(newGridLayout(4,1));//设置网格布局con.add(label);//添加标签con.add(labe2);//添加标签con.add(labe3);//添加标签con.add(labe4);//添加标签con.setBackground(Color.green);//添加背景颜色 setResizable(false);//不可更改大小 setSize(380,220);//设置大小 setVisible(true);//可见 setClosable(true);//设置可以关闭 } }AddDeleteUser.java//添加删除用户类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=newJComboBox();jLabel5=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,27);//为空间放置具体位置结束//将所有用用户名读出来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(""); } });//--------------------------------------------------------------}}AmendPassword.java//修改密码类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("用户名:");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(ActionEvente){ pas1.setText(""); pas2.setText(""); pas3.setText(""); } });}}BIQ.java//员工信息查询类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[]={"员工编号","员工姓名","性别","出生日期","婚姻状况","政治面貌","学历","进入公司时间","转正时间","部门","职务","员工状态","备注"}; publicBIQ(){ setTitle("基本信息查询"); 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); //设列头/* 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); //设置边框btxtid.setBorder(BorderFactory.createLineBorder(Color.black)); btxtname.setBorder(BorderFactory.createLineBorder(Color.black)); btn1.setBorder(BorderFactory.createRaisedBevelBorder());sl.setBorder(BorderFactory.createLineBorder(Color.black));//----连接数据库-------------------------------------------------------------------------- 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("初始化数据失败！"); } }//为查询按钮加事件-------------------------------------------------------- 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//计算器类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("计算器"); setSize(345,265); Containerpane=getContentPane(); //displayText.setBackground(Color.blue);// editMenu.add("复制");// editMenu.add("粘贴");// seeMenu.add("标准型");// seeMenu.add("科学型");// seeMenu.addSeparator();// seeMenu.add("数字型");// helpMenu.add("帮助主题");// helpMenu.addSeparator();// helpMenu.add("关于计算器");// 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