人事管理系统.docx
《人事管理系统.docx》由会员分享,可在线阅读,更多相关《人事管理系统.docx(63页珍藏版)》请在冰豆网上搜索。
人事管理系统
人事管理系统
只要将这些放在eclips中就可以了,还要加一个mysql架包,自己应该知道。
Jdbc包
packagecom.jdbc;
importjava.sql.DriverManager;
importjava.sql.PreparedStatement;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importjava.util.ArrayList;
importjavax.swing.JOptionPane;
importcom.person.Person;
/*
*@author一木
*欢迎来访穹庐网
*Jdbc类——主要用于增删改查,和数据库交互,使用SQL语句实现数据库的操作
*
*/
publicclassJdbc{
Statementste1;
ResultSetrt1;
ResultSetrt2;
PreparedStatementps1;
PreparedStatementps2;
PreparedStatementps3;
PreparedStatementps4;
Stringurl="jdbc:
mysql:
//localhost:
3306/manage";//数据库地址
Stringuser="root";//用户
Stringpassword="123";//密码
publicbooleanflag=true;
//1加载驱动
publicvoidconnection(){
try{
Class.forName("com.mysql.jdbc.Driver");//加载驱动,驱动程序类自身的一个static代码块自动生成驱动程序的实例
//System.out.println("加载成功");
}catch(ClassNotFoundExceptione1){
System.out.println("加载失败");
}
try{//获得连接
DriverManager.getConnection(url,user,password);//connection类型连接数据库
//System.out.println("连接成功");
}catch(SQLExceptione111){
System.out.println("连接失败");
}
}
//2查询全部并导入数据
publicvoidlead(){
connection();
Stringsql="select*fromcompany";
try{
ste1=DriverManager.getConnection(url,user,password).createStatement();//connection类下的Statement对象执行SQL
rt1=ste1.executeQuery(sql);//ResultSet结果集合
}catch(SQLExceptione1){
e1.printStackTrace();
}
}
//3并添加数据
publicvoidadd(intId,StringName,intSex,StringDapartment,intSalary){
connection();
Stringsql="insertintocompanyvalues(?
?
?
?
?
)";
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);
ps1.execute();//执行
System.out.println("添加成功");
}catch(SQLExceptione){
flag=false;
JOptionPane.showMessageDialog(null,"已经有此编号了","消息框",0);
}
}
//4删除数据
publicbooleandelete(intId){
connection();
Stringsql="deletefromcompanywhereId=?
";
try{
ps2=DriverManager.getConnection(url,user,password).prepareStatement(sql);
ps2.setInt(1,Id);
ps2.execute();
System.out.println("删除成功");
}catch(SQLExceptione){
System.out.println("操作失败");
returnfalse;
}
returntrue;
}
//5修改数据
publicBooleanupdate(intId,StringName,intSex,StringDapartment,intSalary){
connection();
Stringsql="updatecompanysetName=?
Sex=?
Dapartment=?
Salary=?
whereId=?
";//问号不能有有引号
try{
ps3=DriverManager.getConnection(url,user,password).prepareStatement(sql);
ps3.setString(1,Name);
ps3.setInt(2,Sex);
ps3.setString(3,Dapartment);
ps3.setInt(4,Salary);
ps3.setInt(5,Id);
ps3.execute();
System.out.println("修改成功");
}catch(SQLExceptione){
System.out.println("操作失败");
returnfalse;
}
returntrue;
}
//按各个查询
//按Id查询
publicArrayListselectId(intId){//
connection();
ArrayListarr=newArrayList();
System.out.println(Id);
Stringsql="select*fromcompanywhereId=?
";
try{
ps4=DriverManager.getConnection(url,user,password).prepareStatement(sql);
ps4.setInt(1,Id);
ps4.execute();
rt2=ps4.executeQuery();
while(rt2.next()){
arr.add(newPerson(rt2.getInt
(1),rt2.getString
(2),rt2.getInt(3),rt2.getString(4),rt2.getInt(5)));
}
System.out.println("查询成功");
}catch(SQLExceptione){
System.out.println("操作失败");
}
returnarr;
}
//按Name查询
publicArrayListselectName(StringName){
connection();
ArrayListarr=newArrayList();
Stringsql="select*fromcompanywhereNamelike?
";
try{
ps4=DriverManager.getConnection(url,user,password).prepareStatement(sql);
ps4.setString(1,"%"+Name+"%");
ps4.execute();
rt2=ps4.executeQuery();
while(rt2.next()){
arr.add(newPerson(rt2.getInt
(1),rt2.getString
(2),rt2.getInt(3),rt2.getString(4),rt2.getInt(5)));
}
System.out.println("查询成功");
}catch(SQLExceptione){
System.out.println("操作失败");
}
returnarr;
}
//按Sex查询
publicArrayListselectSex(intSex){
connection();
ArrayListarr=newArrayList();
Stringsql="select*fromcompanywhereSex=?
";
try{
ps4=DriverManager.getConnection(url,user,password).prepareStatement(sql);
ps4.setInt(1,Sex);
ps4.execute();
rt2=ps4.executeQuery();
while(rt2.next()){
arr.add(newPerson(rt2.getInt
(1),rt2.getString
(2),rt2.getInt(3),rt2.getString(4),rt2.getInt(5)));
}
}catch(SQLExceptione){
System.out.println("操作失败");
}
returnarr;
}
//按Dapartment查询
publicArrayListselectDapartment(StringDapartment){
connection();
ArrayListarr=newArrayList();
Stringsql="select*fromcompanywhereDapartment=?
";
try{
ps4=DriverManager.getConnection(url,user,password).prepareStatement(sql);
ps4.setString(1,Dapartment);
ps4.execute();
rt2=ps4.executeQuery();
while(rt2.next()){
arr.add(newPerson(rt2.getInt
(1),rt2.getString
(2),rt2.getInt(3),rt2.getString(4),rt2.getInt(5)));
}
}catch(SQLExceptione){
System.out.println("操作失败");
}
returnarr;
}
//按Salary查询
publicArrayListselectSalary(intSalary){
connection();
ArrayListarr=newArrayList();
Stringsql="select*fromcompanywhereSalary=?
";
try{
ps4=DriverManager.getConnection(url,user,password).prepareStatement(sql);
ps4.setInt(1,Salary);
ps4.execute();
rt2=ps4.executeQuery();
while(rt2.next()){
arr.add(newPerson(rt2.getInt
(1),rt2.getString
(2),rt2.getInt(3),rt2.getString(4),rt2.getInt(5)));
}
}catch(SQLExceptione){
System.out.println("操作失败");
}
returnarr;
}
//更新时添加
publicvoidadd2(intId,StringName,intSex,StringDapartment,intSalary){
connection();
StringSex2=null;
Stringsql="insertintocompanyvalues(?
?
?
?
?
)";
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("1")){
Sex2="男";
}elseif(String.valueOf(Sex).equals("0")){
Sex2="女";}
ps1.execute();//执行
System.out.println(Id+""+Name+""+Sex2+""+Dapartment+""+Salary+"添加成功");
}catch(SQLExceptione){
System.out.println("已经有Id:
"+Id+"该条"+Id+""+Name+""+Sex2+""+Dapartment+""+Salary+"数据添加失败");
//e.printStackTrace();
}
}
publicStatementgetSte1(){
returnste1;
}
publicResultSetgetRt1(){
returnrt1;
}
}
Lisnter包
packagecom.lisnter;
importjava.awt.event.ActionEvent;
importjava.awt.event.ActionListener;
importjavax.swing.JComboBox;
importjavax.swing.JOptionPane;
importjavax.swing.JTextField;
importcom.jdbc.Jdbc;
importcom.swing.Model;
importcom.swing.Model2;
/*
*@author一木
*欢迎来访穹庐网
*AddListening类——主要用于添加表格数据的类,实现表格和数据库交互,与数据库同步
*
*/
publicclassAddListeningimplementsActionListener{
Model2M2;
ModelM1;
publicAddListening(Model2M2){
this.M2=M2;
}
publicAddListening(ModelM1,Model2M2){
this.M1=M1;
this.M2=M2;
}
intId;
StringName;
intSex;
StringDapartment;
intSalary;
@Override
publicvoidactionPerformed(ActionEvente){
Stringstr=e.getActionCommand();
if(str.equals("确定")){
//拿到各个器件
JTextFieldf1=M2.getField1();
JTextFieldf2=M2.getField2();
JComboBoxc3=M2.getCbox3();
JComboBoxc4=M2.getCbox4();
JTextFieldf5=M2.getField5();
//得到文本的值
Stringr11=f1.getText();
Stringr22=f2.getText();
Stringr33=(String)c3.getSelectedItem();
Stringr44=(String)c4.getSelectedItem();
Stringr55=f5.getText();
//提示输入有误
booleanflag=true;
Stringregex="\\d+";//数字字符串
booleanflag1=r11.matches(regex);//匹配数字
booleanflag2=r55.matches(regex);//匹配数字
if(r11.equals("")){
flag=false;
JOptionPane.showMessageDialog(null,"编号输入不能有空","消息框",0);
}elseif(!
flag1){
flag=false;
JOptionPane.showMessageDialog(null,"编号输入必须全为数字","消息框",0);
}elseif(r22.equals("")){
flag=false;
JOptionPane.showMessageDialog(null,"姓名输入不能有空","消息框",0);
}elseif(r55.equals("")){
flag=false;
JOptionPane.showMessageDialog(null,"工资输入不能有空","消息框",0);
}elseif(!
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());
Jdbcj=newJdbc();
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);
}
}
}
packagecom.lisnter;
importjava.awt.event.ActionEvent;
importjava.awt.event.ActionListener;
importjava.io.File;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjavax.swing.JComboBox;
importjavax.swing.JFileChooser;
importjavax.swing.JOptionPane;
importjavax.swing.JTextField;
importjavax.swing.table.DefaultTableModel;
importjavax.xml.parsers.ParserConfigurationException;
importjavax.xml.transform.TransformerException;
importcom.Xml.Dom;
importcom.jdbc.Jdbc;
importcom.swing.Model;
importcom.swing.Model2;
importcom.swing.SelectModle;
/*
*@author一木
*欢迎来访穹庐网
*主界面监听类——用于主界面各