《数据库应用》课程设计人事管理系统(java源代码)

最新推荐文章于 2024-05-10 15:49:49 发布

qq_38220914

最新推荐文章于 2024-05-10 15:49:49 发布

阅读量1.1k

点赞数 2

文章标签：数据库 java sql

本文链接：https://blog.csdn.net/qq_38220914/article/details/127618006

版权

//用户登陆类
package classsource;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class Land extends JFrame{
JFrame jf ;

JTextField textName=new JTextField();
JPasswordField textage=new JPasswordField();

   JLabel label = new JLabel("员工管理系统");
   JLabel labelName=new JLabel("用户名：");
   JLabel labelage=new JLabel("密码：");

JButton buttonEnter=new JButton("登录");
JButton buttoncancel=new JButton("清空");

   public Land(){
       jf=this;
       setTitle("登录");
       Font f = new Font("新宋体",Font.PLAIN,12);
       Container con = getContentPane();
       con.setLayout(null);
       label.setBounds(95,10,110,20);
       label.setFont(new Font("新宋体",Font.PLAIN,14));
       con.add(label);
       labelName.setBounds(45,40,55,20);
       labelName.setFont(f);
       con.add(labelName);
       textName.setBounds(95,40,120,20);
       con.add(textName);

labelage.setBounds(45,70,45,20);
       con.add(labelage);
       labelage.setFont(f);
    textage.setBounds(95,70,120,20);
       con.add(textage);

       buttonEnter.setBounds(90,110,60,20);
       buttonEnter.setFont(f);
       con.add(buttonEnter);

       //登陆的鼠标监听

       buttonEnter.addMouseListener(new MouseAdapter(){
           public void mouseClicked(MouseEvent me){
               if(textName.getText().equals("")){
                   new JOptionPane().showMessageDialog(null,"用户名不能为空!");
                   }
               else if(textage.getText().equals("")){
                   new JOptionPane().showMessageDialog(null,"密码不能为空!");
                   }
               else{
                   String sql="select * from UserInformation where User_Name = '" + textName.getText() + "' and Password = '" + textage.getText()+ "'";
                   System.out.println(sql);
                   Judge(sql);
                   }
               }
           });

       buttoncancel.setBounds(155,110,60,20);
       buttoncancel.setFont(f);
       con.add(buttoncancel);

       //清空按钮的鼠标监听方法
       buttoncancel.addMouseListener(new MouseAdapter(){
           public void mouseClicked(MouseEvent me){
               textName.setText("");
               textage.setText("");
               }
           });

   setResizable(false);

   Image img=Toolkit.getDefaultToolkit().getImage("image\\main.gif");
   setIconImage(img);
   Toolkit t = Toolkit.getDefaultToolkit();
   int w = t.getScreenSize().width;
   int h = t.getScreenSize().height;
   setBounds(w/2-150,h/2-90,300,180);
   setVisible(true);
       }

private void Judge(String sqlString) {

if (Database.joinDB()) {
if (Database.query(sqlString))
try{
if(Database.rs.isBeforeFirst()) {
System.out.println("密码正确");
jf.setVisible(false);

Database.cn.close();
new Main();
}
else {
System.out.println("错误");
new JOptionPane().showMessageDialog(null,"用户名或密码错误!","",JOptionPane.ERROR_MESSAGE);
}
}catch(Exception ex) {
System.out.println(ex.getMessage());
}
}
else{
    System.out.println("连接数据库不成功!!!");
    }
}

   public static void main(String args[]){
       new Land();
       }
   }

//主函数类，可以独立运行

package classsource;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class Main extends JFrame implements Runnable{

   Thread t=new Thread(this);
   JDesktopPane deskpane = new JDesktopPane();
   JPanel p = new JPanel();
   Label lp1=new Label("欢迎使用员工管理系统 !");

    ImageIcon icon1=new ImageIcon("imagetjsc.gif");
   ImageIcon icon2=new ImageIcon("imagecxdl.gif");
   ImageIcon icon3=new ImageIcon("imagexgmm.gif");
   ImageIcon icon4=new ImageIcon("imagetcxt.gif");
   ImageIcon icon5=new ImageIcon("imagejj.gif");
   ImageIcon icon6=new ImageIcon("imagehelp.gif");
   ImageIcon icon7=new ImageIcon("imagecx.gif");
   ImageIcon icon8=new ImageIcon("imagegl.gif");
   ImageIcon icon9=new ImageIcon("imagext.gif");
   ImageIcon icon10=new ImageIcon("imagexxgl.gif");
   ImageIcon icon11=new ImageIcon("imagexxcx.gif");
   ImageIcon icon12=new ImageIcon("imagebz.gif");
   ImageIcon icon13=new ImageIcon("imagegy.gif");
   ImageIcon icon14=new ImageIcon("imageglxx.gif");
   ImageIcon icon15=new ImageIcon("imagecxxx.gif");
//完--------------------------------------------------------------------------------

   public Main(){
       setTitle("员工管理系统");
       Container con = getContentPane();
       con.setLayout(new BorderLayout());
       con.add(deskpane,BorderLayout.CENTER);

       Font f =new Font("新宋体",Font.PLAIN,12);

       JMenuBar mb = new JMenuBar();

       JMenu systemM = new JMenu("系统管理");
       systemM.setFont(f);
       JMenu manageM = new JMenu("信息管理");
       manageM.setFont(f);
       JMenu employeeMM = new JMenu("员工信息管理");
       employeeMM.setFont(f);
       JMenu selectM = new JMenu("信息查询");
       selectM.setFont(f);
       JMenu employeeSM =new JMenu("员工信息查询");
       employeeSM.setFont(f);

       JMenu helpM = new JMenu("帮助");
       helpM.setFont(f);
       JMenu aboutM=new JMenu("关于");
       aboutM.setFont(f);

       JMenuItem password = new JMenuItem("密码修改");
       password.setFont(f);
       JMenuItem land = new JMenuItem("重新登陆");
       land.setFont(f);
       JMenuItem addDelete = new JMenuItem("添加/删除用户");
       addDelete.setFont(f);
       JMenuItem exit = new JMenuItem("退出系统");
       exit.setFont(f);
       systemM.add(password);
       systemM.add(land);
       systemM.add(addDelete);
       systemM.add(exit);

//为系统管理菜单加事件
password.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       System.out.println("AmendPassword");
       deskpane.add(new AmendPassword());
       }
   });

land.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       System.out.println("Land");
       setVisible(false);
       new Land();
       }
   });

addDelete.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       deskpane.add(new AddDeleteUser());
       }
   });

exit.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       //new JOptionPane().showMessageDialog(
       setVisible(false);
       }
   });

       JMenuItem departmentM = new JMenuItem("部门信息管理");
       departmentM.setFont(f);
       JMenuItem employeeM = new JMenuItem("基本信息管理");
       employeeM.setFont(f);
       JMenuItem trainM = new JMenuItem("培训信息管理");
       trainM.setFont(f);
       JMenuItem encouragementPunishM = new JMenuItem("奖罚信息管理");
       encouragementPunishM.setFont(f);
       JMenuItem wageM =new JMenuItem("薪资信息管理");
       wageM.setFont(f);
       employeeMM.add(trainM);
       employeeMM.add(employeeM);
       employeeMM.add(encouragementPunishM);
       employeeMM.add(wageM);
       manageM.add(employeeMM);
       manageM.add(departmentM);

//为管理菜单加事件
departmentM.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       System.out.println("Departmentmanage");
       deskpane.add(new Departmentmanage());
       }
   });

employeeM.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       System.out.println("Employeemanage");
       deskpane.add(new Employeemanage());
       }
   });

trainM.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       System.out.println("Trainmanage");
       deskpane.add(new Trainmanage());
       }
   });

encouragementPunishM.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       System.out.println("EncouragementPunish");
       deskpane.add(new EncouragementPunish());
       }
   });

wageM.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       System.out.println("WageManage");
       deskpane.add(new WageManage());
       }
   });

       JMenuItem departmentS = new JMenuItem("部门信息查询");
       departmentS.setFont(f);
       JMenuItem employeeS = new JMenuItem("基本信息查询");
       employeeS.setFont(f);
       JMenuItem trainS = new JMenuItem("培训信息查询");
       trainS.setFont(f);
       JMenuItem encouragementPunishS = new JMenuItem("奖罚信息查询");
       encouragementPunishS.setFont(f);
       JMenuItem wageS =new JMenuItem("薪资信息查询");
       wageS.setFont(f);
       employeeSM.add(trainS);
       employeeSM.add(employeeS);
       employeeSM.add(encouragementPunishS);
       employeeSM.add(wageS);
       selectM.add(employeeSM);
       selectM.add(departmentS);

//为查询菜单加事件

       departmentS.addActionListener(new ActionListener(){
           public void actionPerformed(ActionEvent e){
               System.out.println("DIQ");
               deskpane.add(new DIQ());
               }
           });

       employeeS.addActionListener(new ActionListener(){
           public void actionPerformed(ActionEvent e){
               System.out.println("BIQ");
               deskpane.add(new BIQ());
               }
           });

       trainS.addActionListener(new ActionListener(){
           public void actionPerformed(ActionEvent e){
               System.out.println("TIQ");
               deskpane.add(new TIQ());
               }
           });

       encouragementPunishS.addActionListener(new ActionListener(){
           public void actionPerformed(ActionEvent e){
               System.out.println("EPIQ");
               deskpane.add(new EPIQ());
               }
           });

       wageS.addActionListener(new ActionListener(){
           public void actionPerformed(ActionEvent e){
               System.out.println("SIQ");
               deskpane.add(new SIQ());
               }
           });

       JMenuItem help = new JMenuItem("帮助");
       help.setFont(f);
       JMenuItem about =new JMenuItem("关于");
       about.setFont(f);
       helpM.add(help);
       aboutM.add(about);

//为帮助菜单加事件
       about.addActionListener(new ActionListener(){
           public void actionPerformed(ActionEvent e){
               deskpane.add(new About());
               }
           });

       mb.add(systemM);
       mb.add(manageM);
       mb.add(selectM);
       mb.add(helpM);
       mb.add(aboutM);
   setJMenuBar(mb);

Image img=Toolkit.getDefaultToolkit().getImage("imagemain.gif");
setIconImage(img);

       systemM.setIcon(icon9);
       manageM.setIcon(icon8);
       selectM.setIcon(icon7);
       helpM.setIcon(icon6);
       addDelete.setIcon(icon1);
       land.setIcon(icon2);
       password.setIcon(icon3);
       exit.setIcon(icon4);
       employeeMM.setIcon(icon5);
       employeeSM.setIcon(icon5);
       departmentM.setIcon(icon10);
       departmentS.setIcon(icon11);

       help.setIcon(icon6);
       aboutM.setIcon(icon13);
       about.setIcon(icon13);

       employeeM.setIcon(icon14);
       trainM.setIcon(icon14);
       encouragementPunishM.setIcon(icon14);
       wageM.setIcon(icon14);

       employeeS.setIcon(icon15);
       trainS.setIcon(icon15);
       encouragementPunishS.setIcon(icon15);
       wageS.setIcon(icon15);

    JToolBar jToolBar1 = new JToolBar();
    jToolBar1.setLayout(new GridLayout(9,1));
JButton jButton1 = new JButton();
jButton1.setToolTipText("员工基本信息管理");
JButton jButton2 = new JButton();
jButton2.setToolTipText("员工基本信息查询");
JButton jButton3 = new JButton();
jButton3.setToolTipText("修改密码");
JButton jButton5 = new JButton();
jButton5.setToolTipText("计算器");
JButton jButton6 = new JButton();
jButton6.setToolTipText("退出系统");

jToolBar1.setMaximumSize(new java.awt.Dimension(600, 50));
jToolBar1.setMinimumSize(new java.awt.Dimension(600, 50));

//添加工具栏中按钮的方法

