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

蕾蕾

// 项目目标：建立员工管理系统第一个版本。
; l- Y6 v; K9 z2 A, g1 b4 Q& I" B// 实现图形用户界面的员工信息查询、增、删、改；与数据库建立，并将修改结果时时保存到数据库。
- t4 T, V+ F4 |// 模块：1.GUI界面 2.数据库连接 3.查询 4.增、5删 6改(操作数据库）

import java.sql.*;
" a5 c6 i, ?( G3 V7 jimport java.awt.*;
import java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
Connection con;
Statement stmt;
& {: t. ]) f6 N# z5 _. D3 |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) {
String str = e.getActionCommand();
- o; x  o5 Y: q+ n0 Pif ("查询".equals(str)) {

//if check the button of 查询，then go to method of searchEmp()
7 Z' r2 k) u. T9 R* d: zsearchEmp();
} 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()
alterEmp();
} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
8 U9 N8 J2 D- [; x4 d& [deleteEmp();
}
}

//this is the constructor.

EmpManageSys() {
* _: g- s9 K8 T2 w  O, tcreateGUI();
% L# o+ ]- Q: Y9 NconnectToDataBase();
// searchEmp();
// addEmp();
4 q) B2 B1 v7 l4 i- `// deleteEmp();
alterEmp();
  o. D+ F7 s; [0 [, B}

//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() {
4 x! y# ^5 L: ?con = JdbcUtil.getConnection();
+ ?1 X/ r: x$ b- A: @System.out.println(con);
! [7 z3 z3 ]$ sreturn con;

}

public void searchEmp() {
2 x4 h& E9 t* h7 u# b; N9 h1 Jjta10.setText("");
try {
stmt = con.createStatement();
// sql = "select * from Mstar where id=" + jtf3.getText();
// sql1="select * from sd100343 where ="+jtf3.getText();
sql = "select * from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
! |8 b4 S- w+ g! c+ jtf5.getText().toLowerCase().trim() + "or TEAM="
+ jtf6.getText().toLowerCase().trim() + "or Phone="
2 O/ f6 G" c9 ^/ c# D4 s- D+ jtf7.getText().toLowerCase().trim() + "or region="
% }1 F8 r$ T7 v7 u$ H# S+ jtf8.getText().toLowerCase().trim() + "or busStation="
2 {. U5 f4 z* T; h8 B$ \. g+ jtf9.getText().toLowerCase().trim();
& T" @3 V4 X3 h5 X- M/ B3 {/ rstmt.executeQuery(sql);
9 U% w7 W# |1 R: A, ^9 v/ G& u% Wrs = stmt.getResultSet();
ResultSetMetaData meta = rs.getMetaData();
# M0 v8 {# r' J5 x: Hint cols = meta.getColumnCount();
# |9 P. ^; [" T+ K( Zwhile (rs.next()) {
! a1 f/ ^5 o1 p6 y/ p$ X! f/ @for (int i = 1; i <= cols; i++) {
6 `: C5 i8 E# v9 rsb.append(" " + meta.getColumnName(i) + " =");
sb.append(rs.getString(i));
8 d9 B4 M6 ^3 g% Y( F' V; O}
sb.append("\n");
jta10.setText(sb.toString());
}
! D: C8 W  `3 l* u5 D, h! J0 r} catch (SQLException e11) {
  S; J6 ]- U9 Me11.printStackTrace();
}

}

public void addEmp() {
try {
! B! {( M3 N9 K/ q8 Y6 |stmt = con.createStatement();
, }2 ?  W+ i' [: G% H2 X& Nsql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
* b% H1 v4 [- P% ?4 o+ jtf4.getText() + jtf5.getText() + jtf6.getText()
- }  w- J$ S- @! m3 D1 {5 _+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
int i = stmt.getUpdateCount();
if ((jtf2.getText() != null) && (jtf4.getText() != null)
+ C6 t9 j+ z- [  v& Y8 v  d&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
5 j- L4 {( Y  g; zstmt.executeUpdate(sql);
jta10.setText("添加记录成功" + i + "条");
} else {
* |5 ^& Z: K- n$ g1 ejta10.setText("带*号项为添加记录时不能为空");
}
" ?" y+ B' w$ E' n} catch (SQLException e1) {
8 b4 L4 f$ n5 x) h9 j6 Me1.printStackTrace();
}
}

public void deleteEmp() {
searchEmp();
( A1 w( P" E! R' Wtry {
3 Y4 R% m  H( d- r' ]. t. Bstmt = con.createStatement();
sql = "delete from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
6 w: C/ \4 k6 Z3 n2 U/ R' q+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
$ Y4 F* w6 d7 e+ jtf6.getText().toLowerCase().trim() + "or Phone="
% V6 z2 {7 N, y/ g+ jtf7.getText().toLowerCase().trim() + "or region="
+ jtf8.getText().toLowerCase().trim() + "or busStation="
+ jtf9.getText().toLowerCase().trim();
stmt.executeUpdate(sql);
- A* i( [% ^# n  b  Z  t9 o/ Y. wint i = stmt.getUpdateCount();
, V: U2 }6 W, o+ A; _& w( kjta10.setText("撤除操作成功" + i + "条");
} catch (SQLException e) {
e.printStackTrace();
& |" j+ p6 E" q0 k}

}

public void alterEmp() {
$ c% s3 X4 n* k  b& {searchEmp();
sql = "update Mstar set chineseName="
2 G" T$ O3 m* x! J. @  v+ jtf2.getText().toLowerCase().trim() + "and id="
# I9 v, ^+ ^1 ]3 N7 y: x4 A+ jtf3.getText().toLowerCase().trim() + "and engName="
9 w) }+ G. T; }# m# G  ^4 D6 c0 F) A/ T+ jtf4.getText().toLowerCase().trim() + "and UNIT="
+ jtf5.getText().toLowerCase().trim() + "and TEAM="
+ jtf6.getText().toLowerCase().trim() + "and Phone="
+ jtf7.getText().toLowerCase().trim() + "and region="
+ jtf8.getText().toLowerCase().trim() + "and busStation="
% u1 S6 v9 Y5 U, a( [, A; I! Q+ jtf9.getText().toLowerCase().trim();

int i = 0;
9 f5 _5 f& ?+ j: x3 _/ C7 ktry {
4 B. W8 Y; `1 Fstmt.executeUpdate(sql);
8 |; e- t! _" J4 _$ ]i = stmt.getUpdateCount();
} catch (SQLException e) {
e.printStackTrace();
}
  x1 o/ |5 x4 J7 J; h# q* S: ?jta10.setText("修改操作成功" + i + "条");
}

