人事管理信息系统mysql代码_人事管理系统——数据库操作类

最新推荐文章于 2021-04-13 19:41:56 发布

weixin_39876145

最新推荐文章于 2021-04-13 19:41:56 发布

阅读量811

点赞数

文章标签：人事管理信息系统mysql代码

本文链接：https://blog.csdn.net/weixin_39876145/article/details/113253719

版权

PersonBean类用于人事管理系统中数据库操作，包括添加、修改、删除人员信息，并进行错误检查。涉及字段包括PersonID、Name、Sex、Birth、Nat、Address、DeptID、Salary、Assess和其他信息。

摘要由CSDN通过智能技术生成

1 packagePersonSystem;2

3 //import java.util.*;

4 import java.sql.*;5 import javax.swing.*;6 /**

7 *8 * 有关人员信息数据库操作的类9 *10 */

11 public classPersonBean12 {13 String sql;14 ResultSet rs = null;15

16 String field1; //PersonID

17 String field2; //Name

18 String field3; //Sex

19 String field4; //Birth

20 String field5; //Nat

21 String field6; //Address

22 String field7; //DeptID

23 String field8; //Salary

24 String field9; //Assess

25 String field10; //Other

27 String colName; //列名

28 String colValue; //列值

29 String colValue2; //列值

31 /**

32 * 添加信息33 */

34 public voidadd(String f1,String f2,String f3,String f4,String f5,35 String f6,String f7,String f8,String f9,String f10)36 {37 Database DB = newDatabase();38

39 this.field1 =f1;40 this.field2 =f2;41 this.field3 =f3;42 this.field4 =f4;43 this.field5 =f5;44 this.field6 =f6;45 this.field7 =f7;46 this.field8 =f8;47 this.field9 =f9;48 this.field10 =f10;49

50 if(field2 == null||field2.equals("")){51 JOptionPane.showMessageDialog(null, "请输入员工姓名","错误",JOptionPane.ERROR_MESSAGE);52 return;53 }54 else if(field3 == null||field3.equals("")){55 JOptionPane.showMessageDialog(null, "请输入性别","错误",JOptionPane.ERROR_MESSAGE);56 return;57 }58 else if(field4 == null||field4.equals("")){59 JOptionPane.showMessageDialog(null, "请输入出生年月","错误",JOptionPane.ERROR_MESSAGE);60 return;61 }62 else if(field5 == null||field5.equals("")){63 JOptionPane.showMessageDialog(null, "请输入民族","错误",JOptionPane.ERROR_MESSAGE);64 return;65 }66 else if(field6 == null||field6.equals("")){67 JOptionPane.showMessageDialog(null, "请输入地址","错误",JOptionPane.ERROR_MESSAGE);68 return;69 }70 else if(field7 == null||field7.equals("")){71 JOptionPane.showMessageDialog(null, "请输入部门","错误",JOptionPane.ERROR_MESSAGE);72 return;73 }74 else if(field8 == null||field8.equals("")){75 JOptionPane.showMessageDialog(null, "请输入薪酬","错误",JOptionPane.ERROR_MESSAGE);76 return;77 }78 else{79 sql = "insert into Person(PersonID,Name,Sex,Birth,Nat,Address,DeptID,Salary,Assess,Other)"

80 +"values('"+field1+"','"+field2+"','"+field3+"','"+field4+"','"+field5+"',"

81 + "'"+field6+"','"+field7+"','"+fiel