JAVA员工管理系统(需求分析+数据字典+源代码)-课程设计.doc

JAVA员工管理系统(需求分析+数据字典+源代码)-课程设计JAVA员工管理系统(需求分析+数据字典+源代码)一概述：人才过剩的今天，企业对于有用人才的需求逐步加大，企业内部的人事变动和部门规划也开始加速，传统的人事档案已经不能满足各个企业的人员流动速度，迫使人们起用新的管理方法来管理员工的相关信息。科学技术日新月异的进步，让人类生活发生了巨大的变化，计算机技术的飞速发展，使各行各业在计算机技术应用方面得到了广泛的普及和使用。信息化时代的到来成为不可抗拒的潮流，人类文明正在进入一个崭新的时代。因此，员工管理系统也以方便、快捷、费用低、绿色环保的优点正慢慢地进入各个行业和领域，将传统的员工管理方式彻底的解脱出来，提高效率，减轻工人人员以往繁忙的工作，加速信息的更新速度，使企业管理层第一时间了解到员工的信息，从而进一步的进行对员工的调配。二功能需求详细说明：增加增加员工的基本信息、培训信息、奖罚信息、薪资信息删除可根据员工的编号及姓名等资料的删除修改用户可以对员工的姓名和编号、进行修改。查询用户可以根据姓名、编号，准确的查到要找的员工，也可以选择部门，查看选中的部门的所有员工。辅助可以调用单独制作的计算器进行数字计算，节省操作时间（数据字典）库名（EmployeeInformationMS）用户信息表（UserInformation）字段类型说明大小是否为空User_ID Int 员工编号NOT NULLUser_Name varchar员工姓名20NOT NULLPasswordvarchar密码20NOT NULLPopedom varchar权限20NOT NULL部门信息管理（DepartmentInformation）字段类型说明大小是否为空D_Numberint部门编号NOT NULLD_Namevarchar部门名称20NOT NULLD_Countvarchar部门人数20NOT NULL员工基本信息表（EmployeeInformation）字段类型说明大小是否为空E_Numberint-员工编号NOT NULLE_Namevarchar-姓名20NOT NULLE_Sexvarchar-性别2NOT NULLE_BornDatevarchar-出生日期30NOT NULLE_Marriagevarchar-婚姻状态4NOT NULLE_PoliticsVisagevarchar政治面貌20NOT NULLE_SchoolAgevarchar学历20NOT NULLE_EnterDatevarchar进入公司时间30NOT NULLE_InDueFormDatevarchar转正时间30NOT NULLE_Departmentvarchar部门20NOT NULLE_Headshipvarchar职务20NOT NULLE_Estatevarchar状态20NOT NULLE_Remarkvarchar备注500NOT NULL培训信息表（TrainInformation）字段类型说明大小是否为空T_Numbervarchar培训编号20NOT NULLT_Contentvarchar培训内容100NOT NULLT_Namevarchar培训员工姓名20NOT NULLT_Dateint培训天数NOT NULLT_Moneyint培训费用NOT NULL奖罚信息表（EncouragementPunishInformation）字段类型说明大小是否为空EP_Numberint员工编号NOT NULLEP_Namevarchar员工姓名30NOT NULLEP_Datevarchar奖罚时间30NOT NULLEP_Addressvarchar奖罚地点50NOT NULLEP_Causationvarchar奖罚原因200NOT NULLEP_Remarkvarchar备注500NOT NULL薪资信息表（WageInformation）字段类型说明大小是否为空W_Numberint员工编号NOT NULLW_Namevarchar员工姓名30NOT NULLW_BasicWageint基本工资NOT NULLW_Boonint福利NOT NULLW_Bonusint奖金NOT NULLW_CountMethodvarchar计算方法50NOT NULLW_FactWageint实发工资NOT NULL994JAVA员工管理系统(需求分析+数据字典+源代码)/薪筹管理类package classsource;import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.util.*;import java.sql.*;public class WageManage extends JInternalFrameprivate JLabel lbl7=new JLabel(员工编号：); private JLabel lbl1=new JLabel(员工姓名：); private JLabel lbl2=new JLabel( 福 利：); private JLabel lbl4=new JLabel(基本工资：); private JLabel lbl3=new JLabel( 奖 金：); private JLabel lbl5=new JLabel(薪资计算：); private JLabel lbl6=new JLabel(实发工资：); private JTextField stid=new JTextField(10); private JTextField stname=new JTextField(10); private JTextField stsalary=new JTextField(10); private JTextField stboon=new JTextField(10); private JTextField stprize=new JTextField(10); private JTextField stcounter=new JTextField(10); private JTextField stfact=new JTextField(10);ImageIcon icon1=new ImageIcon(image/up.gif);ImageIcon icon2=new ImageIcon(image/down.gif); private JButton btnadd=new JButton(添加); private JButton delete=new JButton(删除); private JButton updete=new JButton(修改); private JButton save=new JButton(保存); private JButton up=new JButton();public WageManage() initComponents();private void initComponents() setTitle(薪资信息管理);Font f=new Font(宋体,Font.PLAIN,12);getContentPane().setLayout(null);lbl7.setBounds(30,30,80,25);lbl7.setFont(f);getContentPane().add(lbl7);stid.setBounds(100,30,100,25);stid.setBorder(BorderFactory.createLineBorder(Color.black);getContentPane().add(stid);/-lbl1.setBounds(30,70,80,25);lbl1.setFont(f);getContentPane().add(lbl1);stname.setBounds(100,70,100,25);stname.setBorder(BorderFactory.createLineBorder(Color.black);getContentPane().add(stname); lbl2.setBounds(230,70,80,25); lbl2.setFont(f); getContentPane().add(lbl2); stsalary.setBounds(300,70,100,25); stsalary.setBorder(BorderFactory.createLineBorder(Color.black); getContentPane().add(stsalary);/- lbl3.setBounds(30,110,80,25); lbl3.setFont(f); getContentPane().add(lbl3); stboon.setBounds(100,110,100,25); stboon.setBorder(BorderFactory.createLineBorder(Color.black); getContentPane().add(stboon);lbl4.setBounds(230,110,80,25);lbl4.setFont(f);getContentPane().add(lbl4);stprize.setBounds(300,110,100,25);stprize.setBorder(BorderFactory.createLineBorder(Color.black);getContentPane().add(stprize);/- lbl5.setBounds(30,150,80,25); lbl5.setFont(f); getContentPane().add(lbl5); stcounter.setBounds(100,150,100,25); stcounter.setBorder(BorderFactory.createLineBorder(Color.black); getContentPane().add(stcounter); lbl6.setBounds(230,150,80,25); lbl6.setFont(f); getContentPane().add(lbl6); stfact.setBounds(300,150,100,25); stfact.setBorder(BorderFactory.createLineBorder(Color.black); getContentPane().add(stfact);/- /按钮 btnadd.setBounds(30,220,60,25); btnadd.setFont(f); btnadd.setBorder(BorderFactory.createRaisedBevelBorder(); getContentPane().add(btnadd); delete.setBounds(110,220,60,25); delete.setFont(f); delete.setBorder(BorderFactory.createRaisedBevelBorder(); getContentPane().add(delete); updete.setBounds(190,220,60,25); updete.setFont(f); updete.setBorder(BorderFactory.createRaisedBevelBorder(); getContentPane().add(updete); save.setBounds(270,220,60,25); save.setFont(f); save.setBorder(BorderFactory.createRaisedBevelBorder(); getContentPane().add(save); up.setBounds(350,218,60,15); up.setBorder(BorderFactory.createRaisedBevelBorder();JAVA员工管理系统(需求分析+数据字典+源代码) getContentPane().add(up); next.setBounds(350,232,60,15); next.setBorder(BorderFactory.createRaisedBevelBorder(); getContentPane().add(next);/-连接数据库- Database.joinDB(); /初始化数据- String sqlw=select * from WageInformation; try if(Database.query(sqlw) Database.rs.next(); String wNumber=(+Database.rs.getInt(W_Number); String wName=Database.rs.getString(W_Name); String wBasicWage=Database.rs.getString(W_BasicWage); String wBoon=Database.rs.getString(W_Boon); String wBonus=Database.rs.getString(W_Bonus); String wCountMethod=Database.rs.getString(W_CountMethod); String wFactWage=Database.rs.getString(W_FactWage); stid.setText(wNumber); stname.setText(wName); stsalary.setText(wBasicWage); stboon.setText(wBoon); stprize.setText(wBonus); stcounter.setText(wCountMethod); stfact.setText(wFactWage); catch(Exception esql) System.out.println(薪资信息管理-初始化数据失败!); /-按钮事件- up.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) try if(Database.rs.previous() String wNumber=(+Database.rs.getString(W_Number); String wName=Database.rs.getString(W_Name); String wBasicWage=Database.rs.getString(W_BasicWage); String wBoon=Database.rs.getString(W_Boon); String wBonus=Database.rs.getString(W_Bonus); String wCountMethod=Database.rs.getString(W_CountMethod); String wFactWage=Database.rs.getString(W_FactWage); stid.setText(wNumber); stname.setText(wName); stsalary.setText(wBasicWage); stboon.setText(wBoon); stprize.setText(wBonus); stcounter.setText(wCountMethod); stfact.setText(wFactWage); catch(Exception eup) System.out.println(以到最前一条!); ); next.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) try if(Database.rs.next() String wNumber=(+Database.rs.getString(W_Number); String wName=Database.rs.getString(W_Name); String wBasicWage=Database.rs.getString(W_BasicWage); String wBoon=Database.rs.getString(W_Boon); String wBonus=Database.rs.getString(W_Bonus); String wCountMethod=Database.rs.getString(W_CountMethod); String wFactWage=Database.rs.getString(W_FactWage); stid.setText(wNumber); stname.setText(wName); stsalary.setText(wBasicWage); stboon.setText(wBoon); stprize.setText(wBonus); stcounter.setText(wCountMethod); stfact.setText(wFactWage); catch(Exception enext) System.out.println(以到最后一条); );/为添加删除保存修改按钮加事件- /添加 btnadd.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) save.setEnabled(true); stid.setText(); stid.setEditable(false); stname.setText(); stsalary.setText(); stboon.setText(); stprize.setText(); stcounter.setText(); stfact.setText(); ); /保存 save.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) if(stname.getText().equals()|stsalary.getText().equals()|stboon.getText().equals()| stprize.getText().equals()|stcounter.getText().equals()|stfact.getText().equals() !); else / String wNumber=stid.getText(); String wName=stname.getText(); String wBasicWage=stsalary.getText(); String wBoon=stboon.getText(); String wBonus=stprize.getText(); String wCountMethod=stcounter.getText(); String wFactWage=stfact.getText(); String Insert=insert WageInformation values(+wName+,+wBasicWage+,+wBoon+,+wBonus+,+wCountMethod+,+wFactWage+); try if(Database.executeSQL(Insert) stid.setEditable(true);JAVA员工管理系统(需求分析+数据字典+源代码)save.setEnabled(false); new JOptionPane().showMessageDialog(null,添加数据成功！); Database.joinDB(); String sql=select * from WageInformation; Database.query(sql); Database.rs.last(); String wNumber1=(+Database.rs.getString(W_Number); String wName1=Database.rs.getString(W_Name); String wBasicWage1=Database.rs.getString(W_BasicWage); String wBoon1=Database.rs.getString(W_Boon); String wBonus1=Database.rs.getString(W_Bonus); String wCountMethod1=Database.rs.getString(W_CountMethod); String wFactWage1=Database.rs.getString(W_FactWage); stid.setText(wNumber1); stname.setText(wName1); stsalary.setText(wBasicWage1); stboon.setText(wBoon1); stprize.setText(wBonus1); stcounter.setText(wCountMethod1); stfact.setText(wFactWage1); else new JOptionPane().showMessageDialog(null,添加数据不成功！); catch(Exception esave) new JOptionPane().showMessageDialog(null,添加数据不成功！); ); /删除 delete.addActionListener(new ActionListener() public void actionPerformed(ActionEvent edel) try String sqle=delete from WageInformation where W_Number =+stid.getText()+; System.out.println(sqle); if(Database.executeSQL(sqle) new JOptionPane().showMessageDialog(null,数据删除成功！); Database.joinDB(); String sqll=select * from WageInformation; Database.query(sqll); Database.rs.last(); String wNumber1=(+Database.rs.getString(W_Number); String wName1=Database.rs.getString(W_Name); String wBasicWage1=Database.rs.getString(W_BasicWage); String wBoon1=Database.rs.getString(W_Boon); String wBonus1=Database.rs.getString(W_Bonus); String wCountMethod1=Database.rs.getString(W_CountMethod); String wFactWage1=Database.rs.getString(W_FactWage); stid.setText(wNumber1); stname.setText(wName1); stsalary.setText(wBasicWage1); stboon.setText(wBoon1); stprize.setText(wBonus1); stcounter.setText(wCountMethod1); stfact.setText(wFactWage1); catch(Exception edelete) System.out.println(数据删除失败!); ); /修改 updete.addActionListener(new ActionListener() publi