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

蕾蕾

// 项目目标：建立员工管理系统第一个版本。
" Q; I8 _- L+ t/ d8 r7 ]( K// 实现图形用户界面的员工信息查询、增、删、改；与数据库建立，并将修改结果时时保存到数据库。
9 j; {- u2 w1 {. e) S4 {// 模块：1.GUI界面 2.数据库连接 3.查询 4.增、5删 6改(操作数据库）

import java.sql.*;
import java.awt.*;
. |! O$ d7 W# uimport java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
Connection con;
Statement stmt;
# a: W9 B/ @* O/ s5 @& i9 J6 ^0 yString sql;
ResultSet rs;
% n3 G3 F) Z1 I6 yStringBuffer 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();
# P5 V3 g! X) Z, S' qif ("查询".equals(str)) {

//if check the button of 查询，then go to method of searchEmp()
searchEmp();
1 v! r! B  q9 t! w) D# c3 F} else if ("增加".equals(str)) {

//if check the button of 增加，then go to method of addEmp()
% D8 c$ H7 K6 }) `addEmp();
} else if ("修改".equals(str)) {

//if check the button of 修改，then go to method of alterEmp()
1 I, j# X4 S/ Q& N, T/ SalterEmp();
} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
: A1 f7 X/ [& m: a1 J8 `9 h/ g( ndeleteEmp();
0 _$ m7 \! @  h2 Y( H3 X}
}

//this is the constructor.

