简单的JAVA员工信息管理系统源码

蕾蕾

// 项目目标：建立员工管理系统第一个版本。
// 实现图形用户界面的员工信息查询、增、删、改；与数据库建立，并将修改结果时时保存到数据库。
5 J# B9 W: g( O& ]+ J7 ]7 I// 模块：1.GUI界面 2.数据库连接 3.查询 4.增、5删 6改(操作数据库）

import java.sql.*;
0 q2 P  P: V6 P: X4 |) rimport java.awt.*;
1 S) t0 J. m  t9 a7 K* Simport java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
0 ]$ ]0 ^: }) MConnection con;
6 s- m, y2 E; A2 nStatement stmt;
6 k. N& w3 U+ u- S: R5 KString sql;
ResultSet rs;
StringBuffer sb = new StringBuffer();

JTextField jtf2 = new JTextField("张飞",10);

JTextField jtf3 = new JTextField(10);

JTextField jtf4 = new JTextField(10);

JTextField jtf7 = new JTextField(10);

JTextField jtf5 = new JTextField(10);

JTextField jtf6 = new JTextField(10);

JTextField jtf8 = new JTextField(10);

JTextField jtf9 = new JTextField(10);

JTextArea jta10 = new JTextArea(50, 40);

public void actionPerformed(ActionEvent e) {
String str = e.getActionCommand();
" R- g6 d* \: g: b( Sif ("查询".equals(str)) {

//if check the button of 查询，then go to method of searchEmp()
9 E2 y/ g" `5 L' B2 @6 X/ M& {# _# o7 BsearchEmp();
} else if ("增加".equals(str)) {

//if check the button of 增加，then go to method of addEmp()
/ U7 V- e: X: q" R! ^addEmp();
} else if ("修改".equals(str)) {

//if check the button of 修改，then go to method of alterEmp()
  d5 o' U# Q. N4 _! e, X. qalterEmp();
} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
* P4 Y/ G+ x9 _+ p8 ]deleteEmp();
0 M0 x+ ?5 y$ n/ [* U0 P! T& n}
0 z4 c. }- K8 M: o3 L}

//this is the constructor.

EmpManageSys() {
! I' `* r! u1 H8 F  {createGUI();
, S% \$ @$ o8 ]* T* }' G8 V+ b4 {connectToDataBase();
: [6 b$ v/ Z4 R& I0 q' j. s// searchEmp();
// addEmp();
// deleteEmp();
& ^) s9 ~0 p$ d: yalterEmp();
}

//connect to the database by using the method getConnection from the class of JdbcUtil.

//You can find the class of JdbcUtil at the button of this page.

public Connection connectToDataBase() {
con = JdbcUtil.getConnection();
. H' b6 {  z" h! lSystem.out.println(con);
return con;

}

public void searchEmp() {
jta10.setText("");
try {
9 W+ i6 r) A) D7 C+ ostmt = con.createStatement();
// sql = "select * from Mstar where id=" + jtf3.getText();
, u( ^- b9 K' U! U1 x// sql1="select * from sd100343 where ="+jtf3.getText();
sql = "select * from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
" F  p, u8 W$ E- w+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
6 q- M+ g0 c* }! s) s5 l1 q9 t5 K* r) V  d+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
$ ]5 ?/ F  `, R" t( U+ jtf8.getText().toLowerCase().trim() + "or busStation="
* h& [# `0 T) a7 j. b2 n& K' H+ jtf9.getText().toLowerCase().trim();
* E, J& g; \* `2 z$ d8 _  {stmt.executeQuery(sql);
rs = stmt.getResultSet();
0 o8 z' f, ~2 T4 AResultSetMetaData meta = rs.getMetaData();
* ?& x( q% G1 u" L. j) T7 uint cols = meta.getColumnCount();
2 @. F* i& o5 Y: V7 ?. cwhile (rs.next()) {
for (int i = 1; i <= cols; i++) {
sb.append(" " + meta.getColumnName(i) + " =");
% Z% c; v0 W7 S8 A- r7 Msb.append(rs.getString(i));
4 B% t, A* z1 M) I' c7 a}
% P- e5 }% W/ `8 J( r: Esb.append("\n");
jta10.setText(sb.toString());
1 x9 c! L. Y  r" I: `' Z}
! |6 @  [4 N. p& ]} catch (SQLException e11) {
e11.printStackTrace();
$ |% d$ |# ~* E- j  b" ^}

}

