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

蕾蕾

// 项目目标：建立员工管理系统第一个版本。
// 实现图形用户界面的员工信息查询、增、删、改；与数据库建立，并将修改结果时时保存到数据库。
! }' c# H$ t% L; S9 ]// 模块：1.GUI界面 2.数据库连接 3.查询 4.增、5删 6改(操作数据库）

import java.sql.*;
- P0 Z% E- I! v) simport java.awt.*;
: T# \8 S1 s3 j0 m. E: l, yimport java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
  N% m0 W6 j: N: bConnection con;
Statement stmt;
1 [& A& e( z: P( ~+ S- e6 q9 u% dString sql;
1 R" g8 M8 k% O+ G6 fResultSet 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();
if ("查询".equals(str)) {

//if check the button of 查询，then go to method of searchEmp()
' E/ @" t  A5 }0 L' ?5 M1 b. xsearchEmp();
} else if ("增加".equals(str)) {

//if check the button of 增加，then go to method of addEmp()
addEmp();
  ^4 m2 l; [1 v9 L" u7 R} else if ("修改".equals(str)) {

//if check the button of 修改，then go to method of alterEmp()
alterEmp();
} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
/ R7 V1 }9 `) |deleteEmp();
2 n& N5 m& q! J3 t}
}

//this is the constructor.

EmpManageSys() {
: H- }# R/ w' t# `$ D) F! QcreateGUI();
connectToDataBase();
// searchEmp();
: r6 m/ ]4 O6 k% F# y// addEmp();
1 b5 B% r5 V/ {% G! ?+ G. a// deleteEmp();
alterEmp();
# N, O8 z4 y. `+ t$ v}

//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() {
; i: N+ K  B  }+ o/ W& Jcon = JdbcUtil.getConnection();
& S5 i5 q. o/ i0 }" k- \System.out.println(con);
return con;

}

