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

蕾蕾

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

import java.sql.*;
import java.awt.*;
import java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
& h) i3 |+ A3 G  R4 Q( D- u- VConnection con;
Statement stmt;
String sql;
  n# @' y5 b! z" dResultSet 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) {
  ^# Q- a/ z' S/ P' a2 R8 [# KString str = e.getActionCommand();
if ("查询".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();
} 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()
+ n5 d' S9 l; F% K+ gdeleteEmp();
9 {( T/ ^% c! C) n}
0 M- p# T  d( E% p}

//this is the constructor.

EmpManageSys() {
createGUI();
4 D* d( T# F* H9 ~2 aconnectToDataBase();
4 R) [8 f; H% G; D5 Z* k8 I, Z( s5 @// searchEmp();
// addEmp();
: ?8 [2 b6 D9 z+ I  }3 W# {9 R7 F// deleteEmp();
6 f( ^$ W7 N; {0 S1 HalterEmp();
}

//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() {
, t; \3 j( [/ i# e) C: g/ Ucon = JdbcUtil.getConnection();
+ Z4 @( o$ D5 A- F' ^# u) ySystem.out.println(con);
return con;

}

public void searchEmp() {
; N1 s2 @) V2 G" N$ k: j0 q4 Bjta10.setText("");
try {
9 p# j2 ~  f' x8 I7 pstmt = con.createStatement();
0 f, F! d  Q. L/ Z, c// sql = "select * from Mstar where id=" + jtf3.getText();
3 e; n0 l& w* w4 l4 C4 }// sql1="select * from sd100343 where ="+jtf3.getText();
sql = "select * from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
, q. S3 x) T" V2 d+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
5 X( X8 _$ ]% Z7 [  D+ c+ jtf5.getText().toLowerCase().trim() + "or TEAM="
' e; ?9 X3 t! n& p3 V+ jtf6.getText().toLowerCase().trim() + "or Phone="
0 o1 P. X# y( n1 G  a+ jtf7.getText().toLowerCase().trim() + "or region="
+ jtf8.getText().toLowerCase().trim() + "or busStation="
+ D  v! ~* Y, g" u5 z4 b+ jtf9.getText().toLowerCase().trim();
stmt.executeQuery(sql);
rs = stmt.getResultSet();
ResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
* f, \/ W- W$ W8 u' u# dwhile (rs.next()) {
& y8 p  i$ p5 `  p6 B% Efor (int i = 1; i <= cols; i++) {
sb.append(" " + meta.getColumnName(i) + " =");
sb.append(rs.getString(i));
}
3 f: B: N1 U4 x4 o: Osb.append("\n");
4 C2 S' C9 H: X# a! {9 C( o" k; ojta10.setText(sb.toString());
}
' U2 G: e$ S; a: Y/ Q$ g9 a8 U! a0 S} catch (SQLException e11) {
' _" M2 U" N6 f. c& Le11.printStackTrace();
}

}

public void addEmp() {
2 U9 f2 u# J9 ctry {
( k+ K7 x! n$ u3 ostmt = con.createStatement();
sql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
2 @6 M/ H9 b6 v2 x$ x% N+ jtf4.getText() + jtf5.getText() + jtf6.getText()
1 k* K* ?4 r. Q+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
+ v6 b2 \. K( l! Y+ @4 @7 F8 I1 Hint i = stmt.getUpdateCount();
/ ^$ A% w+ X: Z8 U# k. Vif ((jtf2.getText() != null) && (jtf4.getText() != null)
6 |; z) ?5 z3 u&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
stmt.executeUpdate(sql);
jta10.setText("添加记录成功" + i + "条");
9 f1 J, V! ^$ o) }/ h  x} else {
+ x2 ?( S6 P( J# G4 Xjta10.setText("带*号项为添加记录时不能为空");
2 Y) Q5 W- q/ `1 t}
8 B% U5 v& [+ ]& F: ]( w, W} catch (SQLException e1) {
/ ^' T- @# c* n! I1 l& W- C  \e1.printStackTrace();
}
}

public void deleteEmp() {
searchEmp();
; l8 k- v4 U9 w7 W. stry {
8 }' U' g# \3 F2 M: v' U( Q0 Zstmt = con.createStatement();
sql = "delete from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
' `- F! x, p' O/ l1 Y8 V2 h' x+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
1 X$ h1 D/ S$ e1 g. o+ N+ jtf8.getText().toLowerCase().trim() + "or busStation="
+ jtf9.getText().toLowerCase().trim();
+ F: r) Z. W) L0 @stmt.executeUpdate(sql);
: C3 h. Z+ a  n: lint i = stmt.getUpdateCount();
jta10.setText("撤除操作成功" + i + "条");
% ]2 P2 \7 F. j0 w) o} catch (SQLException e) {
e.printStackTrace();
}

}

