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

蕾蕾

// 项目目标：建立员工管理系统第一个版本。
  u, Q" x' X* `& e! ^! v2 [* \// 实现图形用户界面的员工信息查询、增、删、改；与数据库建立，并将修改结果时时保存到数据库。
# a  p* V9 r5 y1 ^: q// 模块：1.GUI界面 2.数据库连接 3.查询 4.增、5删 6改(操作数据库）

import java.sql.*;
import java.awt.*;
7 X: g8 p# w6 s# m! Cimport java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
Connection con;
+ E$ F) [! @3 G  H- @' b+ eStatement stmt;
. I5 I1 v3 j2 y$ \, s/ cString sql;
+ y1 G) s" h$ ~! E) ^ResultSet rs;
8 T  k/ M3 D# h% c+ l) fStringBuffer 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) {
& C" T* r; M9 B2 |String str = e.getActionCommand();
2 ~3 p; {2 E2 F: P  ^& eif ("查询".equals(str)) {

//if check the button of 查询，then go to method of searchEmp()
8 Z& r, r2 O, w. UsearchEmp();
} else if ("增加".equals(str)) {

//if check the button of 增加，then go to method of addEmp()
addEmp();
0 i. l9 B( E! w6 q$ t} else if ("修改".equals(str)) {

//if check the button of 修改，then go to method of alterEmp()
* [1 g: z; p7 K2 ^0 _& Q& X" LalterEmp();
1 i8 b* ]! J$ _) C6 D# a} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
deleteEmp();
- _) c" G: k# D7 z) ~* L- C}
}

//this is the constructor.

EmpManageSys() {
createGUI();
connectToDataBase();
// searchEmp();
// addEmp();
// deleteEmp();
alterEmp();
0 y' c. U* `/ [: W}

//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() {
. G" I6 O* ]0 d" b: X: Ncon = JdbcUtil.getConnection();
System.out.println(con);
return con;

}

public void searchEmp() {
jta10.setText("");
! c! X! P" j! K% `# J6 p) Mtry {
stmt = con.createStatement();
6 \: H: N3 u! I; A: `1 q// sql = "select * from Mstar where id=" + jtf3.getText();
8 M4 j1 d" ]; d5 c. g// sql1="select * from sd100343 where ="+jtf3.getText();
; ]$ j4 Z2 U, F, M  l! H. tsql = "select * from Mstar where chineseName="
5 k* T* b. P% {- U! T1 C+ jtf2.getText().toLowerCase().trim() + "or id="
* B- s6 ^" o) l2 n; l+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
& N' t% P( N, G5 R# g- e+ jtf5.getText().toLowerCase().trim() + "or TEAM="
. p  ^: {4 q3 Y) [9 M9 |, W+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
3 b1 _- r$ m3 Z+ ^3 W. X4 a4 u+ e+ jtf8.getText().toLowerCase().trim() + "or busStation="
7 J# x' c9 h9 d7 G( ^+ jtf9.getText().toLowerCase().trim();
stmt.executeQuery(sql);
% m7 e5 M: ~# S- A6 N+ J' v1 X' @2 t6 Grs = stmt.getResultSet();
ResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
- u: ]3 D* m' T$ c8 Hwhile (rs.next()) {
for (int i = 1; i <= cols; i++) {
1 L+ z6 l; J5 L/ \! k7 N. Tsb.append(" " + meta.getColumnName(i) + " =");
sb.append(rs.getString(i));
: ~/ C% v5 W' o}
4 c: S( c6 l* l7 e# D2 s+ S- q7 g4 E) Osb.append("\n");
8 h2 l& v5 h# t$ [' q% X- S0 hjta10.setText(sb.toString());
8 Q& w% F( x5 u! m% \* D0 G}
8 X  T) a. F) ~} catch (SQLException e11) {
e11.printStackTrace();
/ ?( q% B: i+ S/ _5 x# {' U+ ]& Q  H}

}

public void addEmp() {
' {( J! a( C# G, _% D/ L4 ctry {
stmt = con.createStatement();
sql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
+ jtf4.getText() + jtf5.getText() + jtf6.getText()
2 d- T( u: r8 d; }" Z- G3 u+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
int i = stmt.getUpdateCount();
0 V1 d1 j) C: B" f) D- u$ m' z: _: z+ Jif ((jtf2.getText() != null) && (jtf4.getText() != null)
&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
stmt.executeUpdate(sql);
jta10.setText("添加记录成功" + i + "条");
3 v& B& o1 {' P( b" m. G3 h( N} else {
- [5 a& g6 G4 G! a, Djta10.setText("带*号项为添加记录时不能为空");
; L, E6 |& }5 F5 _4 a; d" H$ e}
} catch (SQLException e1) {
e1.printStackTrace();
& [# V2 q9 ~; y  y% c! r}
}

public void deleteEmp() {
searchEmp();
) o6 w1 l0 I( r8 X. a9 }) Ctry {
$ o, g2 ^( S) D: G4 sstmt = con.createStatement();
sql = "delete from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
( P% `. B9 m1 J; U6 \' c- b+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
# k% g9 u' H  W. p1 p: ?+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ {6 @" B1 h, l8 @+ k5 [; V7 X+ jtf7.getText().toLowerCase().trim() + "or region="
+ jtf8.getText().toLowerCase().trim() + "or busStation="
; I/ b1 T: a, k1 a0 K+ jtf9.getText().toLowerCase().trim();
0 X" q6 o8 d5 v1 G8 p' T3 h+ N0 Fstmt.executeUpdate(sql);
, {1 x# O8 q$ b8 s- Jint i = stmt.getUpdateCount();
jta10.setText("撤除操作成功" + i + "条");
} catch (SQLException e) {
; L1 p. R4 C+ T2 ^8 B  t2 Xe.printStackTrace();
}

}

