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

蕾蕾

// 项目目标：建立员工管理系统第一个版本。
& p5 a& Q2 \  A+ o/ f3 M// 实现图形用户界面的员工信息查询、增、删、改；与数据库建立，并将修改结果时时保存到数据库。
3 k6 F4 R" K" z( d3 ~+ U// 模块：1.GUI界面 2.数据库连接 3.查询 4.增、5删 6改(操作数据库）

import java.sql.*;
import java.awt.*;
* g# E  R' k# g% h- v+ f7 wimport java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
Connection con;
Statement stmt;
$ K& [" u, J) y+ Y, x1 o! \" o* qString 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) {
+ [- H. q" z2 H7 e% cString str = e.getActionCommand();
* \  \. t4 O- l5 Wif ("查询".equals(str)) {

//if check the button of 查询，then go to method of searchEmp()
searchEmp();
} else if ("增加".equals(str)) {

//if check the button of 增加，then go to method of addEmp()
addEmp();
0 c. Y) A* d8 K. t' b" f' y* Q} else if ("修改".equals(str)) {

//if check the button of 修改，then go to method of alterEmp()
" `" I% n" O, A7 k( C- HalterEmp();
+ B( g! G# e! r5 s5 B9 _} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
1 P+ K2 U+ x& l1 odeleteEmp();
}
2 }" d% [, U: \6 }+ @}

//this is the constructor.

EmpManageSys() {
createGUI();
+ A/ a& y1 {, pconnectToDataBase();
// searchEmp();
// addEmp();
// deleteEmp();
alterEmp();
}

//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();
8 H& ^! J' ^; e  F0 T6 y& kSystem.out.println(con);
8 d$ k- `1 _6 ]3 v) d' {. `return con;

}

public void searchEmp() {
jta10.setText("");
6 i8 ]1 ~% @9 Dtry {
stmt = con.createStatement();
// sql = "select * from Mstar where id=" + jtf3.getText();
+ P1 {9 x8 u% ?( |6 }8 v6 r$ {// sql1="select * from sd100343 where ="+jtf3.getText();
  L9 u) Q4 t$ y4 s4 t* zsql = "select * from Mstar where chineseName="
1 r1 h! F% D1 a9 |+ jtf2.getText().toLowerCase().trim() + "or id="
7 C. W. R9 d/ b- B+ jtf3.getText().toLowerCase().trim() + "or engName="
3 s. t& G! E. ^, p$ I. h' a( n+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
+ t7 O3 d; c- `. e( {$ Y+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
4 T( k: V+ D" k+ jtf8.getText().toLowerCase().trim() + "or busStation="
1 q5 n' d5 X" ]: S+ jtf9.getText().toLowerCase().trim();
stmt.executeQuery(sql);
0 X9 P! w+ F: V7 w6 J" U' Brs = stmt.getResultSet();
: ]$ o( w% p& t  y/ c- A6 [, aResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
while (rs.next()) {
( f2 m  ~; K% |  tfor (int i = 1; i <= cols; i++) {
7 @  T7 \$ t% e$ d0 P7 E: v4 Hsb.append(" " + meta.getColumnName(i) + " =");
sb.append(rs.getString(i));
}
& L& i$ K' C# e, k. wsb.append("\n");
jta10.setText(sb.toString());
}
" t" d" n6 P* x! l0 q- l/ G% a! i) q} catch (SQLException e11) {
e11.printStackTrace();
3 w& I* u# A0 Z}

}

public void addEmp() {
try {
" g  {7 C0 U- E$ p; e; Zstmt = con.createStatement();
sql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
+ jtf4.getText() + jtf5.getText() + jtf6.getText()
1 ?9 h$ P& i# o1 X2 h& d+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
. }* |! w! P. ^  m& vint i = stmt.getUpdateCount();
if ((jtf2.getText() != null) && (jtf4.getText() != null)
5 d- F2 q2 m- A% Y" k&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
8 W, w( \" |/ m9 T  ^+ ]4 _stmt.executeUpdate(sql);
  e4 z$ ^3 N0 D+ V7 D% hjta10.setText("添加记录成功" + i + "条");
* L6 k( ]" K8 @} else {
jta10.setText("带*号项为添加记录时不能为空");
+ G5 K% K( `5 ~}
7 Q, ~% S! h1 C; e} catch (SQLException e1) {
e1.printStackTrace();
}
}

public void deleteEmp() {
' j! L0 Q$ Z9 m0 y% m* nsearchEmp();
& |& @3 H( q3 c" e. b) Y* y3 T0 Ftry {
" n0 V9 r% v$ g5 d, sstmt = con.createStatement();
sql = "delete from Mstar where chineseName="
* W4 S$ j/ z$ V, V  X) Y+ jtf2.getText().toLowerCase().trim() + "or id="
1 X2 U% b% U' y$ a& Q7 f+ jtf3.getText().toLowerCase().trim() + "or engName="
9 \0 c$ [' |& Y) _& y& q/ ]+ jtf4.getText().toLowerCase().trim() + "or UNIT="
5 `" [6 R0 Q+ t3 b! \5 O+ jtf5.getText().toLowerCase().trim() + "or TEAM="
+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
+ jtf8.getText().toLowerCase().trim() + "or busStation="
! r2 |8 G* B8 i+ Y7 ], o& F2 U# i9 p+ jtf9.getText().toLowerCase().trim();
stmt.executeUpdate(sql);
int i = stmt.getUpdateCount();
& d) E, H1 X1 w3 `& f7 r. Kjta10.setText("撤除操作成功" + i + "条");
} catch (SQLException e) {
e.printStackTrace();
3 }6 q: S$ Q0 T0 O+ Y; n! l$ b0 n+ V8 [}

}

public void alterEmp() {
searchEmp();
- b$ o* \6 X/ Y3 |3 ^( q1 c+ p; Z  V7 fsql = "update Mstar set chineseName="
+ jtf2.getText().toLowerCase().trim() + "and id="
+ jtf3.getText().toLowerCase().trim() + "and engName="
' W! X; b4 m4 l+ jtf4.getText().toLowerCase().trim() + "and UNIT="
; c9 M  v) m6 T) _' [# f+ jtf5.getText().toLowerCase().trim() + "and TEAM="
+ jtf6.getText().toLowerCase().trim() + "and Phone="
* U# ^7 f6 }: f: q- s# q+ jtf7.getText().toLowerCase().trim() + "and region="
3 P$ ~2 I' S/ x0 W# G" B3 `/ H+ jtf8.getText().toLowerCase().trim() + "and busStation="
% |0 ]$ z+ \5 c9 w+ jtf9.getText().toLowerCase().trim();

