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

蕾蕾

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

import java.sql.*;
import java.awt.*;
1 z' V$ k2 U9 M& q; i7 eimport java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
Connection con;
( l, R" ]$ o% @6 M9 Y" YStatement stmt;
, J$ P7 D" g% H! w" E  YString sql;
* x) T; V; e9 f0 |2 t0 TResultSet 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) {
( w& b2 u& `% ~! _String str = e.getActionCommand();
: I2 `* L5 ?7 X9 w4 t6 h' S( i1 kif ("查询".equals(str)) {

//if check the button of 查询，then go to method of searchEmp()
2 O+ t$ A. e) T4 N0 VsearchEmp();
} else if ("增加".equals(str)) {

//if check the button of 增加，then go to method of addEmp()
4 ]9 x) j" {4 l7 IaddEmp();
3 c+ J6 M- B/ c, z} else if ("修改".equals(str)) {

//if check the button of 修改，then go to method of alterEmp()
alterEmp();
; H. w# w2 v% h3 x( _} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
- ]. d; F5 X$ q8 d3 j- BdeleteEmp();
}
}

//this is the constructor.

EmpManageSys() {
createGUI();
connectToDataBase();
( T9 d3 i6 i- R- t// searchEmp();
// addEmp();
0 H' o9 X* Q" r3 W8 N! Y// deleteEmp();
alterEmp();
; q0 ~4 [+ P2 `/ 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() {
1 m" B1 g! {! q2 A9 P0 v0 Ccon = JdbcUtil.getConnection();
$ Q  I$ {) @  U' y- @7 m4 YSystem.out.println(con);
return con;

}

public void searchEmp() {
jta10.setText("");
9 V9 a) C) x. rtry {
) M3 f. E( Y* Y! t/ U% L, ^, N; xstmt = con.createStatement();
, x: i- J; r: p$ o9 F% \) [# K// sql = "select * from Mstar where id=" + jtf3.getText();
" _/ M8 S! |0 z: }2 F7 ]8 ]9 k// sql1="select * from sd100343 where ="+jtf3.getText();
8 c' F; U; J) A2 ?8 W4 \sql = "select * from Mstar where chineseName="
% A$ ^* j4 s- y, L+ jtf2.getText().toLowerCase().trim() + "or id="
+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
* ?5 M7 l; a9 ]: x5 N+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
+ jtf8.getText().toLowerCase().trim() + "or busStation="
+ jtf9.getText().toLowerCase().trim();
- M2 E/ J% Z# s) Y  E6 j2 lstmt.executeQuery(sql);
, i1 Y  m0 n% b2 |+ Rrs = stmt.getResultSet();
ResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
while (rs.next()) {
for (int i = 1; i <= cols; i++) {
sb.append(" " + meta.getColumnName(i) + " =");
sb.append(rs.getString(i));
6 R8 a* S8 E3 x1 n& ?& x}
( ^) C+ b4 x+ _% ssb.append("\n");
jta10.setText(sb.toString());
3 }" l8 f$ I' J+ e3 x" j( r# b}
} catch (SQLException e11) {
+ X7 ?! x6 l" C% S4 Q; c  Ve11.printStackTrace();
3 ~6 U7 ^2 S+ q: V: X7 K9 Y}

}

public void addEmp() {
4 }7 S* U) o) I' K2 ]: u; @try {
stmt = con.createStatement();
' z, n1 x/ e  C$ Y( V$ g5 U  nsql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
2 ]9 Y. c. O& f* L6 J, ]+ jtf4.getText() + jtf5.getText() + jtf6.getText()
+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
0 U( [; p8 g3 N! ^* t. e/ Iint i = stmt.getUpdateCount();
if ((jtf2.getText() != null) && (jtf4.getText() != null)
) C7 I  o' _. P8 o&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
stmt.executeUpdate(sql);
& Q* g5 f! ^0 o! i" Ojta10.setText("添加记录成功" + i + "条");
} else {
jta10.setText("带*号项为添加记录时不能为空");
}
# W% |: C  A: G7 t) g( N1 `} catch (SQLException e1) {
e1.printStackTrace();
}
}

public void deleteEmp() {
searchEmp();
try {
- W: M, g: j  L+ r1 Y4 ystmt = con.createStatement();
- z6 W/ {) e6 i9 a5 Rsql = "delete from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
+ jtf3.getText().toLowerCase().trim() + "or engName="
8 [1 m% V) j: d5 H, M; X" Y+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
+ jtf6.getText().toLowerCase().trim() + "or Phone="
& D4 K% J+ H% F; m, N* Y- ~+ jtf7.getText().toLowerCase().trim() + "or region="
+ jtf8.getText().toLowerCase().trim() + "or busStation="
& P# C$ \. S/ C+ jtf9.getText().toLowerCase().trim();
stmt.executeUpdate(sql);
8 K6 K0 L6 r  q& oint i = stmt.getUpdateCount();
8 v% V# x+ j  K4 P) K! }jta10.setText("撤除操作成功" + i + "条");
; i  y, [# G3 N% ~3 q4 d% C4 _} catch (SQLException e) {
e.printStackTrace();
}

}

public void alterEmp() {
searchEmp();
( K+ e' ?. g. C/ d* nsql = "update Mstar set chineseName="
+ jtf2.getText().toLowerCase().trim() + "and id="
, q4 W4 ~4 Z5 @+ @  d! W! e+ jtf3.getText().toLowerCase().trim() + "and engName="
$ [- D6 g9 H6 |9 U0 |) j+ jtf4.getText().toLowerCase().trim() + "and UNIT="
+ jtf5.getText().toLowerCase().trim() + "and TEAM="
% a1 i# h! S" `3 n! s4 c; P+ jtf6.getText().toLowerCase().trim() + "and Phone="
+ jtf7.getText().toLowerCase().trim() + "and region="
+ jtf8.getText().toLowerCase().trim() + "and busStation="
+ jtf9.getText().toLowerCase().trim();

int i = 0;
try {
: F" r% j% i# f7 m$ ystmt.executeUpdate(sql);
i = stmt.getUpdateCount();
} catch (SQLException e) {
% @' i$ N7 v. a6 ie.printStackTrace();
}
jta10.setText("修改操作成功" + i + "条");
/ n  [* n! b7 O$ f8 j}

public void createGUI() {
JFrame jf = new JFrame("员工信息管理系统");
jf.setLayout(new GridLayout(2, 1));
6 b8 N3 w, [/ S& K+ v// jf.setLayout(new GridLayout(10,2));
JPanel jp00 = new JPanel(new GridLayout(5, 4));

JPanel jp1 = new JPanel();
- v, G. O, p+ Z6 bJButton jb11 = new JButton("查询");
jb11.addActionListener(this);
' ^0 {  }1 M. V8 yJButton jb12 = new JButton("增加");
* ^% B8 h( p3 ?+ A! E  C$ G( ljb12.addActionListener(this);
jp1.add(jb11);
1 K: x  W; F$ c0 n  F  W. cjp1.add(jb12);
jp00.add(jp1);
JPanel jp11 = new JPanel();
JButton jb111 = new JButton("修改");
jb111.addActionListener(this);
JButton jb112 = new JButton("撤除");
$ |' S) r9 f$ j0 b- Y6 H/ y7 K& Zjb112.addActionListener(this);
9 L5 w4 l6 f. |jp11.add(jb111);
jp11.add(jb112);
# n8 d( V, s9 w6 t1 }jp00.add(jp11);
0 H" W1 J+ Q/ W$ S  T' aJPanel jp2 = new JPanel();
9 M" z. a' m2 J" v0 D! G$ GJLabel jl2 = new JLabel("中 文 名 * ");
" [; N0 V. y, ?. ^8 {3 e" Ojp2.add(jl2);
3 S& M) w; c, [* G( gjp2.add(jtf2);
* l0 X0 S3 E% i1 ~0 y0 _: Zjp00.add(jp2);
% k% @4 n# V7 t- n- zJPanel jp3 = new JPanel();
JLabel jl3 = new JLabel("工 号 ");
jp3.add(jl3);
; P/ e3 |5 {) [% u/ njp3.add(jtf3);
$ w4 E# n' Z" @/ n' C+ Vjp00.add(jp3);
JPanel jp4 = new JPanel();
JLabel jl4 = new JLabel("EngName*");
7 B% L; Y6 H6 v8 N3 {( h3 w' Kjp4.add(jl4);
/ h' K. e6 _; H$ K' Ajp4.add(jtf4);
jp00.add(jp4);
JPanel jp5 = new JPanel();
/ }$ m$ l4 y, \9 |+ T5 E/ ZJLabel jl5 = new JLabel("UNIT ");
jp5.add(jl5);
jp5.add(jtf5);
; }, j1 K! @2 w; gjp00.add(jp5);
JPanel jp6 = new JPanel();
JLabel jl6 = new JLabel("TEAM* ");
jp6.add(jl6);
0 n1 Y! C: G; ejp6.add(jtf6);
jp00.add(jp6);
! o0 m! ^6 x; v& LJPanel jp7 = new JPanel();
. j2 F( a9 C4 F, e, J( T5 wJLabel jl7 = new JLabel("Phone* ");
jp7.add(jl7);
jp7.add(jtf7);
2 r( G* ?. ?6 D3 L2 l5 B1 njp00.add(jp7);
JPanel jp8 = new JPanel();
JLabel jl8 = new JLabel("区域 ");
jp8.add(jl8);
jp8.add(jtf8);
. e$ h" L( o% N3 P, j) pjp00.add(jp8);
) c- b( m- p! e* \: pJPanel jp9 = new JPanel();
JLabel jl9 = new JLabel("公交站 ");
' H$ F5 e/ _  Y+ @" T+ u. vjp9.add(jl9);
3 |6 d7 m- `# w4 c$ w! Ijp9.add(jtf9);
jp00.add(jp9);
6 _/ a% ]- e' @4 ^jf.add(jp00);
# U* \5 k6 v8 _5 {! ~JPanel jp01 = new JPanel();
' ]2 c7 N7 h% f0 Zjta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
% \& I1 W# p; \- J: e$ r- hjp01.add(jta10);
jf.add(jp01);
  i' M- n( a5 V' o& G4 n  {jf.setSize(700, 500);
jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jf.setVisible(true);

}

public static void main(String[] args) {
. I. N, ~) ?5 Z9 O+ Snew EmpManageSys();
}
8 K' k) K' t+ K) g}

: \4 |* p6 l" f% S

蕾蕾

//---------------------------------------------------------------------
SQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
& H  R* U$ z4 Pimport java.sql.*;
public class JdbcUtil
* a% z: ~3 X: ~4 ^) E  }{
6 e4 J% n& q# {! J  h//load driver from file
static{
try{
String driverName =
8 ~0 M' B( R, w"oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
}catch(Exception e){
! I1 d% U2 s% [* s1 W/ A6 e" ae.printStackTrace();
. e% p8 `. Z4 k* `}
0 l, @4 g3 m# t6 @% w3 {6 |7 d}
//establish connection
public static Connection getConnection(){
Connection con = null;
8 q: B4 e. H  T3 h( c; b% D, Btry{
String url =
"jdbcracle:thin192.168.0.26:1521:tarena";
String usr = "openlab";
String pwd = "open123";
con = DriverManager.getConnection(
; ?- R$ {) P/ C6 k4 `: ~url,usr,pwd);
+ c* l- T5 b5 ]6 h/ d}catch(Exception e){
e.printStackTrace();
4 ]5 ?/ g& p& r/ s& @}
return con;
+ N# S8 y  n4 B: l5 e}
/ h( W9 W5 r, E" m
//close resultSet,statement and connection
8 e; E. Q. h# S, ~9 y; F* g# L' Tpublic static void close(ResultSet rs,Statement stmt,Connection con){
8 s* |$ {9 B0 vtry{
4 X$ ^+ p# B. g. \if(rs!=null) rs.close();
( b" N5 A* }/ K, G# N% q( Y6 x& r}catch(Exception ex){
+ s. q+ f4 d9 H! yex.printStackTrace();
4 E- j( B5 _8 }* \}
9 L6 D; |" q6 c4 y8 g! }9 ftry{
if(stmt!=null) stmt.close();
}catch(Exception ex){
- r7 K5 L4 S. h. ^ex.printStackTrace();
}
try{
7 c; Q) u1 z5 I3 n8 N8 l& X& A3 hif(con!=null) con.close();
! d+ l& ^, u! ^# S6 z0 U1 G! [0 L( S}catch(Exception ex){
: [. h# {7 N6 H4 wex.printStackTrace();
& y( A/ ~; I& w1 X8 }4 s8 B}
0 z1 a: l, g/ {: h$ A}
/ d# i+ D" }5 _" I8 N& c! S}