jButton1.setIcon(new ImageIcon("image1.png"));
jButton1.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       System.out.println("Employeemanage");
       deskpane.add(new Employeemanage());
       }
   });
jToolBar1.add(jButton1);

jButton2.setIcon(new ImageIcon("image2.png"));
jButton2.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       deskpane.add(new BIQ());
       }
   });
jToolBar1.add(jButton2);

jButton3.setIcon(new ImageIcon("image3.png"));
jButton3.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       deskpane.add(new AmendPassword());
       }
   });
jToolBar1.add(jButton3);

jButton5.setIcon(new ImageIcon("image5.png"));
jButton5.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       System.out.println("Calculator");
       deskpane.add(new Calculator());
       }
   });
jToolBar1.add(jButton5);


jButton6.setIcon(new javax.swing.ImageIcon("image6.png"));
jButton6.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
System.exit(0);
       }
   });
       jToolBar1.add(jButton6);




jToolBar1.setBounds(0, 0, 30, 600);
jToolBar1.setEnabled(false);
con.add(jToolBar1,BorderLayout.WEST);

p.setLayout(new BorderLayout());
p.add(lp1,BorderLayout.EAST);
t.start();

con.add(p,BorderLayout.SOUTH);

   Toolkit t = Toolkit.getDefaultToolkit();
   int width = t.getScreenSize().width - 200;
   int height = t.getScreenSize().height - 100;
   setSize(width,height);
   setLocation(150,100);
       setVisible(true);
       setResizable(false);
       }

       //线程的方法
   public void run(){
   System.out.println("线程启动了!");
   Toolkit t = Toolkit.getDefaultToolkit();
   int x=t.getScreenSize().width;
   System.out.println("x=" + x);

   lp1.setForeground(Color.red);
       while(true)
       {
if(x<-600){
    x=t.getScreenSize().width;
    }
           lp1.setBounds(x,0,700,20);
           x-=10;
           try{Thread.sleep(100);}catch(Exception e){}

      }
}

   public static void main(String[] args){
       new Main();
       }
   }

//数据库联接类
package classsource;

import java.sql.*;

public class Database {
public static Connection cn;
public static Statement st;
public static ResultSet rs;

public static boolean joinDB() {
boolean joinFlag;
try {
joinFlag = true;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cn = DriverManager.getConnection("jdbc:odbc:EmployeeInformationMS","sa","");

cn.setCatalog("EmployeeInformationMS");
System.out.println("数据库连接成功");
st = cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
return joinFlag;

} catch (SQLException sqlEx) {
System.out.println(sqlEx.getMessage());

joinFlag = false;
return joinFlag;

} catch (ClassNotFoundException notfoundEX) {
System.out.println(notfoundEX.getMessage());

joinFlag = false;
return joinFlag;
}
}

public static boolean executeSQL(String sqlString) {
boolean executeFlag;
try {
st.execute(sqlString);
executeFlag = true;
} catch (Exception e) {
executeFlag = false;
System.out.println("sql exception:" + e.getMessage());
}
return executeFlag;
}

public static boolean query(String sqlString) {

try {
rs = null;
//System.out.println(sqlString);
rs = st.executeQuery(sqlString);
} catch (Exception Ex) {
System.out.println("sql exception:" + Ex);
return false;
}
return true;
}
}

//添加删除用户类

package classsource;

import java.awt.event.*;
import java.awt.*;
import javax.swing.*;
import java.sql.*;

public class AddDeleteUser extends javax.swing.JInternalFrame {

private JButton butACancel,butDCancel,butDelete,butOk;
private JComboBox cbUserName;
private JLabel jLabel1,jLabel2,jLabel3,jLabel4,jLabel5;
private JPasswordField pas1,pas2,pas3;
private JTextField txtname;

public AddDeleteUser() {
initComponents();
this.setVisible(true);
this.setClosable(true);
this.setSize(268,350);

}

private void initComponents() {

jLabel1 = new JLabel();
jLabel2 = new JLabel();
jLabel3 = new JLabel();
txtname = new JTextField();
pas1 = new JPasswordField();
pas2 = new JPasswordField();
butOk = new JButton();
butACancel = new JButton();
jLabel4 = new JLabel();
cbUserName = new JComboBox();
jLabel5 = new JLabel();
pas3 = new JPasswordField();
butDelete = new JButton();
butDCancel = new JButton();

getContentPane().setLayout(null);

jLabel1.setText("新用户名:");
getContentPane().add(jLabel1);
jLabel1.setBounds(30, 30, 70, 20);

jLabel2.setText("输入密码:");
getContentPane().add(jLabel2);
jLabel2.setBounds(30, 60, 70, 18);

jLabel3.setText("确认密码:");
getContentPane().add(jLabel3);
jLabel3.setBounds(30, 90, 60, 18);

getContentPane().add(txtname);
txtname.setBounds(100, 30, 130, 24);

getContentPane().add(pas1);
pas1.setBounds(100, 60, 130, 24);

getContentPane().add(pas2);
pas2.setBounds(100, 90, 130, 24);

butOk.setText("添加");

getContentPane().add(butOk);
butOk.setBounds(80, 130, 70, 27);

butACancel.setText("清空");
getContentPane().add(butACancel);
butACancel.setBounds(160, 130, 70, 27);

jLabel4.setText("已有用户名:");
getContentPane().add(jLabel4);
jLabel4.setBounds(30, 180, 80, 18);

getContentPane().add(cbUserName);
cbUserName.setBounds(100, 180, 130, 24);

jLabel5.setText("密码:");
getContentPane().add(jLabel5);
jLabel5.setBounds(30, 210, 60, 18);

getContentPane().add(pas3);
pas3.setBounds(100, 216, 130, 24);

butDelete.setText("删除");
getContentPane().add(butDelete);
butDelete.setBounds(79, 260, 70, 27);

butDCancel.setText("清空");
getContentPane().add(butDCancel);
butDCancel.setBounds(160, 260, 70, 27);

//将所有用用户名读出来
Database.joinDB();
String sql="select * from UserInformation";
try{
    if(Database.query(sql)){
        while(Database.rs.next()){
            String name=Database.rs.getString("User_Name");
            cbUserName.addItem(name);
            }
        }
    }
catch(Exception e){}

//为添加和取消按钮加事件-----------------------------------------
butOk.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
               if(txtname.getText().equals("")){
                   new JOptionPane().showMessageDialog(null,"用户名不能为空!");
                   }
               else if(pas1.getText().equals("")){
                   new JOptionPane().showMessageDialog(null,"密码不能为空!");
                   }
               else if(pas1.getText().equals(pas2.getText())){
                   String sql="insert UserInformation values('"+ txtname.getText() +"','"+ pas1.getText() +"','B')";
                   try{
                       if(Database.executeSQL(sql)){
                       new JOptionPane().showMessageDialog(null,"添加成功！");
            cbUserName.addItem(txtname.getText());
        }
                       }
                   catch(Exception ea){}
                   }
       }
   });

butACancel.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       txtname.setText("");
       pas1.setText("");
       pas2.setText("");
       }
   });

//为删除和取消按钮加事件---------------------------------------
butDelete.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
        String name="" + cbUserName.getSelectedItem();
        String sql="select * from UserInformation where User_Name='"+ name +"'";
        try{
        if(Database.query(sql)){
           Database.rs.next();
              String pas=pas3.getText();
              String password=Database.rs.getString("Password");
              System.out.println(password);
              if(pas.equals(password)){
                      String sdelete="delete from UserInformation where User_Name='"+ name +"'";
                      if(Database.executeSQL(sdelete)){
                          new JOptionPane().showMessageDialog(null,"删除成功！");
pas3.setText("");
cbUserName.removeAllItems();
String sql1="select * from UserInformation";
                          if(Database.query(sql1)){
                              while(Database.rs.next()){
                                  String name1=Database.rs.getString("User_Name");
                                  cbUserName.addItem(name1);
                                  }
                              }
                          }
                  }
              else{
                  new JOptionPane().showMessageDialog(null,"密码不正确！");
                  }
              }
      }
      catch(Exception el){
         System.out.println(el);
         }
       }
   });

butDCancel.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       pas3.setText("");
       }
   });

}
}

//修改密码类

package classsource;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class AmendPassword extends JInternalFrame
{
JLabel lbe1=new JLabel("修改密码");
JPanel p=new JPanel();
public AmendPassword()
{
setTitle("修改密码");
p.add(lbe1);
AmendPanel panel=new AmendPanel();
Container contentPane=getContentPane();
contentPane.add(p,"North");
contentPane.add(panel,"Center");

setBounds(100, 100, 280, 260);
this.setClosable(true);
setVisible(true);
}

}

class AmendPanel extends JPanel
{
JButton b1,b2;
JLabel lbe2,lbe3,lbe4,lbe5;
JPasswordField pas1,pas2,pas3;
JComboBox tf;
public AmendPanel()
{
lbe2=new JLabel("用户名:");
lbe3=new JLabel("输入旧密码:");
lbe4=new JLabel("输入新密码:");
lbe5=new JLabel("确定新密码:");
tf=new JComboBox();
pas1=new JPasswordField();
pas2=new JPasswordField();
pas3=new JPasswordField();
b1=new JButton("确定");
b2=new JButton("清空");

add(lbe2);
lbe2.setBounds(16,10,90,25);
this.add(tf);
tf.setBounds(100,10,120,25);
add(lbe3);
lbe3.setBounds(16,45,90,25);
add(pas1);
pas1.setBounds(100,45,120,25);
add(lbe4);
lbe4.setBounds(16,80,80,25);
add(pas2);
pas2.setBounds(100,80,120,25);
add(lbe5);
lbe5.setBounds(16,115,80,25);
add(pas3);
pas3.setBounds(100,115,120,25);
add(b1);
b1.setBounds(100,160,60,30);
add(b2);
b2.setBounds(160,160,60,30);
setLayout(null);

//将所有用用户名读出来
Database.joinDB();
String sql="select * from UserInformation";
try{
    if(Database.query(sql)){
        while(Database.rs.next()){
            String name=Database.rs.getString("User_Name");
            tf.addItem(name);
            }
        }
    }
catch(Exception e){}

//为确定取消按钮加事件
b1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){

        String name="" + tf.getSelectedItem();
        System.out.println(name);
        String sql="select * from UserInformation where User_Name='"+ name +"'";
        System.out.println(sql);
        try{
        if(Database.query(sql)){
           Database.rs.next();
              String ps1=pas1.getText();
              String password=Database.rs.getString("Password");
              if(ps1.equals(password)){
                  if(pas2.getText().equals(pas3.getText())){
                      String supdate="update UserInformation set Password='"+ pas3.getText()+"' where User_Name='"+ name +"'";
                      Database.executeSQL(supdate);
                      new JOptionPane().showMessageDialog(null,"密码更改成功！");
                      }
                  else{
                      new JOptionPane().showMessageDialog(null,"两次密码不同！");
                      }
                  }
              else{
                  new JOptionPane().showMessageDialog(null,"旧密码不正确！");
                  }
              }
      }
      catch(Exception el){
         System.out.println(el);
         }
      }
    });
b2.addActionListener(new ActionListener(){
    public void actionPerformed(ActionEvent e){
        pas1.setText("");
        pas2.setText("");
        pas3.setText("");
        }
    });
}
}

//关于类
package classsource;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;

public class About extends JInternalFrame {
        JLabel label = new JLabel("运行环境：Windows");
       JLabel labe2 = new JLabel("开发语言：JAVA");
       JLabel labe3 = new JLabel("数据库类型：SqlServer2000");

       public About(){
   setTitle("关于");
      Container con=getContentPane();
con.setLayout(new GridLayout(4,1));
con.add(label);
con.add(labe2);
con.add(labe3);
con.setBackground(Color.white);

      setResizable(false);
      setSize(380,220);
      setVisible(true);
      setClosable(true);
           }
   }

//员工信息查询类
package classsource;

