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

蕾蕾

// 项目目标：建立员工管理系统第一个版本。
0 G1 i6 s, f$ k. r' a: o* ?// 实现图形用户界面的员工信息查询、增、删、改；与数据库建立，并将修改结果时时保存到数据库。
// 模块：1.GUI界面 2.数据库连接 3.查询 4.增、5删 6改(操作数据库）

import java.sql.*;
import java.awt.*;
$ x% d4 U5 ^) o' P0 Fimport java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
Connection con;
" \5 m+ V  @$ U5 bStatement stmt;
* n, s; a* T& F! a4 L0 _; \String 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) {
, g# L0 |, V4 h0 U* wString str = e.getActionCommand();
* {# m3 `8 A+ O+ e% R1 Hif ("查询".equals(str)) {

//if check the button of 查询，then go to method of searchEmp()
' Z; ?/ u$ j8 A$ K. r# K* rsearchEmp();
) @8 E) ]7 K0 @' J! _. \" f. f+ N! D} else if ("增加".equals(str)) {

//if check the button of 增加，then go to method of addEmp()
addEmp();
} else if ("修改".equals(str)) {

//if check the button of 修改，then go to method of alterEmp()
! N. `$ ]* }/ Q5 lalterEmp();
} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
deleteEmp();
}
1 k# G% B2 l1 D$ ?}

//this is the constructor.

EmpManageSys() {
createGUI();
connectToDataBase();
. j7 e: w$ {& t* u' ]/ @8 y# z1 _' [// searchEmp();
; \( P$ S  V* o! u// addEmp();
, v& h4 g. u3 S! j- x// deleteEmp();
alterEmp();
: p$ y6 C4 t; X0 y}

//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() {
$ F/ A. {% ]- B9 l" q1 Qcon = JdbcUtil.getConnection();
- A' I0 T6 t( ?1 Y/ wSystem.out.println(con);
8 C: W7 Z" F. mreturn con;

}

public void searchEmp() {
, ^2 D, j- \$ M" e! Z2 c5 {. Ljta10.setText("");
( l: o7 C; y) t6 h- O( Stry {
/ [6 s" F) [- C5 V; b# x1 ~! ?stmt = con.createStatement();
9 T  w( F8 U. d// sql = "select * from Mstar where id=" + jtf3.getText();
3 }  R; y" K; w9 I  E// sql1="select * from sd100343 where ="+jtf3.getText();
" ]4 y+ E, {; j) W" G; U$ m6 zsql = "select * from Mstar where chineseName="
! M( [3 c5 n: Y+ [/ G& h2 s+ jtf2.getText().toLowerCase().trim() + "or id="
8 g8 w' L8 p3 K9 J# O; @/ P+ jtf3.getText().toLowerCase().trim() + "or engName="
/ g$ d  t1 o  x# Q+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
% e. Q8 _8 e+ D9 p+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
* {5 T7 P& s$ s. x+ k  ]1 t+ jtf8.getText().toLowerCase().trim() + "or busStation="
8 q" l. m2 n+ S7 \$ |+ jtf9.getText().toLowerCase().trim();
stmt.executeQuery(sql);
7 Z; l, \5 ]. `* m2 m  T/ m  Prs = stmt.getResultSet();
3 H/ s. b, m1 v+ AResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
while (rs.next()) {
6 K3 p' a/ ?5 P5 m5 V! gfor (int i = 1; i <= cols; i++) {
  [' P' M% N+ e* z" hsb.append(" " + meta.getColumnName(i) + " =");
3 W" G1 G* V, |% X+ c) gsb.append(rs.getString(i));
( w+ G& q' o# Q7 m. R}
sb.append("\n");
jta10.setText(sb.toString());
}
} catch (SQLException e11) {
e11.printStackTrace();
" m+ B* j+ G. N% c% G}

}

public void addEmp() {
# \7 k! Z: ]9 x. R: F; i% Ytry {
# g: @# e5 \$ `5 A/ O) Qstmt = con.createStatement();
sql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
+ jtf4.getText() + jtf5.getText() + jtf6.getText()
4 Y* K4 n5 _) I) G+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
. p. y5 g/ k- s8 {int i = stmt.getUpdateCount();
. J7 U8 _5 m( Lif ((jtf2.getText() != null) && (jtf4.getText() != null)
&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
+ Q; S" {/ K( f/ s+ Cstmt.executeUpdate(sql);
jta10.setText("添加记录成功" + i + "条");
; g: _3 E" b. k: X$ g' R$ @} else {
jta10.setText("带*号项为添加记录时不能为空");
& G2 [, I2 q# B# l  {( n; l- c6 d}
} catch (SQLException e1) {
+ x- j" O$ N  n4 F5 xe1.printStackTrace();
2 N' R$ ~; h* \" v: w" ~}
}

public void deleteEmp() {
& {2 g% ~9 U) e; EsearchEmp();
try {
stmt = con.createStatement();
" E$ v7 f3 p' Z' C: i3 w  msql = "delete from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
5 J4 `5 T) e0 O5 p. r$ [/ D+ jtf3.getText().toLowerCase().trim() + "or engName="
( H. `( u! z3 |/ |, }+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
+ jtf6.getText().toLowerCase().trim() + "or Phone="
# c0 ^# Y9 \9 f6 y+ jtf7.getText().toLowerCase().trim() + "or region="
* h( g, ~0 U% {, V% W0 M1 `) l4 G0 p+ jtf8.getText().toLowerCase().trim() + "or busStation="
) Z  u9 J+ F) T/ @+ jtf9.getText().toLowerCase().trim();
stmt.executeUpdate(sql);
int i = stmt.getUpdateCount();
jta10.setText("撤除操作成功" + i + "条");
} catch (SQLException e) {
e.printStackTrace();
. \. c* M. e9 r# ~, ]3 N% n2 j4 Q$ x}

}

public void alterEmp() {
, s9 T1 U4 v9 c1 Y9 V, ~( H! _' m5 PsearchEmp();
sql = "update Mstar set chineseName="
+ jtf2.getText().toLowerCase().trim() + "and id="
: ?2 i) C6 W8 R' V' L/ l. ]- e+ jtf3.getText().toLowerCase().trim() + "and engName="
+ jtf4.getText().toLowerCase().trim() + "and UNIT="
+ jtf5.getText().toLowerCase().trim() + "and TEAM="
: j! h# v7 A3 i, t* E$ L+ jtf6.getText().toLowerCase().trim() + "and Phone="
+ jtf7.getText().toLowerCase().trim() + "and region="
' p6 L+ `# Z# n$ y: q7 j# g+ jtf8.getText().toLowerCase().trim() + "and busStation="
# q; j- _/ h$ i+ jtf9.getText().toLowerCase().trim();

int i = 0;
0 D& u* ^/ K/ _1 I8 \try {
- w* N, Q# h* t" v! U- wstmt.executeUpdate(sql);
! _/ S, K/ x$ s1 ki = stmt.getUpdateCount();
} catch (SQLException e) {
e.printStackTrace();
6 J  M+ O# U  z! R}
& K+ Z$ _  h) `; Qjta10.setText("修改操作成功" + i + "条");
; `1 U  o7 V& K/ \5 n}

public void createGUI() {
JFrame jf = new JFrame("员工信息管理系统");
; O0 K# h2 ^. q6 ujf.setLayout(new GridLayout(2, 1));
// jf.setLayout(new GridLayout(10,2));
JPanel jp00 = new JPanel(new GridLayout(5, 4));

JPanel jp1 = new JPanel();
JButton jb11 = new JButton("查询");
jb11.addActionListener(this);
+ K, W& {; o# D4 z( K7 FJButton jb12 = new JButton("增加");
# V0 x) }" g5 O- ajb12.addActionListener(this);
) @0 X7 j+ l3 e! M6 E" b' ujp1.add(jb11);
$ y7 f2 d5 h* i" k3 p3 g" }jp1.add(jb12);
& _! N$ j8 x. A8 vjp00.add(jp1);
& N5 j' Y* r* L/ K' QJPanel jp11 = new JPanel();
JButton jb111 = new JButton("修改");
jb111.addActionListener(this);
% D. |; W: B! A: d) \  PJButton jb112 = new JButton("撤除");
jb112.addActionListener(this);
jp11.add(jb111);
jp11.add(jb112);
1 V) X$ U# n# C) r" Mjp00.add(jp11);
JPanel jp2 = new JPanel();
JLabel jl2 = new JLabel("中 文 名 * ");
jp2.add(jl2);
, ~3 P) x, F, R5 l  p4 ejp2.add(jtf2);
6 u) |' t( ]2 N6 d, m; vjp00.add(jp2);
JPanel jp3 = new JPanel();
JLabel jl3 = new JLabel("工 号 ");
( I+ j, h2 ]9 w; d% Ejp3.add(jl3);
jp3.add(jtf3);
jp00.add(jp3);
, V) J& u5 @1 J# f0 @# ?JPanel jp4 = new JPanel();
+ H. j/ U) O+ L) D' i; xJLabel jl4 = new JLabel("EngName*");
  ^0 v$ i# H# f. Q% t8 c4 D4 z/ ujp4.add(jl4);
