人事管理系统.docx

1、人事管理系统人事管理系统只要将这些放在eclips中就可以了，还要加一个mysql架包，自己应该知道。Jdbc包package com.jdbc;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import javax.swing.JOptionPane;import com.person.Person

2、;/* * author 一木 * 欢迎来访穹庐网 * Jdbc类主要用于增删改查，和数据库交互，使用SQL语句实现数据库的操作 * */public class Jdbc Statement ste1; ResultSet rt1; ResultSet rt2; PreparedStatement ps1; PreparedStatement ps2; PreparedStatement ps3; PreparedStatement ps4; String url=jdbc:mysql:/localhost:3306/manage;/数据库地址 String user=root;/用户 St

3、ring password=123;/密码 public boolean flag=true; /1加载驱动 public void connection() try Class.forName(com.mysql.jdbc.Driver);/加载驱动，驱动程序类自身的一个static代码块自动生成驱动程序的实例 / System.out.println(加载成功); catch (ClassNotFoundException e1) System.out.println(加载失败); try /获得连接 DriverManager.getConnection(url, user, passw

4、ord);/connection类型连接 数据库 / System.out.println(连接成功); catch (SQLException e111) System.out.println(连接失败); /2查询全部并导入数据 public void lead() connection(); String sql=select * from company; try ste1 = DriverManager.getConnection(url, user, password).createStatement();/connection类下的Statement对象执行SQL rt1= st

5、e1.executeQuery(sql);/ResultSet结果集合 catch (SQLException e1) e1.printStackTrace(); /3并添加数据 public void add(int Id,String Name,int Sex,String Dapartment,int Salary) connection(); String sql=insert into company values(?,?,?,?,?); try ps1 = DriverManager.getConnection(url, user, password).prepareStateme

6、nt(sql); /定义一个？号的内容 ps1.setInt(1, Id); ps1.setString(2,Name); /插入第一个？号 ps1.setInt(3,Sex); ps1.setString(4,Dapartment); ps1.setInt(5, Salary); ps1.execute();/ 执行 System.out.println(添加成功); catch (SQLException e) flag=false; JOptionPane.showMessageDialog(null, 已经有此编号了, 消息框, 0); /4删除数据 public boolean de

7、lete(int Id) connection(); String sql=delete from company where Id=?; try ps2=DriverManager.getConnection(url, user, password).prepareStatement(sql); ps2.setInt(1,Id); ps2.execute(); System.out.println(删除成功); catch (SQLException e) System.out.println(操作失败); return false; return true; /5修改数据 public B

8、oolean update(int Id,String Name,int Sex,String Dapartment,int Salary) connection(); String sql=update company set Name=?,Sex=?,Dapartment=?,Salary=? where Id=?;/问号不能有有引号 try ps3=DriverManager.getConnection(url, user, password).prepareStatement(sql); ps3.setString(1, Name); ps3.setInt(2, Sex); ps3.s

9、etString(3, Dapartment); ps3.setInt(4, Salary); ps3.setInt(5, Id); ps3.execute(); System.out.println(修改成功); catch (SQLException e) System.out.println(操作失败); return false; return true; /按各个查询/按Id查询 public ArrayList selectId(int Id)/ connection(); ArrayList arr=new ArrayList(); System.out.println(Id);