import java.awt.*;
import javax.swing.*;
import javax.swing.table.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.JScrollPane.*;
import java.sql.*;

public class BIQ extends JInternalFrame{

   JLabel lbl1=new JLabel("基本信息查询");
    JLabel lbl2=new JLabel("员工编号：");
    JLabel lbl3=new JLabel("员工姓名：");
    JTextField btxtid=new JTextField(10);
    JTextField btxtname=new JTextField(10);
    JButton btn1=new JButton("查询");

JTable table;
DefaultTableModel dtm;

String columns[] = {"员工编号","员工姓名"," 性别 ","出生日期","婚姻状况","政治面貌"," 学历 ","进入公司时间","转正时间"," 部门 "," 职务 ","员工状态"," 备注 "};
public BIQ(){
setTitle("基本信息查询");

dtm = new DefaultTableModel();
table = new JTable(dtm);

       JScrollPane sl = new JScrollPane();
       sl.getViewport().add(table);
       dtm.setColumnCount(5);
       dtm.setColumnIdentifiers(columns);

       getContentPane().setLayout(null);
       lbl1.setBounds(240,10,300,30);
       lbl1.setFont(new Font("宋体",Font.BOLD,24));
       getContentPane().add(lbl1);

       Font f=new Font("宋体",Font.PLAIN,12);
       lbl2.setBounds(10,60,80,25);
       lbl2.setFont(f);
       getContentPane().add(lbl2);
       btxtid.setBounds(80,60,80,23);
       btxtid.setFont(f);
       getContentPane().add(btxtid);
       lbl3.setBounds(10,90,80,25);
       lbl3.setFont(f);
    getContentPane().add(lbl3);
    btxtname.setBounds(80,90,80,23);
    btxtname.setFont(f);
    getContentPane().add(btxtname);
    btn1.setBounds(90,130,60,25);
    btn1.setFont(f);
    getContentPane().add(btn1);

sl.setBounds(180,60,500,370);
getContentPane().add(sl);

   //设置边框
btxtid.setBorder(BorderFactory.createLineBorder(Color.black));
    btxtname.setBorder(BorderFactory.createLineBorder(Color.black));
    btn1.setBorder(BorderFactory.createRaisedBevelBorder());
sl.setBorder(BorderFactory.createLineBorder(Color.black));

//----连接数据库--------------------------------------------------------------------------
       Database.joinDB();
       String sql="select * from EmployeeInformation";
       if(Database.query(sql)){
       System.out.println(sql);
       try{
          while(Database.rs.next()){
              String eNumber=(""+Database.rs.getInt("E_Number"));
              System.out.println(eNumber);
              String eName=Database.rs.getString("E_Name");
              System.out.println(eName);
              String eSex=Database.rs.getString("E_Sex");
              System.out.println(eSex);
              String eBornDate=Database.rs.getString("E_BornDate");
              System.out.println(eBornDate);
              String eMarriage=Database.rs.getString("E_Marriage");
              System.out.println(eMarriage);
              String ePoliticsVisage=Database.rs.getString("E_PoliticsVisage");
              System.out.println(ePoliticsVisage);
              String eSchoolAge=Database.rs.getString("E_SchoolAge");
              System.out.println(eSchoolAge);
              String eEnterDate=Database.rs.getString("E_EnterDate");
              System.out.println(eEnterDate);
              String eInDueFormDate=Database.rs.getString("E_InDueFormDate");
              System.out.println(eInDueFormDate);
              String eDepartment=Database.rs.getString("E_Department");
              System.out.println(eDepartment);
              String eHeadship=Database.rs.getString("E_Headship");
              System.out.println(eHeadship);
              String eEstate=Database.rs.getString("E_Estate");
              System.out.println(eEstate);
              String eRemark=Database.rs.getString("E_Remark");
              System.out.println(eRemark);

       }
       catch(Exception eBIQ){
       System.out.println("初始化数据失败！");
       }

       }
//为查询按钮加事件
       btn1.addActionListener(new ActionListener(){
           public void actionPerformed(ActionEvent eBIQ){
               System.out.println("按钮事件");
               String esql;

       int rc=dtm.getRowCount();
       for(int i=0;i<rc;i++){
           dtm.removeRow(0);
       }
               if(btxtid.getText().equals("")&&btxtname.getText().equals("")){
               esql="select * from EmployeeInformation";
               }
               else if(btxtname.getText().equals("")){
                   esql="select * from EmployeeInformation where E_Number = '" + btxtid.getText() +"'";
                   }
               else{
       esql="select * from EmployeeInformation where E_Number = '" + btxtid.getText() +"' or E_Name like '%"+ btxtname.getText() +"%'";
               }
               System.out.println(esql);
               if(Database.query(esql)){
               try{
                  while(Database.rs.next()){
                      String eNumber=(""+Database.rs.getInt("E_Number"));
                      System.out.println(eNumber);
                      String eName=Database.rs.getString("E_Name");
                      System.out.println(eName);
                      String eSex=Database.rs.getString("E_Sex");
                      System.out.println(eSex);
                      String eBornDate=Database.rs.getString("E_BornDate");
                      System.out.println(eBornDate);
                      String eMarriage=Database.rs.getString("E_Marriage");
                      System.out.println(eMarriage);
                      String ePoliticsVisage=Database.rs.getString("E_PoliticsVisage");
                      System.out.println(ePoliticsVisage);
                      String eSchoolAge=Database.rs.getString("E_SchoolAge");
                      System.out.println(eSchoolAge);
                      String eEnterDate=Database.rs.getString("E_EnterDate");
                      System.out.println(eEnterDate);
                      String eInDueFormDate=Database.rs.getString("E_InDueFormDate");
                      System.out.println(eInDueFormDate);
                      String eDepartment=Database.rs.getString("E_Department");
                      System.out.println(eDepartment);
                      String eHeadship=Database.rs.getString("E_Headship");
                      System.out.println(eHeadship);
                      String eEstate=Database.rs.getString("E_Estate");
                      System.out.println(eEstate);
                      String eRemark=Database.rs.getString("E_Remark");
                      System.out.println(eRemark);

                  Vector v=new Vector();
                  v.add(eNumber);
                       v.add(eName);
                       v.add(eSex);
                       v.add(eBornDate);
                       v.add(eMarriage);
                       v.add(ePoliticsVisage);
                       v.add(eSchoolAge);
                  v.add(eEnterDate);
                       v.add(eInDueFormDate);
                       v.add(eDepartment);
                       v.add(eHeadship);
                       v.add(eEstate);
                       v.add(eRemark);
                       dtm.addRow(v);
                  }
               }
               catch(Exception eB){
               }
               }
           }
       });

   setSize(700,480);
       this.setClosable(true);
       setVisible(true);
       }
   }

package classsource;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import java.util.*;
import java.sql.*;

public class DIQ extends JInternalFrame{

   JLabel lb1=new JLabel("部门信息查询");
    JLabel lb2=new JLabel("部门编号：");
    JLabel lb3=new JLabel("部门名称：");
    JTextField setxtid=new JTextField(10);
    JTextField setxtname=new JTextField(10);
    JButton btn1=new JButton("查询");

    JTable table;
   DefaultTableModel dtm;
   String columns[] = {"部门编号","部门名称","部门人数"};
   public DIQ(){
       setTitle("部门信息查询");

dtm = new DefaultTableModel();
table = new JTable(dtm);

JScrollPane sl = new JScrollPane(table);

dtm.setColumnCount(3);
dtm.setColumnIdentifiers(columns);

       getContentPane().setLayout(null);
       lb1.setBounds(200,10,300,30);
       lb1.setFont(new Font("宋体",Font.BOLD,24));
       getContentPane().add(lb1);

       Font f=new Font("宋体",Font.PLAIN,12);
       lb2.setBounds(10,60,80,25);
       lb2.setFont(f);
       getContentPane().add(lb2);
       setxtid.setBounds(80,60,80,23);
       setxtid.setFont(f);
       getContentPane().add(setxtid);
       lb3.setBounds(10,90,80,25);
       lb3.setFont(f);
    getContentPane().add(lb3);
    setxtname.setBounds(80,90,80,23);
    setxtname.setFont(f);
    getContentPane().add(setxtname);
    btn1.setBounds(90,130,60,25);
    btn1.setFont(f);
    getContentPane().add(btn1);

sl.setBounds(180,60,425,290);
getContentPane().add(sl);

//设置边框
       setxtid.setBorder(BorderFactory.createLineBorder(Color.black));
    setxtname.setBorder(BorderFactory.createLineBorder(Color.black));
    btn1.setBorder(BorderFactory.createRaisedBevelBorder());
       sl.setBorder(BorderFactory.createLineBorder(Color.black));

//连接数据库
Database.joinDB();

//为表格初使化数据
String csf="select * from DepartmentInformation";
if(Database.query(csf)){
    try{
        while(Database.rs.next()){
                                String num = ("" + Database.rs.getInt("D_Number"));
                   System.out.println(num);
                   String name = Database.rs.getString("D_Name");
                   System.out.println(name);
                   String count = Database.rs.getString("D_Count");
                   System.out.println(count);

                   Vector v=new Vector();
                   v.add(num);
                   v.add(name);
                   v.add(count);
                   dtm.addRow(v);

            }
        }
    catch(Exception ecsf){
        System.out.println("初使化表格数据出错!");}
    }

//为查询按钮加事件
btn1.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       String sql;
       int rc=dtm.getRowCount();
       //System.out.println(dtm.getRowCount());
       for(int i=0;i<rc;i++){
                       dtm.removeRow(0);
                       }
       if(setxtid.getText().equals("")&&setxtname.getText().equals("")){
           sql="select * from DepartmentInformation";
           }
       else if(setxtname.getText().equals("")){
           sql = "select * from DepartmentInformation where D_Number = '" + setxtid.getText() +"'";
           }
       else{
       sql = "select * from DepartmentInformation where D_Number = '" + setxtid.getText() +"' or D_Name like '%"+ setxtname.getText() +"%'";
       }

       System.out.println(sql);
           if(Database.query(sql)){
               try{
               while(Database.rs.next()){
                   String num = ("" + Database.rs.getInt("D_Number"));
                   System.out.println(num);
                   String name = Database.rs.getString("D_Name");

                   System.out.println(name);
                   String count = Database.rs.getString("D_Count");
                   System.out.println(count);

                   Vector v=new Vector();
                   v.add(num);
                   v.add(name);
                   v.add(count);
                   dtm.addRow(v);

                   }
               }
               catch(Exception ee){}
               }
       }
   });

       setSize(630,400);
       this.setClosable(true);
       setVisible(true);
       }
   }

//奖惩查询类

package classsource;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import java.util.*;
import java.sql.*;

public class EPIQ extends JInternalFrame{

   JLabel lb1=new JLabel("奖惩信息查询");
    JLabel lb2=new JLabel("员工编号:");
    JLabel lb3=new JLabel("员工姓名：");
    JTextField txt1=new JTextField(10);
    JTextField txt2=new JTextField(10);
    JButton btn1=new JButton("查询");