jp4.add(jtf4);
# x4 I0 S2 [& B( A: L! A, H+ djp00.add(jp4);
JPanel jp5 = new JPanel();
JLabel jl5 = new JLabel("UNIT ");
jp5.add(jl5);
jp5.add(jtf5);
* v! G  W, k( X7 I6 Ijp00.add(jp5);
JPanel jp6 = new JPanel();
JLabel jl6 = new JLabel("TEAM* ");
/ U8 `  I. s7 D/ z$ H" k' g1 K- Tjp6.add(jl6);
7 p9 O: B4 X+ F0 {, A% n' Q6 M# cjp6.add(jtf6);
5 G& O* H, y$ y8 F0 g8 O; ijp00.add(jp6);
JPanel jp7 = new JPanel();
, a  {6 M  T9 K2 X6 a# z2 kJLabel jl7 = new JLabel("Phone* ");
; W5 b$ c3 y& yjp7.add(jl7);
; ]9 u$ u1 r% |jp7.add(jtf7);
( r; _) Q2 X+ l, z' g4 s6 qjp00.add(jp7);
JPanel jp8 = new JPanel();
JLabel jl8 = new JLabel("区域 ");
0 j  y3 B) ~4 L- Z- U2 C. Qjp8.add(jl8);
$ x; ?4 A. f. w5 |8 i/ f* C8 n* Wjp8.add(jtf8);
# E0 ~5 P. x( s& x/ j( ?jp00.add(jp8);
) F! M+ b2 Y" bJPanel jp9 = new JPanel();
0 q& l, O' g8 K5 b& ?! |JLabel jl9 = new JLabel("公交站 ");
jp9.add(jl9);
jp9.add(jtf9);
jp00.add(jp9);
/ I6 }! b; k( `% jjf.add(jp00);
JPanel jp01 = new JPanel();
jta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
5 J+ O. T' B( [7 y0 w7 E, njp01.add(jta10);
jf.add(jp01);
+ |: u7 ^* |! w3 T: C: R3 r  l7 fjf.setSize(700, 500);
jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
+ [" E& Q8 T) o' E8 H. vjf.setVisible(true);

}

public static void main(String[] args) {
new EmpManageSys();
}
  w: N3 b. a5 G) w* c) k}

