java和sql-server2000开发的职工和工资管理系统(全过程及代码)

工资管理系统一，设计数据库SALARYMANAGEMENT职工表工资表二，创建“数据源ODBC”具体步骤“开始”“控制面板”“管理工具”“数据源ODBC在用户DNS里，点“添加”在数据源驱动列表最下方选择“SQLSERVER”点“完成”出现了一个创建到SQLSERVER的新数据源在数据源“名称”右侧，填写数据库的名称在“服务器”右侧，写LOCAL点“下一步”继续点“下一步”在更改默认的数据库为“SALARYMANAGEMENT”，这里的数据库为我刚刚新建的数据库。点“下一步”点“完成”出现一个“ODBCMICROSOFTSQLSERVER安装”对话框点击下面的“测试数据源”出现图21就好了。图21下面依次点击“确定”就完成了。完成了以后，你会在数据源里看到自己刚刚新建的数据源，名为“SALARYMANAGEMENT”三代码的编写31数据库连接（文件名DBCONNECTJAVA）注意，这个文件最好先编译，因为后面的MAINJAVA文件的编译会用到该文件编译完产生的DBCONNECTCLASS文件/类DBCONNECT用于数据库的连接/导入SQL包IMPORTJAVASQL/创建数据库连接类DBCONNECTPUBLICCLASSDBCONNECT/静态方法提高数据库的连接效率PUBLICSTATICCONNECTIONGETCONNTHROWSEXCEPTION/加载JDBC驱动CLASSFORNAME“SUNJDBCODBCJDBCODBCDRIVER“/以系统默认用户身份，连接数据库STUDENTMANAGERRETURNDRIVERMANAGERGETCONNECTION“JDBCODBCSALARYMANAGEMENT“,“,“32添加职工信息（文件名ADDEMPLOYEEJAVA）/添加职工面板类ADDEMPLOYEE/导入系统的类包IMPORTJAVAAWTIMPORTJAVASQLIMPORTJAVAXSWINGIMPORTJAVAAWTEVENT/创建“添加职工“面板类PUBLICCLASSADDEMPLOYEEEXTENDSJPANELIMPLEMENTSACTIONLISTENER/声明连接数据库对象CONNECTIONCON/声明SQL语句对象STATEMENTST/创建组件对象标签、文本行、单选JLABELJLABEL1NEWJLABEL“职工工号“JLABELJLABEL2NEWJLABEL“职工姓名“JLABELJLABEL3NEWJLABEL“职工性别“JLABELJLABEL4NEWJLABEL“职工年龄“JLABELJLABEL5NEWJLABEL“家庭住址“JLABELJLABEL6NEWJLABEL“联系电话“JTEXTFIELDJTEXTFIELD1NEWJTEXTFIELDJTEXTFIELDJTEXTFIELD2NEWJTEXTFIELDJTEXTFIELDJTEXTFIELD3NEWJTEXTFIELDJTEXTFIELDJTEXTFIELD4NEWJTEXTFIELDJTEXTFIELDJTEXTFIELD5NEWJTEXTFIELDJRADIOBUTTONJRADIOBUTTON1NEWJRADIOBUTTON“男“JRADIOBUTTONJRADIOBUTTON2NEWJRADIOBUTTON“女“BUTTONGROUPBUTTONGROUP1NEWBUTTONGROUPJBUTTONJBUTTON1NEWJBUTTON“添加职工“/构造方法PUBLICADDEMPLOYEETRY/调用初始化方法JBINITCATCHEXCEPTIONEXCEPTIONEXCEPTIONPRINTSTACKTRACE/界面初始化方法PRIVATEVOIDJBINITTHROWSEXCEPTION/连接数据库CONDBCONNECTGETCONNSTCONCREATESTATEMENT/框架的布局THISSETLAYOUTNULL/设置各组件的大小JLABEL1SETBOUNDSNEWRECTANGLE21,17,64,24JLABEL2SETBOUNDSNEWRECTANGLE21,51,53,22JLABEL3SETBOUNDSNEWRECTANGLE21,86,61,27JLABEL4SETBOUNDSNEWRECTANGLE21,122,59,25JLABEL5SETBOUNDSNEWRECTANGLE21,168,54,24JLABEL6SETBOUNDSNEWRECTANGLE21,205,54,24JTEXTFIELD1SETBOUNDSNEWRECTANGLE102,10,200,30JTEXTFIELD2SETBOUNDSNEWRECTANGLE102,49,200,30JTEXTFIELD3SETBOUNDSNEWRECTANGLE102,117,80,33JTEXTFIELD4SETBOUNDSNEWRECTANGLE102,163,200,29JTEXTFIELD5SETBOUNDSNEWRECTANGLE102,200,200,29JRADIOBUTTON1SETBOUNDSNEWRECTANGLE102,83,65,30JRADIOBUTTON2SETBOUNDSNEWRECTANGLE190,85,85,30JBUTTON1SETBOUNDSNEWRECTANGLE130,240,150,32/设置单选按钮被选中JRADIOBUTTON1SETSELECTEDTRUE/添加按钮动作事件JBUTTON1ADDACTIONLISTENERTHIS/添加组件到面板THISADDJLABEL1THISADDJTEXTFIELD1THISADDJLABEL2THISADDJTEXTFIELD2THISADDJLABEL3BUTTONGROUP1ADDJRADIOBUTTON1BUTTONGROUP1ADDJRADIOBUTTON2THISADDJRADIOBUTTON1THISADDJRADIOBUTTON2THISADDJLABEL4THISADDJTEXTFIELD3THISADDJLABEL5THISADDJTEXTFIELD4THISADDJLABEL6THISADDJTEXTFIELD5THISADDJBUTTON1/点击按钮事件PUBLICVOIDACTIONPERFORMEDACTIONEVENTE/获取用户输入的信息STRINGEMPLOYEEIDJTEXTFIELD1GETTEXTSTRINGEMPLOYEENAMEJTEXTFIELD2GETTEXTSTRINGEMPLOYEESEX“IFJRADIOBUTTON1ISSELECTEDEMPLOYEESEX“男“IFJRADIOBUTTON2ISSELECTEDEMPLOYEESEX“女“STRINGEMPLOYEEAGEJTEXTFIELD3GETTEXTSTRINGEMPLOYEEADDRESSJTEXTFIELD4GETTEXTSTRINGEMPLOYEEPHONEJTEXTFIELD5GETTEXTTRY/设置日期格式STEXECUTE“SETDATEFORMATYMD“/利用ST对象执行SQL语句，进行插入操作STEXECUTEUPDATE“INSERTINTOEMPLOYEEVALUES“EMPLOYEEID“,“EMPLOYEENAME“,“EMPLOYEESEX“,“EMPLOYEEAGE“,“EMPLOYEEADDRESS“,“EMPLOYEEPHONE“/利用消息对话框提示职工添加成功JOPTIONPANESHOWMESSAGEDIALOGTHIS,“职工添加成功“/清空文本行的内容JTEXTFIELD1SETTEXT“JTEXTFIELD2SETTEXT“JTEXTFIELD3SETTEXT“JTEXTFIELD4SETTEXT“JTEXTFIELD5SETTEXT“CATCHEXCEPTIONEX/利用消息对话框提示异常的信息JOPTIONPANESHOWMESSAGEDIALOGTHIS,“职工添加失败“EXPRINTSTACKTRACE33修改职工信息（文件名MODIFYEMPLOYEEJAVA）/“职工信息修改”面板类MODIFYEMPLOYEE/导入系统的类包IMPORTJAVAAWTIMPORTJAVASQLIMPORTJAVAXSWINGIMPORTJAVAAWTEVENT/创建“职工信息修改资”类PUBLICCLASSMODIFYEMPLOYEEEXTENDSJPANELIMPLEMENTSACTIONLISTENER/声明连接数据库对象CONNECTIONCON/声明SQL语句对象STATEMENTST/创建组件对象标签、文本行、单选JLABELJLABEL1NEWJLABEL“请输入职工的编号“JTEXTFIELDJTEXTFIELD1NEWJTEXTFIELDJBUTTONJBUTTON1NEWJBUTTON“查找该职工“JLABELJLABEL2NEWJLABEL“职工编号“JTEXTFIELDJTEXTFIELD2NEWJTEXTFIELDJLABELJLABEL3NEWJLABEL“职工姓名“JTEXTFIELDJTEXTFIELD3NEWJTEXTFIELDJLABELJLABEL4NEWJLABEL“职工性别“JTEXTFIELDJTEXTFIELD4NEWJTEXTFIELDJLABELJLABEL5NEWJLABEL“职工年龄“JTEXTFIELDJTEXTFIELD5NEWJTEXTFIELDJLABELJLABEL6NEWJLABEL“家庭住址“JTEXTFIELDJTEXTFIELD6NEWJTEXTFIELDJLABELJLABEL7NEWJLABEL“联系电话“JTEXTFIELDJTEXTFIELD7NEWJTEXTFIELDJBUTTONJBUTTON2NEWJBUTTON“修改职工信息“/构造方法PUBLICMODIFYEMPLOYEETRY/调用初始化方法JBINITCATCHEXCEPTIONEXCEPTIONEXCEPTIONPRINTSTACKTRACE/面板初始化方法PRIVATEVOIDJBINITTHROWSEXCEPTION/连接数据库CONDBCONNECTGETCONNSTCONCREATESTATEMENT/框架的布局THISSETLAYOUTNULL/设置各组件的大小JLABEL1SETFONTNEWJAVAAWTFONT“楷体“,FONTBOLD,14JLABEL1SETBOUNDSNEWRECTANGLE40,15,140,30JTEXTFIELD1SETBOUNDSNEWRECTANGLE185,15,120,30JBUTTON1SETBOUNDSNEWRECTANGLE110,55,150,30JLABEL2SETFONTNEWJAVAAWTFONT“楷体“,FONTBOLD,14JLABEL2SETBOUNDSNEWRECTANGLE20,105,80,30JTEXTFIELD2SETBOUNDSNEWRECTANGLE100,105,80,30JLABEL3SETFONTNEWJAVAAWTFONT“楷体“,FONTBOLD,14JLABEL3SETBOUNDSNEWRECTANGLE190,105,80,30JTEXTFIELD3SETBOUNDSNEWRECTANGLE270,105,80,30JLABEL4SETFONTNEWJAVAAWTFONT“楷体“,FONTBOLD,14JLABEL4SETBOUNDSNEWRECTANGLE20,145,80,30JTEXTFIELD4SETBOUNDSNEWRECTANGLE100,145,80,30JLABEL5SETFONTNEWJAVAAWTFONT“楷体“,FONTBOLD,14JLABEL5SETBOUNDSNEWRECTANGLE190,145,80,30JTEXTFIELD5SETBOUNDSNEWRECTANGLE270,145,80,30JLABEL6SETFONTNEWJAVAAWTFONT“楷体“,FONTBOLD,14JLABEL6SETBOUNDSNEWRECTANGLE20,185,80,30JTEXTFIELD6SETBOUNDSNEWRECTANGLE100,185,80,30JLABEL7SETFONTNEWJAVAAWTFONT“楷体“,FONTBOLD,14JLABEL7SETBOUNDSNEWRECTANGLE190,185,80,30JTEXTFIELD7SETBOUNDSNEWRECTANGLE270,185,80,30JBUTTON2SETBOUNDSNEWRECTANGLE120,240,150,30/添加按钮动作事件JBUTTON1ADDACTIONLISTENERTHISJBUTTON2ADDACTIONLISTENERTHIS/添加组件到面板THISADDJLABEL1THISADDJTEXTFIELD1THISADDJBUTTON1THISADDJLABEL2THISADDJTEXTFIELD2JTEXTFIELD2SETEDITABLEFALSETHISADDJLABEL3THISADDJTEXTFIELD3THISADDJLABEL4THISADDJTEXTFIELD4THISADDJLABEL5THISADDJTEXTFIELD5THISADDJLABEL6THISADDJTEXTFIELD6THISADDJLABEL7THISADDJTEXTFIELD7THISADDJBUTTON2/点击按钮事件PUBLICVOIDACTIONPERFORMEDACTIONEVENTACTIONEVENT/点击“查找该职工”按钮IFACTIONEVENTGETSOURCEJBUTTON1TRY/利用ST对象执行SQL语句，返回结果集对象RESULTSETRSSTEXECUTEQUERY“SELECTFROMEMPLOYEEWHERE职工编号“JTEXTFIELD1GETTEXT“/处理结果集IFRSNEXTJTEXTFIELD2SETTEXTRSGETSTRING“职工编号“JTEXTFIELD3SETTEXTRSGETSTRING“职工姓名“JTEXTFIELD4SETTEXTRSGETSTRING“职工性别“JTEXTFIELD5SETTEXTRSGETSTRING“职工年龄“JTEXTFIELD6SETTEXTRSGETSTRING“家庭住址“JTEXTFIELD7SETTEXTRSGETSTRING“联系电话“ELSEJOPTIONPANESHOWMESSAGEDIALOGTHIS,“没有这个工号的职工“CATCHEXCEPTIONEX/利用消息对话框提示查询失败JOPTIONPANESHOWMESSAGEDIALOGTHIS,“职工信息修改失败“/点击“修改工资”按钮IFACTIONEVENTGETSOURCEJBUTTON2/获取用户更改的工资TRY/利用ST对象执行SQL语句，进行插入操作STEXECUTEUPDATE“UPDATEEMPLOYEESET职工姓名“JTEXTFIELD3GETTEXT“WHERE职工编号“JTEXTFIELD2GETTEXT“STEXECUTEUPDATE“UPDATEEMPLOYEESET职工性别“JTEXTFIELD4GETTEXT“WHERE职工编号“JTEXTFIELD2GETTEXT“STEXECUTEUPDATE“UPDATEEMPLOYEESET职工年龄“JTEXTFIELD5GETTEXT“WHERE职工编号“JTEXTFIELD2GETTEXT“STEXECUTEUPDATE“UPDATEEMPLOYEESET家庭住址“JTEXTFIELD6GETTEXT“WHERE职工编号“JTEXTFIELD2GETTEXT“STEXECUTEUPDATE“UPDATEEMPLOYEESET联系电话“JTEXTFIELD7GETTEXT“WHERE职工编号“JTEXTFIELD2GETTEXT“/利用消息对话框提示职工信息修改成功JOPTIONPANESHOWMESSAGEDIALOGTHIS,“职工信息修改成功“CATCHEXCEPTIONEX/利用消息对话框提示异常的信息JOPTIONPANESHOWMESSAGEDIALOGTHIS,“职工信息修改失败“EXPRINTSTACKTRACE34删除职工信息（文件名DELETEEMPLOYEEJAVA）/”删除职工“面板类DELETEEMPLOYEE/导入系统的类包IMPORTJAVAAWTIMPORTJAVASQLIMPORTJAVAXSWINGIMPORTJAVAAWTEVENT/创建“删除职工”类PUBLICCLASSDELETEEMPLOYEEEXTENDSJPANELIMPLEMENTSACTIONLISTENER/声明连接数据库对象CONNECTIONCON/声明SQL语句对象STATEMENTST/创建组件对象JLABELJLABEL1NEWJLABEL“请输入待删除的职工的编号“JTEXTFIELDJTEXTFIELD1NEWJTEXTFIELDJBUTTONJBUTTON1NEWJBUTTON“删除“/构造方法PUBLICDELETEEMPLOYEETRY/调用初始化方法JBINITCATCHEXCEPTIONEXCEPTIONEXCEPTIONPRINTSTACKTRACE/界面初始化方法PRIVATEVOIDJBINITTHROWSEXCEPTION/连接数据库CONDBCONNECTGETCONNSTCONCREATESTATEMENT/框架的布局THISSETLAYOUTNULL/设置各组件的大小JLABEL1SETFONTNEWJAVAAWTFONT“黑体“,FONTBOLD,14JLABEL1SETBOUNDSNEWRECTANGLE70,20,200,30JTEXTFIELD1SETBOUNDSNEWRECTANGLE70,80,207,41JBUTTON1SETBOUNDSNEWRECTANGLE70,175,205,36/添加按钮动作事件JBUTTON1ADDACTIONLISTENERTHIS/添加组件到面板THISADDJLABEL1THISADDJTEXTFIELD1THISADDJBUTTON1/点击按钮事件PUBLICVOIDACTIONPERFORMEDACTIONEVENTE/获取用户输入的职工编号STRINGEMPLOYEEIDJTEXTFIELD1GETTEXT/要求用户确认删除IFJOPTIONPANESHOWCONFIRMDIALOGTHIS,“确认要删除吗“JOPTIONPANEYES_OPTIONTRY/利用ST对象执行SQL删除操作STEXECUTEUPDATE“DELETEFROMEMPLOYEEWHERE职工编号“EMPLOYEEID“/利用消息对话框提示删除操作成功JOPTIONPANESHOWMESSAGEDIALOGTHIS,“职工删除操作，执行成功“/清空输入学号的文本行JTEXTFIELD1SETTEXT“CATCHEXCEPTIONEX/利用消息对话框提示不能删除JOPTIONPANESHOWMESSAGEDIALOGTHIS,“职工删除操作，执行失败“35添加工资类（文件名ADDSALARYJAVA）/“添加工资“面板类ADDSALARY/导入系统的类包IMPORTJAVAAWTIMPORTJAVASQLIMPORTJAVAXSWINGIMPORTJAVAAWTEVENT/创建“添加工资“类PUBLICCLASSADDSALARYEXTENDSJPANELIMPLEMENTSACTIONLISTENER/声明连接数据库对象CONNECTIONCON/声明SQL语句对象STATEMENTST/创建组件对象标签、文本行、单选JLABELJLABEL1NEWJLABEL“职工工号“JLABELJLABEL2NEWJLABEL“职工工资“JTEXTFIELDJTEXTFIELD1NEWJTEXTFIELDJTEXTFIELDJTEXTFIELD2NEWJTEXTFIELDJBUTTONJBUTTON1NEWJBUTTON“添加工资“/构造方法PUBLICADDSALARYTRY/调用初始化方法JBINITCATCHEXCEPTIONEXCEPTIONEXCEPTIONPRINTSTACKTRACE/界面初始化方法PRIVATEVOIDJBINITTHROWSEXCEPTION/连接数据库CONDBCONNECTGETCONNSTCONCREATESTATEMENT/框架的布局THISSETLAYOUTNULL/设置各组件的大小JLABEL1SETBOUNDSNEWRECTANGLE21,17,64,24JLABEL2SETBOUNDSNEWRECTANGLE21,51,53,22JTEXTFIELD1SETBOUNDSNEWRECTANGLE102,10,200,30JTEXTFIELD2SETBOUNDSNEWRECTANGLE102,60,200,30JBUTTON1SETBOUNDSNEWRECTANGLE130,120,150,32/添加按钮动作事件JBUTTON1ADDACTIONLISTENERTHIS/添加组件到面板THISADDJLABEL1THISADDJTEXTFIELD1THISADDJLABEL2THISADDJTEXTFIELD2THISADDJBUTTON1/点击按钮事件PUBLICVOIDACTIONPERFORMEDACTIONEVENTE/获取用户输入的信息STRINGEMPLOYEEIDJTEXTFIELD1GETTEXTSTRINGEMPLOYEESALARYJTEXTFIELD2GETTEXTTRY/利用ST对象执行SQL语句，进行插入操作STEXECUTEUPDATE“INSERTINTOSALARYVALUES“EMPLOYEEID“,“EMPLOYEESALARY“/利用消息对话框提示工资添加成功JOPTIONPANESHOWMESSAGEDIALOGTHIS,“工资添加成功“/清空文本行的内容JTEXTFIELD1SETTEXT“JTEXTFIELD2SETTEXT“CATCHEXCEPTIONEX/利用消息对话框提示异常的信息JOPTIONPANESHOWMESSAGEDIALOGTHIS,“工资添加失败“EXPRINTSTACKTRACE36修改工资信息（文件名MODIFYSALARYJAVA）/“修改工资”面板类MODIFYSALARY/导入系统的类包IMPORTJAVAAWTIMPORTJAVASQLIMPORTJAVAXSWINGIMPORTJAVAAWTEVENT/创建“修改工资”面板类PUBLICCLASSMODIFYSALARYEXTENDSJPANELIMPLEMENTSACTIONLISTENER/声明连接数据库对象CONNECTIONCON/声明SQL语句对象STATEMENTST/创建组件对象标签、文本行、单选JLABELJLABEL1NEWJLABEL“请输入职工的编号“JTEXTFIELDJTEXTFIELD1NEWJTEXTFIELDJBUTTONJBUTTON1NEWJBUTTON“查找该职工“JLABELJLABEL2NEWJLABEL“职工编号“JTEXTFIELDJTEXTFIELD2NEWJTEXTFIELDJLABELJLABEL3NEWJLABEL“职工工资“JTEXTFIELDJTEXTFIELD3NEWJTEXTFIELDJBUTTONJBUTTON2NEWJBUTTON“修改工资“/构造方法PUBLICMODIFYSALARYTRY/调用初始化方法JBINITCATCHEXCEPTIONEXCEPTIONEXCEPTIONPRINTSTACKTRACE/面板初始化方法PRIVATEVOIDJBINITTHROWSEXCEPTION/连接数据库CONDBCONNECTGETCONNSTCONCREATESTATEMENT/框架的布局THISSETLAYOUTNULL/设置各组件的大小JLABEL1SETFONTNEWJAVAAWTFONT“楷体“,FONTBOLD,14JLABEL1SETBOUNDSNEWRECTANGLE40,25,140,30JTEXTFIELD1SETBOUNDSNEWRECTANGLE185,25,120,30JBUTTON1SETBOUNDSNEWRECTANGLE110,65,120,30JLABEL2SETFONTNEWJAVAAWTFONT“楷体“,FONTBOLD,14JLABEL2SETBOUNDSNEWRECTANGLE90,125,80,30JTEXTFIELD2SETBOUNDSNEWRECTANGLE170,125,80,30JLABEL3SETFONTNEWJAVAAWTFONT“楷体“,FONTBOLD,14JLABEL3SETBOUNDSNEWRECTANGLE90,160,80,30JTEXTFIELD3SETBOUNDSNEWRECTANGLE170,160,80,30JBUTTON2SETBOUNDSNEWRECTANGLE120,200,100,30/添加按钮动作事件JBUTTON1ADDACTIONLISTENERTHISJBUTTON2ADDACTIONLISTENERTHIS/添加组件到面板THISADDJLABEL1THISADDJTEXTFIELD1THISADDJBUTTON1THISADDJLABEL2THISADDJTEXTFIELD2JTEXTFIELD2SETEDITABLEFALSETHISADDJLABEL3THISADDJTEXTFIELD3THISADDJBUTTON2/点击按钮事件PUBLICVOIDACTIONPERFORMEDACTIONEVENTACTIONEVENT/点击“查找该职工”按钮IFACTIONEVENTGETSOURCEJBUTTON1/获取输入的职工的编号STRINGEMPLOYEEIDJTEXTFIELD1GETTEXTTRY/利用ST对象执行SQL语句，返回结果集对象RESULTSETRSSTEXECUTEQUERY“SELECTFROMSALARYWHERE职工编号“EMPLOYEEID“/处理结果集IFRSNEXTJTEXTFIELD2SETTEXTRSGETSTRING“职工编号“JTEXTFIELD3SETTEXTRSGETSTRING“职工工资“ELSEJOPTIONPANESHOWMESSAGEDIALOGTHIS,“没有这个工号的职工“CATCHEXCEPTIONEX/利用消息对话框提示查询失败JOPTIONPANESHOWMESSAGEDIALOGTHIS,“工资修改失败“/点击“修改工资”按钮IFACTIONEVENTGETSOURCEJBUTTON2/获取用户更改的工资TRY/利用ST对象执行SQL语句，进行修改操作STEXECUTEUPDATE“UPDATESALARYSET职工工资“JTEXTFIELD3GETTEXT“WHERE职工编号“JTEXTFIELD2GETTEXT“/利用消息对话框提示工资修改成功JOPTIONPANESHOWMESSAGEDIALOGTHIS,“工资修改成功“CATCHEXCEPTIONEX/利用消息对话框提示异常的信息JOPTIONPANESHOWMESSAGEDIALOGTHIS,“工资修改失败“EXPRINTSTACKTRACE37查询工资（文件名SALARYINQUIREJAVA）/“工资查询“面板类SALARYINQUIRE/导入系统的类包IMPORTJAVAAWTIMPORTJAVASQLIMPORTJAVAXSWINGIMPORTJAVAAWTEVENT/创建“工资查询”类PUBLICCLASSSALARYINQUIREEXTENDSJPANELIMPLEMENTSACTIONLISTENER/声明连接数据库对象CONNECTIONCON/声明SQL语句对象STATEMENTST/创建组件对象标签、文本行、单选JLABELJLABEL1NEWJLABEL“请输入要查询的职工的编号“JTEXTFIELDJTEXTFIELD1NEWJTEXTFIELDJBUTTONJBUTTON1NEWJBUTTON“工资查询“JTEXTAREAJTEXTAREA1NEWJTEXTAREA/构造方法PUBLICSALARYINQUIRETRY/调用初始化方法JBINITCATCHEXCEPTIONEXCEPTIONEXCEPTIONPRINTSTACKTRACE/面板初始化方法PRIVATEVOIDJBINITTHROWSEXCEPTION/连接数据库CONDBCONNECTGETCONNSTCONCREATESTATEMENT/框架的布局THISSETLAYOUTNULL/设置各组件的大小JLABEL1SETFONTNEWJAVAAWTFONT“黑体“,FONTBOLD,16JLABEL1SETBOUNDSNEWRECTANGLE46,4,222,32JTEXTFIELD1SETBOUNDSNEWRECTANGLE47,37,247,31JBUTTON1SETBOUNDSNEWRECTANGLE47,86,247,30JTEXTAREA1SETBOUNDSNEWRECTANGLE24,130,305,109/添加按钮动作事件JBUTTON1ADDACTIONLISTENERTHIS/添加组件到面板THISADDJLABEL1THISADDJTEXTFIELD1THISADDJTEXTAREA1THISADDJBUTTON1/点击按钮事件PUBLICVOIDACTIONPERFORMEDACTIONEVENTE/获取输入的职工的编号STRINGEMPLOYEEIDJTEXTFIELD1GETTEXT/清空文本区原有的内容JTEXTAREA1SETTEXT“TRY/利用ST对象执行SQL语句，返回结果集对象RESULTSETRSSTEXECUTEQUERY“SELECTFROMSALARYWHERE职工编号“EMPLOYEEID“/处理结果集IFRSNEXTJTEXTAREA1SETTEXT“职工编号“RSGETSTRING“职工编号“N“职工工资“RSGETSTRING“职工工资“N“ELSEJOPTIONPANESHOWMESSAGEDIALOGTHIS,“该工号的职工没有工资记录“CATCHEXCEPTIONEX/利用消息对话框提示查询失败JOPTIONPANESHOWMESSAGEDIALOGTHIS,“工资查询失败“38按编号查询程序（文件名INQUIREONGHJAVA）/“按职工的编号查询“面板类INQUIREONGH/导入系统的类包IMPORTJAVAAWTIMPORTJAVASQLIMPORTJAVAXSWINGIMPORTJAVAAWTEVENT/创建“按职工的编号查询”类PUBLICCLASSINQUIREONGHEXTENDSJPANELIMPLEMENTSACTIONLISTENER/声明连接数据库对象CONNECTIONCON/声明SQL语句对象STATEMENTST/创建组件对象标签、文本行、单选JLABELJLABEL1NEWJLABEL“请输入职工的编号“JTEXTFIELDJTEXTFIELD1NEWJTEXTFIELDJBUTTONJBUTTON1NEWJBUTTON“查找“JTEXTAREAJTEXTAREA1NEWJTEXTAREA/构造方法PUBLICINQUIREONGHTRY/调用初始化方法JBINITCATCHEXCEPTIONEXCEPTIONEXCEPTIONPRINTSTACKTRACE/面板初始化方法PRIVATEVOIDJBINITTHROWSEXCEPTION/连接数据库CONDBCONNECTGETCONNSTCONCREATESTATEMENT/框架的布局THISSETLAYOUTNULL/设置各组件的大小JLABEL1SETFONTNEWJAVAAWTFONT“黑体“,FONTBOLD,16JLABEL1SETBOUNDSNEWRECTANGLE46,4,222,32JTEXTFIELD1SETBOUNDSNEWRECTANGLE47,37,247,31JBUTTON1SETBOUNDSNEWRECTANGLE47,86,247,30JTEXTAREA1SETBOUNDSNEWRECTANGLE24,130,305,109/添加按钮动作事件JBUTTON1ADDACTIONLISTENERTHIS/添加组件到面板THISADDJLABEL1THISADDJTEXTFIELD1THISADDJTEXTAREA1THISADDJBUTTON1/点击按钮事件PUBLICVOIDACTIONPERFORMEDACTIONEVENTE/获取输入的职工的编号STRINGEMPLOYEEIDJTEXTFIELD1GETTEXT/清空文本区原有的内容JTEXTAREA1SETTEXT“TRY/利用ST对象执行SQL语句，返回结果集对象RESULTSETRSSTEXECUTEQUERY“SELECTFROMEMPLOYEEWHERE职工编号“EMPLOYEEID“/处理结果集IFRSNEXTJTEXTAREA1SETTEXT“职工编号“RSGETSTRING“职工编号“N“职工姓名“RSGETSTRING“职工姓名“N“职工性别“RSGETSTRING“职工性别“N“职工年龄“RSGETSTRING“职工年龄“N“家庭住址“RSGETSTRING“家庭住址“N“联系电话“RSGETSTRING“联系电话“N“ELSEJOPTIONPANESHOWMESSAGEDIALOGTHIS,“没有这个工号的职工“CATCHEXCEPTIONEX/利用消息对话框提示查询失败JOPTIONPANESHOWMESSAGEDIALOGTHIS,“职工查询失败“39按姓名查询程序（文件名INQUIREONNAMEJAVA）/“按职工的姓名查询“面板类INQUIREONNAME/导入系统的类包IMPORTJAVAAWTIMPORTJAVASQLIMPORTJAVAXSWINGIMPORTJAVAAWTEVENT/创建“按职工的姓名查询”类PUBLICCLASSINQUIREONNAMEEXTENDSJPANELIMPLEMENTSACTIONLISTENER/声明连接数据库对象CONNECTIONCON/声明SQL语句对象STATEMENTST/创建组件对象标签、文本行、单选JLABELJLABEL1NEWJLABEL“请输入职工的姓名“JTEXTFIELDJTEXTFIELD1NEWJTEXTFIELDJBUTTONJBUTTON1NEWJBUTTON“查找“JTEXTAREAJTEXTAREA1NEWJTEXTAREA/构造方法PUBLICINQUIREONNAMETRY/调用初始化方法JBINITCATCHEXCEPTIONEXCEPTIONEXCEPTIONPRINTSTACKTRACE/面板初始化方法PRIVATEVOIDJBINITTHROWSEXCEPTION/连接数据库CONDBCONNECTGETCONNSTCONCREATESTATEMENT/框架的布局THISSETLAYOUTNULL/设置各组件的大小JLABEL1SETFONTNEWJAVAAWTFONT“黑体“,FONTBOLD,16JLABEL1SETBOUNDSNEWRECTANGLE46,4,222,32JTEXTFIELD1SETBOUNDSNEWRECTANGLE47,37,247,31JBUTTON1SETBOUNDSNEWRECTANGLE47,86,247,30JTEXTAREA1SETBOUNDSNEWRECTANGLE24,130,305,109/添加按钮动作事件JBUTTON1ADDACTIONLISTENERTHIS/添加组件到面板THISADDJLABEL1THISADDJTEXTFIELD1THISADDJTEXTAREA1THISADDJBUTTON1/点击按钮事件PUBLICVOIDACTIONPERFORMEDACTIONEVENTE/获取输入的职工的姓名STRINGEMPLOYEENAMEJTEXTFIELD1GETTEXT/清空文本区原有的内容JTEXTAREA1SETTEXT“TRY/利用ST对象执行SQL语句，返回结果集对象RESULTSETRSSTEXECUTEQUERY“SELECTFROMEMPLOYEEWHERE职工姓名“EMPLOYEENAME“/处理结果集IFRSNEXTJTEXTAREA1SETTEXT“职工编号“RSGETSTRING“职工编号“N“职工姓名“RSGETSTRING“职工姓名“N“职工性别“RSGETSTRING“职工性别“N“职工年龄“RSGETSTRING“职工年龄“N“家庭住址“RSGETSTRING“家庭住址“N“联系电话“RSGETSTRING“联系电话“N“ELSEJOPTIONPANESHOWMESSAGEDIALOGTHIS,“没有这个工号的职工“CATCHEXCEPTIONEX/利用消息对话框提示查询失败JOPTIONPANESHOWMESSAGEDIALOGTHIS,“职工查询失败“310按帮助查询程序（文件名EMPLOYEEHELPJAVA）/“帮助”面板类EMPLOYEEHELP/导入系统的类包IMPORTJAVAAWTIMPORTJAVASQLIMPORTJAVAXSWINGIMPORTJAVAAWTEVENT/创建“帮助”面板类PUBLICCLASSEMPLOYEEHELPEXTENDSJPANEL/创建组件对象标签JLABELJLABEL1NEWJLABEL“有问题，请你联系作者“JLABELJLABEL4NEWJLABEL“林德军“JLABELJLABEL2NEWJLABEL“QQ929156887“JLABELJLABEL3NEWJLABEL“邮箱929156887QQCOM“/构造方法PUBLICEMPLOYEEHELPTRY/调用初始化方法JBINITCATCHEXCEPTIONEXCEPTIONEXCEPTIONPRINTSTACKTRACE/初始化PRIVATEVOIDJBINITTHROWSEXCEPTION/框架的布局THISSETLAYOUTNULL/设置各组件的大小JLABEL1SETFONTNEWJAVAAWTFONT“楷体“,FONTBOLD,20JLABEL1SETBOUNDSNEWRECTANGLE50,50,300,30JLABEL4SETFONTNEWJAVAAWTFONT“楷体“,FONTBOLD,20JLABEL4SETBOUNDSNEWRECTANGLE50,90,150,30JLABEL2SETFONTNEWJAVAAWTFONT“楷体“,FONTBOLD,20JLABEL2SETBOUNDSNEWRECTANGLE50,140,300,30JLABEL3SETFONTNEWJAVAAWTFONT“楷体“,FONTBOLD,20JLABEL3SETBOUNDSNEWRECTANGLE50,180,300,30/添加组件到面板THISADDJLABEL1THISADDJLABEL2THISADDJLABEL3THISADDJLABEL4311主框架程序（文件名MAINFRAMEJAVA）/系统主框架类/导入系统的包IMPORTJAVAAWTIMPORTJAVAAWTEVENTIMPORTJAVAXSWING/创建主框架类MAINFRAMEPUBLICCLASSMAINFRAMEEXTENDSJFRAMEIMPLEMENTSACTIONLISTENER/创建内容面板JPANELCONTENTPANE/创建菜单栏组件的对象JMENUBARJMENUBAR1NEWJMENUBAR/菜单条JMENUJMENU0NEWJMENU“系统“/菜单JMENUITEMJMENUITEM0NEWJMENUITEM“退出“/子菜单JMENUJMENU1NEWJMENU“职工管理“JMENUITEMJMENUITEM1NEWJMENUITEM“添加职工“JMENUITEMJMENUITEM2NEWJMENUITEM“修改职工“JMENUITEMJMENUITEM3NEWJMENUITEM“删除职工“JMENUJMENU2NEWJMENU“工资管理“JMENUITEMJMENUITEM4NEWJMENUITEM“添加工资“JMENUITEMJMENUITEM5NEWJMENUITEM“修改工资“JMENUITEMJMENUITEM8NEWJMENUITEM“工资查询“JMENUJMENU3NEWJMENU“职工查询“JMENUITEMJMENUITEM6NEWJMENUITEM“按工号查询“JMENUITEMJMENUITEM7NEWJMENUITEM“按姓名查询“JMENUJMENU4NEWJMENU“帮助“JMENUITEMJMENUITEM9NEWJMENUITEM“互动“/创建标签，用于显示信息JLABELJLABEL1NEWJLABEL“职工和工资管理小系统“JLABELJLABEL2NEWJLABEL“2010年12月22日，林德军“/创建构造方法PUBLICMAINFRAMETRY/关闭框架窗口时的默认事件方法SETDEFAULTCLOSEOPERATIO