    JTable table;
   DefaultTableModel dtm;
   String columns[] = {"奖惩人编号","奖惩人姓名：","奖惩时间","奖惩地点","奖惩原因","备注"};
   public EPIQ(){
       setTitle("奖惩信息查询");

       dtm = new DefaultTableModel();
       table = new JTable(dtm);
       JScrollPane sl = new JScrollPane(table);

dtm.setColumnCount(6);
dtm.setColumnIdentifiers(columns);

       getContentPane().setLayout(null);
       lb1.setBounds(200,10,300,30);
       lb1.setFont(new Font("宋体",Font.BOLD,24));
       getContentPane().add(lb1);

       Font f=new Font("宋体",Font.PLAIN,12);
       lb2.setBounds(10,60,80,25);
       lb2.setFont(f);
       getContentPane().add(lb2);
       txt1.setBounds(80,60,80,23);
       txt1.setFont(f);
       getContentPane().add(txt1);
       lb3.setBounds(10,90,80,25);
       lb3.setFont(f);
    getContentPane().add(lb3);
    txt2.setBounds(80,90,80,23);
    txt2.setFont(f);
    getContentPane().add(txt2);
    btn1.setBounds(90,130,60,25);
    btn1.setFont(f);
    getContentPane().add(btn1);

    //设置边框
       txt1.setBorder(BorderFactory.createLineBorder(Color.black));
    txt2.setBorder(BorderFactory.createLineBorder(Color.black));
    btn1.setBorder(BorderFactory.createRaisedBevelBorder());
       sl.setBorder(BorderFactory.createLineBorder(Color.black));

//连接数据库
Database.joinDB();

//初始化表数据
String scEPIQ="select * from EncouragementPunishInformation";

       if(Database.query(scEPIQ)){
           System.out.println(scEPIQ);
           try{
               while(Database.rs.next()){
                   String number = ("" + Database.rs.getInt("EP_Number"));
                   String name = Database.rs.getString("EP_Name");
                   System.out.println(name);
                   String date = Database.rs.getString("EP_Date");
                   System.out.println(date);
                   String address = Database.rs.getString("EP_Address");
                   System.out.println(address);
                   String causation = Database.rs.getString("EP_Causation");
                   System.out.println(causation);
                   String remark = Database.rs.getString("EP_Remark");
                   System.out.println(remark);

                   Vector v = new Vector();
                   v.add(number);
                   v.add(name);
                   v.add(date);
                   v.add(address);
                   v.add(causation);
                   v.add(remark);

                   dtm.addRow(v);
                    }
               }
          catch(Exception eEPIQ){}

}

//为查询按钮加事件--------------------------------------------------------
btn1.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       System.out.println("查询按钮事件执行");
       String sEPIQ;
       int rc=dtm.getRowCount();
       //System.out.println(dtm.getRowCount());
       for(int i=0;i<rc;i++){
                       dtm.removeRow(0);
                       }

if(txt1.getText().equals("")&&txt2.getText().equals("")){
sEPIQ="select * from EncouragementPunishInformation";

           }
       else if(txt2.getText().equals("")){
           sEPIQ="select * from EncouragementPunishInformation where EP_Number = '" + txt1.getText() +"'";
           }
       else{
           sEPIQ="select * from EncouragementPunishInformation where EP_Number = '" + txt1.getText() +"' or EP_Name like '%"+ txt2.getText() +"%'";
           }
       System.out.println(sEPIQ);

       if(Database.query(sEPIQ)){
           System.out.println(sEPIQ);
           try{
               while(Database.rs.next()){
                   String number = ("" + Database.rs.getInt("EP_Number"));
                   String name = Database.rs.getString("EP_Name");
                   System.out.println(name);
                   String date = Database.rs.getString("EP_Date");
                   System.out.println(date);
                   String address = Database.rs.getString("EP_Address");
                   System.out.println(address);
                   String causation = Database.rs.getString("EP_Causation");
                   System.out.println(causation);
                   String remark = Database.rs.getString("EP_Remark");
                   System.out.println(remark);

                   dtm.addRow(v);
                    }
               }
          catch(Exception eEPIQ){}

           }
        }
   });

sl.setBounds(180,60,425,290);
getContentPane().add(sl);

       setSize(630,400);
       this.setClosable(true);
       setVisible(true);
       }
   }

//薪酬查询类

package classsource;

import java.awt.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.*;
import javax.swing.table.*;
import java.sql.*;

public class SIQ extends JInternalFrame{

   JLabel lbl4=new JLabel("薪资信息查询");
    JLabel lbl5=new JLabel("员工编号：");
    JLabel lbl6=new JLabel("员工姓名：");
    JTextField stxtid=new JTextField(10);
    JTextField stxtname=new JTextField(10);
    JButton btn1=new JButton("查询");

    JTable table;
   DefaultTableModel dtm;
   String columns[] = {"员工编号","员工姓名","基本工资","福利","奖金","计算方法","实发工资"};
   public SIQ(){
       setTitle("薪资信息查询");

       dtm = new DefaultTableModel();
       table = new JTable(dtm);
       table.setPreferredScrollableViewportSize(new Dimension(400, 80));
JScrollPane sl = new JScrollPane(table);

dtm.setColumnCount(7);
dtm.setColumnIdentifiers(columns);

       getContentPane().setLayout(null);
       lbl4.setBounds(200,10,300,30);
       lbl4.setFont(new Font("宋体",Font.BOLD,24));
       getContentPane().add(lbl4);

       Font f=new Font("宋体",Font.PLAIN,12);
       lbl5.setBounds(10,60,80,25);
       lbl5.setFont(f);
       getContentPane().add(lbl5);
       stxtid.setBounds(80,60,80,23);
       stxtid.setFont(f);
       getContentPane().add(stxtid);
       lbl6.setBounds(10,90,80,25);
       lbl6.setFont(f);
    getContentPane().add(lbl6);
    stxtname.setBounds(80,90,80,23);
    stxtname.setFont(f);
    getContentPane().add(stxtname);
    btn1.setBounds(90,130,60,25);
    btn1.setFont(f);
    getContentPane().add(btn1);

    //设置边框
       stxtid.setBorder(BorderFactory.createLineBorder(Color.black));
    stxtname.setBorder(BorderFactory.createLineBorder(Color.black));
    btn1.setBorder(BorderFactory.createRaisedBevelBorder());
       sl.setBorder(BorderFactory.createLineBorder(Color.black));

//连接数据库
Database.joinDB();

//初始化表格数据
String sql;

sql="select * from WageInformation";

       if(Database.query(sql)){
       try{
           System.out.println(sql);
       while(Database.rs.next()){
           String number =("" + Database.rs.getInt("W_Number"));
           String name = Database.rs.getString("W_Name");
           String basicwage = Database.rs.getString("W_BasicWage");
           String boon = Database.rs.getString("W_Boon");
           String bonus = Database.rs.getString("W_Bonus");
           String countmethod = Database.rs.getString("W_CountMethod");
           String factwage = Database.rs.getString("W_FactWage");

           Vector v =new Vector();
       v.add(number);
       v.add(name);
       v.add(basicwage);
       v.add(boon);
       v.add(bonus);
       v.add(countmethod);
       v.add(factwage);

       dtm.addRow(v);
           }
           }
       catch(Exception ex){}
       }

       if(stxtid.getText().equals("")&&stxtname.getText().equals("")){
           sql="select * from WageInformation";
           }
       else if(stxtname.getText().equals("")){
           sql="select * from WageInformation where W_Number = '"+ stxtid.getText() +"'";
           }
       else{
           sql="select * from WageInformation where W_Number = '"+ stxtid.getText() +"' or W_Name like '%"+ stxtname.getText()+"%'";
           }

           Vector v =new Vector();
       v.add(number);
       v.add(name);
       v.add(basicwage);
       v.add(boon);
       v.add(bonus);
       v.add(countmethod);
       v.add(factwage);

       dtm.addRow(v);
           }
           }
       catch(Exception ex){}
       }
   }

});

sl.setBounds(180,60,425,290);
getContentPane().add(sl);

       setSize(630,450);
       this.setClosable(true);
       setVisible(true);
       }
   }

//培训查询类
package classsource;

import java.awt.*;
import javax.swing.*;
import javax.swing.table.*;
import java.util.*;
import java.awt.event.*;
import java.sql.*;

public class TIQ extends JInternalFrame{

   JLabel lb1=new JLabel("培训信息查询");
    JLabel lb2=new JLabel("培训编号:");
    JLabel lb3=new JLabel("员工姓名:");
    JTextField ttxtid=new JTextField(10);
    JTextField ttxtname=new JTextField(10);
    JButton btn1=new JButton("查询");

    JTable table;
   DefaultTableModel dtm;
   String columns[] = {"培训编号","培训内容","员工姓名","培训天数","培训费用"};
   public TIQ(){
       setTitle("培训信息查询");

       dtm=new DefaultTableModel();
       table = new JTable(dtm);
       JScrollPane s1=new JScrollPane(table);

dtm.setColumnCount(5);
dtm.setColumnIdentifiers(columns);

       getContentPane().setLayout(null);
       lb1.setBounds(200,10,300,30);
       lb1.setFont(new Font("宋体",Font.BOLD,24));
       getContentPane().add(lb1);

       Font f=new Font("宋体",Font.PLAIN,12);
       lb2.setBounds(10,60,80,25);
       lb2.setFont(f);
       getContentPane().add(lb2);
       ttxtid.setBounds(80,60,80,23);
       ttxtid.setFont(f);
       getContentPane().add(ttxtid);
       lb3.setBounds(10,90,80,25);
       lb3.setFont(f);
    getContentPane().add(lb3);
    ttxtname.setBounds(80,90,80,23);
    ttxtname.setFont(f);
    getContentPane().add(ttxtname);
    btn1.setBounds(90,130,60,25);
    btn1.setFont(f);
    getContentPane().add(btn1);

s1.setBounds(180,60,425,290);
getContentPane().add(s1);

//设置边框
       ttxtid.setBorder(BorderFactory.createLineBorder(Color.black));
    ttxtname.setBorder(BorderFactory.createLineBorder(Color.black));
    btn1.setBorder(BorderFactory.createRaisedBevelBorder());
       s1.setBorder(BorderFactory.createLineBorder(Color.black));

//连接数据库
Database.joinDB();

       String Tim="select * from TrainInformation";
       if(Database.query(Tim)){
           System.out.println(Tim);
           try{
               while(Database.rs.next()){
                   String number=(""+Database.rs.getString("T_Number"));
                   System.out.println(number);
                   String Content=Database.rs.getString("T_Content");
                   System.out.println(Content);
                   String name=Database.rs.getString("T_Name");
                   System.out.println(name);
                   String date=Database.rs.getString("T_Date");
                   System.out.println(date);
                   String Money=Database.rs.getString("T_Money");
                   System.out.println(Money);

                   Vector v=new Vector();
                   v.add(number);
                   v.add(Content);
                   v.add(name);
                   v.add(date);
                   v.add(Money);

dtm.addRow(v);

               }
           }
           catch(Exception eTIQ){
           System.out.println("初始化表格失败！");
           }
       }
//为查询按钮加事件
btn1.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       System.out.println("查询按钮加事件");
       String STIQ;
       int rc=dtm.getRowCount();
       for(int i=0;i<rc;i++){
           dtm.removeRow(0);
       }

       if(ttxtid.getText().equals("")&&ttxtname.getText().equals("")){
       STIQ="select * from TrainInformation";
       }
       else if(ttxtname.getText().equals("")){
           STIQ="select * from TrainInformation where T_Number = '" + ttxtid.getText() +"'";
           }
       else{
       STIQ="select * from TrainInformation where T_Number = '" + ttxtid.getText() +"' or T_Name like '%"+ ttxtname.getText() +"%'";
       }
       System.out.println(STIQ);
       if(Database.query(STIQ)){
           try{
                       while(Database.rs.next()){
                           String number=(""+Database.rs.getString("T_Number"));
                           System.out.println(number);
                           String Content=Database.rs.getString("T_Content");
                           System.out.println(Content);
                           String name=Database.rs.getString("T_Name");
                           System.out.println(name);
                           String date=Database.rs.getString("T_Date");
                           System.out.println(date);
                           String Money=Database.rs.getString("T_Money");
                           System.out.println(Money);

                           Vector v=new Vector();
                           v.add(number);
                           v.add(Content);
                           v.add(name);
                           v.add(date);
                           v.add(Money);

                           dtm.addRow(v);
                       }
           }
           catch(Exception eT){}
       }
   }

});
       setSize(630,400);
       this.setClosable(true);
       setVisible(true);
       }
   }