public void addEmp() {
try {
  q6 S; l' F4 T% d+ k0 Fstmt = con.createStatement();
% X! \- h$ b% I" j& vsql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
+ jtf4.getText() + jtf5.getText() + jtf6.getText()
+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
4 s5 a% x# J# ?int i = stmt.getUpdateCount();
if ((jtf2.getText() != null) && (jtf4.getText() != null)
. Q, A: l; ^5 q&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
stmt.executeUpdate(sql);
jta10.setText("添加记录成功" + i + "条");
} else {
, R& T( D+ P; gjta10.setText("带*号项为添加记录时不能为空");
}
} catch (SQLException e1) {
" {$ a6 ~$ A$ y# {e1.printStackTrace();
+ C0 E& V# J2 d. u+ h}
* e& `: Z5 T: N+ l}

public void deleteEmp() {
9 F! ]/ W- v1 r1 usearchEmp();
try {
+ m+ o2 f; [0 A5 N: W% ~" C! Fstmt = con.createStatement();
* M& z) A' b1 r+ gsql = "delete from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
0 E. e- }/ t6 @( [. f+ b6 J6 M+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
/ a5 r: Y9 Q! N+ jtf8.getText().toLowerCase().trim() + "or busStation="
  A! V. R! L! w- w+ jtf9.getText().toLowerCase().trim();
stmt.executeUpdate(sql);
% ?2 J  A3 {0 X5 `4 W1 L, yint i = stmt.getUpdateCount();
# U  ]) H1 Z# |' ?9 n) J6 n7 Wjta10.setText("撤除操作成功" + i + "条");
5 s2 t2 s0 K& n6 i) ]: i+ b} catch (SQLException e) {
# {1 r  @% x7 V7 i5 ?* H- ~2 e$ \e.printStackTrace();
! N1 B" S, o  a$ p, r}

}