public void alterEmp() {
% l: ^, o. g% @- r2 CsearchEmp();
sql = "update Mstar set chineseName="
+ jtf2.getText().toLowerCase().trim() + "and id="
2 {8 Z% u  l, J' l' C6 e4 ?+ jtf3.getText().toLowerCase().trim() + "and engName="
& d. Z. f, ?$ I; r) l- l+ jtf4.getText().toLowerCase().trim() + "and UNIT="
. Y) \& M  \: e/ s* J$ X+ jtf5.getText().toLowerCase().trim() + "and TEAM="
. _; o6 z7 _3 i1 @7 w; g5 A+ jtf6.getText().toLowerCase().trim() + "and Phone="
+ jtf7.getText().toLowerCase().trim() + "and region="
+ jtf8.getText().toLowerCase().trim() + "and busStation="
1 n; M5 }! a% ^; n+ S+ ?" N+ jtf9.getText().toLowerCase().trim();

int i = 0;
- t7 L: \- D) m) A. Q& R$ z: _try {
stmt.executeUpdate(sql);
i = stmt.getUpdateCount();
1 {7 W4 D$ q, }7 f; ?+ ^% H- M} catch (SQLException e) {
e.printStackTrace();
}
9 G: V( ]# t8 i8 G+ ^2 B4 w& Y" qjta10.setText("修改操作成功" + i + "条");
( i& G. n/ d( k* _6 f- N4 j}

public void createGUI() {
) C- U% J3 e5 ^1 }4 ]1 m4 }JFrame jf = new JFrame("员工信息管理系统");
0 ~  u+ O3 P- w* u( e- l' [jf.setLayout(new GridLayout(2, 1));
// jf.setLayout(new GridLayout(10,2));
& C5 S% J/ ?- M/ o* O/ F6 IJPanel jp00 = new JPanel(new GridLayout(5, 4));

JPanel jp1 = new JPanel();
# i, u1 b- n  z0 m) ]7 [JButton jb11 = new JButton("查询");
# `3 B! I( d8 s/ ]" _* H$ K1 gjb11.addActionListener(this);
JButton jb12 = new JButton("增加");
jb12.addActionListener(this);
6 T3 d  ~8 T, P  Z. B5 k+ e* ejp1.add(jb11);
jp1.add(jb12);
jp00.add(jp1);
JPanel jp11 = new JPanel();
6 k' J5 K. x9 O& G8 tJButton jb111 = new JButton("修改");
; C1 q" a8 ]8 O7 s. e$ N' N1 n5 Jjb111.addActionListener(this);
9 O+ U% w3 k6 F- {JButton jb112 = new JButton("撤除");
jb112.addActionListener(this);
% i% p3 [5 W- Vjp11.add(jb111);
# \! _2 A. Q$ X+ A! h1 I* v4 cjp11.add(jb112);
/ k: ?; x. H  |$ ]jp00.add(jp11);
JPanel jp2 = new JPanel();
" e+ s8 _0 ]" e. U. ~JLabel jl2 = new JLabel("中 文 名 * ");
jp2.add(jl2);
$ }% l* a+ G) m# O0 K1 \( \7 Mjp2.add(jtf2);
jp00.add(jp2);
8 d. [1 Y$ i# p  sJPanel jp3 = new JPanel();
& y' B9 k  R, n' ]3 }- ?5 r; T* YJLabel jl3 = new JLabel("工 号 ");
& [" Y- J6 `) c7 W7 W$ ^jp3.add(jl3);
jp3.add(jtf3);
jp00.add(jp3);
JPanel jp4 = new JPanel();
8 [8 y' a% Q0 E  _# ~: GJLabel jl4 = new JLabel("EngName*");
jp4.add(jl4);
) _/ n7 J+ T- i0 _! e+ cjp4.add(jtf4);
( T5 v( r5 Z. p0 @" l: y  O, e- ijp00.add(jp4);
JPanel jp5 = new JPanel();
+ U2 C4 E! I9 bJLabel jl5 = new JLabel("UNIT ");
" N- I2 e( h4 C9 \# e$ \jp5.add(jl5);
) r* f9 k- o/ ~+ {6 J5 F9 Ujp5.add(jtf5);
/ R5 X2 ^( ~& H/ n9 I0 G; wjp00.add(jp5);
JPanel jp6 = new JPanel();
JLabel jl6 = new JLabel("TEAM* ");
jp6.add(jl6);
7 J4 t+ c: ~2 ajp6.add(jtf6);
jp00.add(jp6);
' n$ ]2 a, c  I9 e( X9 O" eJPanel jp7 = new JPanel();
JLabel jl7 = new JLabel("Phone* ");
jp7.add(jl7);
jp7.add(jtf7);
- V" o( A. o) F# f$ L& Hjp00.add(jp7);
JPanel jp8 = new JPanel();
: w( B8 Z" T0 k3 w' CJLabel jl8 = new JLabel("区域 ");
, h! l1 r7 ^) q; Jjp8.add(jl8);
jp8.add(jtf8);
jp00.add(jp8);
. u3 n7 y1 @- o4 _; wJPanel jp9 = new JPanel();
+ F, j) b" C6 T) m" ?, n4 A; q2 f& ?) c# ]JLabel jl9 = new JLabel("公交站 ");
, N9 u) s7 F# X, Tjp9.add(jl9);
jp9.add(jtf9);
jp00.add(jp9);
+ t- ^1 u7 `0 P: s0 xjf.add(jp00);
( b& w6 E- b! e! F' [4 O7 a: S- @JPanel jp01 = new JPanel();
1 c9 i/ Q; |7 j  i7 k$ @5 Zjta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
) Z! w: D4 }0 V( T) cjp01.add(jta10);
7 B) p  S6 E9 x/ H3 Gjf.add(jp01);
jf.setSize(700, 500);
jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jf.setVisible(true);

}

public static void main(String[] args) {
new EmpManageSys();
}
- x- \$ ~$ y. v. H3 A) ?}

- _3 T/ D- S# ?* ]" P. b

蕾蕾

//---------------------------------------------------------------------
9 w: P/ U1 |7 I$ z: A, }SQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
/ o5 ~/ J; s! h: Y, ]& }& \import java.sql.*;
public class JdbcUtil
{
//load driver from file
) c5 L2 j3 z8 ?6 m' v+ n  cstatic{
try{
  h+ |/ V) T5 CString driverName =
"oracle.jdbc.driver.OracleDriver";
3 V' R6 M% j" K# O+ D0 o: q& F* EClass.forName(driverName);
}catch(Exception e){
  o! {! ]) Q0 J: B8 Y( Te.printStackTrace();
}
0 _3 b4 i* |7 K% h}
2 W# q6 c$ F1 `* h! C- y//establish connection
4 w" @. U: t, R& d& @public static Connection getConnection(){
2 L% ^7 @6 T/ V- `( J4 M. k9 _( `3 CConnection con = null;
! `8 j3 S1 h; P  E3 F7 Otry{
String url =
"jdbcracle:thin192.168.0.26:1521:tarena";
) j" j4 l: K! \2 RString usr = "openlab";
String pwd = "open123";
( p8 L5 d3 m" \7 _3 jcon = DriverManager.getConnection(
: ?5 @# F1 _8 durl,usr,pwd);
}catch(Exception e){
e.printStackTrace();
}
return con;
}
) _# R; G( r7 `' R, h7 ?
//close resultSet,statement and connection
public static void close(ResultSet rs,Statement stmt,Connection con){
try{
if(rs!=null) rs.close();
}catch(Exception ex){
ex.printStackTrace();
}
& }" g# R6 n7 v4 F8 ^$ j' ^* B8 l5 |try{
if(stmt!=null) stmt.close();
}catch(Exception ex){
ex.printStackTrace();
2 w+ W+ Y1 l# x# i, }' t/ I" _}
try{
" U6 Y8 J3 j5 p4 d$ ?if(con!=null) con.close();
}catch(Exception ex){
ex.printStackTrace();
}
6 t3 h# ?& S4 W% s6 I7 o' s* x}
}