//部门管理类
package classsource;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class Departmentmanage extends JInternalFrame{

   JLabel lb1 = new JLabel("部门信息");
   JLabel lb2 = new JLabel("部门编号：");
   JLabel lb3 = new JLabel("部门名称：");
   JLabel lb4 = new JLabel("部门人数：");
   JTextField tnumber = new JTextField();
   JTextField tname = new JTextField();
   JTextField tcount = new JTextField();
   JButton btright = new JButton("<<");
JButton btleft = new JButton(">>");
JButton btdelet = new JButton("删除");
JButton btamend = new JButton("修改");
JButton btsave = new JButton("保存");
JButton btadd = new JButton("添加");
   public Departmentmanage(){

setTitle("部门信息管理!");
btsave.setEnabled(false);

       getContentPane().setLayout(null);
       Font f = new Font("新宋体",0,14);
       btleft.setFont(f);

lb1.setFont(new java.awt.Font("新宋体", 1, 18));
lb1.setForeground(new Color(0, 51, 255));
getContentPane().add(lb1);
lb1.setBounds(110, 20, 160, 30);

lb2.setFont(f);
getContentPane().add(lb2);
lb2.setBounds(40, 85, 70, 20);
lb3.setFont(f);
getContentPane().add(lb3);
lb3.setBounds(40, 125, 70, 20);
lb4.setFont(f);
getContentPane().add(lb4);
lb4.setBounds(40,165,70,20);

getContentPane().add(tnumber);
tnumber.setBounds(155,85,100,23);
getContentPane().add(tname);
tname.setBounds(155,125,120,23);
getContentPane().add(tcount);
tcount.setBounds(155,165,120,23);

btright.setFont(f);
getContentPane().add(btright);
btright.setBounds(330, 250, 50, 20);

btleft.setFont(f);
getContentPane().add(btleft);
btleft.setBounds(330, 230, 50, 20);

btdelet.setFont(f);
getContentPane().add(btdelet);
btdelet.setBounds(250, 240, 70, 25);

btamend.setFont(f);
getContentPane().add(btamend);
btamend.setBounds(170, 240, 70, 25);

btsave.setFont(f);
getContentPane().add(btsave);
btsave.setBounds(10, 240, 70, 25);

btadd.setFont(f);
getContentPane().add(btadd);
btadd.setBounds(90, 240, 70, 25);
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
setBounds((screenSize.width-403)/2, (screenSize.height-329)/2, 403, 329);

//连接数据库
Database.joinDB();

//初始化窗体数据
String sqlc="select * from DepartmentInformation";
try{
if(Database.query(sqlc)){
   //System.out.println("ok");
   Database.rs.next();
   String number=("" + Database.rs.getInt("D_Number"));
   //System.out.println(number);
   String name=Database.rs.getString("D_Name");
   String count=Database.rs.getString("D_Count");
   tnumber.setText(number);
   tname.setText(name);
   tcount.setText(count);
   }
}
catch(Exception e){
    System.out.println(e);
    }

//为左右按钮加事件
btright.addActionListener(new ActionListener(){
    public void actionPerformed(ActionEvent e){
        try{
        if(Database.rs.previous()){
        String number=("" + Database.rs.getInt("D_Number"));
   String name=Database.rs.getString("D_Name");
   String count=Database.rs.getString("D_Count");
   tnumber.setEditable(true);
   tnumber.setText(number);
   tname.setText(name);
   tcount.setText(count);
            }
        }
        catch(Exception el){
           System.out.println(el);
           }
        }
    });

btleft.addActionListener(new ActionListener(){
    public void actionPerformed(ActionEvent e){
        try{
        if(Database.rs.next()){
        String number=("" + Database.rs.getInt("D_Number"));
   String name=Database.rs.getString("D_Name");
   String count=Database.rs.getString("D_Count");
   tnumber.setEditable(true);
   tnumber.setText(number);
   tname.setText(name);
   tcount.setText(count);
            }
        }
        catch(Exception er){
           System.out.println(er);
           }
        }
    });

//为添加删除保存修改按钮加事件
btadd.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       btsave.setEnabled(true);
       tnumber.setText("");
       tnumber.setEditable(false);
   tname.setText("");
   tcount.setText("");
       }
   });
btsave.addActionListener(new ActionListener(){
    public void actionPerformed(ActionEvent e){
        if(tname.getText().equals("") || tcount.getText().equals("")){
            new JOptionPane().showMessageDialog(null,"部门名和部门人数都不能为空！");
            }
        else{
            String name=tname.getText();
            String count=tcount.getText();
            String sInsert = "insert DepartmentInformation values('"+ name +"','"+ count +"')";
            try{
                if(Database.executeSQL(sInsert)){
                    tnumber.setEditable(true);
                    btsave.setEnabled(false);
                    new JOptionPane().showMessageDialog(null,"添加数据成功！");
                    Database.joinDB();
                    String sql="select * from DepartmentInformation";
                    Database.query(sql);
                    Database.rs.last();
                    String number1=("" + Database.rs.getInt("D_Number"));
   //System.out.println(number);
   String name1=Database.rs.getString("D_Name");
   String count1=Database.rs.getString("D_Count");
   tnumber.setText(number1);
   tname.setText(name1);
   tcount.setText(count1);
                    }

                else{
                    new JOptionPane().showMessageDialog(null,"添加数据不成功！");
                    }
                }
            catch(Exception ei){
                new JOptionPane().showMessageDialog(null,"添加数据不成功！");
                }
            }
        }
    });

    btdelet.addActionListener(new ActionListener(){
        public void actionPerformed(ActionEvent e){
            try{
                String sql="delete from DepartmentInformation where D_Number ='"+ tnumber.getText()+"'";
                System.out.println(sql);
                if(Database.executeSQL(sql)){
                    new JOptionPane().showMessageDialog(null,"数据删除成功！");
                    Database.joinDB();
                    String sqll="select * from DepartmentInformation";
                    Database.query(sqll);
                    Database.rs.last();
                    String number1=("" + Database.rs.getInt("D_Number"));
   String name1=Database.rs.getString("D_Name");
   String count1=Database.rs.getString("D_Count");
   tnumber.setText(number1);
   tname.setText(name1);
   tcount.setText(count1);
                    }
                }
            catch(Exception el){}
            }
        });

    btamend.addActionListener(new ActionListener(){
        public void actionPerformed(ActionEvent e){
            try{
                String supdate="update DepartmentInformation set D_Name='"+ tname.getText() +"',D_count='"+ tcount.getText()+"' where D_Number='"+ tnumber.getText()+"'";

                if(Database.executeSQL(supdate)){
                    new JOptionPane().showMessageDialog(null,"数据修改成功！");
                    Database.joinDB();
                    String sqll="select * from DepartmentInformation";
                    Database.query(sqll);
                    Database.rs.last();
                    String number1=("" + Database.rs.getInt("D_Number"));
   String name1=Database.rs.getString("D_Name");
   String count1=Database.rs.getString("D_Count");
   tnumber.setText(number1);
   tname.setText(name1);
   tcount.setText(count1);
                    }
                }
                catch(Exception es){}
            }
        });

this.setClosable(true);
setVisible(true);

}

//员工信息管理类

package classsource;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class Employeemanage extends JInternalFrame{
JInternalFrame jif;
public Employeemanage() {
jif=this;
initComponents();
}

private void initComponents() {

   setTitle("员工基本信息");
   String politicsVisage[]={"党员","群众"};
   String Estate[]={"在职","停薪留职","离职"};
   String Sex[]={"男","女"};
   String Marriage[]={"未婚","已婚","离婚"};
   Font f = new Font("新宋体", 0, 14);

lb1 = new JLabel("员工基本信息管理");
lb2 = new JLabel("编号:");
lb3 = new JLabel("政治面貌:");
lb4 = new JLabel("婚姻状态:");
lb5 = new JLabel("性别:");
lb6 = new JLabel("状态:");
lb7 = new JLabel("职务:");
lb8 = new JLabel("备注:");
lb9 = new JLabel("部门:");
lb10 = new JLabel("转正时间:");
lb11 = new JLabel("进入公司日期:");
lb12 = new JLabel("出生日期:");
lb13 = new JLabel("学历:");
lb14 = new JLabel("姓名:");
txt_number = new JTextField();
txt_name = new JTextField();
sex_cb = new JComboBox(Sex);
theadship = new JTextField();
tschoolage= new JTextField();
tdepartment = new JTextField();
txt_borndate = new JTextField();
marriage_cb = new JComboBox(Marriage);
politicsVisage_cb = new JComboBox(politicsVisage);
estate_cb = new JComboBox(Estate);
txt_enterdate = new JTextField();
txt_InDueFormDate = new JTextField();
remark_ta = new JTextArea();
save_bt = new JButton("保存");
rm_bt = new JButton(">>");
lm_bt = new JButton("<<");
right_bt = new JButton(">|");
left_bt = new JButton("|<");
exit_bt = new JButton("退出");
append_bt = new JButton("添加");
delet_bt= new JButton("删除");
amend_bt = new JButton("修改");

getContentPane().setLayout(null);

setFont(new Font("黑体", 1, 24));
lb1.setBackground(new Color(0, 0, 0));
lb1.setFont(new Font("新宋体", 1, 24));
lb1.setForeground(new Color(0, 0, 255));
getContentPane().add(lb1);
lb1.setBounds(140, 10, 210, 40);

lb2.setFont(f);

getContentPane().add(lb2);
lb2.setBounds(20, 80, 60, 20);

lb3.setFont(f);

getContentPane().add(lb3);
lb3.setBounds(10, 240, 80, 20);

lb4.setFont(f);

getContentPane().add(lb4);
lb4.setBounds(10, 190, 80, 20);

lb5.setFont(f);

getContentPane().add(lb5);
lb5.setBounds(360, 140, 60, 20);

lb6.setFont(f);

getContentPane().add(lb6);
lb6.setBounds(200, 290, 60, 20);

lb7.setFont(f);

getContentPane().add(lb7);
lb7.setBounds(200, 190, 60, 20);

lb8.setFont(f);

getContentPane().add(lb8);
lb8.setBounds(350, 240, 60, 20);

lb9.setFont(f);

getContentPane().add(lb9);
lb9.setBounds(200, 140, 60, 20);

lb10.setFont(f);

getContentPane().add(lb10);
lb10.setBounds(350, 190, 70, 20);

lb11.setFont(f);

getContentPane().add(lb11);
lb11.setBounds(10, 290, 110, 20);

lb12.setFont(f);

getContentPane().add(lb12);
lb12.setBounds(10, 140, 80, 20);

lb13.setFont(f);

getContentPane().add(lb13);
lb13.setBounds(200, 240, 60, 20);

lb14.setFont(f);

getContentPane().add(lb14);
lb14.setBounds(190, 80, 60, 20);

getContentPane().add(txt_number);
txt_number.setBounds(80, 80, 80, 21);

getContentPane().add(txt_name);
txt_name.setBounds(250, 80, 80, 20);

getContentPane().add(sex_cb);
sex_cb.setFont(f);
sex_cb.setSelectedIndex(1);
sex_cb.setBounds(430, 140, 90, 23);

getContentPane().add(txt_borndate);
txt_borndate.setBounds(80, 140, 100, 20);

getContentPane().add(marriage_cb);
marriage_cb.setFont(f);
marriage_cb.setBounds(80, 190, 100, 23);

getContentPane().add(politicsVisage_cb);
politicsVisage_cb.setFont(f);
politicsVisage_cb.setBounds(80, 240, 100, 23);

getContentPane().add(estate_cb);
estate_cb.setFont(f);
estate_cb.setBounds(250, 290, 90, 23);

getContentPane().add(tdepartment);
tdepartment.setFont(f);
tdepartment.setBounds(250, 140, 90, 20);

getContentPane().add(theadship);
theadship.setFont(f);
theadship.setBounds(250, 190, 90, 20);

getContentPane().add(tschoolage);
tschoolage.setFont(f);
tschoolage.setBounds(250, 240, 90, 20);

getContentPane().add(txt_enterdate);
txt_enterdate.setBounds(100, 290, 90, 20);

getContentPane().add(txt_InDueFormDate);
txt_InDueFormDate.setBounds(430, 190, 100, 20);

getContentPane().add(remark_ta);
remark_ta.setBounds(350, 260, 190, 53);

save_bt.setFont(f);

getContentPane().add(save_bt);
save_bt.setBounds(20, 390, 70, 25);
save_bt.setEnabled(false);

rm_bt.setFont(f);

getContentPane().add(rm_bt);
rm_bt.setBounds(260, 350, 70, 25);

lm_bt.setFont(f);

getContentPane().add(lm_bt);
lm_bt.setBounds(150, 350, 70, 25);

right_bt.setFont(f);

getContentPane().add(right_bt);
right_bt.setBounds(370, 350, 70, 25);

left_bt.setFont(f);
getContentPane().add(left_bt);
left_bt.setBounds(50, 350, 70, 25);

exit_bt.setFont(f);

getContentPane().add(exit_bt);
exit_bt.setBounds(410, 390, 70,25);

append_bt.setFont(f);

getContentPane().add(append_bt);
append_bt.setBounds(110, 390, 70, 25);

delet_bt.setFont(f);

getContentPane().add(delet_bt);
delet_bt.setBounds(310, 390, 70, 25);

amend_bt.setFont(f);
getContentPane().add(amend_bt);
amend_bt.setBounds(210, 390, 70, 25);

//连接数据库
Database.joinDB();

//初始化窗体数据
String csql="select * from EmployeeInformation";
try{
if(Database.query(csql)){
Database.rs.next();

   txt_number.setText("" + Database.rs.getInt("E_Number"));
   txt_name.setText(Database.rs.getString("E_Name"));
   if(Database.rs.getString("E_Sex").equals("男")){
       sex_cb.setSelectedIndex(0);
       }
   else{
       sex_cb.setSelectedIndex(1);
       }
    txt_borndate.setText(Database.rs.getString("E_BornDate"));
   tdepartment.setText(Database.rs.getString("E_Department"));

    if(Database.rs.getString("E_Marriage").equals("未婚")){
       marriage_cb.setSelectedIndex(0);
       }
   else if(Database.rs.getString("E_Marriage").equals("已婚")){
       marriage_cb.setSelectedIndex(1);
       }
   else{
       marriage_cb.setSelectedIndex(2);
       }
   theadship.setText(Database.rs.getString("E_Headship"));
   txt_InDueFormDate.setText(Database.rs.getString("E_InDueFormDate"));
   if(Database.rs.getString("E_PoliticsVisage").equals("党员")){
       politicsVisage_cb.setSelectedIndex(0);
       }
   else{
       politicsVisage_cb.setSelectedIndex(1);
       }
   tschoolage.setText(Database.rs.getString("E_SchoolAge"));
   txt_enterdate.setText(Database.rs.getString("E_EnterDate"));
   if(Database.rs.getString("E_Estate").equals("在职")){
       estate_cb.setSelectedIndex(0);
       }
   else if(Database.rs.getString("E_Estate").equals("停薪留职")){
       estate_cb.setSelectedIndex(1);
       }
   else{
       estate_cb.setSelectedIndex(2);
       }
   remark_ta.setText(Database.rs.getString("E_Remark"));
   }
   }
catch(Exception e){System.out.println(e);};

//为上一条，下一条按钮添加事件
//上一条按钮事件
rm_bt.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
   try{
       if(Database.rs.next()){
           txt_number.setText("" + Database.rs.getInt("E_Number"));
           txt_name.setText(Database.rs.getString("E_Name"));
           if(Database.rs.getString("E_Sex").equals("男")){
               sex_cb.setSelectedIndex(0);
               }
           else{
               sex_cb.setSelectedIndex(1);
               }
           txt_borndate.setText(Database.rs.getString("E_BornDate"));
           tdepartment.setText(Database.rs.getString("E_Department"));

           tschoolage.setText(Database.rs.getString("E_SchoolAge"));
           txt_enterdate.setText(Database.rs.getString("E_EnterDate"));
           if(Database.rs.getString("E_Estate").equals("在职")){
               estate_cb.setSelectedIndex(0);
               }
           else if(Database.rs.getString("E_Estate").equals("停薪留职")){
               estate_cb.setSelectedIndex(1);
               }
           else{
               estate_cb.setSelectedIndex(2);
               }
           remark_ta.setText(Database.rs.getString("E_Remark"));
           }
       }
   catch(Exception erm){
       System.out.println(erm);
       }
   }
    });

