java课程设计职工工资管理系统

目录一、设计目的⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯ 2二、功能介绍⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯ 2三、程序流程⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯ 2四、设计步骤⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯ 3五、设计总结⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯ 7六、程序清单⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯ 8七、参考文献⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯ 17一、设计目的通过课程设计，使学生提高理论联系实际解决实际问题的能力；也使学生对基于面向对象的理论进行系统设计过程中的诸多具体问题有感性的认识和深入的理解；进而提高学生的学习兴趣为其将来顺利进入毕业环节作必要的准备。二、功能介绍1）具有新用户注册功能。2）具有注册用户登录功能。3）具有职工工资的录入功能，要求只录入工资各项，自动计算每个职工工资总额。4）具有数据查询功能，可以实现查询全部信息和按条件执行查询。5）具有按条件删除数据功能。三、程序流程开始新用户登录？YN注册新用户 输入用户名和密码进入系统选择操作录入功能 查找功能 删除功能向数据库添加记 可按职工号查询 按选中行的行号录 或查询所有数据 删除数据结束四、设计步骤4.1、登陆界面进入系统首先进入登陆界面如图 4.1，输入账号和密码，点击登录就会进入职工工资管理系统，点击注册进入新用户注册界面，定义了局部变量String类型的user，password和pass分别记录界面输入的账号，密码和数据库查找的密码，定义了成员变量boolean型的bool记录输入账号和密码是否匹配。图4.1登陆界面4.2、职工工资管理系统登陆成功后进入的界面如图4.2，界面有增删改查的功能。widgetSelected()方法创建button的点击事件，创建DBHelper类的对象db连接数据库，进行查找，删除修改功能，增删改用update（）方法，查询用query（）方法。图4.2职工工资管理界面4.3、全部查找功能点击右边的查询按钮可以查找出所有员工的工资信息如图 4.3，通过自己封装的连接数据库的类DBHelper类的对象db，传递sql语句查找数据库的所有信息，用getString（）方法导出从数据库中查找到的数据，所得工资=基本工资+职位提成-50*迟到天数-100*旷工天数，通过查找的数据和自己定义的公式得到所得工资。图4.3全部查找界面4.4、按条件查找功能在文本框中输入职工号，点击查找能找到对应职工的工资情况，如图 4.4。用getText（）方法获得text 文本框中的的输入信息，定义局部变量 boolean型的数据bool，记录数据库中是否有对应的职工号，如果查到则为

true

，并且在表格中先用removeAll（）方法清空表的信息，然后用

sql

语句找出

text

中的职工号对应的数据。图4.4

按条件查找界面4.5、录入功能点击录入键进入录入界面如图4.5，输入职工信息，点击录入修改数据库的信息，并且能更新查找的结果。用getText（）方法获得text文本框的信息，定义局部变量String类型的s1,s2,s3,s4,s5,s6记录六个文本框的信息，通过DBHelper的对象db调用update方法把信息传入数据库。图

4.5

录入功能界面4.6、删除功能点击选中行，然后点击删除按钮就会将选种的行删除掉， 例如删除图三行数据如图4.6。定义局部变量TableItem[] 数组用table.getSelection()找并存储选中行的信息，定义 int[] 型数组用table.getSelectionIndices()找并存储选中行的行号，用这两个信息分别删除数据库和界面的选中信息。

4.3中第方法查方法查图

4.6

删除功能界面4.7、注册功能点击注册键后进入如图 4.7所示的界面，输入新用户账号和密码，码输入相同就注册成功。定义局部变量 String 类型的user，password

如果两次密和pass分别记录三个文本框输入的内容，用

equals

方法判断

pass

和