int i = 0;
try {
8 \' w! x6 ~5 T0 C0 G# tstmt.executeUpdate(sql);
i = stmt.getUpdateCount();
7 z8 Y1 w' k( w# y& k/ g) b} catch (SQLException e) {
5 h9 V6 J  E) P# e3 we.printStackTrace();
3 ]" O. \9 N7 c$ W4 }8 M9 |9 ?2 }( Z}
jta10.setText("修改操作成功" + i + "条");
}

public void createGUI() {
: q5 R9 d* N6 J' qJFrame jf = new JFrame("员工信息管理系统");
jf.setLayout(new GridLayout(2, 1));
// jf.setLayout(new GridLayout(10,2));
9 {! ?( D- h: ^1 X8 Y$ eJPanel jp00 = new JPanel(new GridLayout(5, 4));

JPanel jp1 = new JPanel();
& L9 z6 U. {- j6 ?  ^& E) f2 zJButton jb11 = new JButton("查询");
- d, K6 k* _% W3 d- E! c$ ljb11.addActionListener(this);
% v$ G. N, @: _/ H8 q6 _) bJButton jb12 = new JButton("增加");
: Z; `6 h7 x$ n% ]# s5 {7 Z8 tjb12.addActionListener(this);
6 N3 _$ A( e- b; U+ m3 Q8 Ljp1.add(jb11);
jp1.add(jb12);
6 a- v" F# Q5 I* `' i; S. k0 A, {jp00.add(jp1);
  ^$ W! R3 f+ x8 I) O1 Y7 wJPanel jp11 = new JPanel();
JButton jb111 = new JButton("修改");
jb111.addActionListener(this);
; }0 d& g: D0 x: HJButton jb112 = new JButton("撤除");
. l* c6 M, P: A, P2 p7 @jb112.addActionListener(this);
0 J! g$ B/ a( @; T7 y7 E9 a6 x8 Cjp11.add(jb111);
jp11.add(jb112);
( Z; c/ k; I. O8 z* {! j/ r% ajp00.add(jp11);
, U1 z. \" G' t/ VJPanel jp2 = new JPanel();
JLabel jl2 = new JLabel("中 文 名 * ");
1 d8 O6 p: o% r/ f4 @jp2.add(jl2);
) T' R+ |* G* @, C0 k0 c4 y+ rjp2.add(jtf2);
, w& ~1 E+ F- L; m1 ojp00.add(jp2);
JPanel jp3 = new JPanel();
JLabel jl3 = new JLabel("工 号 ");
jp3.add(jl3);
jp3.add(jtf3);
jp00.add(jp3);
JPanel jp4 = new JPanel();
JLabel jl4 = new JLabel("EngName*");
' S& J8 ?9 t% h: @& |# j4 H5 Kjp4.add(jl4);
/ J- v7 r' [8 S8 \jp4.add(jtf4);
jp00.add(jp4);
; j# @+ e2 o4 q5 ]6 O6 x6 w6 nJPanel jp5 = new JPanel();
1 r$ p5 F3 }/ L2 B9 B0 }: C% xJLabel jl5 = new JLabel("UNIT ");
jp5.add(jl5);
jp5.add(jtf5);
1 Y: u7 X$ Y* \% Xjp00.add(jp5);
# m% @5 i; R  D+ E; x& i  U3 {5 UJPanel jp6 = new JPanel();
" I, j. p. k, k- dJLabel jl6 = new JLabel("TEAM* ");
3 I' ^  Y1 }" {( B1 mjp6.add(jl6);
jp6.add(jtf6);
jp00.add(jp6);
JPanel jp7 = new JPanel();
: L, m  N5 L! O# I/ [! aJLabel jl7 = new JLabel("Phone* ");
4 [. y5 N$ _' d) \jp7.add(jl7);
jp7.add(jtf7);
jp00.add(jp7);
JPanel jp8 = new JPanel();
; d& j1 C, `2 y  v, l/ W4 jJLabel jl8 = new JLabel("区域 ");
jp8.add(jl8);
jp8.add(jtf8);
jp00.add(jp8);
% o4 D" j. d, l7 R5 e- ?JPanel jp9 = new JPanel();
JLabel jl9 = new JLabel("公交站 ");
jp9.add(jl9);
jp9.add(jtf9);
jp00.add(jp9);
& i8 Z# c2 j/ xjf.add(jp00);
JPanel jp01 = new JPanel();
jta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
jp01.add(jta10);
$ c8 _9 E3 y& q( k5 @- Y% ^jf.add(jp01);
, \, \) E. d! C8 t: p9 @/ K4 x3 jjf.setSize(700, 500);
* U9 W/ w  i% Qjf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
, S  m2 i( Y! b& r0 D3 `% Qjf.setVisible(true);

}