//下一条按钮事件
lm_bt.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
   try{
       if(Database.rs.previous()){
           txt_number.setText("" + Database.rs.getInt("E_Number"));
           txt_name.setText(Database.rs.getString("E_Name"));
           if(Database.rs.getString("E_Sex").equals("男")){
               sex_cb.setSelectedIndex(0);
               }
           else{
               sex_cb.setSelectedIndex(1);
               }
           txt_borndate.setText(Database.rs.getString("E_BornDate"));
           tdepartment.setText(Database.rs.getString("E_Department"));

//最前一条按钮事件
left_bt.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
   try{
       if(Database.rs.first()){
           txt_number.setText("" + Database.rs.getInt("E_Number"));
           txt_name.setText(Database.rs.getString("E_Name"));
           if(Database.rs.getString("E_Sex").equals("男")){
               sex_cb.setSelectedIndex(0);
               }
           else{
               sex_cb.setSelectedIndex(1);
               }
           txt_borndate.setText(Database.rs.getString("E_BornDate"));
           tdepartment.setText(Database.rs.getString("E_Department"));

right_bt.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
   try{
       if(Database.rs.last()){
           txt_number.setText("" + Database.rs.getInt("E_Number"));
           txt_name.setText(Database.rs.getString("E_Name"));
           if(Database.rs.getString("E_Sex").equals("男")){
               sex_cb.setSelectedIndex(0);
               }
           else{
               sex_cb.setSelectedIndex(1);
               }

txt_borndate.setText(Database.rs.getString("E_BornDate"));
tdepartment.setText(Database.rs.getString("E_Department"));

           theadship.setText(Database.rs.getString("E_Headship"));
           txt_InDueFormDate.setText(Database.rs.getString("E_InDueFormDate"));
           if(Database.rs.getString("E_PoliticsVisage").equals("党员")){
               politicsVisage_cb.setSelectedIndex(0);
               }
           else{
               politicsVisage_cb.setSelectedIndex(1);
               }

//为添加保存按钮加事件
append_bt.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
    save_bt.setEnabled(true);
txt_number.setText("");
txt_number.setEditable(false);
   txt_name.setText("");
   sex_cb.setSelectedIndex(0);
   txt_borndate.setText("");
   tdepartment.setText("");
   marriage_cb.setSelectedIndex(0);
   theadship.setText("");
   txt_InDueFormDate.setText("");
   politicsVisage_cb.setSelectedIndex(0);
   tschoolage.setText("");
   txt_enterdate.setText("");
   estate_cb.setSelectedIndex(0);
   remark_ta.setText("");
        }
    });

    save_bt.addActionListener(new ActionListener(){
        public void actionPerformed(ActionEvent e){
            if(txt_name.getText().equals("")||txt_borndate.getText().equals("")||tdepartment.getText().equals("")
            ||theadship.getText().equals("")||txt_InDueFormDate.getText().equals("")||tschoolage.getText().equals("")
||txt_enterdate.getText().equals("")){
   new JOptionPane().showMessageDialog(null,"除备注外，其余数据均不能为空！");
   }
else{
   String name=txt_name.getText();
   String borndate=txt_borndate.getText();
   String department=tdepartment.getText();
   String headship=theadship.getText();
   String indueformdate=txt_InDueFormDate.getText();
   String schoolage=tschoolage.getText();
   String enterdate=txt_enterdate.getText();
   String remark=remark_ta.getText();

   String sex=("" + sex_cb.getSelectedItem());
   String marriage=(""+marriage_cb.getSelectedItem());
   String estate=("" + estate_cb.getSelectedItem());
   String politicsVisage=("" + politicsVisage_cb.getSelectedItem());

   String sInsert="insert EmployeeInformation values('"+ name +"','"+ sex +"','"+ borndate+"',"+
   "'"+ marriage +"','"+ politicsVisage +"','"+ schoolage +"','"+ enterdate +"','"+ indueformdate +"',"+
   "'"+ department +"','"+ headship +"','"+ estate +"','"+ remark +"')";
   //System.out.println(sInsert);

   try{
       if(Database.executeSQL(sInsert)){
           txt_number.setEditable(true);
           save_bt.setEnabled(false);
           new JOptionPane().showMessageDialog(null,"添加数据成功！");

           Database.joinDB();
           String sql="select * from EmployeeInformation";
           Database.query(sql);
           Database.rs.last();
           txt_number.setText("" + Database.rs.getInt("E_Number"));
           }
       }
   catch(Exception einsert){
       System.out.println(einsert);
       }
   }
            }
        });//qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq

//为修改删除按钮添加事件
amend_bt.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){

    String name=txt_name.getText();
   String borndate=txt_borndate.getText();
   String department=tdepartment.getText();
   String headship=theadship.getText();
   String indueformdate=txt_InDueFormDate.getText();
   String schoolage=tschoolage.getText();
   String enterdate=txt_enterdate.getText();
   String remark=remark_ta.getText();

        String supdate="update EmployeeInformation set E_Name ='"+ name +"',E_Sex='"+ sex +"'," +
        "E_BornDate='"+ borndate +"',E_Marriage='"+ marriage +"',E_PoliticsVisage='"+ politicsVisage +"'," +
        "E_SchoolAge='"+ schoolage+"',E_EnterDate='"+ enterdate +"',E_InDueFormDate='"+ indueformdate +"',"+
        "E_Department='"+ department +"',E_Headship='"+ headship +"',E_Estate='"+ estate +"'," +
        "E_Remark='"+ remark +"' where E_Number='"+ txt_number.getText() +"'";

        System.out.println(supdate);
        try{
       if(Database.executeSQL(supdate)){
                    new JOptionPane().showMessageDialog(null,"数据修改成功！");

                    Database.joinDB();
                    String sqll="select * from EmployeeInformation";
                   Database.query(sqll);
                }
            }
        catch(Exception eupdate){}
        }
    });

delet_bt.addActionListener(new ActionListener(){
    public void actionPerformed(ActionEvent e){
        String sdelete = "delete from EmployeeInformation where E_Number ='"+ txt_number.getText()+"'";
        try{
            if(Database.executeSQL(sdelete)){
                new JOptionPane().showMessageDialog(null,"数据删除成功！");

          String sql="select * from EmployeeInformation";
          Database.query(sql);
          Database.rs.next();

       txt_number.setText("" + Database.rs.getInt("E_Number"));
       txt_name.setText(Database.rs.getString("E_Name"));
       if(Database.rs.getString("E_Sex").equals("男")){
           sex_cb.setSelectedIndex(0);
           }
       else{
           sex_cb.setSelectedIndex(1);
           }

txt_borndate.setText(Database.rs.getString("E_BornDate"));
tdepartment.setText(Database.rs.getString("E_Department"));

       theadship.setText(Database.rs.getString("E_Headship"));
       txt_InDueFormDate.setText(Database.rs.getString("E_InDueFormDate"));
       if(Database.rs.getString("E_PoliticsVisage").equals("党员")){
           politicsVisage_cb.setSelectedIndex(0);
           }
       else{
           politicsVisage_cb.setSelectedIndex(1);
           }

       tschoolage.setText(Database.rs.getString("E_SchoolAge"));
       txt_enterdate.setText(Database.rs.getString("E_EnterDate"));
       if(Database.rs.getString("E_Estate").equals("在职")){
           estate_cb.setSelectedIndex(0);
           }
       else if(Database.rs.getString("E_Estate").equals("停薪留职")){
           estate_cb.setSelectedIndex(1);
           }
       else{
           estate_cb.setSelectedIndex(2);
           }
       remark_ta.setText(Database.rs.getString("E_Remark"));
                  }
            }
        catch(Exception er){
            System.out.println(er);
            }
        }
    });