public void alterEmp() {
searchEmp();
5 ?7 R, {# I* T4 j+ Q& N; Q8 h# Ssql = "update Mstar set chineseName="
+ jtf2.getText().toLowerCase().trim() + "and id="
1 [3 U' \, Y7 q+ jtf3.getText().toLowerCase().trim() + "and engName="
+ jtf4.getText().toLowerCase().trim() + "and UNIT="
" k' D$ l8 L0 Y+ @9 ?( C+ jtf5.getText().toLowerCase().trim() + "and TEAM="
+ jtf6.getText().toLowerCase().trim() + "and Phone="
+ jtf7.getText().toLowerCase().trim() + "and region="
% |" c9 H! [7 |+ jtf8.getText().toLowerCase().trim() + "and busStation="
& ~& `! s" L( R% ~+ jtf9.getText().toLowerCase().trim();

int i = 0;
try {
stmt.executeUpdate(sql);
$ K& t9 T; o: k& H2 o/ \. i* li = stmt.getUpdateCount();
} catch (SQLException e) {
e.printStackTrace();
1 s2 R* S8 [% C1 u0 b}
jta10.setText("修改操作成功" + i + "条");
* t5 E0 r. |: k4 k, d}

public void createGUI() {
8 {  l: r. M) n0 J) ^. }) cJFrame jf = new JFrame("员工信息管理系统");
jf.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);
" L% O8 g- J8 G- bJButton jb12 = new JButton("增加");
jb12.addActionListener(this);
8 V+ J" z8 B2 M( k4 kjp1.add(jb11);
5 W& P, [8 j- V: R3 J3 q/ @jp1.add(jb12);
* W5 _! Z- w* G, V! djp00.add(jp1);
+ I/ Q& K  `: [2 k% X1 nJPanel jp11 = new JPanel();
7 V1 G( H: d8 h6 m) wJButton jb111 = new JButton("修改");
2 M+ ^1 j2 F; o' njb111.addActionListener(this);
8 t/ |/ E! N/ N  N/ a8 k5 F1 y) UJButton jb112 = new JButton("撤除");
9 r& l; _  |  _( `) g9 Gjb112.addActionListener(this);
1 G- ~5 z2 I6 l' }4 b; J8 Qjp11.add(jb111);
jp11.add(jb112);
jp00.add(jp11);
JPanel jp2 = new JPanel();
JLabel jl2 = new JLabel("中 文 名 * ");
+ [( i. |6 [% R3 Vjp2.add(jl2);
jp2.add(jtf2);
jp00.add(jp2);
2 @6 j2 l, ]8 f3 G( yJPanel jp3 = new JPanel();
0 |0 a/ Y0 N' lJLabel jl3 = new JLabel("工 号 ");
: W; p5 @4 F% V  p5 ^% q3 u& Djp3.add(jl3);
9 i; }! V: `8 sjp3.add(jtf3);
jp00.add(jp3);
JPanel jp4 = new JPanel();
* {9 e& s& I) Z2 ?. [5 vJLabel jl4 = new JLabel("EngName*");
+ u! {7 o6 s& g+ _2 ejp4.add(jl4);
$ u# ~( H7 H7 F  F; ?jp4.add(jtf4);
jp00.add(jp4);
JPanel jp5 = new JPanel();
: Y( V! C! ^& k  ?3 }! WJLabel jl5 = new JLabel("UNIT ");
jp5.add(jl5);
. n; ^6 `9 r1 u7 n" _jp5.add(jtf5);
jp00.add(jp5);
JPanel jp6 = new JPanel();
# `0 K  y! c# WJLabel jl6 = new JLabel("TEAM* ");
, M$ F# O8 P+ }' O+ Zjp6.add(jl6);
jp6.add(jtf6);
% X' ], c* ^7 |jp00.add(jp6);
: l' s: U( y  IJPanel jp7 = new JPanel();
; V+ F2 Q( F5 X! q6 E$ ]0 S, r' [1 ~JLabel jl7 = new JLabel("Phone* ");
& H$ P1 P% H$ N& B) I: djp7.add(jl7);
) z( k- ~6 g# t9 ]6 njp7.add(jtf7);
jp00.add(jp7);
# ]* r9 G, E3 Y$ L! D3 RJPanel jp8 = new JPanel();
JLabel jl8 = new JLabel("区域 ");
jp8.add(jl8);
jp8.add(jtf8);
! t9 s' Y, r3 ~) c5 Rjp00.add(jp8);
# Q( {( |. l7 S, eJPanel jp9 = new JPanel();
JLabel jl9 = new JLabel("公交站 ");
jp9.add(jl9);
jp9.add(jtf9);
jp00.add(jp9);
1 Z& G2 A+ [  p3 u! k  i3 k( Q/ Djf.add(jp00);
JPanel jp01 = new JPanel();
jta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
jp01.add(jta10);
jf.add(jp01);
jf.setSize(700, 500);
, z; F8 M. T1 {8 D* u, ^1 j5 bjf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jf.setVisible(true);

}

public static void main(String[] args) {
new EmpManageSys();
; L& v6 Y; U0 R% l( f}
}

, U# }5 i( g, Q/ [

蕾蕾

//---------------------------------------------------------------------
4 I; @. e" p( \9 D9 _* hSQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
1 Z7 ?" }6 [* t% Bimport java.sql.*;
2 @6 X7 Z* _0 V  I/ Hpublic class JdbcUtil
{
; D3 U) c/ A( S, {( a//load driver from file
static{
try{
String driverName =
"oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
}catch(Exception e){
e.printStackTrace();
}
& c1 b0 A4 v: l$ }: ?4 W}
- W9 q( W: h8 W1 f//establish connection
; n0 s  N% R* lpublic static Connection getConnection(){
Connection con = null;
7 a% D/ k6 B! C7 B( j3 \; I- stry{
String url =
! h# s6 L% P7 E* s"jdbcracle:thin192.168.0.26:1521:tarena";
String usr = "openlab";
! o1 d- S; w8 m2 k( o" Y* sString pwd = "open123";
0 x! U( G! H, @6 T# U6 Gcon = DriverManager.getConnection(
url,usr,pwd);
/ G. A% [4 K- a5 I4 g) Y( N}catch(Exception e){
+ p2 W4 M$ i# j" p+ w) I' N' I) Be.printStackTrace();
}
* P" \1 A6 |; E+ _! s! Areturn con;
! U+ p. M5 E; Z3 p6 y8 k}
8 @7 ^  \$ z& i, ~8 r7 p
7 ]0 t2 g; g" a( ?. {9 [5 P( D//close resultSet,statement and connection
1 y+ x% ^- Q, m/ Upublic static void close(ResultSet rs,Statement stmt,Connection con){
try{
if(rs!=null) rs.close();
1 H- [6 a$ U3 J8 ]}catch(Exception ex){
& D( N- ?8 |6 D. dex.printStackTrace();
2 a6 ?, i9 Z+ T" A1 ^/ Z}
; {% }9 g! H4 Z/ Utry{
8 [: w, i  P  Z$ d1 H: f* k4 Kif(stmt!=null) stmt.close();
7 `' P! v" L$ G% W* a  d}catch(Exception ex){
4 H7 @' o& s5 m1 P/ Vex.printStackTrace();
$ f+ ~; U: F5 j' B}
  V6 M) S- a. n2 [- R# N# ftry{
2 g) R* W6 K+ w/ _" K7 O5 \& Iif(con!=null) con.close();
5 z1 s- Z7 y* K8 y/ s8 c" t}catch(Exception ex){
ex.printStackTrace();
}
}
: r7 h; v2 A- g7 Z5 C8 n; g& K}