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

蕾蕾

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

import java.sql.*;
import java.awt.*;
+ _+ A( p$ ~! Q4 T: z  ~* P' ?import java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
; e- R4 a* O! {$ Q, V0 s. @Connection con;
/ T/ s7 n4 q; [  s  a8 ~  ]Statement stmt;
9 }+ I1 z5 h: k/ W3 V! z4 aString sql;
ResultSet rs;
+ W4 ]$ P8 \9 P" z2 FStringBuffer 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();
if ("查询".equals(str)) {

//if check the button of 查询，then go to method of searchEmp()
6 G" t5 d) j" I1 G# ZsearchEmp();
. L' [$ C; k8 V$ ?- J4 B# u: Z} else if ("增加".equals(str)) {

//if check the button of 增加，then go to method of addEmp()
addEmp();
$ r5 z% C# ?0 X+ Y9 F} else if ("修改".equals(str)) {

//if check the button of 修改，then go to method of alterEmp()
alterEmp();
3 `' i+ v/ q- f7 n# x} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
deleteEmp();
}
}

//this is the constructor.

EmpManageSys() {
' D. @' R& ?/ S6 u; R- e( h9 w/ LcreateGUI();
) u- @/ j( }  `+ i: ^- CconnectToDataBase();
5 v' E; Y* y- a// searchEmp();
// addEmp();
// deleteEmp();
. o8 Q5 U( \1 t% b& aalterEmp();
, o$ o4 N' X1 i}

//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() {
- M* D8 [5 I1 G2 q3 F( ccon = JdbcUtil.getConnection();
) k8 E! j" W0 k! {" Y! M4 {System.out.println(con);
return con;

}

public void searchEmp() {
jta10.setText("");
. d$ T6 s: @/ B: B" L: Wtry {
stmt = con.createStatement();
+ m" f3 P( {. ]. F// sql = "select * from Mstar where id=" + jtf3.getText();
// sql1="select * from sd100343 where ="+jtf3.getText();
sql = "select * from Mstar where chineseName="
7 o1 h- o* c3 |- I+ jtf2.getText().toLowerCase().trim() + "or id="
) Q3 J+ ]& @% @* o7 d$ d+ jtf3.getText().toLowerCase().trim() + "or engName="
9 k' K" U# @, Z+ jtf4.getText().toLowerCase().trim() + "or UNIT="
7 T/ F6 o' J- g& b7 b- Y- f+ jtf5.getText().toLowerCase().trim() + "or TEAM="
+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
  H2 I6 W% N8 d( e+ jtf8.getText().toLowerCase().trim() + "or busStation="
+ jtf9.getText().toLowerCase().trim();
stmt.executeQuery(sql);
rs = stmt.getResultSet();
ResultSetMetaData meta = rs.getMetaData();
1 G4 j% e# k; p* r$ T5 Lint cols = meta.getColumnCount();
9 c8 u2 w7 Q# v- h% \- cwhile (rs.next()) {
( b$ E) z, l1 z* R$ U* }0 i0 xfor (int i = 1; i <= cols; i++) {
sb.append(" " + meta.getColumnName(i) + " =");
sb.append(rs.getString(i));
; L" K7 o( W! T& c3 d: {. t0 y3 U2 _}
- s& N7 v# i, Vsb.append("\n");
jta10.setText(sb.toString());
}
} catch (SQLException e11) {
e11.printStackTrace();
& @  p* G( k, d: O}

}

public void addEmp() {
* B/ j$ ]% X5 |1 a- }" ltry {
  {" d$ f' l, N3 ^. @$ s+ I& N  Wstmt = con.createStatement();
sql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
8 O7 n9 z5 ?1 \  Z0 z+ jtf4.getText() + jtf5.getText() + jtf6.getText()
+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
int i = stmt.getUpdateCount();
/ x' v# K9 @, Iif ((jtf2.getText() != null) && (jtf4.getText() != null)
+ u) J" V5 ~- S. r# @6 y+ g6 |&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
stmt.executeUpdate(sql);
jta10.setText("添加记录成功" + i + "条");
} else {
! b, [# q, G3 ?; pjta10.setText("带*号项为添加记录时不能为空");
0 U1 b8 i; J3 ]) S7 }}
$ a- p! n* H5 }# Q! m: [} catch (SQLException e1) {
7 A, Z. Q' P4 s. N- A' }  X# [. c9 Ce1.printStackTrace();
}
}

