职工工资管理系统--数据库课程实训报告

数据库课程实训报告题目职工工资管理系统目录1课题内容和要求111课题描述112课题要求12需求分析121功能需求分析122数据需求分析23系统设计331功能模块设计332数据库概念设计333数据库逻辑设计534数据库物理设计535数据库表间联系54系统实现641添加模块实现642删除模块实现643修改模块实现75代码调试与功能测试751测试方案752测试结果86收获与体会10参考文献11附录1源程序部分清单12附录11登陆代码12附录12查询代码17附录13添加代码22附录14删除代码25附录15修改代码27附录16加工资代码35附录17扣工资代码37职工工资管理系统1课题内容和要求11课题描述职工工资管理是公司比较内部比较重要的一个管理环节，其中的财务管理则是公司工作中的中心环节，要聘请专业的会计人员和财务人员，根据公司的规模而定的，而现在都是由会计人员手动操作，这样让整个工作难度和复杂度提高了。这样工作效率也不是很好，而且一般员工还无法查看自己的工资表单，为此带来了很多不便，此课程设计就是为了解决一些不便的问题，对工资表单的设定、查询、修改、删除、打印同时对员工的信息进行系统性的管理，实现多项功能。12课题要求可以按照科室（经理室、财务科、技术科和销售科）增加、修改、删除职工的基本资料1职工信息应包含职称，分为高级、中级、初级，同一职称职工基本工资相同2职工工资由基本工资、奖金、扣除金额组成，其中奖金、扣除金额可每月输入不同数据3可以计算职工每月工资4可以按照科室、职称、月份统计职工工资5可以按照科室、职工号、职工名称查询职工工资2需求分析21功能需求分析（1）注册登录功能财务部人员先注册用户名和密码后，才可以用已经注册后的用户名进行登录，方可成功进入员工工资管理的主界面。（2）添加/修改员工工资功能财务部人员进入添加/修改员工工资的界面，可以添加职工编号、职工姓名、职工性别、现任职务、工资状况以及职工年龄。如若需要进行修改，进入修改界面后需要输入已添加成功的职工编号，从而对其他信息进行修改，在主界面点击查询的时候会发现该员工的有些信息会有所改变。（3）查询员工工资功能财务部人员通过登录进入主界面后，输入已成功添加的职工编号，点击查询，会显示之前所添加的信息。（4）删除员工工资功能财务部人员进入删除员工工资的界面，输入已添加成功的职工编号，点击删除后，在进行查询的时候会发现查无此人。（5）扣工资财务部人员根据员工表现在主界面点击加工资，进入加工资界面，输入所需加工资的职工编号以及所加工资的金额。在主界面点击查询的时候会发现该员工的工资状况有所增加。（6）扣工资财务部人员根据员工表现在主界面点击扣工资，进入扣工资界面，输入所需扣工资的职工编号以及所扣工资的金额。在主界面点击查询的时候会发现该员工的工资状况有所减少。22数据需求分析职工信息所属科室职工信息职工信息工资信息基本工资奖扣工资221数据流图数据字典（A）职工信息表字段名称所属表编码备注登录名1BIAO2SA记录登录的基本信息登录名2BIAO2CSY记录登录的基本信息登录名3BIAO2YHL记录登录的基本信息B用户表字段名称所属表编码数据类型长度备注职工编号BIAO1ZGBHVARCHAR50主键职工姓名BIAO1ZGXMNACHAR10职工性别BIAO1ZGXBNACHAR10男/女职工年龄BIAO1ZGNLNACHAR1018/0/判断注册是否成功SYSTEMOUTPRINTLN“OK“JOPTIONPANESHOWMESSAGEDIALOGNULL,“成功，请用新用户名登录“,“提示“,JOPTIONPANEINFORMATION_MESSAGETHISDISPOSEELSESYSTEMOUTPRINTLN“FALSE“JOPTIONPANESHOWMESSAGEDIALOGNULL,“失败“,“提示“,JOPTIONPANEERROR_MESSAGEPSCLOSECONCLOSECATCHSQLEXCEPTIONE1JT0SETTEXT“JT1SETTEXT“/点击按钮完毕后清空文本框附录12查询代码IMPORTJAVAAWTIMPORTJAVAAWTEVENTACTIONEVENTIMPORTJAVAAWTEVENTACTIONLISTENERIMPORTJAVASQLCONNECTIONIMPORTJAVASQLDRIVERMANAGERIMPORTJAVASQLRESULTSETIMPORTJAVASQLSQLEXCEPTIONIMPORTJAVASQLSTATEMENTIMPORTJAVAUTILSCANNERIMPORTJAVAXSWINGCLASSSECONDEXTENDSJFRAMEIMPLEMENTSACTIONLISTENERSTRINGBMSTRINGURL“JDBCSQLSERVER/LOCALHOST1433DATABASENAMEXT“STRINGDRIVER“COMMICROSOFTSQLSERVERJDBCSQLSERVERDRIVER“STATEMENTSTCONNECTIONCONPRIVATEJLABELJB01NEWJLABEL“员工工资管理系统“PRIVATEJBUTTONJB03NEWJBUTTON“添加数据“PRIVATEJBUTTONJB07NEWJBUTTON“重置“PRIVATEJBUTTONJB04NEWJBUTTON“删除数据“PRIVATEJBUTTONJB08NEWJBUTTON“修改数据“PRIVATEJBUTTONJB05NEWJBUTTON“退出程序“PRIVATEJBUTTONJBJNEWJBUTTON“加工资“PRIVATEJBUTTONJBJ2NEWJBUTTON“扣工资“PRIVATEJBUTTONJBNEWJBUTTON“查询“PRIVATEJLABELJB0NEWJLABEL“输入职工编号“PRIVATEJLABELJB1NEWJLABEL“所在部门“PRIVATEJLABELJB2NEWJLABEL“职工姓名“PRIVATEJLABELJB3NEWJLABEL“职工性别“PRIVATEJLABELJB4NEWJLABEL“现任职务“PRIVATEJLABELJB5NEWJLABEL“工资状况“PRIVATEJLABELJB6NEWJLABEL“职工年龄“PRIVATEJTEXTFIELDJT1NEWJTEXTFIELDPRIVATEJTEXTFIELDJT2NEWJTEXTFIELDPRIVATEJTEXTFIELDJT3NEWJTEXTFIELDPRIVATEJTEXTFIELDJT4NEWJTEXTFIELDPRIVATEJTEXTFIELDJT5NEWJTEXTFIELDPRIVATEJTEXTFIELDJT6NEWJTEXTFIELDPRIVATEJTEXTFIELDJT7NEWJTEXTFIELDPUBLICSECONDIMAGEICONIMGNEWIMAGEICON“2JPG“JLABELIMGLABELNEWJLABELIMGTHISGETLAYEREDPANEADDIMGLABEL,NEWINTEGERINTEGERMIN_VALUEIMGLABELSETBOUNDS0,0,IMGGETICONWIDTH,IMGGETICONHEIGHT/设置背景标签的位置THISSETDEFAULTCLOSEOPERATIONJFRAMEEXIT_ON_CLOSECONTAINERCPTHISGETCONTENTPANECPSETLAYOUTNULLJPANELCPSETOPAQUEFALSETHISSETLAYOUTNULLTHISSETBOUNDS400,100,600,500THISSETTITLE“员工工资管理系统“JBSETBOUNDS320,90,80,20JB0SETBOUNDS140,90,100,20JB01SETBOUNDS180,40,400,40JB1SETBOUNDS40,150,90,20JB2SETBOUNDS130,150,90,20JB3SETBOUNDS220,150,90,20JB4SETBOUNDS310,150,90,20JB5SETBOUNDS400,150,90,20JB6SETBOUNDS490,150,90,20JBJSETBOUNDS160,330,90,30JBJ2SETBOUNDS340,330,90,30THISADDJBJ2THISADDJBJTHISADDJBTHISADDJB1THISADDJB2THISADDJB3THISADDJB4THISADDJB5THISADDJB6JT1SETBOUNDS230,90,80,20JT2SETBOUNDS30,170,80,20JT3SETBOUNDS120,170,80,20JT4SETBOUNDS210,170,80,20JT5SETBOUNDS300,170,80,20JT6SETBOUNDS390,170,80,20JT7SETBOUNDS480,170,80,20JT2SETEDITABLEFALSEJT3SETEDITABLEFALSEJT4SETEDITABLEFALSEJT5SETEDITABLEFALSEJT6SETEDITABLEFALSEJT7SETEDITABLEFALSETHISADDJT1THISADDJT2THISADDJT3THISADDJT4THISADDJT5THISADDJT6THISADDJT7THISADDJB01THISADDJB0JB03SETBOUNDS30,250,170,40JB04SETBOUNDS210,250,170,40JB05SETBOUNDS450,400,100,30JB07SETBOUNDS410,90,80,20JB08SETBOUNDS390,250,170,40THISADDJB03THISADDJB04THISADDJB05THISADDJB07THISADDJB08JBADDACTIONLISTENERTHISJT1ADDACTIONLISTENERTHISJB03ADDACTIONLISTENERNEWACTIONLISTENER/点击响应添加窗口PUBLICVOIDACTIONPERFORMEDACTIONEVENTEADDDATAFRM2NEWADDDATAFRM2SETVISIBLETRUEJB04ADDACTIONLISTENERNEWACTIONLISTENER/点击响应删除窗口PUBLICVOIDACTIONPERFORMEDACTIONEVENTEDELETEDATAFRM3NEWDELETEDATAFRM3SETVISIBLETRUEJB05ADDACTIONLISTENERNEWACTIONLISTENERPUBLICVOIDACTIONPERFORMEDACTIONEVENTEJOPTIONPANESHOWMESSAGEDIALOGNULL,“欢迎再次使用“,“提示“,JOPTIONPANEINFORMATION_MESSAGESYSTEMEXIT0JB01SETFONTNEWFONT“SERIF“,FONTBOLD,25JB07ADDACTIONLISTENERNEWACTIONLISTENER/进行重置操作PUBLICVOIDACTIONPERFORMEDACTIONEVENTEJT1SETTEXT“JT2SETTEXT“JT3SETTEXT“JT4SETTEXT“JT5SETTEXT“JT6SETTEXT“JT7SETTEXT“JB08ADDACTIONLISTENERNEWACTIONLISTENER/进行重置操作PUBLICVOIDACTIONPERFORMEDACTIONEVENTEUPDATAFRM3NEWUPDATAFRM3SETVISIBLETRUEJBJ2ADDACTIONLISTENERNEWACTIONLISTENER/进行重置操作PUBLICVOIDACTIONPERFORMEDACTIONEVENTESUBSALARYFRM4NEWSUBSALARYFRM4SETVISIBLETRUEJBJADDACTIONLISTENERNEWACTIONLISTENER/进行重置操作PUBLICVOIDACTIONPERFORMEDACTIONEVENTEADDSALARYFRM5NEWADDSALARYFRM5SETVISIBLETRUEPUBLICVOIDACTIONPERFORMEDACTIONEVENTARG0STRINGS1NULLINTCOUNT0STRINGBHNULLBHJT1GETTEXTTRYCLASSFORNAMEDRIVER/加载驱动CATCHCLASSNOTFOUNDEXCEPTIONESYSTEMOUTPRINT“无法创建驱动程式实体“TRYCLASSFORNAMEDRIVER/加载驱动CATCHCLASSNOTFOUNDEXCEPTIONEVENTSYSTEMOUTPRINT“无法创建驱动程式实体“TRYCONDRIVERMANAGERGETCONNECTIONURL,“SA“,“123456“CONSETAUTOCOMMITTRUESYSTEMOUTPRINTLN“和数据库已经建立连接“/输出到控制台，便于调试程序。STCONCREATESTATEMENTRESULTSETRSSTEXECUTEQUERY“SELECTSZBM,ZGXM,ZGXB,XRZW,HYZK,ZGNLFROMBIAO1WHEREZGBH“BH“WHILERSNEXT/遍历查询结果BMRSGETSTRING“SZBM“/初始化数组内容JT2SETTEXTBM/将数据库里取出的数据放入文本框STRINGXMRSGETSTRING“ZGXM“JT3SETTEXTXMSTRINGXBRSGETSTRING“ZGXB“JT4SETTEXTXBSTRINGZWRSGETSTRING“XRZW“JT5SETTEXTZWSTRINGZKRSGETSTRING“HYZK“JT6SETTEXTZKSTRINGNLSTRINGVALUEOFRSGETINT“ZGNL“JT7SETTEXTNLCOUNTSTCLOSECONCLOSEIFBMNULL/判断是否能从数据库里提取数据SYSTEMOUTPRINTLN“未在数据库找到数据“JOPTIONPANESHOWMESSAGEDIALOGNULL,“查无此人“,“提示“,JOPTIONPANEERROR_MESSAGECATCHSQLEXCEPTIONE1SYSTEMOUTPRINTLN“异常“E1附录13添加代码IMPORTJAVAAWTCONTAINERIMPORTJAVAAWTEVENTACTIONEVENTIMPORTJAVAAWTEVENTACTIONLISTENERIMPORTJAVASQLCONNECTIONIMPORTJAVASQLDRIVERMANAGERIMPORTJAVASQLPREPAREDSTATEMENTIMPORTJAVASQLSQLEXCEPTIONIMPORTJAVASQLSTATEMENTIMPORTJAVAXSWINGCLASSADDDATAEXTENDSJFRAMEIMPLEMENTSACTIONLISTENERSTRINGURL“JDBCSQLSERVER/LOCALHOST1433DATABASENAMEXT“STRINGDRIVER“COMMICROSOFTSQLSERVERJDBCSQLSERVERDRIVER“STATEMENTSTCONNECTIONCONPRIVATEJBUTTONJB01NEWJBUTTON“确定添加“PRIVATEJLABELJL0NEWJLABEL“职工编号“PRIVATEJLABELJL1NEWJLABEL“所在部门“PRIVATEJLABELJL2NEWJLABEL“职员姓名“PRIVATEJLABELJL3NEWJLABEL“职工性别“PRIVATEJLABELJL4NEWJLABEL“现任职务“PRIVATEJLABELJL5NEWJLABEL“工资状况“PRIVATEJLABELJL6NEWJLABEL“职工年龄“PRIVATEJTEXTFIELDJT0NEWJTEXTFIELDPRIVATEJTEXTFIELDJT1NEWJTEXTFIELDPRIVATEJTEXTFIELDJT2NEWJTEXTFIELDPRIVATEJTEXTFIELDJT3NEWJTEXTFIELDPRIVATEJTEXTFIELDJT4NEWJTEXTFIELDPRIVATEJTEXTFIELDJT5NEWJTEXTFIELDPRIVATEJTEXTFIELDJT6NEWJTEXTFIELDPUBLICADDDATAIMAGEICONIMGNEWIMAGEICON“2JPG“JLABELIMGLABELNEWJLABELIMGTHISGETLAYEREDPANEADDIMGLABEL,NEWINTEGERINTEGERMIN_VALUEIMGLABELSETBOUNDS0,0,IMGGETICONWIDTH,IMGGETICONHEIGHT/设置背景标签的位置CONTAINERCPTHISGETCONTENTPANECPSETLAYOUTNULLJPANELCPSETOPAQUEFALSETHISSETLAYOUTNULLTHISSETBOUNDS500,200,400,300THISSETTITLE“添加数据“JL0SETBOUNDS80,20,80,20JL1SETBOUNDS80,50,80,20JL2SETBOUNDS80,80,80,20JL3SETBOUNDS80,110,80,20JL4SETBOUNDS80,140,80,20JL5SETBOUNDS80,170,80,20JL6SETBOUNDS80,200,80,20THISADDJL0THISADDJL1THISADDJL2THISADDJL3THISADDJL4THISADDJL5THISADDJL6JT0SETBOUNDS150,20,80,20JT1SETBOUNDS150,50,80,20JT2SETBOUNDS150,80,80,20JT3SETBOUNDS150,110,80,20JT4SETBOUNDS150,140,80,20JT5SETBOUNDS150,170,80,20JT6SETBOUNDS150,200,80,20THISADDJT0THISADDJT1THISADDJT2THISADDJT3THISADDJT4THISADDJT5THISADDJT6JB01SETBOUNDS250,90,90,40THISADDJB01JB01ADDACTIONLISTENERTHISPUBLICVOIDACTIONPERFORMEDACTIONEVENTARG0STRINGBHJT0GETTEXTSTRINGBMJT1GETTEXTSTRINGXMJT2GETTEXTSTRINGXBJT3GETTEXTSTRINGZWJT4GETTEXTSTRINGZKJT5GETTEXTSTRINGNLJT6GETTEXTTRYCLASSFORNAMEDRIVERCATCHCLASSNOTFOUNDEXCEPTIONESYSTEMOUTPRINT“无法创建驱动程式实体“TRYCLASSFORNAMEDRIVER/加载驱动CATCHCLASSNOTFOUNDEXCEPTIONEVENTSYSTEMOUTPRINT“无法创建驱动程式实体“TRYCONDRIVERMANAGERGETCONNECTIONURL,“SA“,“123456“CONSETAUTOCOMMITTRUESYSTEMOUTPRINTLN“和数据库已经建立连接“STRINGSQ“INSERTINTOBIAO1ZGBH,SZBM,ZGXM,ZGXB,XRZW,HYZK,ZGNLVALUES,“PREPAREDSTATEMENTPSCONPREPARESTATEMENTSQPSSETSTRING1,BHPSSETSTRING2,BMPSSETSTRING3,XMPSSETSTRING4,XBPSSETSTRING5,ZWPSSETSTRING6,ZKPSSETINT7,INTEGERPARSEINTNLINTTPSEXECUTEUPDATEIFT0SYSTEMOUTPRINTLN“已经添加到数据库“JOPTIONPANESHOWMESSAGEDIALOGNULL,“添加成功“,“提示“,JOPTIONPANEINFORMATION_MESSAGEELSESYSTEMOUTPRINTLN“FALSE“JOPTIONPANESHOWMESSAGEDIALOGNULL,“添加失败“,“警告“,JOPTIONPANEERROR_MESSAGEPSCLOSECONCLOSECATCHSQLEXCEPTIONE1SYSTEMOUTPRINTLN“异常“E1JT0SETTEXT“JT1SETTEXT“JT2SETTEXT“JT3SETTEXT“JT4SETTEXT“JT5SETTEXT“JT6SETTEXT“附录14删除代码IMPORTJAVAAWTCONTAINERIMPORTJAVAAWTEVENTACTIONEVENTIMPORTJAVAAWTEVENTACTIONLISTENERIMPORTJAVASQLCONNECTIONIMPORTJAVASQLDRIVERMANAGERIMPORTJAVASQLPREPAREDSTATEMENTIMPORTJAVASQLRESULTSETIMPORTJAVASQLSQLEXCEPTIONIMPORTJAVASQLSTATEMENTIMPORTJAVAXSWINGCLASSDELETEDATAEXTENDSJFRAMEIMPLEMENTSACTIONLISTENERSTRINGURL“JDBCSQLSERVER/LOCALHOST1433DATABASENAMEXT“STRINGDRIVER“COMMICROSOFTSQLSERVERJDBCSQLSERVERDRIVER“STATEMENTSTCONNECTIONCONPRIVATEJTEXTFIELDJT1NEWJTEXTFIELDPRIVATEJLABELJL1NEWJLABEL“请输入删除职工编号“PRIVATEJBUTTONJBNEWJBUTTON“删除“PUBLICDELETEDATAIMAGEICONIMGNEWIMAGEICON“2JPG“JLABELIMGLABELNEWJLABELIMGTHISGETLAYEREDPANEADDIMGLABEL,NEWINTEGERINTEGERMIN_VALUEIMGLABELSETBOUNDS0,0,IMGGETICONWIDTH,IMGGETICONHEIGHT/设置背景标签的位置CONTAINERCPTHISGETCONTENTPANECPSETLAYOUTNULLJPANELCPSETOPAQUEFALSETHISSETLAYOUTNULLTHISSETBOUNDS500,200,400,300THISSETTITLE“删除数据“JT1SETBOUNDS150,100,100,20JBSETBOUNDS160,130,80,20JL1SETBOUNDS140,60,150,20THISADDJBTHISADDJT1THISADDJL1JBADDACTIONLISTENERTHISPUBLICVOIDACTIONPERFORMEDACTIONEVENTARG0STRINGBHNULLBHJT1GETTEXTTRYCLASSFORNAMEDRIVERCATCHCLASSNOTFOUNDEXCEPTIONESYSTEMOUTPRINT“无法创建驱动程式实体“TRYCLASSFORNAMEDRIVER/加载驱动CATCHCLASSNOTFOUNDEXCEPTIONEVENTSYSTEMOUTPRINT“无法创建驱动程式实体“TRYCONDRIVERMANAGERGETCONNECTIONURL,“SA“,“123456“CONSETAUTOCOMMITTRUESYSTEMOUTPRINTLN“和数据库已经建立连接“STRINGSQ“DELETEFROMBIAO1WHEREZGBH“PREPAREDSTATEMENTPSCONPREPARESTATEMENTSQPSSETSTRING1,BHINTTPSEXECUTEUPDATEIFT0SYSTEMOUTPRINTLN“已经删除数据库数据“JOPTIONPANESHOWMESSAGEDIALOGNULL,“删除成功“,“提示“,JOPTIONPANEINFORMATION_MESSAGEELSESYSTEMOUTPRINTLN“数据库数据删除失败“JOPTIONPANESHOWMESSAGEDIALOGNULL,“删除失败“,“提示“,JOPTIONPANEERROR_MESSAGEPSCLOSECONCLOSECATCHSQLEXCEPTIONE1SYSTEMOUTPRINTLN“异常“E1JT1SETTEXT“附录15修改代码IMPORTJAVAAWTCONTAINERIMPORTJAVAAWTEVENTACTIONEVENTIMPORTJAVAAWTEVENTACTIONLISTENERIMPORTJAVASQLCONNECTIONIMPORTJAVASQLDRIVERMANAGERIMPORTJAVASQLPREPAREDSTATEMENTIMPORTJAVASQLRESULTSETIMPORTJAVASQLSQLEXCEPTIONIMPORTJAVASQLSTATEMENTIMPORTJAVAXSWINGCLASSUPDATAEXTENDSJFRAMEIMPLEMENTSACTIONLISTENERSTRINGURL“JDBCSQLSERVER/LOCALHOST1433DATABASENAMEXT“STRINGDRIVER“COMMICROSOFTSQLSERVERJDBCSQLSERVERDRIVER“STATEMENTSTCONNECTIONCONSTRINGSQPREPAREDSTATEMENTPSPRIVATEJTEXTFIELDJT1NEWJTEXTFIELDPRIVATEJTEXTFIELDJT2NEWJTEXTFIELDPRIVATEJTEXTFIELDJT3NEWJTEXTFIELDPRIVATEJTEXTFIELDJT4NEWJTEXTFIELDPRIVATEJTEXTFIELDJT5NEWJTEXTFIELDPRIVATEJTEXTFIELDJT6NEWJTEXTFIELDPRIVATEJTEXTFIELDJT7NEWJTEXTFIELDPRIVATEJLABELJL1NEWJLABEL“请输入职工编号“PRIVATEJBUTTONJBNEWJBUTTON“确定“PRIVATEJBUTTONJB01NEWJBUTTON“确定“PRIVATEJBUTTONJB02NEWJBUTTON“确定“PRIVATEJBUTTONJB03NEWJBUTTON“确定“PRIVATEJBUTTONJB04NEWJBUTTON“确定“PRIVATEJBUTTONJB05NEWJBUTTON“确定“PRIVATEJLABELJB1NEWJLABEL“所在部门“PRIVATEJLABELJB2NEWJLABEL“职工姓名“PRIVATEJLABELJB3NEWJLABEL“职工性别“PRIVATEJLABELJB4NEWJLABEL“现任职务“PRIVATEJLABELJB5NEWJLABEL“工资状况“PRIVATEJLABELJB6NEWJLABEL“职工年龄“PUBLICUPDATAIMAGEICONIMGNEWIMAGEICON“2JPG“JLABELIMGLABELNEWJLABELIMGTHISGETLAYEREDPANEADDIMGLABEL,NEWINTEGERINTEGERMIN_VALUEIMGLABELSETBOUNDS0,0,IMGGETICONWIDTH,IMGGETICONHEIGHT/设置背景标签的位置CONTAINERCPTHISGETCONTENTPANECPSETLAYOUTNULLJPANELCPSETOPAQUEFALSETHISSETLAYOUTNULLTHISSETBOUNDS500,200,400,350THISSETTITLE“修改数据“JT1SETBOUNDS150,50,100,20JBSETBOUNDS280,80,70,20JB01SETBOUNDS280,110,70,20JB02SETBOUNDS280,140,70,20JB03SETBOUNDS280,170,70,20JB04SETBOUNDS280,200,70,20JB05SETBOUNDS280,230,70,20JB1SETBOUNDS90,80,100,20JB2SETBOUNDS90,110,100,20JB3SETBOUNDS90,140,100,20JB4SETBOUNDS90,170,100,20JB5SETBOUNDS90,200,100,20JB6SETBOUNDS90,230,100,20JL1SETBOUNDS150,20,100,20JT2SETBOUNDS150,80,100,20JT3SETBOUNDS150,110,100,20JT4SETBOUNDS150,140,100,20JT5SETBOUNDS150,170,100,20JT6SETBOUNDS150,200,100,20JT7SETBOUNDS150,230,100,20THISADDJBTHISADDJT1THISADDJL1THISADDJB1THISADDJB2THISADDJB3THISADDJB4THISADDJB5THISADDJB6THISADDJB01THISADDJB02THISADDJB03THISADDJB04THISADDJB05THISADDJT2THISADDJT3THISADDJT4THISADDJT5THISADDJT6THISADDJT7JBADDACTIONLISTENERNEWACTIONLISTENERPUBLICVOIDACTIONPERFORMEDACTIONEVENTESTRINGBHJT1GETTEXTSTRINGBMJT2GETTEXTTRYCLASSFORNAMEDRIVERCATCHCLASSNOTFOUNDEXCEPTIONARG0SYSTEMOUTPRINT“无法创建驱动程式实体“TRYCLASSFORNAMEDRIVER/加载驱动CATCHCLASSNOTFOUNDEXCEPTIONEVENTSYSTEMOUTPRINT“无法创建驱动程式实体“TRYCONDRIVERMANAGERGETCONNECTIONURL,“SA“,“123456“CONSETAUTOCOMMITTRUESYSTEMOUTPRINTLN“和数据库已经建立连接“SQ“UPDATEBIAO1SETSZBM“BM“WHEREZGBH“PSCONPREPARESTATEMENTSQPSSETSTRING1,BHINTTPSEXECUTEUPDATEIFT0JOPTIONPANESHOWMESSAGEDIALOGNULL,“修改成功“,“提示“,JOPTIONPANEINFORMATION_MESSAGEELSEJOPTIONPANESHOWMESSAGEDIALOGNULL,“修改失败“,“提示“,JOPTIONPANEERROR_MESSAGEPSCLOSECONCLOSECATCHSQLEXCEPTIONE1SYSTEMOUTPRINTLN“异常“E1JB01ADDACTIONLISTENERNEWACTIONLISTENERPUBLICVOIDACTIONPERFORMEDACTIONEVENTESTRINGBHJT1GETTEXTSTRINGXMJT3GETTEXTTRYCLASSFORNAMEDRIVERCATCHCLASSNOTFOUNDEXCEPTIONARG0SYSTEMOUTPRINT“无法创建驱动程式实体“TRYCLASSFORNAMEDRIVER/加载驱动CATCHCLASSNOTFOUNDEXCEPTIONEVENTSYSTEMOUTPRINT“无法创建驱动程式实体“TRYCONDRIVERMANAGERGETCONNECTIONURL,“SA“,“123456“CONSETAUTOCOMMITTRUESYSTEMOUTPRINTLN“和数据库已经建立连接“SQ“UPDATEBIAO1SETZGXM“XM“WHEREZGBH“PSCONPREPARESTATEMENTSQPSSETSTRING1,BHINTTPSEXECUTEUPDATEIFT0JOPTIONPANESHOWMESSAGEDIALOGNULL,“修改成功“,“提示“,JOPTIONPANEINFORMATION_MESSAGEELSEJOPTIONPANESHOWMESSAGEDIALOGNULL,“修改失败“,“提示“,JOPTIONPANEERROR_MESSAGEPSCLOSECONCLOSECATCHSQLEXCEPTIONE1SYSTEMOUTPRINTLN“异常“E1JB02ADDACTIONLISTENERNEWACTIONLISTENERPUBLICVOIDACTIONPERFORMEDACTIONEVENTESTRINGBHJT1GETTEXTSTRINGXBJT4GETTEXTTRYCLASSFORNAMEDRIVERCATCHCLASSNOTFOUNDEXCEPTIONARG0SYSTEMOUTPRINT“无法创建驱动程式实体“TRYCLASSFORNAMEDRIVER/加载驱动CATCHCLASSNOTFOUNDEXCEPTIONEVENTSYSTEMOUTPRINT“无法创建驱动程式实体“TRYCONDRIVERMANAGERGETCONNECTIONURL,“SA“,“123456“CONSETAUTOCOMMITTRUESYSTEMOUTPRINTLN“和数据库已经建立连接“SQ“UPDATEBIAO1SETZGXB“XB“WHEREZGBH“PSCONPREPARESTATEMENTSQPSSETSTRING1,BHINTTPSEXECUTEUPDATEIFT0JOPTIONPANESHOWMESSAGEDIALOGNULL,“修改成功“,“提示“,JOPTIONPANEINFORMATION_MESSAGEELSEJOPTIONPANESHOWMESSAGEDIALOGNULL,“修改失败“,“提示“,JOPTIONPANEERROR_MESSAGEPSCLOSECONCLOSECATCHSQLEXCEPTIONE1SYSTEMOUTPRINTLN“异常“E1JB03ADDACTIONLISTENERNEWACTIONLISTENERPUBLICVOIDACTIONPERFORMEDACTIONEVENTESTRINGBHJT1GETTEXTSTRINGZWJT5GETTEXTTRYCLASSFORNAMEDRIVERCATCHCLASSNOTFOUNDEXCEPTIONARG0SYSTEMOUTPRINT“无法创建驱动程式实体“TRYCLASSFORNAMEDRIVER/加载驱动CATCHCLASSNOTFOUNDEXCEPTIONEVENTSYSTEMOUTPRINT“无法创建驱动程式实体“TRYCONDRIVERMANAGERGETCONNECTIONURL,“SA“,“123456“CONSETAUTOCOMMITTRUESYSTEMOUTPRINTLN“和数据库已经建立连接“SQ“UPDATEBIAO1SETXRZW“ZW“WHEREZGBH“PSCONPREPARESTATEMENTSQPSSETSTRING1,BHINTTPSEXECUTEUPDATEIFT0JOPTIONPANESHOWMESSAGEDIALOGNULL,“修改成功“,“提示“,JOPTIONPANEINFORMATION_MESSAGEELSEJOPTIONPANESHOWMESSAGEDIALOGNULL,“修改失败“,“提示“,JOPTIONPANEERROR_MESSAGEPSCLOSECONCLOSECATCHSQLEXCEPTIONE1SYSTEMOUTPRINTLN“异常“E1JB04ADDACTIONLISTENERNEWACTIONLISTENERPUBLICVOIDACTIONPERFORMEDACTIONEVENTESTRINGBHJT1GETTEXTSTRINGZKJT6GETTEXTTRYCLASSFORNAMEDRIVERCATCHCLASSNOTFOUNDEXCEPTIONARG0SYSTEMOUTPRINT“无法创建驱动程式实体“TRYCLASSFORNAMEDRIVER/加载驱动CATCHCLASSNOTFOUNDEXCEPTIONEVENTSYSTEMOUTPRINT“无法创建驱动程式实体“TRYCONDRIVERMANAGERGETCONNECTIONURL,“SA“,“123456“CONSETAUTOCOMMITTRUESYSTEMOUTPRINTLN“和数据库已经建立连接“SQ“UPDATEBIAO1SETHYZK“ZK“WHEREZGBH“PSCONPREPARESTATEMENTSQPSSETSTRING1,BHINTTPSEXECUTEUPDATEIFT0JOPTIONPANESHOWMESSAGEDIALOGNULL,“修改成功“,“提示“,JOPTIONPANEINFORMATION_MESSAGEELSEJOPTIONPANESHOWMESSAGEDIALOGNULL,“修改失败“,“提示“,JOPTIONPANEERROR_MESSAGEPSCLOSECONCLOSECATCHSQLEXCEPTIONE1SYSTEMOUTPRINTLN“异常“E1JB05ADDACTIONLISTENERNEWACTIONLISTENERPUBLICVOIDACTIONPERFORMEDACTIONEVENTESTRINGBHJT1GETTEXTINTNLINTEGERPARSEINTJT7GETTEXTTRYCLASSFORNAMEDRIVERCATCHCLASSNOTFOUNDEXCEPTIONARG0SYSTEMOUTPRINT“无法创建驱动程式实体“TRYCLASSFORNAMEDRIVER/加载驱动CATCHCLASSNOTFOUNDEXCEPTIONEVENTSYSTEMOUTPRINT“无法创建驱动程式实体“TRYCONDRIVERMANAGERGETCONNECTIONURL,“SA“,“123456“CONSETAUTOCOMMITTRUESYSTEMOUTPRINTLN“和数据库已经建立连接“SQ“UPDATEBIAO1SETZGNL“NL“WHEREZGBH“PSCONPREPARESTATEMENTSQPSSETSTRING1,BHINTTPSEXECUTEUPDATEIFT0JOPTIONPANESHOWMESSAGEDIALOGNULL,“修改成功“,“提示“,JOPTIONPANEINFORMATION_MESSAGEELSEJOPTIONPANESHOWMESSAGEDIALOGNULL,“修改失败“,“提示“,JOPTIONPANEERROR_MESSAGEPSCLOSECONCLOSECATCHSQLEXCEPTIONE1SYSTEMOUTPRINTLN“异常“E1PUBLICVOIDACTIONPERFORMEDACTIONEVENTARG0附录16加工资代码IMPORTJAVAAWTCONTAINERIMPORTJAVAAWTEVENTACTIONEVENTIMPORTJAVAAWTEVENTACTIONLISTENERIMPORTJAVASQLCONNECTIONIMPORTJAVASQLDRIVERMANAGERIMPORTJAVASQLPREPAREDSTATEMENTIMPORTJAVASQLRESULTSETIMPORTJAVASQLSQLEXCEPTIONIMPORTJAVASQLSTATEMENTIMPORTJAVAXSWINGCLASSSUBSALARYEXTENDSJFRAMEIMPLEMENTSACTIONLISTENERSTRINGURL“JDBCSQLSERVER/LOCALHOST1433DATABASENAMEXT“STRINGDRIVER“COMMICROSOFTSQLSERVERJDBCSQLSERVERDRIVER“STATEMENTSTCONNECTIONCONPRIVATEJTEXTFIELDJT1NEWJTEXTFIELDPRIVATEJLABELJL1NEWJLABEL“请输入扣工资职工编号“PRIVATEJLABELJL2NEWJLABEL“请输入扣工资的金额“PRIVATEJTEXTFIELDJT2NEWJTEXTFIELDPRIVATEJTEXTFIELDJT3NEWJTEXTFIELDPRIVATEJBUTTONJBNEWJBUTTON“确定“PUBLICSUBSALARYIMAGEICONIMGNEWIMAGEICON“2JPG“JLABELIMGLABELNEWJLABELIMGTHISGETLAYEREDPANEADDIMGLABEL,NEWINTEGERINTEGERMIN_VALUEIMGLABELSETBOUNDS0,0,IMGGETICONWIDTH,IMGGETICONHEIGHT/设置背景标签的位置CONTAINERCPTHISGETCONTENTPANECPSETLAYOUTNULLJPANELCPSETOPAQUEFALSETHISSETLAYOUTNULLTHISSETBOUNDS500,200,400,300THISSETTITLE“扣工资