public void createGUI() {
# f+ Y( p4 Z7 J% ^. A! BJFrame jf = new JFrame("员工信息管理系统");
+ y! r+ \  |  q5 m0 n  T. _+ ojf.setLayout(new GridLayout(2, 1));
// jf.setLayout(new GridLayout(10,2));
5 W  p* T" x+ g1 U$ [. D/ ?8 TJPanel jp00 = new JPanel(new GridLayout(5, 4));

JPanel jp1 = new JPanel();
JButton jb11 = new JButton("查询");
6 \- H& b8 z' j/ s6 T! jjb11.addActionListener(this);
JButton jb12 = new JButton("增加");
9 s3 }# ^# r1 z: T. K7 m9 Jjb12.addActionListener(this);
4 I2 [5 w) q: j. Z; F% c' Ijp1.add(jb11);
, s" \$ f! s* W. A. ^jp1.add(jb12);
0 ^( ~( l' m1 x* m+ _* ~4 V1 ]0 M4 Gjp00.add(jp1);
JPanel jp11 = new JPanel();
JButton jb111 = new JButton("修改");
jb111.addActionListener(this);
JButton jb112 = new JButton("撤除");
jb112.addActionListener(this);
- x3 [, w2 {6 sjp11.add(jb111);
  P& K" E% Q4 x' {7 ajp11.add(jb112);
jp00.add(jp11);
; c) i4 U* w2 _- x1 z& rJPanel jp2 = new JPanel();
0 t$ g9 J/ @) S& MJLabel jl2 = new JLabel("中 文 名 * ");
! J0 W- c  J4 e  ?& V6 ujp2.add(jl2);
; q3 i+ ?, h( Tjp2.add(jtf2);
jp00.add(jp2);
; ?& ]5 P) a! w; _2 q/ ^8 d3 xJPanel jp3 = new JPanel();
, m; F: w. L. M7 d1 J) eJLabel jl3 = new JLabel("工 号 ");
jp3.add(jl3);
jp3.add(jtf3);
$ ]4 |+ Q8 Q8 hjp00.add(jp3);
JPanel jp4 = new JPanel();
$ t1 O" ^. y  U. ~. nJLabel jl4 = new JLabel("EngName*");
jp4.add(jl4);
+ _7 y1 {# L9 \" D2 o! Ijp4.add(jtf4);
# U8 R6 z) m- ~4 k8 sjp00.add(jp4);
5 Y9 R' f; d- u+ a9 bJPanel jp5 = new JPanel();
JLabel jl5 = new JLabel("UNIT ");
jp5.add(jl5);
, w: p  i$ }- y" Xjp5.add(jtf5);
0 B2 A2 W) I+ Njp00.add(jp5);
" x4 _7 W% z0 w% xJPanel jp6 = new JPanel();
9 W( F2 ~3 O- RJLabel jl6 = new JLabel("TEAM* ");
, J! k* X% q- W* P; w, S+ V4 xjp6.add(jl6);
jp6.add(jtf6);
9 a, A- s: p) o# @% z' Ljp00.add(jp6);
# Q3 ?2 ~, b) W" yJPanel jp7 = new JPanel();
$ I% _+ s. B9 l* o( }JLabel jl7 = new JLabel("Phone* ");
jp7.add(jl7);
' z( c* C! h0 q! q9 ujp7.add(jtf7);
; ?. I7 B. c4 a3 ?, Fjp00.add(jp7);
3 w; Q" b$ b. d9 iJPanel jp8 = new JPanel();
# \% z: i  i0 w1 SJLabel jl8 = new JLabel("区域 ");
/ u) a& D; ~7 Q( n) q: ~jp8.add(jl8);
* w) n5 r$ F) D" zjp8.add(jtf8);
0 p, y  |% `5 ], m7 g9 djp00.add(jp8);
9 ^3 a  v) f  o9 n! O% IJPanel jp9 = new JPanel();
$ K- R+ N0 V7 H+ T8 P  g$ uJLabel jl9 = new JLabel("公交站 ");
jp9.add(jl9);
' m1 a9 K  B0 R, n7 n" \  Xjp9.add(jtf9);
jp00.add(jp9);
jf.add(jp00);
JPanel jp01 = new JPanel();
jta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
jp01.add(jta10);
/ e5 L  k$ P0 Xjf.add(jp01);
) |/ T; n$ H# L3 V8 ?! hjf.setSize(700, 500);
0 E" S( K$ P' j2 U% Bjf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
% ~) m0 G5 p7 w# Sjf.setVisible(true);

}

public static void main(String[] args) {
new EmpManageSys();
}
7 N0 Z2 X" Z5 S2 W) V5 J" z}

蕾蕾

//---------------------------------------------------------------------
) R: h0 p( j* O; _, ~SQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
import java.sql.*;
* q# @. s2 J3 g6 ^" \/ N# W. Cpublic class JdbcUtil
{
//load driver from file
  W: b4 _1 X3 P$ r  B# kstatic{
try{
7 ]/ x# s% p8 h3 i( eString driverName =
, H8 {  I4 ]" x"oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
( O+ `$ B6 X0 o9 ~& V, B}catch(Exception e){
e.printStackTrace();
}
}
& U  p7 r( u. D4 P. e4 k/ t//establish connection
) p( W0 R4 ~' F& m( b$ f! ^: Upublic static Connection getConnection(){
2 Y' n8 a& c: g; X" o" r8 CConnection con = null;
5 C3 |! a) }* Ktry{
+ O# r3 J* Q. h# e0 z# `" _String url =
"jdbcracle:thin192.168.0.26:1521:tarena";
String usr = "openlab";
2 T' P$ Z  l% O+ x6 w1 O9 ]6 yString pwd = "open123";
con = DriverManager.getConnection(
1 A! ^8 J+ ?7 {8 @2 G/ g1 Uurl,usr,pwd);
}catch(Exception e){
. j: `2 [9 [  I5 s) `/ \/ u, ve.printStackTrace();
& X+ o" u1 ]3 F! E- P8 Q+ Q' h1 w}
2 I) W5 @( }) ]  r( E$ K, Y. C8 z# Zreturn con;
}

//close resultSet,statement and connection
public static void close(ResultSet rs,Statement stmt,Connection con){
6 N7 d  ~% [6 y4 `5 N% Otry{
: b2 F& B) l2 y( {1 G: C" H  uif(rs!=null) rs.close();
}catch(Exception ex){
ex.printStackTrace();
}
  m0 d, ?. B; P6 V4 `  ftry{
if(stmt!=null) stmt.close();
}catch(Exception ex){
ex.printStackTrace();
}
try{
if(con!=null) con.close();
3 ]1 b8 k  J+ U}catch(Exception ex){
ex.printStackTrace();
}
}
' v0 W. A) G: U3 u}