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

蕾蕾

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

import java.sql.*;
1 X) ^5 W, H" wimport java.awt.*;
import java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
Connection con;
Statement stmt;
String sql;
6 y7 s6 y5 w2 P  S" \9 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) {
String str = e.getActionCommand();
/ v4 S6 c+ q1 jif ("查询".equals(str)) {

//if check the button of 查询，then go to method of searchEmp()
# w& e: U- a2 |  ~* v% @0 j% csearchEmp();
3 J: s/ n. ^# C} else if ("增加".equals(str)) {

//if check the button of 增加，then go to method of addEmp()
addEmp();
7 i6 o: ]4 @7 H% g} else if ("修改".equals(str)) {

//if check the button of 修改，then go to method of alterEmp()
! R8 b/ V# t9 ~. O4 k8 kalterEmp();
} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
+ c+ Q+ I& Z" O, U4 a0 d# p' TdeleteEmp();
}
}

//this is the constructor.

EmpManageSys() {
createGUI();
connectToDataBase();
// searchEmp();
// addEmp();
// deleteEmp();
alterEmp();
- o( T; H; N. F4 ~9 ]5 H5 ^. o}

//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();
System.out.println(con);
  S: Z& G: q3 x0 K( t5 V4 kreturn con;

}

public void searchEmp() {
* H# H! O. i) w  J8 Gjta10.setText("");
0 h5 B' s* g' S) C6 W) }. xtry {
stmt = con.createStatement();
// sql = "select * from Mstar where id=" + jtf3.getText();
$ \$ J! M( u% ]1 x2 b// sql1="select * from sd100343 where ="+jtf3.getText();
6 I: P: i2 b- x" O4 ^sql = "select * from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
+ jtf6.getText().toLowerCase().trim() + "or Phone="
3 _+ ~  a: e5 i$ }+ jtf7.getText().toLowerCase().trim() + "or region="
, k+ \% [& g# n6 a& s  P+ jtf8.getText().toLowerCase().trim() + "or busStation="
2 l& J8 u+ x' |6 n) t* |; b+ jtf9.getText().toLowerCase().trim();
stmt.executeQuery(sql);
& Z% F8 c8 P8 xrs = stmt.getResultSet();
% X: M# n( V2 lResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
* ?; }( z0 O. e' h1 w$ `while (rs.next()) {
for (int i = 1; i <= cols; i++) {
6 F$ b2 I3 k8 c; o; ?2 n0 A! [/ Jsb.append(" " + meta.getColumnName(i) + " =");
/ P/ n; U' X; i- W5 _+ `sb.append(rs.getString(i));
}
sb.append("\n");
) [! }( g( l3 x3 ~jta10.setText(sb.toString());
}
5 d0 e/ [: t# _1 J. ~( {} catch (SQLException e11) {
' N+ T' [3 k2 c* @" z! Se11.printStackTrace();
7 n% p" H% f+ ]% P" I' v, |% P}

}

public void addEmp() {
try {
' Y! j: F  w, H& \" @6 V) T: G2 j* l" Astmt = con.createStatement();
sql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
+ jtf4.getText() + jtf5.getText() + jtf6.getText()
1 C, Q. i$ t: ^( _3 W: G5 A+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
1 S" B7 m0 K) ]int i = stmt.getUpdateCount();
0 g3 C  u4 S) J, z) cif ((jtf2.getText() != null) && (jtf4.getText() != null)
3 U& A! n$ s* _5 V# _& W&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
' o. y) I6 L2 w  g9 x/ L; Pstmt.executeUpdate(sql);
+ B$ b4 N& q, Z0 i- i/ X& Jjta10.setText("添加记录成功" + i + "条");
} else {
jta10.setText("带*号项为添加记录时不能为空");
: n0 z* H4 z; U( N* \; W9 c}
} catch (SQLException e1) {
e1.printStackTrace();
6 d! e2 N+ j* l" O" q2 G0 M}
8 A+ x" c# s8 q) @% u. o% t}

public void deleteEmp() {
1 s( [- R# l/ d% _searchEmp();
" t# h4 @) B& K* ~# P/ |0 itry {
$ x  T* m" d& d) c: d* Cstmt = con.createStatement();
sql = "delete from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
+ Z" n& _/ B6 M) i( @/ Q" ~6 M, P+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
+ jtf6.getText().toLowerCase().trim() + "or Phone="
. P7 Y9 W0 g4 p* q- o" D+ u+ jtf7.getText().toLowerCase().trim() + "or region="
: ]1 p' u) L! Y! a+ jtf8.getText().toLowerCase().trim() + "or busStation="
( N9 D0 |4 N: N5 h# z: l6 p+ jtf9.getText().toLowerCase().trim();
stmt.executeUpdate(sql);
int i = stmt.getUpdateCount();
$ _. {# v* ^4 djta10.setText("撤除操作成功" + i + "条");
% @+ u# j, O) h} catch (SQLException e) {
e.printStackTrace();
9 i* A  i: |/ [: N2 z}

}

public void alterEmp() {
searchEmp();
sql = "update Mstar set chineseName="
+ jtf2.getText().toLowerCase().trim() + "and id="
. g/ p% [$ b; l  k- a( U5 |0 o+ jtf3.getText().toLowerCase().trim() + "and engName="
  O- U+ L5 p4 s" \* \+ 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="
+ jtf9.getText().toLowerCase().trim();

int i = 0;
try {
7 z( w7 D& P" {/ J2 H6 \, \1 Cstmt.executeUpdate(sql);
i = stmt.getUpdateCount();
. W, u" {& B: s) r1 u} catch (SQLException e) {
/ T, J9 G2 z/ @e.printStackTrace();
9 ~7 \- d- `$ f1 h6 K2 {}
jta10.setText("修改操作成功" + i + "条");
}

public void createGUI() {
JFrame jf = new JFrame("员工信息管理系统");
jf.setLayout(new GridLayout(2, 1));
// jf.setLayout(new GridLayout(10,2));
& J: ?4 H/ t1 e3 ]$ W8 GJPanel jp00 = new JPanel(new GridLayout(5, 4));

JPanel jp1 = new JPanel();
JButton jb11 = new JButton("查询");
# H2 c5 P+ O; n, u4 p! @$ @' gjb11.addActionListener(this);
, Q' B/ A; l: {/ N, `' f' S+ fJButton jb12 = new JButton("增加");
jb12.addActionListener(this);
2 q7 T. L& l9 ]3 y8 ljp1.add(jb11);
6 V% y2 T0 e# j3 P. W, m' i- ojp1.add(jb12);
9 E, v/ i. F+ v) c; I5 p2 h$ Z2 j! ?jp00.add(jp1);
6 w( M9 Q0 _- D. k7 p# n2 jJPanel jp11 = new JPanel();
5 w4 g6 r- i4 |, ?( L3 AJButton jb111 = new JButton("修改");
, V4 u, f% W$ m6 @( L- Zjb111.addActionListener(this);
JButton jb112 = new JButton("撤除");
jb112.addActionListener(this);
jp11.add(jb111);
jp11.add(jb112);
1 I# B" R( `$ E9 H+ W$ w4 mjp00.add(jp11);
JPanel jp2 = new JPanel();
( [+ O2 f9 V4 rJLabel jl2 = new JLabel("中 文 名 * ");
5 Z+ V2 ]. E) B0 Ajp2.add(jl2);
3 @! o6 C, ]. p, q, N4 [1 v  njp2.add(jtf2);
jp00.add(jp2);
JPanel jp3 = new JPanel();
; E  g$ ?, r5 s2 w* h0 {JLabel jl3 = new JLabel("工 号 ");
( T6 J3 ~) a# R9 ~* e: X5 \7 @jp3.add(jl3);
# z3 k: o9 `3 N/ K5 T/ W# Sjp3.add(jtf3);
0 X* S5 I/ T3 U( w2 d' _6 }/ ]) yjp00.add(jp3);
JPanel jp4 = new JPanel();
! T. X$ Z& u. mJLabel jl4 = new JLabel("EngName*");
9 d2 i' o7 G# B6 i( K, q3 S0 a2 Mjp4.add(jl4);
$ d- i/ ]3 Z, {4 A8 C2 z, |jp4.add(jtf4);
jp00.add(jp4);
2 t+ g- E9 U$ |2 k2 Q3 m, ]% BJPanel jp5 = new JPanel();
JLabel jl5 = new JLabel("UNIT ");
; a! V4 V! g4 m* A/ W7 V0 f& Zjp5.add(jl5);
' h0 A( W! I* J- T' L, Gjp5.add(jtf5);
" ~& B7 \2 |5 c  {& Njp00.add(jp5);
JPanel jp6 = new JPanel();
JLabel jl6 = new JLabel("TEAM* ");
) Y: ]# S0 a2 v/ {! i) H; Ujp6.add(jl6);
jp6.add(jtf6);
8 S# [1 D( C0 v; B9 y0 \jp00.add(jp6);
JPanel jp7 = new JPanel();
4 k7 ]4 w  Z2 ?. e: b5 CJLabel jl7 = new JLabel("Phone* ");
: m' n# f# [6 n7 ijp7.add(jl7);
jp7.add(jtf7);
jp00.add(jp7);
: R9 f8 `3 _$ U+ |8 o6 J: LJPanel jp8 = new JPanel();
JLabel jl8 = new JLabel("区域 ");
* n: o$ l$ B0 N4 M( c' V" U- s3 h* Ijp8.add(jl8);
% v8 W/ E( P# y0 N* r! ~jp8.add(jtf8);
5 n' M/ ]1 u/ b9 U4 Mjp00.add(jp8);
JPanel jp9 = new JPanel();
- K  _" F$ C: J4 p! x9 h+ r+ SJLabel jl9 = new JLabel("公交站 ");
2 P! C6 a8 _# g1 ^/ Ujp9.add(jl9);
$ I3 }  Q* N( [jp9.add(jtf9);
( g* G. u" `! U- a+ b9 ^; j% L3 j% ejp00.add(jp9);
0 E, X" M0 L% b+ R' q0 @  gjf.add(jp00);
JPanel jp01 = new JPanel();
jta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
( x$ l# O8 z- l5 l, Bjp01.add(jta10);
: Z0 U" I6 k* U# ?- z# njf.add(jp01);
jf.setSize(700, 500);
5 ], [5 a) q* X7 K: z0 Ojf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
3 e/ m4 E* f) W: ajf.setVisible(true);

}

public static void main(String[] args) {
) ^9 f8 H. p8 U0 s8 H. Rnew EmpManageSys();
}
2 a; T6 c$ r( v6 o' [: ~# R}

- G0 {/ ~/ a9 f* ^' `+ V

蕾蕾

//---------------------------------------------------------------------
SQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
import java.sql.*;
! f3 w1 Y5 x& v: @! @4 p! Ypublic class JdbcUtil
{
  p& i) \8 v4 \& G//load driver from file
8 U# u' F* R- J1 nstatic{
, F3 z" A' c5 ltry{
String driverName =
' r& ^; P' Z) P"oracle.jdbc.driver.OracleDriver";
: @& e0 ^0 h, L6 S' p& RClass.forName(driverName);
2 r- F5 U, n( w5 `5 Z}catch(Exception e){
, C) X# k) R5 ^# O  _+ f& g& Ke.printStackTrace();
* [, f! I' Q; d/ `, C' Z}
}
//establish connection
public static Connection getConnection(){
Connection con = null;
; E( ^4 H+ c4 q" Vtry{
4 q1 z5 P, i( ^& _String url =
5 z  |2 _' w5 L& E, w"jdbcracle:thin192.168.0.26:1521:tarena";
- K, `8 `- @. A* U& i; ?String usr = "openlab";
( B  f. S, O& H$ o' W0 L% B  AString pwd = "open123";
8 j  }! ?. H0 ~* X. wcon = DriverManager.getConnection(
5 W2 b+ \0 H" }0 Nurl,usr,pwd);
2 G1 i) H1 j* E}catch(Exception e){
e.printStackTrace();
}
return con;
}
& ?1 B5 D1 H/ f2 ]# ^
//close resultSet,statement and connection
8 E- K& E8 ~: D1 @: C3 y; F5 `9 h8 spublic static void close(ResultSet rs,Statement stmt,Connection con){
try{
if(rs!=null) rs.close();
}catch(Exception ex){
ex.printStackTrace();
' y# P# M/ h; w. @9 {* p}
try{
if(stmt!=null) stmt.close();
& k. {9 }1 \% `" \- U}catch(Exception ex){
' M5 k% t$ |; m; j' S- Hex.printStackTrace();
% I9 b# K& l# k' D8 ~8 W}
+ R4 P  U  H# P4 Q% W+ itry{
if(con!=null) con.close();
1 F/ z; {. e  X$ q" R5 n}catch(Exception ex){
/ Q8 y0 I$ @7 S! A( \ex.printStackTrace();
}
}
7 g2 R. d4 J/ _0 M}