public void alterEmp() {
searchEmp();
sql = "update Mstar set chineseName="
1 J+ R" e$ s& u8 h' Y6 w( x. {& u+ jtf2.getText().toLowerCase().trim() + "and id="
+ jtf3.getText().toLowerCase().trim() + "and engName="
+ jtf4.getText().toLowerCase().trim() + "and UNIT="
+ jtf5.getText().toLowerCase().trim() + "and TEAM="
- q/ F7 @0 X. v0 P0 B+ jtf6.getText().toLowerCase().trim() + "and Phone="
, T# w) ~% W3 m4 y+ jtf7.getText().toLowerCase().trim() + "and region="
- f$ T- V0 J2 e, v, k9 ^+ jtf8.getText().toLowerCase().trim() + "and busStation="
$ o2 u5 V+ O( I% g6 E+ jtf9.getText().toLowerCase().trim();

int i = 0;
7 x: X1 r* Q4 _6 wtry {
% X. g9 V7 f* ?! |4 Y8 f4 H6 P& \stmt.executeUpdate(sql);
i = stmt.getUpdateCount();
' Y- \9 {) U# L} catch (SQLException e) {
e.printStackTrace();
$ s3 f: B6 |8 p4 e}
# L6 w. `6 x0 p- y6 ~jta10.setText("修改操作成功" + i + "条");
}

public void createGUI() {
  ~( Q" o0 G4 h! f8 L# ]9 ]JFrame jf = new JFrame("员工信息管理系统");
jf.setLayout(new GridLayout(2, 1));
. F+ q) o5 X8 q7 B) A// jf.setLayout(new GridLayout(10,2));
JPanel jp00 = new JPanel(new GridLayout(5, 4));

JPanel jp1 = new JPanel();
6 T' b6 X) S. v( V# A9 J% j5 Y% o% ZJButton jb11 = new JButton("查询");
! Q3 V( g" D) l1 h* b9 y* N/ k% F# Ijb11.addActionListener(this);
JButton jb12 = new JButton("增加");
jb12.addActionListener(this);
jp1.add(jb11);
jp1.add(jb12);
" x* |! [$ r8 [' @( Kjp00.add(jp1);
JPanel jp11 = new JPanel();
$ j  u. k* b2 g2 M- j9 s7 \JButton jb111 = new JButton("修改");
$ D0 }7 C( @! Z5 ?: C/ e2 Kjb111.addActionListener(this);
JButton jb112 = new JButton("撤除");
$ a8 S- }' j) O+ Bjb112.addActionListener(this);
jp11.add(jb111);
: ~# r7 q: H% Ujp11.add(jb112);
jp00.add(jp11);
* U0 L6 D, ~/ y# M& @& v& {JPanel jp2 = new JPanel();
& z4 f/ q/ C+ t0 sJLabel jl2 = new JLabel("中 文 名 * ");
+ E  D  E# s2 r/ }' V, q2 kjp2.add(jl2);
jp2.add(jtf2);
  b$ T) d) {2 h' Q9 T, v( N8 T. z& Cjp00.add(jp2);
JPanel jp3 = new JPanel();
+ H5 y% Q' N. gJLabel jl3 = new JLabel("工 号 ");
jp3.add(jl3);
jp3.add(jtf3);
jp00.add(jp3);
+ F/ z- f; ^2 i& x; eJPanel jp4 = new JPanel();
JLabel jl4 = new JLabel("EngName*");
jp4.add(jl4);
jp4.add(jtf4);
jp00.add(jp4);
) y% U: {: G/ F% GJPanel jp5 = new JPanel();
JLabel jl5 = new JLabel("UNIT ");
9 K7 j/ F4 N+ s. g2 e9 Ljp5.add(jl5);
jp5.add(jtf5);
jp00.add(jp5);
2 j, }1 [3 Q" VJPanel jp6 = new JPanel();
1 k& O7 L% k- |" c- EJLabel jl6 = new JLabel("TEAM* ");
jp6.add(jl6);
6 I% v' g% S6 p' [4 @4 [9 q* [0 t; Xjp6.add(jtf6);
" ]/ r9 W4 l4 i* x: _jp00.add(jp6);
JPanel jp7 = new JPanel();
JLabel jl7 = new JLabel("Phone* ");
$ O4 @4 A  w+ L5 d. ~- u. v5 I! {jp7.add(jl7);
3 v, M  {5 s1 p  }jp7.add(jtf7);
3 K! p# P: O( @jp00.add(jp7);
JPanel jp8 = new JPanel();
JLabel jl8 = new JLabel("区域 ");
jp8.add(jl8);
jp8.add(jtf8);
jp00.add(jp8);
JPanel jp9 = new JPanel();
JLabel jl9 = new JLabel("公交站 ");
jp9.add(jl9);
jp9.add(jtf9);
; K7 ]8 j- K# }1 e0 Djp00.add(jp9);
0 f! {+ _5 I0 G( D3 \jf.add(jp00);
JPanel jp01 = new JPanel();
3 f; I' d# ]( q4 ~; t2 ijta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
) P4 |( s7 m& l. Q9 \! E# j$ [jp01.add(jta10);
3 f. g& e% E; m5 f+ i4 Njf.add(jp01);
jf.setSize(700, 500);
7 z5 X( S& e* A9 N0 _  \jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
9 F' W+ b% x3 ^jf.setVisible(true);

}

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

' M+ T- m0 j, c" N  Q

蕾蕾

//---------------------------------------------------------------------
$ t" |1 Q) b  S6 \8 ~, a7 @0 a; o; nSQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
$ X8 O% M9 L1 j) uimport java.sql.*;
public class JdbcUtil
! W/ t8 t6 `2 P  t( j7 B* k+ T& [" |{
& O: {# ?7 l, o+ u) m//load driver from file
static{
try{
String driverName =
"oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
6 s. Z4 K" j: H, o; [# G6 Z; w}catch(Exception e){
& e1 ~1 d# [/ Te.printStackTrace();
}
) s1 }# Y, w) ]( z% L( S}
//establish connection
2 e, f2 t+ c( V, e2 npublic static Connection getConnection(){
Connection con = null;
try{
) Z7 c" y7 m& j: a/ h+ x) DString url =
5 Q& ?. b4 X5 {0 S"jdbcracle:thin192.168.0.26:1521:tarena";
String usr = "openlab";
5 s" m5 @' r3 c% l8 L, L! zString pwd = "open123";
  s5 s! |6 \' o0 s; M' t' o. ?' ^con = DriverManager.getConnection(
% k9 R7 S* u  o" z. Q3 Surl,usr,pwd);
}catch(Exception e){
; @2 X! A3 Z" x+ a7 X+ Ve.printStackTrace();
}
* v; b! y5 B% ^. D( V3 Ireturn con;
}
; m; ~, w4 b* \: d/ s9 N6 C
. C. J' t. J- H! {7 r//close resultSet,statement and connection
6 V% x! Q2 s' rpublic static void close(ResultSet rs,Statement stmt,Connection con){
try{
) M+ F* w2 i3 M1 W0 u% M6 Jif(rs!=null) rs.close();
}catch(Exception ex){
( {% o; H8 M0 B4 I$ n# |7 {: Yex.printStackTrace();
}
try{
5 p8 b% G5 J* ]: O2 ~% Bif(stmt!=null) stmt.close();
}catch(Exception ex){
ex.printStackTrace();
}
! Q- V, h5 y9 Ptry{
3 G$ C. d6 b6 T$ Rif(con!=null) con.close();
}catch(Exception ex){
6 |- @7 X- C/ ^, f% Oex.printStackTrace();
}
; [9 e5 c1 z: H! L}
}