public static void main(String[] args) {
new EmpManageSys();
- [8 T0 E, ^( V! s, m7 d. R" }}
}

蕾蕾

//---------------------------------------------------------------------
SQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
import java.sql.*;
public class JdbcUtil
+ K2 B! z% m9 I{
//load driver from file
static{
try{
String driverName =
, X6 p% s" c5 G6 P/ q2 v"oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
, s1 h8 g% x# [; X! ^}catch(Exception e){
e.printStackTrace();
7 W- @, K6 {1 t! y; w8 o+ V! S5 J}
4 i# A+ T! Q. g, e1 ]/ D3 U2 M6 s}
//establish connection
" Q0 m1 k# a7 E/ T* i- ]8 cpublic static Connection getConnection(){
$ q) {5 S6 r3 |8 U' L- s' \- hConnection con = null;
try{
# d% n4 o4 [7 p5 Q) b! |- AString url =
"jdbcracle:thin192.168.0.26:1521:tarena";
9 W4 J5 u7 D2 [5 y& \/ T# R1 EString usr = "openlab";
String pwd = "open123";
; J+ \3 q6 |* d4 a' D1 rcon = DriverManager.getConnection(
url,usr,pwd);
}catch(Exception e){
; r8 p) a5 g" [- w% n% ze.printStackTrace();
}
( P4 C7 z* a- r: z& @return con;
}
( B4 |" q! W% b8 ^/ ]
//close resultSet,statement and connection
+ l1 Y( k, f9 R3 K# C+ A0 {public static void close(ResultSet rs,Statement stmt,Connection con){
try{
if(rs!=null) rs.close();
}catch(Exception ex){
ex.printStackTrace();
}
try{
if(stmt!=null) stmt.close();
  _# D# t7 L6 m( C( P" z* Y+ b: E}catch(Exception ex){
7 Q6 m% _6 y# Oex.printStackTrace();
5 [1 ]- v, |7 l: u7 x}
! p8 m& x+ t7 S/ |0 M3 r% J5 ptry{
if(con!=null) con.close();
% D" \0 N8 b& X: q}catch(Exception ex){
- U- B# \) H3 d7 P% w& sex.printStackTrace();
! k& U6 X* w) Y! @- a- P}
}
}