public void searchEmp() {
' s/ M* ?8 Q+ b- r# \- Vjta10.setText("");
try {
stmt = con.createStatement();
// sql = "select * from Mstar where id=" + jtf3.getText();
// sql1="select * from sd100343 where ="+jtf3.getText();
5 ~5 G" d' k) @7 W( Bsql = "select * from Mstar where chineseName="
) K0 r6 R' a# O! f" t: \, Z+ jtf2.getText().toLowerCase().trim() + "or id="
1 [" X( c- Q- Q: B# k/ ]) h+ jtf3.getText().toLowerCase().trim() + "or engName="
" j4 `: ~5 D* o) T, j+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
4 O3 ~- b6 W3 u3 [+ jtf8.getText().toLowerCase().trim() + "or busStation="
- f1 v7 n3 a6 d* Q+ jtf9.getText().toLowerCase().trim();
& i7 T. J* A' Z8 r- N3 _stmt.executeQuery(sql);
+ D$ M$ T2 w- {6 y" h: C; W8 L9 drs = stmt.getResultSet();
( I) X* V* g4 ?8 DResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
0 S9 t( l8 B7 f; j; k0 r: Iwhile (rs.next()) {
# H; k& p( U5 efor (int i = 1; i <= cols; i++) {
9 f% i$ S0 [9 U1 @& `sb.append(" " + meta.getColumnName(i) + " =");
sb.append(rs.getString(i));
}
# g( e. o' T. a% S0 C& ^sb.append("\n");
. i) b, r# ]3 u0 R2 [% w, Bjta10.setText(sb.toString());
% e; X( r2 s) `; P8 r/ k( x1 ~}
} catch (SQLException e11) {
# h' p+ i" `% J. Se11.printStackTrace();
. i* x. r+ S, k# z$ A}

}

public void addEmp() {
, |& T) W0 P" rtry {
stmt = con.createStatement();
sql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
' L5 T" m1 p( _- y- I$ c8 A+ jtf4.getText() + jtf5.getText() + jtf6.getText()
7 u1 {# S% T. ?6 n6 f9 M& q* G+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
int i = stmt.getUpdateCount();
if ((jtf2.getText() != null) && (jtf4.getText() != null)
&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
; c6 H8 p$ Q3 f7 ~! z2 {8 Fstmt.executeUpdate(sql);
jta10.setText("添加记录成功" + i + "条");
} else {
jta10.setText("带*号项为添加记录时不能为空");
}
3 k) i0 x; N% c$ K$ e/ l0 e  L} catch (SQLException e1) {
  q8 g9 s( V$ D3 o# F4 ]0 ce1.printStackTrace();
1 [  x4 t. l7 k- P( G}
}

public void deleteEmp() {
0 n3 b2 W& F+ K' {; xsearchEmp();
- Z( n+ Q+ i4 J/ S: Rtry {
stmt = con.createStatement();
sql = "delete from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
0 v& K. H9 ^( N# i* B5 j: k4 t+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
+ j* }* N3 m: U  n7 u9 M- D& _+ jtf8.getText().toLowerCase().trim() + "or busStation="
+ jtf9.getText().toLowerCase().trim();
& g6 K( W, P% C6 F3 rstmt.executeUpdate(sql);
' j! ~/ y7 v2 Z0 S: q. Fint i = stmt.getUpdateCount();
jta10.setText("撤除操作成功" + i + "条");
} catch (SQLException e) {
e.printStackTrace();
}

}

public void alterEmp() {
searchEmp();
sql = "update Mstar set chineseName="
+ jtf2.getText().toLowerCase().trim() + "and id="
$ `# Z, z/ c4 y0 m0 [+ jtf3.getText().toLowerCase().trim() + "and engName="
+ jtf4.getText().toLowerCase().trim() + "and UNIT="
+ jtf5.getText().toLowerCase().trim() + "and TEAM="
+ jtf6.getText().toLowerCase().trim() + "and Phone="
9 D( B/ E. `  y: m% i+ jtf7.getText().toLowerCase().trim() + "and region="
' O" K9 x, g3 N$ B& J+ jtf8.getText().toLowerCase().trim() + "and busStation="
8 z+ Y% P8 Z0 ]5 e' [9 G" X  P+ jtf9.getText().toLowerCase().trim();

int i = 0;
' O/ X4 ^' d& u( Ktry {
0 o! @2 Z7 @7 w0 p- H. }' z7 ]6 Nstmt.executeUpdate(sql);
i = stmt.getUpdateCount();
} catch (SQLException e) {
e.printStackTrace();
}
jta10.setText("修改操作成功" + i + "条");
}

public void createGUI() {
JFrame jf = new JFrame("员工信息管理系统");
4 C+ e9 c* f9 Xjf.setLayout(new GridLayout(2, 1));
// jf.setLayout(new GridLayout(10,2));
9 c+ w7 ~$ ~/ s# S1 P0 w! t5 F* ZJPanel jp00 = new JPanel(new GridLayout(5, 4));

JPanel jp1 = new JPanel();
$ g$ J8 O' Z4 M! `3 pJButton jb11 = new JButton("查询");
jb11.addActionListener(this);
JButton jb12 = new JButton("增加");
& n7 ?' p9 b0 F9 ?9 n1 I. a5 R% |jb12.addActionListener(this);
/ B6 y( m, m0 y. _2 Djp1.add(jb11);
7 e1 @' L5 b+ {% W& K- yjp1.add(jb12);
jp00.add(jp1);
# K; N% R" l. I- @JPanel jp11 = new JPanel();
JButton jb111 = new JButton("修改");
jb111.addActionListener(this);
! e" r' N4 _! q0 YJButton jb112 = new JButton("撤除");
' m9 B8 m$ y: v! \$ L, H7 Jjb112.addActionListener(this);
jp11.add(jb111);
7 W; b! Q+ }4 E5 Y$ gjp11.add(jb112);
jp00.add(jp11);
! L; r2 k! C6 o+ l1 \5 jJPanel jp2 = new JPanel();
JLabel jl2 = new JLabel("中 文 名 * ");
- \7 ~  X; K& [2 {, ^  rjp2.add(jl2);
jp2.add(jtf2);
8 i' u  {& ~2 L+ ]' U. A. ^jp00.add(jp2);
- _6 R9 X: `3 vJPanel jp3 = new JPanel();
; Z! m2 [  M" S& v3 A7 l1 N1 QJLabel jl3 = new JLabel("工 号 ");
jp3.add(jl3);
& n/ o9 g9 ^2 f* m3 b& P# ujp3.add(jtf3);
jp00.add(jp3);
JPanel jp4 = new JPanel();
JLabel jl4 = new JLabel("EngName*");
jp4.add(jl4);
" a+ X; X, J: {5 A  F  I3 i/ kjp4.add(jtf4);
jp00.add(jp4);
JPanel jp5 = new JPanel();
+ Z; H5 t* w) y7 zJLabel jl5 = new JLabel("UNIT ");
* X* {- s( J* @2 k: rjp5.add(jl5);
1 m9 [& y& ^0 njp5.add(jtf5);
jp00.add(jp5);
JPanel jp6 = new JPanel();
% o/ V6 O/ H/ d  \JLabel jl6 = new JLabel("TEAM* ");
jp6.add(jl6);
# u- d/ w+ e* a( d0 Yjp6.add(jtf6);
jp00.add(jp6);
4 c  S+ w6 q& f7 V. Z* VJPanel jp7 = new JPanel();
JLabel jl7 = new JLabel("Phone* ");
4 ]& v# P, C( o* _* ijp7.add(jl7);
* q+ a" x! f. k2 M: v0 bjp7.add(jtf7);
jp00.add(jp7);
JPanel jp8 = new JPanel();
: d4 p( q/ q9 h+ n6 \' j& ]/ PJLabel jl8 = new JLabel("区域 ");
) S4 @" f1 x6 f0 {# h/ }jp8.add(jl8);
! ~* G8 F) ?& @+ _3 ]jp8.add(jtf8);
jp00.add(jp8);
# i" x% J; U: {7 t8 L& g. P% D. [8 bJPanel jp9 = new JPanel();
3 |! n! d, X; u( v1 iJLabel jl9 = new JLabel("公交站 ");
0 [4 }# `( s4 I8 J; j" rjp9.add(jl9);
jp9.add(jtf9);
  G( T6 ]. Y+ w/ j5 {, Ijp00.add(jp9);
jf.add(jp00);
JPanel jp01 = new JPanel();
, ?& P- R; E1 \! T7 j% c9 R- Sjta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
jp01.add(jta10);
' q) B2 j- }) |! W3 J9 A/ Gjf.add(jp01);
" x0 h4 C% V( }6 }; A2 F8 {jf.setSize(700, 500);
jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jf.setVisible(true);

}

public static void main(String[] args) {
7 i2 F# [" s: F8 Snew EmpManageSys();
}
+ V, ~6 n6 B8 G) x2 R}

蕾蕾

//---------------------------------------------------------------------
* ]1 c/ d1 U$ G) SSQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
import java.sql.*;
public class JdbcUtil
: V4 N; f, c( J; f7 _5 f{
7 E( D3 @2 u* ]1 Y. _//load driver from file
static{
try{
2 K% f4 z$ }. w2 W  G: q+ v3 fString driverName =
% {  e7 Y- r1 m6 w4 g; m"oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
}catch(Exception e){
e.printStackTrace();
( Z' G+ l5 n4 x# c' V: {! t' ^* f}
}
' o& k& U# T6 Z6 k/ {: p//establish connection
" b. l+ P. n5 O7 g1 [3 V- Z$ K- Jpublic static Connection getConnection(){
Connection con = null;
try{
String url =
"jdbcracle:thin192.168.0.26:1521:tarena";
- b0 k6 U% ]& B. mString usr = "openlab";
String pwd = "open123";
con = DriverManager.getConnection(
url,usr,pwd);
}catch(Exception e){
$ i4 R& |, e8 x( j: |e.printStackTrace();
4 B1 f1 w5 m8 e! x  g6 o}
* t/ V3 \, |: T# _' r! }9 `, Oreturn con;
% A3 @8 |7 \3 }3 K* q* Q# o}
3 D6 z3 [4 X8 y
//close resultSet,statement and connection
public static void close(ResultSet rs,Statement stmt,Connection con){
9 R2 p7 D8 ~, p4 h! q4 Ztry{
6 G1 b- Z# t. yif(rs!=null) rs.close();
, M& i$ V+ \8 M3 D* Q( L1 J}catch(Exception ex){
) F9 K5 B) @+ J( w  {ex.printStackTrace();
' J  s7 R8 @+ z% D; ]! j4 k}
$ y) B7 \6 W# `, s5 _try{
. }, Q# }! U6 `if(stmt!=null) stmt.close();
. G. I2 ^1 a0 \- M, h; q}catch(Exception ex){
) s; ]: S. k- e9 C8 n" Fex.printStackTrace();
}
try{
if(con!=null) con.close();
}catch(Exception ex){
+ t: ^' J9 a1 ]; m0 [% ]- ?ex.printStackTrace();
$ X( N- X% `6 ~2 U: i8 V9 v}
- n- O; e: t, c- F9 ?7 r1 V}
$ M  G( W1 H0 ~* h}