还剩33页未读,继续阅读
本资源只提供10页预览,全部文档请下载后查看!喜欢就下载吧,查找使用更方便
文本内容:
53.
53.
63.
1.功能需求员工信息表;及时反映员工的基本信息员工津贴表,反映员工津贴员工基本工资表基本工资的设定津贴的设定计算出月工资录入员工工资信息添加员工工资信息更改员工工资信息
2.性能需求此工资管理系统对工资数据精度的计算能在默认情况之下精确到小数点后3位小数,即是精确到分的计算但在用户使用过程中,能自行根据实际情况进行小数计算精度的设定,最大能允许保留小数点后5位的精度在时间特性上,当用户发出命令请求时的服务器的响应时间、对数据更新处理、工资数据的查询检索等上,同样要求系统响应时间不会超过
0.5秒时间系统支持多种操作系统的运行环境,多不同操作系统,不同文件格式的磁盘上的数据均能实现信息的互通,及共享当服务器移植到其他的系统平台,如Linux平台下时,同样能和其他的系统进行数据存取同步,不会出现系统之间互不兼容的情况,系统支持多系统之间的互连互通,系统有巨大的强健性本课程设计是用Java语言编写,mysql数据库数据总流程图系统详细设计
1.数据库逻辑设计工资信息管理系统数据库中各个表格的设计结果如下面的几个表格所示表一员工信息表表二:基本工资表表三津贴信息表
2.各模块功能职工信息管理系统功能为财务部门相关人员录入、修改、删除、员工个人信息添加员工信息图修改员工信息图删除员工信息图职工工资管理系统功能为根据工资生成公式,按照员工的考勤情况及各种表现按月生成相应的工资;财务部门相关人员能录入、修改、删除、查询每个月每个员工的工资信息以及工资汇总;员工本人能查询自己的工资信息以及工资汇总;工资录入图工资修改图工资删除图职工登陆查询系统功能为员工本人能通过用户名和密码查询自己的信息以及修改自己的密码员工登录界面员工修改密码图设计代码DB类packagewage_management;importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;classDBextendsJFrameimplementsActionListener{publicDB{}JFrameframe=newJFrame欢迎进入企业工资管理系统;JLabellabel=newJLabelJLabel.CENTER;JButtonbutton1=newJButton进入系统;JButtonbutton2=newJButton退出系统;ImageIconim=newImageIcon1;JLabela1=newJLabelim;voidCreate{JPanelpcontentPane=JPanelframe.getContentPane;pcontentPane.adda1;pcontentPane.addlabel;pcontentPane.setLayoutnewFlowLayout;pcontentPane.addbutton1;pcontentPane.addbutton2;pcontentPane.setVisibletrue;button
1.addActionListenerthis;button
2.addActionListenerthis;frame.setDefaultCloseOperationJFrame.EXIT_ON_CLOSE;frame.pack;frame.setBounds200100550180;frame.setVisibletrue;}publicstaticvoidmainString[]args{DBdome=newDB;dome.Create;}publicvoidactionPerformedActionEvente{ifbutton
1.equalse.getSource{DLdl=newDL;dl.create;frame.dispose;}ifbutton
2.equalse.getSource{//退出System.exit0;}}}登录类packagewage_management;importjava.awt.Color;importjava.awt.FlowLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.Statement;importjavax.swing.ImageIcon;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JPasswordField;importjavax.swing.JTextField;classDLextendsJFrameimplementsActionListener{ImageIconim=newImageIcon
2.jpg;JLabela2=newJLabelim;JFrameframe=newJFrame职工/管理员登陆;JLabellabel1=newJLabel用户名;JLabellabel2=newJLabel密码;JButtonlogonButton1=newJButton管理员登录;JButtonlogonButton2=newJButton职工登录;JButtoncancelButton=newJButton退出;JTextFieldusername=newJTextField9;JPasswordFieldpassword=newJPasswordField9;staticStringt1;staticStringt2;publicvoidcreate{JPanelp=JPanelframe.getContentPane;JPanelp1=newJPanel;p.setLayoutnewFlowLayout;p.adda2;p.addlabel1;p.setSize55;p.setLocation48;p.addusername;p.setSize100200;p.setLocation800800;p.addlabel2;p.setSize5020;p.setLocation4080;p.addpassword;p.setSize10020;p.setLocation80120;p.addlogonButton1;p.addlogonButton2;p.addcancelButton;p.setBackgroundColor.cyan;p.setVisibletrue;logonButton
1.addActionListenerthis;logonButton
2.addActionListenerthis;cancelButton.addActionListenerthis;frame.setDefaultCloseOperationJFrame.EXIT_ON_CLOSE;frame.pack;frame.setBounds200100500220;frame.setVisibletrue;}publicvoidactionPerformedActionEvente{t1=username.getText;t2=password.getText;ife.getSource==logonButton1{ifusername.getText.equalsadmin==truepassword.getText.equals123456==true{JOptionPane.showMessageDialogthis登录成功!;GZGLZJMgz=newGZGLZJM;gz.create;frame.dispose;}else{JOptionPane.showMessageDialognull输入用户名或密码错误!;}}ife.getSource==logonButton2{try{Connectioncon;Statementps;ResultSetrs;Stringsql=null;Class.forNameorg.gjt.mm.mysql.Driver;Class.forNameorg.gjt.mm.mysql.Driver.newInstance;con=DriverManager.getConnectionjdbc:mysql://localhost:3306/db_bookroot123456;sql=select*fromworkerinfowherename=+t1+andmi=+t2+;ps=PreparedStatementcon.prepareStatementsql;rs=ps.executeQuerysql;ifrs.next{ifrs.getStringname.equalst1rs.getStringmi.equalst2{YGGLZJMyg=newYGGLZJM;yg.create;frame.dispose;JOptionPane.showMessageDialogthis登录成功!;this.dispose;}}else{JOptionPane.showMessageDialogthis输入用户名或密码错误!;}}catchExceptione1{//TODOAuto-generatedcatchblocke
1.printStackTrace;}}ifcancelButton.equalse.getSource//退出{System.exit0;}}}packagewage_management;importjava.sql.Connection;importjava.sql.DriverManager;DLUtil类publicclassDLUtil{privateStringdbUrl=jdbc:mysql://localhost:3306/db_book;privateStringdbUserName=root;privateStringdbPassword=123456;privateStringjdbcName=com.mysql.jdbc.Driver;//驱动名称publicConnectiongetConthrowsException{Class.forNamejdbcName;Connectioncon=DriverManager.getConnectiondbUrldbUserNamedbPassword;returncon;}publicvoidcloseConConnectionconthrowsException{ifcon!=null{con.close;}}//ceshipublicstaticvoidmainString[]args{DLUtildbUtil=newDLUtil;try{dbUtil.getCon;System.out.println数据库连接成功!;}catchExceptione{//TODOAuto-generatedcatchblocke.printStackTrace;System.out.println数据库连接失败!;}}}工资管理类packagewage_management;importjava.awt.Color;importjava.awt.FlowLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JScrollPane;importjavax.swing.JSplitPane;importjavax.swing.JTable;importjavax.swing.JTextField;publicclassGZGLextendsJFrameimplementsActionListener{publicGZGL{}JFramef=newJFrame工资管理;JButtonb1=newJButton录入;JButtonb2=newJButton修改;JButtonb3=newJButton删除;JButtonb4=newJButton查询所有;JButtonb5=newJButton返回;JTextFieldtf1=newJTextField4;JTextFieldtf2=newJTextField4;JTextFieldtf3=newJTextField4;JTextFieldtf4=newJTextField4;JTextFieldtf5=newJTextField6;JTextFieldtf6=newJTextField7;String[]cloum={职工号姓名津贴月基本工资月薪};Object[][]row=newObject
[50]
[5];JTabletable=newJTablerowcloum;JScrollPanescrollpane=newJScrollPanetable;JSplitPanesplitpane=newJSplitPaneJSplitPane.VERTICAL_SPLIT;publicvoidcreate{JPanelp=JPanelf.getContentPane;p.setLayoutnewFlowLayout;p.addscrollpane;p.addsplitpane;JPanelp1=newJPanel;p
1.addb1;p
1.addb2;p
1.addb3;p
1.addb4;p
1.addb5;JPanelp2=newJPanel;p
2.setBackgroundColor.cyan;p
2.addscrollpane;JPanelp3=newJPanel;p.setLayoutnewFlowLayout;p.addnewJLabel;p.addnewJLabel职工号;p.addtf1;p.addnewJLabel姓名;p.addtf2;p.addnewJLabel津贴;p.addtf3;p.addnewJLabel月基本工资;p.addtf4;p.addnewJLabel月薪;p.addtf5;p.addnewJLabel在此处输入职工号点击查询删除;p.addtf6;splitpane.addp1splitpane.TOP;splitpane.addp2splitpane.BOTTOM;splitpane.setDividerLocation50;p.setBackgroundColor.CYAN;b
1.addActionListenerthis;b
2.addActionListenerthis;b
3.addActionListenerthis;b
4.addActionListenerthis;b
5.addActionListenerthis;f.setBounds200100500600;f.setResizabletrue;//可以调整界面大小f.setVisibletrue;}publicvoidactionPerformedActionEvente{ifb
1.equalse.getSource{//录入Connectioncon;Statementsql;try{Class.forNameorg.gjt.mm.mysql.Driver;}catchClassNotFoundExceptione1{System.out.println+e1;}try{con=DriverManager.getConnectionjdbc:mysql://localhost:3306/db_bookroot123456;sql=con.createStatement;StringinsertStr=INSERTINTOwelfarenonamejtVALUES+tf
1.getText++tf
2.getText++tf
3.getText+;;sql.executeUpdateinsertStr;StringinsertStr1=INSERTINTOwageinfononamejbVALUES+tf
1.getText++tf
2.getText++tf
4.getText+;;sql.executeUpdateinsertStr1;con.close;JOptionPane.showMessageDialogthis入录成功!;}catchSQLExceptione1{JOptionPane.showMessageDialogthis入录失败!;}}ifb
2.equalse.getSource{//修改Connectioncon;Statementsql;try{Class.forNameorg.gjt.mm.mysql.Driver;}catchClassNotFoundExceptione1{System.out.println+e1;}try{con=DriverManager.getConnectionjdbc:mysql://localhost:3306/db_bookroot123456;sql=con.createStatement;StringupdateStr=UPDATEwelfareSETjt=+tf
3.getText+name=+tf
2.getText+whereno=+tf
1.getText+;;sql.executeUpdateupdateStr;StringupdateStr1=UPDATEwageinfoSETjb=+tf
4.getText+name=+tf
2.getText+whereno=+tf
1.getText+;;sql.executeUpdateupdateStr1;JOptionPane.showMessageDialogthis修改成功!;con.close;}catchSQLExceptione1{JOptionPane.showMessageDialogthis信息不存在!;}}ifb
3.equalse.getSource{//删除Connectioncon;Statementsql;ResultSetrs;try{Class.forNameorg.gjt.mm.mysql.Driver;}catchClassNotFoundExceptione1{System.out.println+e1;}try{con=DriverManager.getConnectionjdbc:mysql://localhost:3306/db_bookroot123456;sql=con.createStatementResultSet.TYPE_SCROLL_SENSITIVEResultSet.CONCUR_READ_ONLY;sql.executeUpdateDELETEFROMwageinfowhereno=+tf
6.getText+;;sql.executeUpdateDELETEFROMwelfarewhereno=+tf
6.getText+;;JOptionPane.showMessageDialogthis删除成功!;con.close;}catchSQLExceptione1{JOptionPane.showMessageDialogthis删除失败!;}}ifb
4.equalse.getSource{//查询全部Connectioncon;Statementsql;ResultSetrs;//Vectorvector=newVector;try{Class.forNameorg.gjt.mm.mysql.Driver;}catchClassNotFoundExceptione1{JOptionPane.showMessageDialogthis连接数据库失败!;}try{con=DriverManager.getConnectionjdbc:mysql://localhost:3306/db_bookroot123456;sql=con.createStatementResultSet.TYPE_SCROLL_SENSITIVEResultSet.CONCUR_READ_ONLY;ifb
4.equalse.getSource{forinti=0;i50;i++forintj=0;j4;j++table.setValueAtij;rs=sql.executeQueryselectdistinct*fromwageinfowelfarewherewageinfo.name=welfare.name;intk=-1;whilers.next{++k;Stringno=rs.getString1;Stringname=rs.getString2;Stringjb=rs.getString3;Stringjt=rs.getString6;intsum=rs.getInt3+rs.getInt6;table.setValueAtnok0;table.setValueAtnamek1;table.setValueAtjbk3;table.setValueAtjtk2;table.setValueAtsumk4;}}}catchSQLExceptione1{JOptionPane.showMessageDialogthis查询失败!;}}ifb
5.equalse.getSource{//返回GZGLZJMgl=newGZGLZJM;gl.create;f.dispose;}}}工资管理主界面类packagewage_management;importjava.awt.Color;importjava.awt.FlowLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjavax.swing.ImageIcon;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JPanel;classGZGLZJMextendsJFrameimplementsActionListener{publicGZGLZJM{}JFramef=newJFrame工资管理系统;JButtonb1=newJButton工资管理;JButtonb2=newJButton员工信息管理;JButtonb3=newJButton返回;ImageIconim=newImageIcon
3.jpg;JLabela1=newJLabelim;voidcreate{JPanelp=JPanelf.getContentPane;p.setLayoutnewFlowLayout;p.adda1;p.addb1;p.addb2;p.addb3;p.setBackgroundColor.cyan;p.setVisibletrue;b
1.addActionListenerthis;b
2.addActionListenerthis;b
3.addActionListenerthis;f.setBounds200100500200;f.setVisibletrue;}publicvoidactionPerformedActionEvente{ifb
3.equalse.getSource{//返回DLd=newDL;d.create;f.dispose;}ifb
2.equalse.getSource{//员工信息管理YGGLyg=newYGGL;yg.create;f.dispose;}ifb
1.equalse.getSource{//工资管理GZGLgz=newGZGL;gz.create;f.dispose;}}}修改密码类packagewage_management;importjava.awt.Color;importjava.awt.FlowLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;importjava.sql.Statement;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JPasswordField;classXGMMextendsDLimplementsActionListener{publicXGMM{}JFrameframe=newJFrame密码修改;JLabellabel1=newJLabel原密码;JLabellabel2=newJLabel新密码;JButtonButton1=newJButton确定;JButtoncancelButton=newJButton返回;JPasswordFieldpassword=newJPasswordField9;JPasswordFieldnewpassword=newJPasswordField9;publicvoidcreate{JPanelp=JPanelframe.getContentPane;p.setLayoutnewFlowLayout;p.addlabel1;p.setSize55;p.setLocation48;p.addpassword;p.setSize100200;p.setLocation600600;p.addlabel2;p.setSize5020;p.setLocation4080;p.addnewpassword;p.setSize10020;p.setLocation80120;p.addButton1;p.addcancelButton;p.setBackgroundColor.cyan;p.setVisibletrue;Button
1.addActionListenerthis;cancelButton.addActionListenerthis;frame.setDefaultCloseOperationJFrame.EXIT_ON_CLOSE;frame.pack;frame.setBounds200100500220;frame.setVisibletrue;}publicvoidactionPerformedActionEvente{ife.getSource==Button1{Connectioncon;Statementsql;try{Class.forNameorg.gjt.mm.mysql.Driver;}catchClassNotFoundExceptione1{JOptionPane.showMessageDialogthis连接数据库失败!;}try{con=DriverManager.getConnectionjdbc:mysql://localhost:3306/db_bookroot123456;sql=con.createStatement;StringupdateStr=UPDATEworkerinfoSETmi=+newpassword.getText+wherename=+t1+;;sql.executeUpdateupdateStr;JOptionPane.showMessageDialogthis修改成功!;con.close;}catchSQLExceptione1{JOptionPane.showMessageDialogthis请输入原密码和新密码!;//System.out.printlne1;}}ife.getSource==cancelButton//返回{YGGLZJMdl=newYGGLZJM;dl.create;frame.dispose;}}}员工管理类packagewage_management;importjava.awt.Color;importjava.awt.FlowLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JScrollPane;importjavax.swing.JSplitPane;importjavax.swing.JTable;importjavax.swing.JTextField;publicclassYGGLextendsJFrameimplementsActionListener{JFramef=newJFrame员工信息管理;JButtonb1=newJButton添加新员工信息;JButtonb2=newJButton修改员工信息;JButtonb3=newJButton删除员工信息;JButtonb4=newJButton查询所有员工信息;JButtonb5=newJButton返回;JTextFieldtf1=newJTextField4;JTextFieldtf2=newJTextField4;JTextFieldtf3=newJTextField4;JTextFieldtf4=newJTextField4;JTextFieldtf5=newJTextField6;JTextFieldtf6=newJTextField7;String[]cloum={职工号姓名津贴月基本工资月薪登陆密码};Object[][]row=newObject
[50]
[6];JTabletable=newJTablerowcloum;JScrollPanescrollpane=newJScrollPanetable;JSplitPanesplitpane=newJSplitPaneJSplitPane.VERTICAL_SPLIT;voidcreate{JPanelp=JPanelf.getContentPane;p.setLayoutnewFlowLayout;p.addscrollpane;p.addsplitpane;JPanelp1=newJPanel;p
1.addb1;p
1.addb2;p
1.addb3;p
1.addb4;p
1.addb5;JPanelp2=newJPanel;p
2.setBackgroundColor.cyan;p
2.addscrollpane;p.setLayoutnewFlowLayout;p.addnewJLabel;p.addnewJLabel职工号;p.addtf1;p.addnewJLabel姓名;p.addtf2;p.addnewJLabel津贴;p.addtf3;p.addnewJLabel月基本工资;p.addtf4;p.addnewJLabel登陆密码;p.addtf5;p.addnewJLabel在此处输入职工号点击查询删除;p.addtf6;splitpane.addp1splitpane.TOP;splitpane.addp2splitpane.BOTTOM;splitpane.setDividerLocation50;p.setBackgroundColor.CYAN;b
1.addActionListenerthis;b
2.addActionListenerthis;b
3.addActionListenerthis;b
4.addActionListenerthis;b
5.addActionListenerthis;f.setBounds200100600600;f.setResizabletrue;//可以调整界面大小f.setVisibletrue;}publicvoidactionPerformedActionEvente{ifb
1.equalse.getSource{//添加新员工信息Connectioncon;Statementsql;try{Class.forNameorg.gjt.mm.mysql.Driver;}catchClassNotFoundExceptione1{JOptionPane.showMessageDialogthis连接数据库失败!;}try{con=DriverManager.getConnectionjdbc:mysql://localhost:3306/db_bookroot123456;sql=con.createStatement;StringinsertStr=INSERTINTOwelfarenonamejtVALUES+tf
1.getText++tf
2.getText++tf
3.getText+;;sql.executeUpdateinsertStr;StringinsertStr1=INSERTINTOwageinfononamejbVALUES+tf
1.getText++tf
2.getText++tf
4.getText+;;sql.executeUpdateinsertStr1;StringinsertStr2=INSERTINTOworkerinfononamemiVALUES+tf
1.getText++tf
2.getText++tf
5.getText+;;sql.executeUpdateinsertStr2;JOptionPane.showMessageDialogthis添加成功!;con.close;}catchSQLExceptione1{JOptionPane.showMessageDialogthis添加失败!;}}ifb
2.equalse.getSource{//修改员工信息Connectioncon;Statementsql;try{Class.forNameorg.gjt.mm.mysql.Driver;}catchClassNotFoundExceptione1{JOptionPane.showMessageDialogthis连接数据库失败!;}try{con=DriverManager.getConnectionjdbc:mysql://localhost:3306/db_bookroot123456;sql=con.createStatement;con=DriverManager.getConnectionjdbc:mysql://localhost:3306/db_bookroot123456;sql=con.createStatement;StringupdateStr=UPDATEwelfareSETjt=+tf
3.getText+name=+tf
2.getText+whereno=+tf
1.getText+;;sql.executeUpdateupdateStr;StringupdateStr1=UPDATEwageinfoSETjb=+tf
4.getText+name=+tf
2.getText+whereno=+tf
1.getText+;;sql.executeUpdateupdateStr1;sql.executeUpdateupdateStr1;StringupdateStr2=UPDATEworkerinfoSETname=+tf
2.getText+mi=+tf
5.getText+whereno=+tf
1.getText+;;sql.executeUpdateupdateStr2;JOptionPane.showMessageDialogthis修改成功!;con.close;}catchSQLExceptione1{JOptionPane.showMessageDialogthis修改失败!;}}ifb
3.equalse.getSource{//删除员工信息Connectioncon;Statementsql;try{Class.forNameorg.gjt.mm.mysql.Driver;}catchClassNotFoundExceptione1{JOptionPane.showMessageDialogthis连接数据库失败!;}try{con=DriverManager.getConnectionjdbc:mysql://localhost:3306/db_bookroot123456;sql=con.createStatementResultSet.TYPE_SCROLL_SENSITIVEResultSet.CONCUR_READ_ONLY;sql.executeUpdateDELETEFROMwageinfowhereno=+tf
6.getText+;;sql.executeUpdateDELETEFROMwelfarewhereno=+tf
6.getText+;;sql.executeUpdateDELETEFROMworkerinfowhereno=+tf
6.getText+;;JOptionPane.showMessageDialogthis删除成功!;con.close;}catchSQLExceptione1{JOptionPane.showMessageDialogthis删除失败!;}}ifb
4.equalse.getSource{//查询全部员工信息Connectioncon;Statementsql;ResultSetrs;try{Class.forNameorg.gjt.mm.mysql.Driver;}catchClassNotFoundExceptione1{JOptionPane.showMessageDialogthis连接数据库失败!;}try{con=DriverManager.getConnectionjdbc:mysql://localhost:3306/db_bookroot123456;sql=con.createStatementResultSet.TYPE_SCROLL_SENSITIVEResultSet.CONCUR_READ_ONLY;ifb
4.equalse.getSource{forinti=0;i50;i++forintj=0;j4;j++table.setValueAtij;rs=sql.executeQueryselectdistinct*fromwageinfowelfareworkerinfowherewageinfo.no=welfare.noandwageinfo.no=workerinfo.no;;intk=-1;whilers.next{++k;Stringno=rs.getString1;Stringname=rs.getString2;Stringjb=rs.getString3;Stringjt=rs.getString6;intsum=rs.getInt3+rs.getInt6;Stringmi=rs.getString9;table.setValueAtnok0;table.setValueAtnamek1;table.setValueAtjbk3;table.setValueAtjtk2;table.setValueAtsumk4;table.setValueAtmik5;}}}catchSQLExceptione1{JOptionPane.showMessageDialogthis查询失败!;}}ifb
5.equalse.getSource{//返回GZGLZJMgl=newGZGLZJM;gl.create;f.dispose;}}}员工管理主界面类packagewage_management;importjava.awt.Color;importjava.awt.FlowLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JScrollPane;importjavax.swing.JSplitPane;importjavax.swing.JTable;publicclassYGGLZJMextendsDLimplementsActionListener{publicYGGLZJM{}JFramef=newJFrame工资管理;JButtonb1=newJButton查询个人工资;JButtonb2=newJButton修改密码;JButtonb3=newJButton返回;String[]cloum={职工号姓名津贴月基本工资月薪};Object[][]row=newObject
[50]
[5];JTabletable=newJTablerowcloum;JScrollPanescrollpane=newJScrollPanetable;JSplitPanesplitpane=newJSplitPaneJSplitPane.VERTICAL_SPLIT;publicvoidcreate{JPanelp=JPanelf.getContentPane;p.setLayoutnewFlowLayout;p.addscrollpane;p.addsplitpane;JPanelp1=newJPanel;p
1.addb1;p
1.addb2;p
1.addb3;JPanelp2=newJPanel;p
2.setBackgroundColor.cyan;p
2.addscrollpane;JPanelp3=newJPanel;p.setLayoutnewFlowLayout;splitpane.addp1splitpane.TOP;splitpane.addp2splitpane.BOTTOM;splitpane.setDividerLocation50;p.setBackgroundColor.CYAN;b
1.addActionListenerthis;b
2.addActionListenerthis;b
3.addActionListenerthis;f.setBounds200100500550;f.setResizabletrue;//可以调整界面大小f.setVisibletrue;}publicvoidactionPerformedActionEvente{ifb
1.equalse.getSource{//查询个人工资Connectioncon;Statementsql;ResultSetrs;try{Class.forNameorg.gjt.mm.mysql.Driver;}catchClassNotFoundExceptione1{System.out.println+e1;}try{con=DriverManager.getConnectionjdbc:mysql://localhost:3306/db_bookroot123456;sql=con.createStatementResultSet.TYPE_SCROLL_SENSITIVEResultSet.CONCUR_READ_ONLY;ifb
1.equalse.getSource{forinti=0;i50;i++forintj=0;j4;j++table.setValueAtij;//System.out.printlnt1;rs=sql.executeQueryselectdistinct*fromwageinfowelfareworkerinfowherewageinfo.no=welfare.noandwageinfo.no=workerinfo.noandworkerinfo.name=+t1+andworkerinfo.mi=+t2+;intk=-1;whilers.next{++k;Stringno=rs.getString1;Stringname=rs.getString2;Stringjb=rs.getString3;Stringjt=rs.getString6;intsum=rs.getInt3+rs.getInt6;table.setValueAtnok0;table.setValueAtnamek1;table.setValueAtjbk3;table.setValueAtjtk2;table.setValueAtsumk4;}}}catchSQLExceptione1{JOptionPane.showMessageDialogthis查询失败!;}}ifb
2.equalse.getSource{//修改密码XGMMxgmm=newXGMM;xgmm.create;}ifb
3.equalse.getSource{//返回DLdl=newDL;dl.create;f.dispose;}}}心得体会通过这次课程设计,使我灵活应用所学数据结构知识,独立完成问题分析,结合数据结构理论知识,编写程序求解指定问题初步掌握软件开发过程的问题分析、系统设计、程序编码、测试等基本方法和技能;提高综合运用所学的理论知识和方法独立分析和解决问题的能力;并用系统的观点和软件开发一般规范进行软件开发,巩固、深化学生的理论知识,提高编程水平,并在此过程中培养我们严谨的科学态度和良好的工作作风熟练掌握数据的存储表示和基本操作的实现,能够利用存储设计算法解决简单的航空订票问题同时在这学期的实验中,培养了独立思考、动手操作的能力,在各种其它能力上也都有了提高在实验课上,我学会了很多学习的方法而这是日后最实用的要面对社会的挑战,只有不断的学习、实践,再学习、再实践这对于我的将来也有很大的帮助、。