员工管理系统

综合实验三员工管理系统一、实验目的掌握编写数据库应用程序的方法，包括菜单、布局管理器、弹出提示信息对话框、输入对话框、数据库读写、事件处理。

二、实验环境PC系列微机，Windows XP。

Eclipse、JDK150或更高版本。

三、实验内容package ch4;import java.awt.BorderLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JFrame;import javax.swing.JMenu;import javax.swing.JMenuBar;import javax.swing.JMenuItem;import javax.swing.JOptionPane;import javax.swing.JTextArea;@SuppressWarnings("serial")public class Employer extends JFrame {JMenuBar cd;JMenuItemaddyg,deleteyg,updateyg,selectyg,addgz,updategz,selectgz,sumgz,help;JMenu cd1,cd2,cd3;JTextArea textarea;public Employer() {super("员工管理系统");cd=new JMenuBar();cd1=new JMenu("员工管理");addyg=new JMenuItem("添加新员工");deleteyg=new JMenuItem("删除员工");updateyg=new JMenuItem("修改员工信息");selectyg=new JMenuItem("查询员工");cd2=new JMenu("工资管理");addgz=new JMenuItem("录入员工工资");updategz=new JMenuItem("修改员工工资");selectgz=new JMenuItem("查询员工工资");sumgz=new JMenuItem("统计工资总额");cd3=new JMenu("关于");help=new JMenuItem("帮助");textarea=new JTextArea();this.add(cd,BorderLayout.NORTH);this.add(textarea,BorderLayout.CENTER);cd.add(cd1);cd1.add(addyg);cd1.add(deleteyg);cd1.add(updateyg);cd1.add(selectyg);cd.add(cd2);cd2.add(addgz);cd2.add(updategz);cd2.add(selectgz);cd2.add(selectgz);cd.add(cd3);cd3.add(help);addyg.addActionListener(new ActionListener() {//添加新员工@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubinsertEmployee add=new insertEmployee();}});deleteyg.addActionListener(new ActionListener() {//删除员工@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubdeleteEmployee yg=new deleteEmployee();}});updateyg.addActionListener(new ActionListener() {//修改员工信息@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubxiugaiEmployee xiugai=new xiugaiEmployee();}});selectyg.addActionListener(new ActionListener() {//查询员工@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubselectEmployee select=new selectEmployee();}});addgz.addActionListener(new ActionListener() {//录入员工工资@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubinsertWage insert=new insertWage();}});updategz.addActionListener(new ActionListener() {//修改员工工资@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubupdateWage update=new updateWage();}});selectgz.addActionListener(new ActionListener() {//查询员工工资@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubselectWage selectwage=new selectWage();});sumgz.addActionListener(new ActionListener() {//统计工资总额@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubsumWage sum=new sumWage();}});help.addActionListener(new ActionListener() {//帮助@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubJOptionPane.showMessageDialog(textarea, "本实验由邹杰所写,2015-5-20", "帮助文档" ,JOptionPane.OK_OPTION);}});}public static void main(String[] args) {Employer em=new Employer();em.setVisible(true);em.setSize(500,500);em.setResizable(false);}}package ch4;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class DBConnection {private Connection conn=null;public Connection getConnection(){return this.conn;}public DBConnection(){try {Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Stringurl="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=workdb";String user="zoujie";String password="888518";conn=DriverManager.getConnection(url,user,password);} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}public void close(){if(conn!=null)try {conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}Package ch4;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class EmployeeDAL {public int insert(Employee e) throws SQLException{String sql="insert intoemployee(employeeID,employeeName,sex,workage,gangwei) values(?,?,?,?,?)";DBConnection dbConn=new DBConnection();Connection cn=dbConn.getConnection();PreparedStatement pst=cn.prepareStatement(sql);pst.setString(1, e.getEmployeeID());pst.setString(2, e.getEmployeeName());pst.setString(3, e.getWorkAge());pst.setString(4, e.getSex());pst.setString(5, e.getGangWei());int ret=pst.executeUpdate();cn.close();return ret;}public int deleteByEmployeeID(String id) throws SQLException{ String sql="delete from employee where employeeID=?";DBConnection dbConn=new DBConnection();Connection cn=dbConn.getConnection();PreparedStatement pst=cn.prepareStatement(sql);pst.setString(1, id);int ret=pst.executeUpdate();cn.close();return ret;}public int updateEmployeeID(Employee e)throws SQLException{ String sql="Update employee setemployeeName=?,sex=?,workage=?,gangwei=? where employeeID=?";DBConnection dbConn=new DBConnection();Connection cn=dbConn.getConnection();PreparedStatement pst=cn.prepareStatement(sql);//添加数据pst.setString(5, e.getEmployeeID());pst.setString(1, e.getEmployeeName());pst.setString(2, e.getWorkAge());pst.setString(3, e.getSex());pst.setString(4, e.getGangWei());int ret=pst.executeUpdate();cn.close();return ret;}public String selectByEmployeeID(String id) throws SQLException{String sql="select * from employee where employeeID=?";DBConnection dbConn=new DBConnection();Connection cn=dbConn.getConnection();PreparedStatement pst=cn.prepareStatement(sql);pst.setString(1, id);ResultSet rs=null;String abc = null;try{rs=pst.executeQuery();while(rs.next()){String employeeID=rs.getString("employeeId");String employeeName=rs.getString("employeeName");String workAge=rs.getString("workage");String sex=rs.getString("sex");String gangWei=rs.getString("gangwei");abc="员工ID："+employeeID+"\n"+"姓名："+employeeName+"\n"+"性别："+sex+"\n"+"工龄："+workAge+"\n"+"岗位："+gangWei;}cn.close();}catch (SQLException e) {abc="查询错误，请核对后再次查询";}return abc;}//向数据库插入数据(2)public int insert2(int t1, int t2, int t3, int t4,int t5, int t6, int t7) throws SQLException {String sql="insert into Wage values(?,?,?,?,?,?,?,?,?)";DBConnection dbConn=new DBConnection();Connection cn=dbConn.getConnection();PreparedStatement pst=cn.prepareStatement(sql);pst.setInt(1, t1);pst.setInt(2, t2);pst.setInt(3, t3);pst.setInt(4, t4);pst.setInt(5, t5);pst.setInt(6, t6);pst.setInt(7, t7);pst.setInt(8, t4+t5);pst.setInt(9, t4+t5-t6-t7);int ret=pst.executeUpdate(); //返回更新了几条记录cn.close();return ret;}//修改数据以适应新表(2)public int UpdateEmployeeID2(int t1, int t2, int t3, int t4,int t5, int t6, int t7) throws SQLException{String sql="Update Wage setyear=?,month=?,gangweiwage=?,salary=?,baoxian=?,gongjijin=?,yingfa=?,shifa=? where employeeID=?";DBConnection dbConn=new DBConnection();Connection cn=dbConn.getConnection();PreparedStatement pst=cn.prepareStatement(sql);//修改数据pst.setInt(9,t1);pst.setInt(1,t2);pst.setInt(2,t3);pst.setInt(3,t4);pst.setInt(4,t5);pst.setInt(5,t6);pst.setInt(6,t7);pst.setInt(7,t4+t5);pst.setInt(8,t4+t5-t6-t7);int ret=pst.executeUpdate();cn.close();return ret;}//根据ID查询数据(2)public String selectByEmployeeID2(int id) throws SQLException{String sql="select * from Wage where employeeID=?";DBConnection dbConn=new DBConnection();Connection cn=dbConn.getConnection();PreparedStatement pst=cn.prepareStatement(sql);pst.setInt(1, id);ResultSet rs=null;String abc = null;try{rs=pst.executeQuery();while(rs.next()){StringemployeeID=rs.getInt("employeeID")+"";String year=rs.getInt("year")+"";String month=rs.getInt("month")+"";Stringgangweigongzi=rs.getInt("gangweiwage")+"";String salary=rs.getInt("salary")+"";String baoxian=rs.getInt("baoxian")+"";String gongjijin=rs.getInt("gongjijin")+"";String yingfa=rs.getInt("yingfa")+"";String shifa=rs.getInt("shifa")+"";abc="员工ID："+employeeID+"\n"+"年份："+year+"\n"+"月份："+month+"\n"+"岗位工资："+gangweigongzi+"\n"+"奖金："+salary+"\n"+"保险："+baoxian+"\n"+"公积金："+gongjijin+"\n"+"应发："+yingfa+"\n"+"实发："+shifa;}cn.close();}catch (SQLException e) {abc="查询错误，请核对后再次查询";}return abc;}//查询员工统计工资public String chaxun(int t1,int t2) throws SQLException{String sql="select * from Wage where year>=? and year<=?";DBConnection dbConn=new DBConnection();Connection cn=dbConn.getConnection();PreparedStatement pst=cn.prepareStatement(sql);pst.setInt(1,t1);pst.setInt(2, t2);ResultSet rs=pst.executeQuery();int sum=0;while(rs.next()){sum=sum+rs.getInt(8);}System.out.println(sum);return sum+"";}}package ch4;public class Employee {private String employeeName,sex,gangWei,employeeID,workAge;;public Employee(){}public Employee(String employeeID,String employeeName,String sex,String workage,String gangWei){super();this.employeeID=employeeID;this.employeeName=employeeName;this.workAge=workage;this.sex=sex;this.gangWei=gangWei;}public String getEmployeeID() {return employeeID;}public void setEmployeeID(String employeeID) {this.employeeID = employeeID;}public String getEmployeeName() {return employeeName;}public void setEmployeeName(String employeeName) { this.employeeName = employeeName;}public String getSex() {return sex;}public void setSex(String sex) {this.sex = sex;}public String getWorkAge() {return workAge;}public void setWorkAge(String workAge) {this.workAge = workAge;}public String getGangWei() {return gangWei;}public void setGangWei(String gangWei) {this.gangWei = gangWei;}}package ch4;import java.awt.GridLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.SQLException;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JTextField;@SuppressWarnings("serial")public class insertEmployee extends JFrame{JPanel p;JButton bt1,bt2;JLabelemployeeid,employeename,employeesex,employeeage,employeegangwei;JTextField em_id,em_name,em_sex,em_age,em_gangwei;public insertEmployee() {super("请输入要添加的员工");p=new JPanel();employeeid = new JLabel("员工编号");employeename =new JLabel("员工姓名");employeesex =new JLabel("员工性别");employeeage =new JLabel("员工年龄");employeegangwei = new JLabel("员工岗位");bt1 =new JButton("确定");bt2 =new JButton("取消");em_id =new JTextField(10);em_name=new JTextField(10);em_sex=new JTextField(10);em_age =new JTextField(10);em_gangwei=new JTextField(10);p.setLayout(new GridLayout(6, 2));p.add(employeeid);p.add(em_id);p.add(employeename);p.add(em_name);p.add(employeesex);p.add(em_sex);p.add(employeeage);p.add(em_age);p.add(employeegangwei);p.add(em_gangwei);p.add(bt1);p.add(bt2);this.add(p);this.setVisible(true);this.setBounds(500, 500, 250, 250);bt1.addActionListener(new ActionListener() {//添加@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubString id=em_id.getText();String name=em_name.getText();String sex=em_sex.getText();String age=em_age.getText();String gangwei=em_gangwei.getText();Employee employee=newEmployee(id,name,sex,age,gangwei);EmployeeDAL ed=new EmployeeDAL();try {ed.insert(employee);} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}JOptionPane.showMessageDialog(p, "恭喜您添加成功！");}});bt2.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubdispose();}});}public static void main(String args[]){insertEmployee it=new insertEmployee();it.setVisible(true);it.setBounds(500, 500, 250, 250);}}package ch4;import java.awt.GridLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.SQLException;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JTextField;@SuppressWarnings("serial")public class deleteEmployee extends JFrame{JPanel p;JLabel delete_id;JTextField jf_id;JButton bt_delete,bt_qx;public deleteEmployee(){super("删除员工");delete_id =new JLabel("要删除员工的ID：");bt_delete =new JButton("确定");bt_qx=new JButton("取消");jf_id =new JTextField(10);p=new JPanel();p.setLayout(new GridLayout(4,1));p.add(delete_id);p.add(jf_id);p.add(bt_delete);p.add(bt_qx);this.add(p);this.setBounds(250, 250, 250, 100);this.setVisible(true);this.setResizable(false);bt_delete.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubEmployeeDAL ed=new EmployeeDAL();String id=jf_id.getText();try {int t=ed.deleteByEmployeeID(id);if(t>0){JOptionPane.showMessageDialog(bt_delete,"删除成功");}else{JOptionPane.showMessageDialog(bt_delete,"未删除任何数据");}} catch (NumberFormatException e1) {// TODO Auto-generated catch blockJOptionPane.showMessageDialog(bt_delete,"删除失败，请检查后删除");} catch (SQLException e1) {// TODO Auto-generated catch blockJOptionPane.showMessageDialog(bt_delete,"删除失败，请检查后删除");}}});bt_qx.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubdispose();}});}@SuppressWarnings("unused")public static void main(String args[]){deleteEmployee yg=new deleteEmployee();}}package ch4;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.SQLException;import javax.swing.JButton;import javax.swing.JDialog;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JTextField;@SuppressWarnings("serial")public class updateEmployee extends JFrame{final JDialog jd=new JDialog();JPanel jp=new JPanel();JLabel id,name,workage,sex,gangwei;final JTextField id_;final JTextField name_;final JTextField sex_;final JTextField workage_;final JTextField gangwei_;public updateEmployee(){super("修改信息");id=new JLabel("员工ID");name=new JLabel(" 姓名");sex=new JLabel(" 性别");workage=new JLabel(" 工龄");gangwei=new JLabel(" 岗位");final JButton button1=new JButton("确定");JButton button2=new JButton("取消");id_=new JTextField(10);name_=new JTextField(10);sex_=new JTextField(10);workage_=new JTextField(10);gangwei_=new JTextField(10);jp.add(id);jp.add(id_);jp.add(name);jp.add(name_);jp.add(sex);jp.add(sex_);jp.add(workage);jp.add(workage_);jp.add(gangwei);jp.add(gangwei_);jp.add(button1);jp.add(button2);jd.add(jp);jd.setBounds(550,240,200,220);jd.setVisible(true);button1.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent arg0) {String id_0=(id_.getText()); //读取信息String name_0=name_.getText();String sex_0=sex_.getText();String workage_0=(workage_.getText());String gangwei_0=gangwei_.getText();try {EmployeeDAL edal=new EmployeeDAL();Employee e=newEmployee(id_0,name_0,sex_0,workage_0,gangwei_0);int t=edal.updateEmployeeID(e);if(t==0){JOptionPane.showMessageDialog(button1,"未修改任何信息");}else{JOptionPane.showMessageDialog(button1,"修改成功");}} catch (SQLException e1) {JOptionPane.showMessageDialog(button1,"修改失败，请检查后修改");}}});button2.addActionListener(new ActionListener(){@Overridepublic void actionPerformed(ActionEvent arg0) {jd.setVisible(false);}});}public static void main(String[] args){updateEmployee xiugai=new updateEmployee();}}package ch4;import java.awt.TextArea;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.SQLException;import javax.swing.JButton;import javax.swing.JDialog;import javax.swing.JLabel;import javax.swing.JPanel;import javax.swing.JTextField;public class selectEmployee {public selectEmployee(){final JDialog jd1=new JDialog();final JPanel jp1=new JPanel();JLabel jl1=new JLabel("请输入员工ID：");final JTextField jft=new JTextField(10);JButton button1=new JButton("确定");JButton button2=new JButton("取消");final TextArea ta=new TextArea();//布局设置jp1.add(jl1); jp1.add(jft); jp1.add(button1);jp1.add(button2);jp1.add(ta);jd1.add(jp1);jd1.setBounds(550,240,450,250);jd1.setVisible(true);button1.addActionListener(new ActionListener(){@Overridepublic void actionPerformed(ActionEvent e) {EmployeeDAL edal=new EmployeeDAL();try {Strings=edal.selectByEmployeeID((jft.getText()));ta.setText(s);} catch (NumberFormatException e1) {// // TODO Auto-generated catch block} catch (SQLException e1) {}}});button2.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubjd1.setVisible(false);}});}public static void main(String[] args){selectEmployee select=new selectEmployee();}}package ch4;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.SQLException;import javax.swing.JButton;import javax.swing.JDialog;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JTextField;public class insertWage {final JDialog jd=new JDialog();JPanel jp;JLabel id,year,month,gongzi,jiangjin,baoxian,gongjijin,yfgz,sfgz;final JTextField id_,year_,month_,gongzi_,jiangjin_,baoxian_,gongjijin_; public insertWage(){jp=new JPanel();id=new JLabel("员工ID");year=new JLabel("年份 ");month=new JLabel("月份 ");gongzi=new JLabel("岗位工资");jiangjin=new JLabel("奖金 ");baoxian=new JLabel("保险 ");gongjijin=new JLabel("公积金 ");JButton button1=new JButton("确定");JButton button2=new JButton("取消");id_=new JTextField(10);year_=new JTextField(10);month_=new JTextField(10);gongzi_=new JTextField(10);jiangjin_=new JTextField(10);baoxian_=new JTextField(10);gongjijin_=new JTextField(10);jp.add(id);jp.add(id_);jp.add(year);jp.add(year_);jp.add(month);jp.add(month_);jp.add(gongzi);jp.add(gongzi_);jp.add(jiangjin);jp.add(jiangjin_);jp.add(baoxian);jp.add(baoxian_);jp.add(gongjijin);jp.add(gongjijin_);jp.add(button1);jp.add(button2);jd.add(jp);jd.setBounds(550,240,210,290);jd.setVisible(true);button1.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent arg0) {int id_0=Integer.parseInt(id_.getText()); //读取信息int year_0=Integer.parseInt(year_.getText());int month_0=Integer.parseInt(month_.getText());int gongzi_0=Integer.parseInt(gongzi_.getText());int jiangjin_0=Integer.parseInt(jiangjin_.getText());int baoxian_0=Integer.parseInt(baoxian_.getText());int gongjijin_0=Integer.parseInt(gongjijin_.getText());try {EmployeeDAL edal=new EmployeeDAL();intt=edal.insert2(id_0,year_0,month_0,gongzi_0,jiangjin_0,baoxian_0,gongjijin_0);if(t==0){JOptionPane.showMessageDialog(null,"没有添加");}else{JOptionPane.showMessageDialog(null,"已添加");}} catch (SQLException e1) {JOptionPane.showMessageDialog(null,"已存在，请确认后添加");}}});button2.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent arg0) {jd.setVisible(false);}});}public static void main(String[] args){insertWage insert=new insertWage();}}package ch4;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.SQLException;import javax.swing.JButton;import javax.swing.JDialog;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JTextField;public class updateWage {final JDialog jd=new JDialog();JPanel jp=new JPanel();JLabel id,year,month,gongzi,jiangjin,baoxian,gongjijin,yfgz,sfgz;final JTextField id_,year_,month_,gongzi_,jiangjin_,baoxian_,gongjijin_;public updateWage(){id=new JLabel("员工ID");year=new JLabel("年份 ");month=new JLabel("月份 ");gongzi=new JLabel("岗位工资");jiangjin=new JLabel("奖金 ");baoxian=new JLabel("保险 ");gongjijin=new JLabel("公积金 ");JButton button1=new JButton("确定");JButton button2=new JButton("取消");id_=new JTextField(10);year_=new JTextField(10);month_=new JTextField(10);gongzi_=new JTextField(10);jiangjin_=new JTextField(10);baoxian_=new JTextField(10);gongjijin_=new JTextField(10);jp.add(id);jp.add(id_);jp.add(year);jp.add(year_);jp.add(month);jp.add(month_);jp.add(gongzi);jp.add(gongzi_);jp.add(jiangjin);jp.add(jiangjin_);jp.add(baoxian);jp.add(baoxian_);jp.add(gongjijin);jp.add(gongjijin_);jp.add(button1);jp.add(button2);jd.add(jp);jd.setBounds(550,240,210,290);jd.setVisible(true);button1.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent arg0) {int id_0=Integer.parseInt(id_.getText()); //读取信息int year_0=Integer.parseInt(year_.getText());int month_0=Integer.parseInt(month_.getText());int gongzi_0=Integer.parseInt(gongzi_.getText());int jiangjin_0=Integer.parseInt(jiangjin_.getText());int baoxian_0=Integer.parseInt(baoxian_.getText());int gongjijin_0=Integer.parseInt(gongjijin_.getText());try {EmployeeDAL edal=new EmployeeDAL();intt=edal.UpdateEmployeeID2(id_0,year_0,month_0,gongzi_0,jiangjin_0,baoxian_0,gongjijin_0);if(t!=0){JOptionPane.showMessageDialog(null,"已经修改");}else{JOptionPane.showMessageDialog(null,"未修改成功");}} catch (SQLException e1) {JOptionPane.showMessageDialog(null,"请确认之后再修改");}}});button2.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent arg0) {jd.setVisible(false);}});}public static void main(String[] args){updateWage update=new updateWage();}}package ch4;import java.awt.TextArea;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.SQLException;import javax.swing.JButton;import javax.swing.JDialog;import javax.swing.JLabel;import javax.swing.JPanel;import javax.swing.JTextField;public class selectWage {final JDialog jd1=new JDialog();final JPanel jp1=new JPanel();public selectWage(){JLabel jl1=new JLabel("请输入员工ID：");final JTextField jft=new JTextField(10);JButton button1=new JButton("确定");JButton button2=new JButton("取消");final TextArea ta=new TextArea();//布局设置jp1.add(jl1); jp1.add(jft); jp1.add(button1);jp1.add(button2);jp1.add(ta);jd1.add(jp1);jd1.setBounds(550,240,450,250);jd1.setVisible(true);button1.addActionListener(new ActionListener(){@Overridepublic void actionPerformed(ActionEvent e) {EmployeeDAL edal=new EmployeeDAL();try {Strings=edal.selectByEmployeeID2(Integer.parseInt(jft.getText()));ta.setText(s);} catch (NumberFormatException e1) {} catch (SQLException e1) {}}});button2.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubjd1.setVisible(false);}});}@SuppressWarnings("unused")public static void main(String[] args){selectWage select=new selectWage();}}package ch4;import java.awt.TextArea;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.SQLException;import javax.swing.JButton;import javax.swing.JDialog;import javax.swing.JLabel;import javax.swing.JPanel;import javax.swing.JTextField;public class sumWage {JDialog jd=new JDialog();JPanel jp=new JPanel();public sumWage(){JLabel jl1=new JLabel("请输入起始年份：");JLabel jl2=new JLabel("请输入终止年份：");JButton btn=new JButton("确定");final JTextField jtf1=new JTextField(5);final JTextField jtf2=new JTextField(5);final TextArea ta=new TextArea();jp.add(jl1);jp.add(jtf1);jp.add(jl2);jp.add(jtf2);jp.add(ta);jp.add(btn);jd.add(jp);jd.setBounds(550,240,475,290);jd.setVisible(true);final EmployeeDAL edal=new EmployeeDAL();btn.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {try {Strings=edal.chaxun(Integer.parseInt(jtf1.getText()),Integer.parseInt(jtf2.getText()));String ss="该月份期间实际上发出的工资是："+s+"\n";ta.append(ss);} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}});}public static void main(String[] args){sumWage sum=new sumWage();}}四、用到的类及总结Employer.java //主界面DBconnection.java //数据库连接类Employee.java //数据封装类EmployeeDAL.java //数据访问层insertEmployee.java //插入员工类deleteEmployee.java //删除员工信息类updateEmployee.java //更新员工信息类selectEmployee.java //查询员工信息类insertWage.java //插入工资类updateWage.java //修改工资类selectWage.java //查询工资类sumWage.java //统计工资总额类。