password是否相同，如果相同，则注册成功，并用 dispose（）方法关闭此窗口。图4.7注册功能界面五、设计总结这次课程设计，我们知道了成员变量和局部变量的不同，有些变量如果不设成成员变量就无法把数据传递出去，我们学会了封装，将连接数据库的方法封装到DBHelper类中，封装的便利让我们写程序更快捷，但是界面的功能还不够人性化。六、程序清单import import import import import import import import import import import public class denglu extends Shell{boolean bool;private Text text_1;private Text text;public static void main(Stringargs[]){try {Displaydisplay=Display. getDefaultdenglushell= newdenglu(display,SWT.shell.open();

();

SHELL_TRIM);shell.layout();while (!shell.isDisposed()){if (!display.readAndDispatch())display.sleep();}}catch(Exceptione){e.printStackTrace();}}public denglu(Displaydisplay, int style){super(display,style);createContents();}protectedvoidcreateContents(){setText("登陆界面");setSize(622,439);this,SWT.BORDER);finalLabellabel=newLabel(label.setFont(SWTResourceManager.getFont("",12,SWT.BOLD));label.setText("账号：");label.setBounds(90,112,60,27);,SWT.BORDER);finalLabellabel_1=newLabel(thislabel_1.setFont(SWTResourceManager.getFont("",12,SWT.BOLD));label_1.setText("密码：");label_1.setBounds(90,185,60,27);text=newText(this,SWT.);BORDERtext.setBounds(208,112,125,27);text_1=newText(this,SWT.|SWT.);BORDERPASSWORDtext_1.setBounds(208,185,125,27);finalButtonbutton=newButton(this,SWT.);NONEbutton.addSelectionListener(newSelectionAdapter(){publicvoidwidgetSelected(finalSelectionEvente){Stringuser=text.getText();Stringpassword=text_1.getText();DBHelperdb=newDBHelper();Stringsql="select密码fromuser_Tablewhere账号='"+user+"'";ResultSetrs=db.query(sql);try {while(rs.next()){Stringpass=rs.getString(if(password.equals(pass)){bool=true;}else{bool=false;

"密码");}if

(booltry

==true){{Displaydisplay=Display.zhigonggongzishell=

getDefault();newzhigonggongzi(display,SWT.SHELL_TRIM);shell.open();shell.layout();while (!shell.isDisposed()){if (!display.readAndDispatch())display.sleep();}}catch(Exceptione2){e2.printStackTrace();}}}}catch(SQLExceptione1){TODOAuto-generatedcatchblocke1.printStackTrace();}}});button.setFont(SWTResourceManager.getFont("",12,SWT.BOLD));button.setText("登陆");button.setBounds(388,255,48,22);,SWT.NONE);finalButtonbutton_1=newButton(thisbutton_1.setFont(SWTResourceManager.getFont("",12,SWT.BOLD));button_1.setText("注册");button_1.setBounds(388,306,48,22);finalLabellabel_2=newLabel(this,SWT.BORDER);label_2.setFont(SWTResourceManager.getFont("",15,SWT.BOLD));label_2.setText("欢迎使用员工工资管理系统");label_2.setBounds(90,37,271,27);//}@Overrideprotected voidcheckSubclass(){//DisablethecheckthatpreventssubclassingofSWTcomponents}}import import importorg.eclipse.swt.SWT;importorg.eclipse.swt.events.SelectionAdapter;importorg.eclipse.swt.events.SelectionEvent;importorg.eclipse.swt.widgets.Button;importorg.eclipse.swt.widgets.Display;importorg.eclipse.swt.widgets.Label;importorg.eclipse.swt.widgets.Shell;importorg.eclipse.swt.widgets.Table;importorg.eclipse.swt.widgets.TableColumn;importorg.eclipse.swt.widgets.TableItem;importorg.eclipse.swt.widgets.Text;importcom.swtdesigner.SWTResourceManager;publicclasszhigonggongziextendsShell{privateTexttext;privateTabletable;publicstaticvoidmain(Stringargs[]){try{Displaydisplay=Display.getDefault();zhigonggongzishell=newzhigonggongzi(display,SWT.SHELL_TRIM);shell.open();shell.layout();while(!shell.isDisposed()){if(!display.readAndDispatch())display.sleep();}}catch(Exceptione){e.printStackTrace();}}public zhigonggongzi(Displaydisplay, int style){super(display,style);createContents();}protectedvoidcreateContents(){setText("职工工资管理系统界面");setSize(697,458);,SWT.FULL_SELECTION|SWT.BORDER);table=newTable(thistable.setLinesVisible(true);table.setHeaderVisible(true);table.setBounds(10,67,573,214);finalTableColumnnewColumnTableColumn=newTableColumn(table,SWT.);NONEnewColumnTableColumn.setWidth(73);newColumnTableColumn.setText("职工号");finalTableColumnnewColumnTableColumn_1=newTableColumn(table,SWT.NONE);newColumnTableColumn_1.setWidth(76);newColumnTableColumn_1.setText("职工姓名");finalTableColumnnewColumnTableColumn_2=newTableColumn(table,SWT.);NONEnewColumnTableColumn_2.setWidth(76);newColumnTableColumn_2.setText("基本工资");finalTableColumnnewColumnTableColumn_3=newTableColumn(table,SWT.NONE);newColumnTableColumn_3.setWidth(80);newColumnTableColumn_3.setText( "职位提成");final TableColumnnewColumnTableColumn_4= newTableColumn(tablenewColumnTableColumn_4.setWidth(79);newColumnTableColumn_4.setText( "迟到天数");final TableColumnnewColumnTableColumn_5= newTableColumn(tablenewColumnTableColumn_5.setWidth(83);newColumnTableColumn_5.setText( "旷工天数");final TableColumnnewColumnTableColumn_6= newTableColumn(tablenewColumnTableColumn_6.setWidth(100);newColumnTableColumn_6.setText( "所得工资");final Buttonbutton= newButton( this,SWT.NONE);button.addSelectionListener( newSelectionAdapter(){public void widgetSelected( final SelectionEvente){try {Displaydisplay=Display. getDefault ();lurushell= newluru(display,SWT. SHELL_TRIM);shell.open();shell.layout();while (!shell.isDisposed()){if (!display.readAndDispatch())display.sleep();

,SWT.NONE);,SWT.NONE);,SWT.NONE);}}catch (Exceptione2){e2.printStackTrace();}a();}});button.setFont(SWTResourceManager.

getFont

("",12,SWT.

BOLD));button.setText( "录入");button.setBounds(604,142,55,31);final Buttonbutton_1= newButton( this,SWT.NONE);button_1.addSelectionListener( newSelectionAdapter(){public void widgetSelected( final SelectionEvente){TableItem[]item= table.getSelection();DBHelperdb=newDBHelper();for(int i=0;i<item. length;i++){Stringid=item[i].getText(0);Stringsql= "deletefrom 职工信息表 wheredb.update(sql);

职工号

='"+id+"'"

;}db.close();int[]a= table.getSelectionIndices();table.remove(a);}});button_1.setFont(SWTResourceManager.getFont("",12,SWT.));BOLDbutton_1.setText("删除");button_1.setBounds(604,196,55,31);finalButtonbutton_2=newButton(this,SWT.NONE);button_2.addSelectionListener(newSelectionAdapter(){publicvoidwidgetSelected(finalSelectionEvente){a();}});button_2.setFont(SWTResourceManager.getFont("",12,SWT.));BOLDbutton_2.setText("查询");button_2.setBounds(604,91,55,31);text=newText(this,SWT.BORDER);text.setBounds(209,314,89,31);finalLabellabel=newLabel(this,SWT.BORDER);label.setFont(SWTResourceManager.getFont("",12,SWT.BOLD));label.setText("按职工号查找：");label.setBounds(53,314,136,31);finalButtonbutton_3=newButton(this,SWT.NONE);button_3.addSelectionListener(newSelectionAdapter(){publicvoidwidgetSelected(finalSelectionEvente){table.removeAll();Stringid=text.getText();DBHelperdb=newDBHelper();Stringsql="select*from职工信息表";ResultSetrs=db.query(sql);booleanbool=true;if(bool){try{while(rs.next()){if(id.equals(rs.getString("职工号"))){bool=false;finalTableItemnewItemTableItem=newTableItem(table,SWT.BORDER);newItemTableItem.setText(0,rs.getString("职工号"));newItemTableItem.setText(1,rs.getString("姓名"));newItemTableItem.setText(2,rs.getString("基本工资"));doublemoney1=Double.parseDouble(rs.getString("基本工资"));newItemTableItem.setText(3,rs.getString("职位提成"));doublemoney2=Double.parseDouble(rs.getString("职位提成"));newItemTableItem.setText(4,rs.getString("迟到天数"));intday1=Integer.parseInt(rs.getString("迟到天数"));newItemTableItem.setText(5,rs.getString("旷工天数"));intday2=Integer.parseInt(rs.getString("旷工天数"));doublemoney=money1+money2-day1*50-day2*100;if(money<0){money=0;}StringMoney=String. valueOf(money);newItemTableItem.setText(6,Money);}}}catch(SQLExceptione1){TODOAuto-generatedcatchblocke1.printStackTrace();}}}});button_3.setFont(SWTResourceManager.getFont("",12,SWT.BOLD));button_3.setText("查找");button_3.setBounds(347,312,73,33);final Labellabel_1= newLabel( this,SWT.BORDER);label_1.setFont(SWTResourceManager. getFont("",15,SWT. BOLD));label_1.setText( "职工工资管理系统 ");label_1.setBounds(189,24,177,31);//}publicvoida(){table.removeAll();DBHelperdb=newDBHelper();Stringsql="select*from职工信息表";ResultSetrs=db.query(sql);try{while(rs.next()){finalTableItemnewItemTableItem=newTableItem(table,SWT.);BORDERnewItemTableItem.setText(0,rs.getString("职工号"));newItemTableItem.setText(1,rs.getString("姓名"));newItemTableItem.setText(2,rs.getString("基本工资"));doublemoney1=Double.parseDouble(rs.getString("基本工资"));newItemTableItem.setText(3,rs.getString("职位提成"));doublemoney2=Double.parseDouble(rs.getString("职位提成"));newItemTableItem.setText(4,rs.getString("迟到天数"));intday1=Integer.parseInt(rs.getString("迟到天数"));newItemTableItem.setText(5,rs.getString("旷工天数"));intday2=Integer.parseInt(rs.getString("旷工天数"));doublemoney=money1+money2-day1*50-day2*100;if(money<0){money=0;}valueOf(money);StringMoney=String.newItemTableItem.setText(6,Money);}}catch(SQLExceptione){TODOAuto-generatedcatchblocke.printStackTrace();}}@Overrideprotected voidcheckSubclass(){//DisablethecheckthatpreventssubclassingofSWTcomponents}}import import importorg.eclipse.swt.events.SelectionEvent;importorg.eclipse.swt.widgets.Button;importorg.eclipse.swt.widgets.Display;importorg.eclipse.swt.widgets.Label;importorg.eclipse.swt.widgets.Shell;importorg.eclipse.swt.widgets.Text;importcom.swtdesigner.SWTResourceManager;publicclassluruextendsShell{privateTexttext_5;privateTexttext_4;privateTexttext_3;privateTexttext_2;privateTexttext_1;privateTexttext;public static void main(Stringargs[]){try {Displaydisplay=Display. getDefaultlurushell= newluru(display,SWT.shell.open();shell.layout();while (!shell.isDisposed()){if (!display.readAndDispatch())display.sleep();