EmpManageSys() {
createGUI();
connectToDataBase();
9 c7 H! s. [* l0 F4 h0 E// searchEmp();
& M. ?' K4 X6 c9 a% E' N$ X// addEmp();
// deleteEmp();
5 p% X7 n3 T# E6 a8 V" M% galterEmp();
2 t& f8 A/ ?: A2 X' x0 R, ^}

//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() {
; z# D' ?5 R4 bcon = JdbcUtil.getConnection();
System.out.println(con);
return con;

}

public void searchEmp() {
jta10.setText("");
try {
stmt = con.createStatement();
// sql = "select * from Mstar where id=" + jtf3.getText();
- A9 S9 c4 p& J# B9 k# ~// sql1="select * from sd100343 where ="+jtf3.getText();
' R' Y3 u+ c& N7 Vsql = "select * from Mstar where chineseName="
3 B1 U( Q, E1 [+ g& [  u  R+ jtf2.getText().toLowerCase().trim() + "or id="
  m! r6 q' M- w4 H% b) i+ 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="
, q+ w  \# {& k+ jtf8.getText().toLowerCase().trim() + "or busStation="
/ C3 ^+ Z9 n( Z2 Y$ J+ jtf9.getText().toLowerCase().trim();
stmt.executeQuery(sql);
rs = stmt.getResultSet();
ResultSetMetaData meta = rs.getMetaData();
) N. Z# H& q+ b* l4 h1 s, ]int cols = meta.getColumnCount();
while (rs.next()) {
for (int i = 1; i <= cols; i++) {
# g( l- a5 ]4 M8 [- ^5 D7 M0 m( ^' Nsb.append(" " + meta.getColumnName(i) + " =");
sb.append(rs.getString(i));
}
6 {  c; l4 ]3 g4 H: Fsb.append("\n");
jta10.setText(sb.toString());
  @3 u3 J/ I" s2 u) t  [# P}
7 I& F, R" U8 A4 b} catch (SQLException e11) {
% [0 ?4 s8 g) y# D0 L% Y* be11.printStackTrace();
}

}

public void addEmp() {
try {
0 h# W! }: e6 j& ^stmt = con.createStatement();
5 t6 j" X' l# A, K! h- D" O! V/ U, Lsql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
+ jtf4.getText() + jtf5.getText() + jtf6.getText()
+ b% R/ u6 U. _" w+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
int i = stmt.getUpdateCount();
# H# D' Z  I' ^5 r, Uif ((jtf2.getText() != null) && (jtf4.getText() != null)
4 l3 m4 D; b$ K/ a0 e&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
! }/ |: z% T2 h7 r) {; M( bstmt.executeUpdate(sql);
jta10.setText("添加记录成功" + i + "条");
" W$ ~, z( @$ _+ c7 L} else {
- }/ \+ @& ]3 c( t  y9 Ajta10.setText("带*号项为添加记录时不能为空");
}
} catch (SQLException e1) {
7 w7 K3 K) J+ g# x% Je1.printStackTrace();
}
5 D6 H1 l$ S, R  Q6 y}

public void deleteEmp() {
searchEmp();
4 g5 n9 U/ {7 d" i  ctry {
stmt = con.createStatement();
sql = "delete 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="
' b% e3 K2 Z& n2 j% l# I+ jtf7.getText().toLowerCase().trim() + "or region="
+ jtf8.getText().toLowerCase().trim() + "or busStation="
5 m' Q* |1 W8 y, B9 F4 D: i+ jtf9.getText().toLowerCase().trim();
6 a" p9 g  V# Z" O/ I& Q8 [- D$ Istmt.executeUpdate(sql);
: Z, [5 ]8 ?+ }: U" Pint i = stmt.getUpdateCount();
jta10.setText("撤除操作成功" + i + "条");
} catch (SQLException e) {
3 Z! H( m3 C! m7 `e.printStackTrace();
}

}

public void alterEmp() {
searchEmp();
sql = "update Mstar set chineseName="
$ j4 Z+ \9 r; I6 u/ T. T( r& q+ jtf2.getText().toLowerCase().trim() + "and id="
+ jtf3.getText().toLowerCase().trim() + "and engName="
+ jtf4.getText().toLowerCase().trim() + "and UNIT="
0 i" |* I: ?% p2 h) K+ jtf5.getText().toLowerCase().trim() + "and TEAM="
/ S/ x5 x! j2 b+ C+ 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;
' S+ ^4 p; J3 T( F5 C1 ptry {
stmt.executeUpdate(sql);
6 Z" @2 y3 ~1 f, |i = stmt.getUpdateCount();
} catch (SQLException e) {
. ~! O* b4 r: n, {e.printStackTrace();
}
. y% g! K0 M, {% f$ }jta10.setText("修改操作成功" + i + "条");
}

public void createGUI() {
JFrame 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);
7 i) r0 E+ v/ K2 N: EJButton jb12 = new JButton("增加");
0 v: p* @$ }3 m4 @. f, o! R; Kjb12.addActionListener(this);
- ]4 s% }* M+ \; |- Q: jjp1.add(jb11);
jp1.add(jb12);
8 ^; M& e+ C; Vjp00.add(jp1);
  D8 x* c# j9 `JPanel jp11 = new JPanel();
& X- s( p7 |  \6 [2 vJButton jb111 = new JButton("修改");
jb111.addActionListener(this);
8 b7 q# q% t. M; H$ ?* F" sJButton jb112 = new JButton("撤除");
jb112.addActionListener(this);
jp11.add(jb111);
jp11.add(jb112);
jp00.add(jp11);
JPanel jp2 = new JPanel();
% \- j% x7 U; @4 l$ E& kJLabel jl2 = new JLabel("中 文 名 * ");
3 S& M! e0 g9 z8 |0 s6 k2 Qjp2.add(jl2);
* s( C# Z4 g6 m9 W# L% a3 ]jp2.add(jtf2);
jp00.add(jp2);
JPanel jp3 = new JPanel();
" A: W: |' f5 t; Y$ ]( ~: w4 A, x9 q; V: h5 tJLabel jl3 = new JLabel("工 号 ");
8 S( k- D: f+ A  Y0 Q5 Pjp3.add(jl3);
jp3.add(jtf3);
jp00.add(jp3);
" E7 s- J7 M8 w; z  [) fJPanel jp4 = new JPanel();
$ N: R* _  S" x5 x* E5 EJLabel jl4 = new JLabel("EngName*");
4 |7 p; [5 A, x4 s1 `jp4.add(jl4);
jp4.add(jtf4);
jp00.add(jp4);
, `3 V! q0 |7 N+ \  ~' w- qJPanel jp5 = new JPanel();
; R( ^2 E$ G( c$ yJLabel jl5 = new JLabel("UNIT ");
jp5.add(jl5);
jp5.add(jtf5);
6 a+ |! I( K  _8 [9 g" p% I' _jp00.add(jp5);
JPanel jp6 = new JPanel();
JLabel jl6 = new JLabel("TEAM* ");
jp6.add(jl6);
1 j1 K8 G/ |0 Z" Z+ E, S, t. _jp6.add(jtf6);
jp00.add(jp6);
4 t6 q; @/ j4 @' S5 r# j1 mJPanel jp7 = new JPanel();
" P, _/ f( d7 F1 bJLabel jl7 = new JLabel("Phone* ");
! r2 M& V  w: i+ k  ojp7.add(jl7);
jp7.add(jtf7);
jp00.add(jp7);
JPanel jp8 = new JPanel();
, E* I2 S" T( Q% BJLabel jl8 = new JLabel("区域 ");
( V* }' M3 z# n& I/ L& ^& gjp8.add(jl8);
, x) Q3 G& }7 e5 T3 k. S8 Vjp8.add(jtf8);
jp00.add(jp8);
  b& V, c/ ]) J" cJPanel jp9 = new JPanel();
( w7 ?) F0 d2 w, F2 M) {6 cJLabel jl9 = new JLabel("公交站 ");
jp9.add(jl9);
jp9.add(jtf9);
jp00.add(jp9);
jf.add(jp00);
JPanel jp01 = new JPanel();
jta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
jp01.add(jta10);
jf.add(jp01);
jf.setSize(700, 500);
jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
# Y; C5 ~6 J2 rjf.setVisible(true);

}

public static void main(String[] args) {
1 c5 Z2 P1 R) m+ k' [( H8 R6 inew EmpManageSys();
  T8 Y& D( _2 b}
6 ~' L4 ]* E2 X0 B}

6 o  w# H! F4 N& o+ `% U2 I  R

蕾蕾

//---------------------------------------------------------------------
( T. f% S8 {' \$ e$ CSQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
import java.sql.*;
) E2 Y( ~: F0 F" C7 @2 Bpublic class JdbcUtil
1 h) a4 ]. z/ }; z- }{
//load driver from file
0 }0 n9 [( X' Q' g* Bstatic{
try{
String driverName =
2 Y: S# X, z8 `$ C9 h( q0 h4 O"oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
}catch(Exception e){
e.printStackTrace();
$ C8 I+ j: }  e& C% t}
}
//establish connection
2 s$ U4 }/ t  r# U6 j5 |# W7 Apublic static Connection getConnection(){
Connection con = null;
/ j+ ~$ j* i+ S+ {3 Y3 Rtry{
0 I" F; b( E: g, }0 Q  v5 wString url =
5 b' ^6 s+ T& O) M; [! w: A  U, ^"jdbcracle:thin192.168.0.26:1521:tarena";
; `9 j1 q0 R& w% z, @3 O; vString usr = "openlab";
String pwd = "open123";
% o0 q1 \' R6 z% J3 s! Zcon = DriverManager.getConnection(
url,usr,pwd);
  T/ u* @, ^& X4 O/ w" q9 q! {}catch(Exception e){
; ~+ F. g/ d* U; D5 @. }e.printStackTrace();
}
6 j3 i7 s! m5 n5 h$ c  Ireturn con;
}
! b, w$ L% h" e" R- e' ?
//close resultSet,statement and connection
9 l3 |5 G* C6 B4 opublic static void close(ResultSet rs,Statement stmt,Connection con){
try{
9 R8 l8 c2 Y6 K7 A( Y) iif(rs!=null) rs.close();
, K) H8 B9 S) Z$ Z6 a9 ~+ F}catch(Exception ex){
ex.printStackTrace();
}
try{
if(stmt!=null) stmt.close();
}catch(Exception ex){
2 g* p, \+ @( z0 M: @ex.printStackTrace();
}
try{
; i3 A  G  r1 N( L+ p6 eif(con!=null) con.close();
}catch(Exception ex){
# l& D9 n) j) Q% |6 G( oex.printStackTrace();
}
' {; ~8 ~4 F  L. G2 }}
}