public void deleteEmp() {
- i! h4 P6 T; P) J3 bsearchEmp();
' C4 P" n' ]8 h. _( Q8 etry {
stmt = con.createStatement();
5 _" R; S1 [' O3 lsql = "delete from Mstar where chineseName="
' w7 G9 |4 r" N3 Q! M3 x5 h+ jtf2.getText().toLowerCase().trim() + "or id="
+ N/ {" j0 F/ W7 g+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
, n" D/ l% p8 b5 o; }7 u2 N- y6 r+ jtf5.getText().toLowerCase().trim() + "or TEAM="
/ `" S$ |2 T2 E/ Q3 o. J- c4 j+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
+ jtf8.getText().toLowerCase().trim() + "or busStation="
. d# c3 ~: O- U5 o9 H+ jtf9.getText().toLowerCase().trim();
stmt.executeUpdate(sql);
int i = stmt.getUpdateCount();
jta10.setText("撤除操作成功" + i + "条");
; X. p" X+ D2 f" }. @$ _} catch (SQLException e) {
* z1 Y! X! u% x  b' f" ?5 @$ Q( re.printStackTrace();
}

}

public void alterEmp() {
! E; ^' @/ Q" G2 T7 @' GsearchEmp();
* u/ u4 J2 |. m* v1 D: _7 wsql = "update Mstar set chineseName="
+ jtf2.getText().toLowerCase().trim() + "and id="
% u  w% Z' O1 |8 I+ jtf3.getText().toLowerCase().trim() + "and engName="
! `7 k# }3 j8 s. n+ F* ~3 ~+ jtf4.getText().toLowerCase().trim() + "and UNIT="
+ jtf5.getText().toLowerCase().trim() + "and TEAM="
* f! Q: I2 n( d) J9 i* x5 {* S+ jtf6.getText().toLowerCase().trim() + "and Phone="
+ jtf7.getText().toLowerCase().trim() + "and region="
+ jtf8.getText().toLowerCase().trim() + "and busStation="
& x+ R& m* N5 p8 R6 M& g+ jtf9.getText().toLowerCase().trim();

int i = 0;
. ~! j, E! W) D9 u# l9 b8 qtry {
2 G( A2 C+ C0 D. G4 Rstmt.executeUpdate(sql);
i = stmt.getUpdateCount();
( y4 O% P$ J* M1 M- f) Z7 g} catch (SQLException e) {
6 y$ [/ \% Q$ |1 y# Ye.printStackTrace();
}
jta10.setText("修改操作成功" + i + "条");
7 [2 W/ S  q& v! R& s' q% ^3 h5 S}

public void createGUI() {
JFrame jf = new JFrame("员工信息管理系统");
jf.setLayout(new GridLayout(2, 1));
// jf.setLayout(new GridLayout(10,2));
( \$ N$ W! f2 v7 H: xJPanel jp00 = new JPanel(new GridLayout(5, 4));

JPanel jp1 = new JPanel();
2 ]5 o& Y$ |; S% f3 gJButton jb11 = new JButton("查询");
+ |/ O: \% L: d) Hjb11.addActionListener(this);
JButton jb12 = new JButton("增加");
$ B& v+ f8 @3 k6 c* gjb12.addActionListener(this);
jp1.add(jb11);
2 K  w, L% H- O! O0 D7 }: pjp1.add(jb12);
( D& x# h& h/ H1 S9 mjp00.add(jp1);
( H. N- N! |) T: n; d3 |( C8 `JPanel jp11 = new JPanel();
JButton jb111 = new JButton("修改");
8 o$ l9 _& r& T; b- R6 {2 R$ wjb111.addActionListener(this);
JButton jb112 = new JButton("撤除");
% B8 N- R# y5 n" Mjb112.addActionListener(this);
jp11.add(jb111);
) h) V# m3 ^! l) f" }4 r) ujp11.add(jb112);
jp00.add(jp11);
JPanel jp2 = new JPanel();
JLabel jl2 = new JLabel("中 文 名 * ");
jp2.add(jl2);
/ o; Z  ?$ U: V# D& Sjp2.add(jtf2);
$ V( X( Y$ B# S8 ], E  qjp00.add(jp2);
% |  I; ^6 Z% j- t. O5 GJPanel jp3 = new JPanel();
JLabel jl3 = new JLabel("工 号 ");
jp3.add(jl3);
jp3.add(jtf3);
jp00.add(jp3);
JPanel jp4 = new JPanel();
! d- L" I2 u0 J( \4 h2 T& ^( [JLabel jl4 = new JLabel("EngName*");
jp4.add(jl4);
jp4.add(jtf4);
jp00.add(jp4);
JPanel jp5 = new JPanel();
JLabel jl5 = new JLabel("UNIT ");
0 P9 }2 T. v+ |; _5 J- s* k1 a8 Djp5.add(jl5);
jp5.add(jtf5);
  w2 d* w' j* ]6 H  A* T3 D* ?; djp00.add(jp5);
JPanel jp6 = new JPanel();
' G2 O3 N4 t3 ]+ x/ P- K/ ]3 ^7 j( YJLabel jl6 = new JLabel("TEAM* ");
jp6.add(jl6);
jp6.add(jtf6);
7 E! y# u7 a& {8 b# gjp00.add(jp6);
) m% {0 y0 E7 [- ~! I( C1 g$ D$ FJPanel jp7 = new JPanel();
JLabel jl7 = new JLabel("Phone* ");
jp7.add(jl7);
+ m9 |# C. X" c8 djp7.add(jtf7);
jp00.add(jp7);
JPanel jp8 = new JPanel();
JLabel jl8 = new JLabel("区域 ");
/ |4 x, {4 X" R2 J1 x; W2 z  ?- Wjp8.add(jl8);
jp8.add(jtf8);
jp00.add(jp8);
* q& h1 R' W4 u" M7 M; `% |JPanel jp9 = new JPanel();
JLabel jl9 = new JLabel("公交站 ");
( q1 ?) a$ V) G2 R! Kjp9.add(jl9);
jp9.add(jtf9);
9 m9 G+ A6 V) o  ^9 w) z6 x) J4 B( Sjp00.add(jp9);
jf.add(jp00);
! h& X, K; z" [4 z% t8 y  T/ F( ZJPanel jp01 = new JPanel();
jta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
9 y7 h# |' i+ [) i' O; v: vjp01.add(jta10);
$ i8 K2 F% J! O5 I0 A2 ~- _+ Ojf.add(jp01);
: T, ^. @9 }; ?% pjf.setSize(700, 500);
" Y& B4 X; E; D6 S0 djf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jf.setVisible(true);

}

public static void main(String[] args) {
new EmpManageSys();
/ _1 }% v( `% P$ |9 Q}
}

6 ^  e$ y) h( x" H# I  H+ U

蕾蕾

//---------------------------------------------------------------------
" @+ T2 W8 d9 M( JSQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
: ]$ x! y- n9 F0 f- e* [+ m  ~import java.sql.*;
* W5 ?+ a: S; p: Q, U3 Dpublic class JdbcUtil
{
//load driver from file
' V* e1 d/ k( A. Y. hstatic{
, A7 Y& h3 t$ ]try{
8 t+ F: d' k3 i: }) @8 hString driverName =
: N: }% L/ X% m8 `. n"oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
}catch(Exception e){
e.printStackTrace();
) l+ M3 ^9 i9 k9 N9 U5 f}
}
//establish connection
public static Connection getConnection(){
Connection con = null;
try{
7 Q0 z, K; t0 q7 Y" o2 eString url =
' k- X& T  J7 {0 B8 i/ ^"jdbcracle:thin192.168.0.26:1521:tarena";
8 f5 U9 E% n# l3 IString usr = "openlab";
2 T, o3 y( g9 }6 H+ R: F. lString pwd = "open123";
# B% \$ W; h# Q- G2 e8 ncon = DriverManager.getConnection(
url,usr,pwd);
}catch(Exception e){
( u# J7 U9 m! b0 F( V* Q; [  me.printStackTrace();
  p7 y: d: c7 p6 U3 t}
$ a5 @- _0 V, j8 P- ~6 Freturn con;
}

//close resultSet,statement and connection
8 j" C1 K( P0 P: Spublic static void close(ResultSet rs,Statement stmt,Connection con){
3 [! W- j* y5 {* W2 o" ktry{
if(rs!=null) rs.close();
}catch(Exception ex){
: ]& C) X( L4 B, {: W6 t+ Mex.printStackTrace();
  Y1 _" N* Y* o5 i' U- A# J6 e7 n' f% R}
try{
1 F, [$ g9 p9 ]" `4 A* n; U& Nif(stmt!=null) stmt.close();
}catch(Exception ex){
& K6 U: f0 W- r) {; z! G' I- l& P8 [ex.printStackTrace();
$ b- U9 |: ]' a. F}
4 d. a! G8 G1 j) Mtry{
: b& J& {: V9 z, P6 l! Hif(con!=null) con.close();
}catch(Exception ex){
; n) d) B0 V5 f* G7 i. {( P! J, W2 ^$ Qex.printStackTrace();
}
}
% a' v0 P5 r- m* a8 R! H}