exit_bt.addActionListener(new ActionListener(){
    public void actionPerformed(ActionEvent e){
        jif.setVisible(false);
        }
    });

Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
setBounds((screenSize.width-558)/2, (screenSize.height-477)/2, 558, 455);
this.setClosable(true);
this.setMaximizable(true);
setVisible(true);
}

private JButton save_bt;
private JButton rm_bt;
private JButton lm_bt;
private JButton right_bt;
private JButton left_bt;
private JButton exit_bt;
private JButton append_bt;
private JButton delet_bt;
private JButton amend_bt;
private JComboBox sex_cb;
private JComboBox marriage_cb;
private JComboBox politicsVisage_cb;
private JComboBox estate_cb;
private JFrame jFrame1;
private JLabel lb1;
private JLabel lb10;
private JLabel lb11;
private JLabel lb12;
private JLabel lb13;
private JLabel lb14;
private JLabel lb2;
private JLabel lb3;
private JLabel lb4;
private JLabel lb5;
private JLabel lb6;
private JLabel lb7;
private JLabel lb8;
private JLabel lb9;
private JList headship_ls;
private JList schoolage_ls;
private JList department_ls;
private JTextArea remark_ta;
private JTextField txt_number;
private JTextField txt_name;
private JTextField txt_borndate;
private JTextField txt_enterdate;
private JTextField txt_InDueFormDate;
private JTextField theadship;
private JTextField tschoolage;
private JTextField tdepartment;

}

//奖惩管理类

package classsource;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class EncouragementPunish extends JInternalFrame {

public EncouragementPunish() {
//连接数据库
Database.joinDB();
setTitle("员工奖罚管理!");
Font f = new Font("新宋体", 0, 14);
lb1 = new JLabel("员工奖罚信息");
lb2 = new JLabel("员工编号:");
lb3 = new JLabel("地点:");
lb4 = new JLabel("奖罚时间:");
lb5 = new JLabel("奖罚原因:");
lb6 = new JLabel("备注:");
lb7 = new JLabel("员工姓名:");
tnumber = new JTextField();
tname = new JTextField();
tremarks = new JTextArea();
tadress = new JTextField();
treason = new JTextField();
ttime = new JTextField();
btright = new JButton("<<");
btleft = new JButton(">>");
btdelet = new JButton("删除");
btamend = new JButton("修改");
btsave = new JButton("保存");
btadd = new JButton("添加");

getContentPane().setLayout(null);

lb1.setBackground(new java.awt.Color(204, 204, 204));
lb1.setFont(new java.awt.Font("新宋体", 1, 18));
lb1.setForeground(new java.awt.Color(0, 0, 255));
getContentPane().add(lb1);
lb1.setBounds(120, 10, 190, 30);

lb2.setFont(f);
getContentPane().add(lb2);
lb2.setBounds(20, 60, 70, 20);

lb7.setFont(f);
getContentPane().add(lb7);
lb7.setBounds(215, 60, 70, 20);

getContentPane().add(tname);
tname.setBounds(280,60,90,20);
lb3.setFont(f);
getContentPane().add(lb3);
lb3.setBounds(20, 100, 70, 20);

lb4.setFont(f);
getContentPane().add(lb4);
lb4.setBounds(20, 140, 70, 20);

lb5.setFont(f);

getContentPane().add(lb5);
lb5.setBounds(20, 180, 70, 20);

lb6.setFont(f);

getContentPane().add(lb6);
lb6.setBounds(260, 100, 70, 20);

getContentPane().add(tnumber);
tnumber.setBounds(100, 60, 90, 20);

getContentPane().add(tremarks);
tremarks.setBounds(260, 130, 130, 70);

getContentPane().add(tadress);
tadress.setBounds(100, 100, 150, 20);

getContentPane().add(treason);
ttime.setBounds(100, 140, 150, 20);

getContentPane().add(ttime);
treason.setBounds(100, 180, 150, 21);

btright.setFont(f);
getContentPane().add(btright);
btright.setBounds(330, 250, 50, 20);

btleft.setFont(f);
getContentPane().add(btleft);
btleft.setBounds(330, 230, 50, 20);

btdelet.setFont(f);
getContentPane().add(btdelet);
btdelet.setBounds(250, 240, 70, 25);

btamend.setFont(f);
getContentPane().add(btamend);
btamend.setBounds(170, 240, 70, 25);

btsave.setFont(f);
getContentPane().add(btsave);
btsave.setBounds(10, 240, 70, 25);

btadd.setFont(f);
getContentPane().add(btadd);
btadd.setBounds(90, 240, 70, 25);
//初始化窗体数据
String sqlc="select * from EncouragementPunishInformation";
try{
if(Database.query(sqlc)){

Database.rs.next();
tnumber.setText(""+Database.rs.getInt("EP_Number"));
tname.setText(Database.rs.getString("EP_Name"));
ttime.setText(Database.rs.getString("EP_Date"));
tadress.setText(Database.rs.getString("EP_Address"));
treason.setText(Database.rs.getString("EP_Causation"));
tremarks.setText(Database.rs.getString("EP_Remark"));

   }
}
catch(Exception e){
    System.out.println(e);
    }

//为左右按钮加事件
btright.addActionListener(new ActionListener(){
    public void actionPerformed(ActionEvent e){
        try{
        if(Database.rs.previous()){
    tnumber.setEditable(true);
tnumber.setText(""+Database.rs.getInt("EP_Number"));
tname.setText(Database.rs.getString("EP_Name"));
ttime.setText(Database.rs.getString("EP_Date"));
tadress.setText(Database.rs.getString("EP_Address"));
treason.setText(Database.rs.getString("EP_Causation"));
tremarks.setText(Database.rs.getString("EP_Remark"));
            }
        }
        catch(Exception el){
           System.out.println(el);
           }
        }
    });

btleft.addActionListener(new ActionListener(){
    public void actionPerformed(ActionEvent e){
        try{
        if(Database.rs.next()){

        tnumber.setEditable(true);
tnumber.setText(""+Database.rs.getInt("EP_Number"));
tname.setText(Database.rs.getString("EP_Name"));
ttime.setText(Database.rs.getString("EP_Date"));
tadress.setText(Database.rs.getString("EP_Address"));
treason.setText(Database.rs.getString("EP_Causation"));
tremarks.setText(Database.rs.getString("EP_Remark"));
            }
        }
        catch(Exception er){
           System.out.println(er);
           }
        }
    });

//添加添加按扭事件
btadd.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       tnumber.setText("");
       tnumber.setEditable(false);
       btsave.setEnabled(true);
       tname.setText("");
       ttime.setText("");
       treason.setText("");
       tadress.setText("");
       tremarks.setText("");
   }
});

//添加保存按扭事件
btsave.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

   if(tname.getText().equals("") || ttime.getText().equals("") || tadress.getText().equals("") || treason.getText().equals("")){
   new JOptionPane().showMessageDialog(null,"姓名,地址,时间,奖励原因!填写不能为空！");
   }
   else{
   String name=tname.getText();
   String time=ttime.getText();
   String reason=treason.getText();
   String address=tadress.getText();
   String remarks=tremarks.getText();
   String sInsert="insert EncouragementPunishInformation values ('"+name+"','"+time+"','"+ address +"','"+remarks+"','"+reason+"')";

   System.out.println(sInsert);
   try{
   if(Database.executeSQL(sInsert)){
   tnumber.setEditable(true);
   btsave.setEnabled(false);
   new JOptionPane().showMessageDialog(null,"成功添加数据！");
   String sql="select * from EncouragementPunishInformation ";
   Database.joinDB();
   Database.query(sql);

   Database.rs.last();
   tnumber.setText(""+Database.rs.getInt("EP_Number"));
}
}catch(Exception el){
    new JOptionPane().showMessageDialog(null,"添加数据不成功！");
}
}
    }
});
//添加修改和删除事件按扭
    btdelet.addActionListener(new ActionListener(){
        public void actionPerformed(ActionEvent e){
            try{
                String sql="delete from EncouragementPunishInformation where EP_Number ='"+ tnumber.getText()+"'";
                System.out.println(sql);
                if(Database.executeSQL(sql)){
                    new JOptionPane().showMessageDialog(null,"数据删除成功！");
                    Database.joinDB();
                    String sqll="select * from EncouragementPunishInformation";
                    Database.query(sqll);
                    Database.rs.last();
tnumber.setText(""+Database.rs.getInt("EP_Number"));
tname.setText(Database.rs.getString("EP_Name"));
ttime.setText(Database.rs.getString("EP_Date"));
tadress.setText(Database.rs.getString("EP_Address"));
treason.setText(Database.rs.getString("EP_Causation"));
tremarks.setText(Database.rs.getString("EP_Remark"));
                    }
                }
            catch(Exception el){}
            }
        });

    btamend.addActionListener(new ActionListener(){
        public void actionPerformed(ActionEvent e){
            try{
                String supdate="update EncouragementPunishInformation set EP_Name='"+ tname.getText()+ "',EP_Date='"+ ttime.getText() +"',EP_Address='"+tadress.getText()+"',EP_Causation='"+treason.getText()+"',EP_Remark='"+tremarks.getText()+"'where EP_Number='"+tnumber.getText()+"'";

                if(Database.executeSQL(supdate)){
                    new JOptionPane().showMessageDialog(null,"数据修改成功！");
                    Database.joinDB();
                    String sqll="select * from EncouragementPunishInformation";
                    Database.query(sqll);
                    Database.rs.last();
tnumber.setText(""+Database.rs.getInt("EP_Number"));
tname.setText(Database.rs.getString("EP_Name"));
ttime.setText(Database.rs.getString("EP_Date"));
tadress.setText(Database.rs.getString("EP_Address"));
treason.setText(Database.rs.getString("EP_Causation"));
tremarks.setText(Database.rs.getString("EP_Remark"));
                    }
                }
                catch(Exception es){new JOptionPane().showMessageDialog(null,"修改数据不成功！");}
            }
        });

Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
setBounds((screenSize.width-403)/2, (screenSize.height-329)/2, 403, 329);
this.setClosable(true);
setVisible(true);

}

JButton btadd;
JButton btamend;
JButton btdelet;
JButton btleft;
JButton btright;
JButton btsave;
JLabel lb1;
JLabel lb2;
JLabel lb3;
JLabel lb4;
JLabel lb5;
JLabel lb6;
JLabel lb7;
JTextField tadress;
JTextField tname;
JTextField tnumber;
JTextField treason;
JTextArea tremarks;
JTextField ttime;

}