10、 String sql=select * from company where Id =? ; try ps4=DriverManager.getConnection(url, user, password).prepareStatement(sql); ps4.setInt(1,Id); ps4.execute(); rt2 = ps4.executeQuery(); while(rt2.next() arr.add(new Person(rt2.getInt(1),rt2.getString(2),rt2.getInt(3),rt2.getString(4),rt2.getInt(5);

11、System.out.println(查询成功); catch (SQLException e) System.out.println(操作失败); return arr; /按 Name查询 public ArrayList selectName(String Name) connection(); ArrayList arr=new ArrayList(); String sql=select * from company where Name like ? ; try ps4=DriverManager.getConnection(url, user, password).prepare

12、Statement(sql); ps4.setString(1,%+Name+%); ps4.execute(); rt2 = ps4.executeQuery(); while(rt2.next() arr.add(new Person(rt2.getInt(1),rt2.getString(2),rt2.getInt(3),rt2.getString(4),rt2.getInt(5); System.out.println(查询成功); catch (SQLException e) System.out.println(操作失败); return arr; /按Sex查询 public A

13、rrayList selectSex(int Sex) connection(); ArrayList arr=new ArrayList(); String sql=select * from company where Sex=? ; try ps4=DriverManager.getConnection(url, user, password).prepareStatement(sql); ps4.setInt(1,Sex); ps4.execute(); rt2 = ps4.executeQuery(); while(rt2.next() arr.add(new Person(rt2.

14、getInt(1),rt2.getString(2),rt2.getInt(3),rt2.getString(4),rt2.getInt(5); catch (SQLException e) System.out.println(操作失败); return arr; /按Dapartment查询 public ArrayList selectDapartment(String Dapartment) connection(); ArrayList arr=new ArrayList(); String sql=select * from company where Dapartment=?;

15、try ps4=DriverManager.getConnection(url, user, password).prepareStatement(sql); ps4.setString(1,Dapartment); ps4.execute(); rt2 = ps4.executeQuery(); while(rt2.next() arr.add(new Person(rt2.getInt(1),rt2.getString(2),rt2.getInt(3),rt2.getString(4),rt2.getInt(5); catch (SQLException e) System.out.pri

16、ntln(操作失败); return arr; /按Salary查询 public ArrayList selectSalary(int Salary) connection(); ArrayList arr=new ArrayList(); String sql=select * from company where Salary = ?; try ps4=DriverManager.getConnection(url, user, password).prepareStatement(sql); ps4.setInt(1,Salary); ps4.execute(); rt2 = ps4.

17、executeQuery(); while(rt2.next() arr.add(new Person(rt2.getInt(1),rt2.getString(2),rt2.getInt(3),rt2.getString(4),rt2.getInt(5); catch (SQLException e) System.out.println(操作失败); return arr; /更新时添加 public void add2(int Id,String Name,int Sex,String Dapartment,int Salary) connection(); String Sex2 = n

18、ull; String sql=insert into company values(?,?,?,?,?); try ps1 = DriverManager.getConnection(url, user, password).prepareStatement(sql); /定义一个？号的内容 ps1.setInt(1, Id); ps1.setString(2,Name); /插入第一个？号 ps1.setInt(3,Sex); ps1.setString(4,Dapartment); ps1.setInt(5, Salary); if(String.valueOf(Sex).equals(

19、1) Sex2=男; else if(String.valueOf(Sex).equals(0) Sex2=女; ps1.execute();/ 执行 System.out.println(Id+ + Name+ +Sex2+ +Dapartment+ +Salary+添加成功); catch (SQLException e) System.out.println(已经有Id： +Id+ 该条+Id+ + Name+ +Sex2+ +Dapartment+ +Salary+ 数据添加失败); /e.printStackTrace(); public Statement getSte1() re

20、turn ste1; public ResultSet getRt1() return rt1; Lisnter包package com.lisnter;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JComboBox;import javax.swing.JOptionPane;import javax.swing.JTextField;import com.jdbc.Jdbc;import com.swing.Model;import com.swing.M

21、odel2;/* * author 一木 * 欢迎来访穹庐网 * AddListening类主要用于添加表格数据的类，实现表格和数据库交互，与数据库同步 * */public class AddListening implements ActionListener Model2 M2; Model M1; public AddListening (Model2 M2) this.M2=M2; public AddListening (Model M1,Model2 M2) this.M1=M1; this.M2=M2; int Id; String Name; int Sex; String

22、Dapartment; int Salary; Override public void actionPerformed(ActionEvent e) String str=e.getActionCommand(); if(str.equals(确定) /拿到各个器件 JTextField f1 = M2.getField1(); JTextField f2 = M2.getField2(); JComboBox c3 = M2.getCbox3(); JComboBox c4 = M2.getCbox4(); JTextField f5 = M2.getField5(); /得到文本的值 S

23、tring r11=f1.getText(); String r22=f2.getText(); String r33 =(String) c3.getSelectedItem(); String r44 = (String) c4.getSelectedItem(); String r55 =f5.getText(); /提示输入有误 boolean flag=true; String regex=d+;/数字字符串 boolean flag1=r11.matches(regex);/匹配数字 boolean flag2=r55.matches(regex);/匹配数字 if(r11.equ

24、als() flag=false; JOptionPane.showMessageDialog(null, 编号输入不能有空, 消息框, 0); else if(!flag1) flag=false; JOptionPane.showMessageDialog(null, 编号输入必须全为数字, 消息框, 0); else if(r22.equals() flag=false; JOptionPane.showMessageDialog(null, 姓名输入不能有空, 消息框, 0); else if(r55.equals() flag=false; JOptionPane.showMessa

25、geDialog(null, 工资输入不能有空, 消息框, 0); else if(!flag2) flag=false; JOptionPane.showMessageDialog(null, 工资输入必须全为数字, 消息框, 0); else /写入数据库中 Id=Integer.valueOf(f1.getText(); Name=f2.getText(); Sex=c3.getSelectedIndex(); Dapartment=(String) c4.getSelectedItem(); Salary=Integer.valueOf(f5.getText(); Jdbc j = n

26、ew Jdbc(); j.add(Id,Name,Sex,Dapartment,Salary);/jdbc中的添加方法 flag=j.flag; if(flag) String s1=r11,r22,r33,r44,r55; M1.getModel().addRow(s1); M2.getFrame().setVisible(false);/关闭 if(str.equals(取消) M2.getFrame().setVisible(false); package com.lisnter;import java.awt.event.ActionEvent;import java.awt.even

27、t.ActionListener;import java.io.File;import java.sql.ResultSet;import java.sql.SQLException;import javax.swing.JComboBox;import javax.swing.JFileChooser;import javax.swing.JOptionPane;import javax.swing.JTextField;import javax.swing.table.DefaultTableModel;import javax.xml.parsers.ParserConfigurationException;import javax.xml.transform.TransformerException;import com.Xml.Dom;import com.jdbc.Jdbc;import com.swing.Model;import com.swing.Model2;import com.swing.SelectModle;/* * author 一木 * 欢迎来访穹庐网 * 主界面监听类用于主界面各