9 B  |3 }+ ]2 w+ x) N

蕾蕾

//---------------------------------------------------------------------
" Y. M/ }2 Z- K( xSQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
import java.sql.*;
public class JdbcUtil
- c8 o6 L1 p! m* h) G( G* i; h! d{
# n# k  L5 f0 R2 g  b//load driver from file
( j) ^! W2 }- Q8 [  k  K0 Zstatic{
try{
String driverName =
"oracle.jdbc.driver.OracleDriver";
* K$ s( e+ V& u4 J- U  w5 L- `! sClass.forName(driverName);
: `% b3 v5 b$ y}catch(Exception e){
e.printStackTrace();
1 {/ {" `5 Q3 R+ c2 B6 [! W}
}
' v* r" K7 Q$ x" X7 H6 M& `* o//establish connection
public static Connection getConnection(){
) z0 A0 v) L' c* d( c# h/ L! F5 zConnection con = null;
try{
  D& A+ O# P* Y; ^String url =
) q& O, Y: `" \7 [5 \"jdbcracle:thin192.168.0.26:1521:tarena";
String usr = "openlab";
String pwd = "open123";
con = DriverManager.getConnection(
$ x8 l( W6 p5 b: N3 J# Turl,usr,pwd);
}catch(Exception e){
; `) m# G/ w+ Le.printStackTrace();
. N8 i& Z! ^, s9 L4 S6 R}
return con;
}
' J  l8 ?0 w! Y
/ `  n# T+ M$ c  Z' t( a; p- _/ o* K//close resultSet,statement and connection
public static void close(ResultSet rs,Statement stmt,Connection con){
. G8 X9 t! ]$ w0 l$ Itry{
if(rs!=null) rs.close();
}catch(Exception ex){
ex.printStackTrace();
}
3 [5 I+ r1 \' b$ @+ ztry{
if(stmt!=null) stmt.close();
6 S5 }4 u- z! G* Z. L$ M}catch(Exception ex){
ex.printStackTrace();
}
try{
1 B; {' Y8 u5 C! c5 tif(con!=null) con.close();
# g, U3 ?$ T4 e6 |}catch(Exception ex){
ex.printStackTrace();
9 G$ o1 J% M/ t}
# \  U# H9 [2 f4 i) l}
- s. b4 ?8 Q& X) Z: l, v}