//培训管理类
package classsource;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class Trainmanage extends JInternalFrame {

private JButton btadd,btamend,btdelet,btleft,btright,btsave;
private JLabel lb1,lb2,lb3,lb4,lb5;
private JTextField tcontent,tdate,tmoney,tnumber,tname;

public Trainmanage() {

initComponents();
}

private void initComponents() {

setTitle("培训信息管理");
Font f = new Font("新宋体", 0, 14);
lb1 = new JLabel("员工培训信息管理");
lb2 = new JLabel("培训编号:");
lb3 = new JLabel("培训内容:");
lb4 = new JLabel("培训天数:");
lb5 = new JLabel("培训费用:");
JLabel lb6 = new JLabel("员工姓名：");
tnumber = new JTextField();
tcontent = new JTextField();
tmoney = new JTextField();
tdate = new JTextField();
tname = new JTextField();
btright = new JButton("<<");
btleft = new JButton(">>");
btdelet = new JButton("删除");
btamend = new JButton("修改");
btsave = new JButton("保存");
btsave.setEnabled(false);
btadd = new JButton("添加");

getContentPane().setLayout(null);

lb1.setFont(new java.awt.Font("新宋体", 1, 18));
lb1.setForeground(new Color(0, 51, 255));

getContentPane().add(lb1);
lb1.setBounds(110, 10, 160, 30);

lb6.setFont(f);
getContentPane().add(lb6);
lb6.setBounds(30,40,70,20);

lb2.setFont(f);
getContentPane().add(lb2);
lb2.setBounds(30, 80, 70, 20);

lb3.setFont(f);
getContentPane().add(lb3);
lb3.setBounds(30, 200, 70, 20);

lb4.setFont(f);
getContentPane().add(lb4);
lb4.setBounds(30, 120, 70, 20);

lb5.setFont(f);
getContentPane().add(lb5);
lb5.setBounds(30, 160, 70, 20);

getContentPane().add(tname);
tname.setBounds(120,40,110,23);

getContentPane().add(tnumber);
tnumber.setBounds(120, 80, 110, 23);

getContentPane().add(tcontent);
tcontent.setBounds(120, 200, 170, 23);

getContentPane().add(tmoney);
tmoney.setBounds(120, 160, 140, 23);

getContentPane().add(tdate);
tdate.setBounds(120, 120, 110, 23);
btright.setFont(f);
getContentPane().add(btright);
btright.setBounds(330, 255, 50, 20);

btleft.setFont(f);
getContentPane().add(btleft);
btleft.setBounds(330, 235, 50, 20);

btdelet.setFont(f);
getContentPane().add(btdelet);
btdelet.setBounds(250, 245, 70, 25);

btamend.setFont(f);
getContentPane().add(btamend);
btamend.setBounds(170, 245, 70, 25);

btsave.setFont(f);
getContentPane().add(btsave);
btsave.setBounds(10, 245, 70, 25);

btadd.setFont(f);
getContentPane().add(btadd);
btadd.setBounds(90, 245, 70, 25);

//连接数据库
Database.joinDB();
//初始化窗体数据
String sql="select * from TrainInformation";
try{
   if(Database.query(sql)){
       Database.rs.next();
       tname.setText(Database.rs.getString("T_Name"));
       tnumber.setText(Database.rs.getString("T_Number"));
tcontent.setText(Database.rs.getString("T_Content"));
tmoney.setText(Database.rs.getString("T_Money"));
tdate.setText(Database.rs.getString("T_Date"));
       }
   }
catch(Exception e){
   System.out.println(e);
   }

//为上一条下一条按钮加事件
btright.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       try{
           if(Database.rs.previous()){
               tname.setText(Database.rs.getString("T_Name"));
               tnumber.setText(Database.rs.getString("T_Number"));
       tcontent.setText(Database.rs.getString("T_Content"));
       tmoney.setText(Database.rs.getString("T_Money"));
       tdate.setText(Database.rs.getString("T_Date"));
               }
           }
       catch(Exception er){}
       }
   });

btleft.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       try{
           if(Database.rs.next()){
               tname.setText(Database.rs.getString("T_Name"));
               tnumber.setText(Database.rs.getString("T_Number"));
       tcontent.setText(Database.rs.getString("T_Content"));
       tmoney.setText(Database.rs.getString("T_Money"));
       tdate.setText(Database.rs.getString("T_Date"));
               }
           }
       catch(Exception el){}
}
   });

//为添加保存按钮加事件
btadd.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       btsave.setEnabled(true);
       tnumber.setText("");
       tcontent.setText("");
       tmoney.setText("");
       tdate.setText("");
       tname.setText("");
}
   });

btsave.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       if(tnumber.getText().equals("")||tcontent.getText().equals("")||tmoney.getText().equals("")
       ||tdate.getText().equals("")||tname.getText().equals("")){
          new JOptionPane().showMessageDialog(null,"所有数据均不能为空！");
          }
       else{
           String sqlInsert="insert TrainInformation values('"+ tnumber.getText() +"'," +
           "'"+ tcontent.getText() +"','"+ tname.getText() +"','"+ tdate.getText() +"'," +
           "'"+ tmoney.getText() +"')";
           try{
               if(Database.executeSQL(sqlInsert)){
                   new JOptionPane().showMessageDialog(null,"数据添加成功！");
                   Database.joinDB();
                   String sql="select * from TrainInformation";
                   Database.query(sql);
                   }
               }
           catch(Exception einsert){}
           }
}
   });

//为修改删除按钮加事件
btdelet.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
       String sqldelete="delete from TrainInformation where T_Number='"+ tnumber.getText() +"'";
try{
   if(Database.executeSQL(sqldelete)){
       new JOptionPane().showMessageDialog(null,"数据删除成功！");
                   Database.joinDB();
                   String sql="select * from TrainInformation";
                   Database.query(sql);
                   Database.rs.first();
               tname.setText(Database.rs.getString("T_Name"));
               tnumber.setText(Database.rs.getString("T_Number"));
       tcontent.setText(Database.rs.getString("T_Content"));
       tmoney.setText(Database.rs.getString("T_Money"));
       tdate.setText(Database.rs.getString("T_Date"));
       }
   }
catch(Exception edelete){}
}
   });

btamend.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
   String sqlupdate="update TrainInformation set T_Money='"+ tmoney.getText() +"'," +
   "T_Content='"+ tcontent.getText() +"',T_Name='"+ tname.getText() +"',"+
   "T_Date='"+ tdate.getText() +"' where T_Number='"+ tnumber.getText()+"'";
try{
   if(Database.executeSQL(sqlupdate)){
       new JOptionPane().showMessageDialog(null,"数据修改成功！");
                   Database.joinDB();
                   String sql="select * from TrainInformation";
                   Database.query(sql);
       }
   }
catch(Exception edelete){}
}
   });

Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
setBounds((screenSize.width-403)/2, (screenSize.height-329)/2, 403, 329);
this.setClosable(true);
setVisible(true);
}

//薪筹管理类

package classsource;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.util.*;
import java.sql.*;

public class WageManage extends JInternalFrame{

   private 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("<<");
    private JButton next=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());
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("")){
       System.out.println("以上信息必须填写!");
   }
   else{

    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);
       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(){
public void actionPerformed(ActionEvent eupd){
   try{
            String supdate="update WageInformation set W_Name='"+ stname.getText()+"',W_BasicWage='"+ stid.getText() +"',W_Boon='"+stboon.getText()+"',W_Bonus='"+stprize.getText()+"',W_CountMethod='"+stcounter.getText()+"',W_FactWage='"+stfact.getText()+"' where W_Number='"+ stid.getText()+"'";
      if(Database.executeSQL(supdate)){
            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 eupdete){
      System.out.println("修改数据失败!");
   }
}

});

       setSize(460,350);
       this.setClosable(true);
       setVisible(true);
       }

}

//计算器类
package classsource;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.io.*;
import java.sql.*;

public class Calculator extends JInternalFrame implements ActionListener
{
   private JTextField displayText=new JTextField();
   private JButton buttonTag=new JButton();
   private JButton buttonBackspace=new JButton("Backspace");
   private JButton buttonCe=new JButton("CE");
   private JButton buttonc=new JButton("C");
   private JButton[] button=new JButton[24];
   private String[] keys={"MC","7","8","9","/","sqrt","MR","4","5","6","*","%",
               "MS","1","2","3","-","1/x","M+","0","+/-",".","+","="};

   private String numStr1="";
   private String numStr2="";
   private String numsave="";

   private char op;
   private boolean firstInput=true;
   private boolean operatorTag1=true;
   private boolean operatorTag2=true;

   public Calculator(){
       setTitle("计算器");
       setSize(345,265);
       Container pane=getContentPane();

pane.setLayout(null);

displayText.setHorizontalAlignment(JTextField.RIGHT);
       displayText.setSize(320,30);
       displayText.setLocation(10,10);
       pane.add(displayText);

       buttonTag.setSize(60,30);
       buttonTag.setLocation(10,50);
       pane.add(buttonTag);

       buttonBackspace.setSize(110,30);
       buttonBackspace.setLocation(90,50);
       buttonBackspace.setForeground(Color.red);
       buttonBackspace.addActionListener(this);
       pane.add(buttonBackspace);

       buttonCe.setSize(65,30);
       buttonCe.setLocation(200,50);
       buttonCe.setForeground(Color.red);
       pane.add(buttonCe);

       buttonc.setSize(65,30);
       buttonc.setLocation(265,50);
       buttonc.setForeground(Color.red);
       buttonc.addActionListener(this);
       pane.add(buttonc);

int x,y;

       x=10;
       y=85;
       for(int ind=0;ind<24;ind++){

           button[ind]=new JButton(keys[ind]);
           button[ind].addActionListener(this);
           button[ind].setLocation(x,y);
           if(ind%6==0 || ind%6==5)
               {button[ind].setSize(60,30);
               x=x+60;}
           else
               {button[ind].setSize(50,30);
               x=x+50;}

           if(ind%6==0 || ind%6==4 ||ind%24==23)
               button[ind].setForeground(Color.red);
           else
               button[ind].setForeground(Color.blue);

pane.add(button[ind]);

           if((ind+1)%6==0)
               {
               x=10;
               y=y+30;
               }
           }

       setVisible(true);
       this.setClosable(true);
       }

public void actionPerformed(ActionEvent e){
String resultStr="";

String str=String.valueOf(e.getActionCommand());
char ch=str.charAt(0);

           if(str.equals("0")||str.equals("1")||str.equals("2")||str.equals("3")||str.equals("4")||
               str.equals("5")||str.equals("6")||str.equals("7")||str.equals("8")||
               str.equals("9")||str.equals(".")){
                       if(firstInput){
                           numStr1=numStr1+ch;
                           displayText.setText(numStr1);
                           }
                       else{
                           numStr2=numStr2+ch;
                           displayText.setText(numStr2);
                           }
                       }
           else if(str.equals("+")||str.equals("-")||str.equals("*")
                       ||str.equals("/") & operatorTag2){
                       if(numStr2.equals(""))
               op=ch;
               else{
                   resultStr=evaluate();
                   displayText.setText(resultStr);
                   numStr1=resultStr;
                       numStr2="";
                       op=ch;
                   }
                       firstInput=false;
                       //operatorTag1=false;
                       }
           else if(str.equals("=")){
                       resultStr=evaluate();
                       displayText.setText(resultStr);
                       numStr1="";
                       numStr2="";
                       firstInput=true;
                   }
           else if(str.equals("C")){
                       displayText.setText("");
                       numStr1="";
                       numStr2="";
                       firstInput=true;
               }
           else if((str.equals("sqrt")|str.equals("1/x")) & !numStr1.equals("")& operatorTag1){
               float A=Float.parseFloat(numStr1);
               float result=0;
               if(str.equals("sqrt"))
                   result=(float)Math.sqrt(A);
               if(str.equals("1/x"))
                   result=1/A;
               numStr1=Float.toString(result);
               displayText.setText(numStr1);
               firstInput=false;

               }
           else if (str.equals("Backspace")){
               String str1=displayText.getText();
               if(!str1.equals("")){
                   displayText.setText(str1.substring(0,str1.length()-1));
               if(!numStr1.equals(""))
                   numStr1=displayText.getText();
               else
                   numStr2=displayText.getText();
                   }
               }
           else if(str.equals("MS")){
               numsave=displayText.getText();
               buttonTag.setText("M");
           numStr1="";
               }
           else if(str.equals("MC")){
               numsave="";
               buttonTag.setText("");
               }
           else if (str.equals("MR")){
               displayText.setText(numsave);
               }
           else if(str.equals("M+")){

}
}

   private String evaluate(){

       if(!numStr1.equals("") & !numStr2.equals("")){
           float A=Float.parseFloat(numStr1);
           float B=Float.parseFloat(numStr2);
           float result=0;
           switch(op){
                   case '+':result=A+B;break;
                   case '-':result=A-B;break;
                   case '*':result=A*B;break;
                   case '/':result=A/B;break;
                   }
           return String.valueOf(result);
           }
       else
           return numStr1;
       }
}