();SHELL_TRIM);}}catch(Exceptione){e.printStackTrace();}}public luru(Displaydisplay, int style){super(display,style);createContents();}protectedvoidcreateContents(){setText("职工工资录入界面");setSize(660,451);finalLabellabel=newLabel(this,SWT.BORDER);label.setFont(SWTResourceManager.getFont("",12,SWT.BOLD));label.setText("职工号：");label.setBounds(87,82,87,26);finalLabellabel_1=newLabel(this,SWT.BORDER);label_1.setFont(SWTResourceManager.getFont("",12,SWT.));BOLDlabel_1.setText("姓名：");label_1.setBounds(87,119,87,24);finalLabellabel_2=newLabel(this,SWT.BORDER);label_2.setFont(SWTResourceManager.getFont("",12,SWT.));BOLDlabel_2.setText("基本工资：");label_2.setBounds(87,149,87,24);finalLabellabel_3=newLabel(this,SWT.BORDER);label_3.setFont(SWTResourceManager.getFont("",12,SWT.));BOLDlabel_3.setText("职位提成：");label_3.setBounds(87,179,87,26);finalLabellabel_4=newLabel(this,SWT.);BORDERlabel_4.setFont(SWTResourceManager.getFont("",12,SWT.BOLD));label_4.setText("迟到天数：");label_4.setBounds(87,219,87,26);finalLabellabel_5=newLabel(this,SWT.);BORDERlabel_5.setFont(SWTResourceManager.getFont("",12,SWT.BOLD));label_5.setText("旷工天数：");label_5.setBounds(87,258,87,26);finalLabellabel_6=newLabel(this,SWT.);BORDERlabel_6.setFont(SWTResourceManager.getFont("",15,SWT.BOLD));label_6.setText("职工工资录入界面");label_6.setBounds(209,25,177,35);text=newText(this,SWT.BORDER);text.setBounds(241,82,70,26);text_1=newText(this,SWT.BORDER);text_1.setBounds(241,119,70,24);text_2=newText(this,SWT.BORDER);text_2.setBounds(241,149,70,24);text_3=newText(this,SWT.BORDER);text_3.setBounds(241,179,70,26);text_4=newText(this,SWT.BORDER);text_4.setBounds(241,219,70,26);text_5=newText(this,SWT.BORDER);text_5.setBounds(241,260,70,26);finalButtonbutton=newButton(this,SWT.NONE);button.addSelectionListener(newSelectionAdapter(){publicvoidwidgetSelected(finalSelectionEvente){Strings1=text.getText();Strings2=text_1.getText();Strings3=text_2.getText();Strings4=text_3.getText();Strings5=text_4.getText();Strings6=text_5.getText();迟到天数

DBHelperdb= newDBHelper();Stringsql= "insertinto 职工信息表 (职工号,姓名,基本工资,旷工天数)values('" +s1+"','" +s2+"','" +s3+"','" +s4+"','" +s5+"','"

,职位提成+s6+"')"

,

;db.update(sql);luru. this.dispose();}});button.setFont(SWTResourceManager. getFont("",12,SWT. BOLD));button.setText( "录入");button.setBounds(430,321,48,22);//}@Overrideprotected voidcheckSubclass(){//DisablethecheckthatpreventssubclassingofSWTcomponents}import import importorg.eclipse.swt.events.SelectionEvent;importorg.eclipse.swt.widgets.Button;importorg.eclipse.swt.widgets.Display;importorg.eclipse.swt.widgets.Label;importorg.eclipse.swt.widgets.Shell;importorg.eclipse.swt.widgets.Text;importcom.swtdesigner.SWTResourceManager;publicclasszhuceextendsShell{privateTexttext_2;privateTexttext_1;privateTexttext;public static void main(Stringargs[]){try {Displaydisplay=Display. getDefaultzhuceshell= newzhuce(display,SWT.shell.open();

();SHELL_TRIM);shell.layout();while (!shell.isDisposed()){if (!display.readAndDispatch())display.sleep();}}catch(Exceptione){e.printStackTrace();}}public zhuce(Displaydisplay, int style){super(display,style);createContents();}protectedvoidcreateContents(){setText("新用户注册界面");setSize(611,455);newLabel(this,SWT.BORDER);finalLabellabel=label.setFont(SWTResourceManager.getFont("",15,SWT.BOLD));label.setText("新用户注册界面");label.setBounds(161,49,163,22);,SWT.BORDER);finalLabellabel_1=newLabel(thislabel_1.setFont(SWTResourceManager.getFon