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

蕾蕾

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

import java.sql.*;
import java.awt.*;
3 E$ N3 N7 D5 n1 k0 P4 A) \  m* himport java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
Connection con;
Statement stmt;
String sql;
ResultSet rs;
: W* \( p# }' q5 O8 ~6 ~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();
if ("查询".equals(str)) {

//if check the button of 查询，then go to method of searchEmp()
7 M" M' s% |+ b, ^( m$ ^6 _searchEmp();
" c4 ^+ r+ k6 l% v( v+ k} else if ("增加".equals(str)) {

//if check the button of 增加，then go to method of addEmp()
7 }% P3 c  P1 t( F- W; x: ?. _addEmp();
} else if ("修改".equals(str)) {

//if check the button of 修改，then go to method of alterEmp()
alterEmp();
# I6 E) }1 [8 a, b% M! T' \} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
) m+ c- i7 U3 i5 m9 fdeleteEmp();
0 S1 n+ x8 F, X" E0 P}
4 T  c# t+ v7 ]}

//this is the constructor.

EmpManageSys() {
5 X* T7 N- c# K* s" X# e! R' ncreateGUI();
connectToDataBase();
2 P2 o) H  @# H. z// searchEmp();
: J. R7 u- `9 f// addEmp();
/ J4 ]: {/ n1 E// deleteEmp();
alterEmp();
}

//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();
4 h) ?; g, I* e& B# bSystem.out.println(con);
% p- t9 ^' ~5 G" u" Ureturn con;

}

public void searchEmp() {
jta10.setText("");
, b! c- B) b% m; O0 I7 ?try {
stmt = con.createStatement();
6 e2 A% }' v( {/ ~3 K$ y4 `/ b// sql = "select * from Mstar where id=" + jtf3.getText();
* R: \4 O0 i0 M6 ?# \8 _- O// sql1="select * from sd100343 where ="+jtf3.getText();
sql = "select * from Mstar where chineseName="
; j5 V% F  G& B% w# t; y+ jtf2.getText().toLowerCase().trim() + "or id="
0 Q$ ?: f9 J4 E9 h( y/ X+ jtf3.getText().toLowerCase().trim() + "or engName="
6 }3 c6 d* g1 h9 y" n+ jtf4.getText().toLowerCase().trim() + "or UNIT="
! k- J7 b# }# }% }# U+ jtf5.getText().toLowerCase().trim() + "or TEAM="
+ jtf6.getText().toLowerCase().trim() + "or Phone="
9 ?) T8 X. ]4 @( e8 b+ jtf7.getText().toLowerCase().trim() + "or region="
! T2 Q! M$ z4 E* R5 N. y# l+ jtf8.getText().toLowerCase().trim() + "or busStation="
! F( C& F2 k8 G5 f1 }& ?9 x+ jtf9.getText().toLowerCase().trim();
stmt.executeQuery(sql);
% p: b" ]) _1 _3 T3 Y5 Lrs = stmt.getResultSet();
ResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
while (rs.next()) {
! z) \4 `, Y& {  x5 ?for (int i = 1; i <= cols; i++) {
sb.append(" " + meta.getColumnName(i) + " =");
0 w' r0 U8 D2 s- e9 D1 hsb.append(rs.getString(i));
}
sb.append("\n");
3 ^& [& C- S3 I% Pjta10.setText(sb.toString());
}
! O' B, ?+ _" s' A6 {} catch (SQLException e11) {
e11.printStackTrace();
  X$ O8 a$ u3 r; T" c, J; V/ ]}

}

public void addEmp() {
try {
0 A0 S: T/ \! k7 J, ]. q, cstmt = con.createStatement();
sql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
+ jtf4.getText() + jtf5.getText() + jtf6.getText()
3 d% R( S# S( I$ H: u+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
: l; |. _/ W5 Zint i = stmt.getUpdateCount();
if ((jtf2.getText() != null) && (jtf4.getText() != null)
& C9 ~# @0 `* W2 O0 a- W4 ^&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
stmt.executeUpdate(sql);
7 w% B/ [7 W: I, H1 r' i4 ajta10.setText("添加记录成功" + i + "条");
} else {
6 Q8 ^* ~# y( r7 Y7 P: Jjta10.setText("带*号项为添加记录时不能为空");
9 K& Y; \( {$ q3 ]7 a$ H}
8 A7 \2 `& g* H8 y, }! b9 Z1 p9 C" [} catch (SQLException e1) {
e1.printStackTrace();
}
0 w& I9 T( i* ~0 m& e}

public void deleteEmp() {
searchEmp();
try {
stmt = con.createStatement();
sql = "delete from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
: I& S/ G. a4 @5 r6 }2 C: k" X+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
2 H1 m  n& H4 a' x  Z* S" ]; r+ jtf5.getText().toLowerCase().trim() + "or TEAM="
6 P6 A4 Q7 Q5 m- g: S* P+ jtf6.getText().toLowerCase().trim() + "or Phone="
  @* U( u! k" {- l9 v# ^+ jtf7.getText().toLowerCase().trim() + "or region="
, {" Q; X" e% S9 Y  _4 i8 N) F/ S+ jtf8.getText().toLowerCase().trim() + "or busStation="
+ jtf9.getText().toLowerCase().trim();
- Z2 u8 s# p* v4 ^* Rstmt.executeUpdate(sql);
% n$ n6 V( S! J" hint i = stmt.getUpdateCount();
0 a9 i6 J  [% F5 t( `, jjta10.setText("撤除操作成功" + i + "条");
. _3 a) H$ e; K4 W4 E. q& h; R9 H} catch (SQLException e) {
e.printStackTrace();
) Z0 B# u9 D5 }. |}

}

public void alterEmp() {
0 t  P4 J, a* n( @% p2 R2 l5 JsearchEmp();
" P, ~( L1 K$ q7 z3 Vsql = "update Mstar set chineseName="
+ jtf2.getText().toLowerCase().trim() + "and id="
. q" u4 p1 b: x) ]+ V2 G' Y+ jtf3.getText().toLowerCase().trim() + "and engName="
6 \3 L  ~: ]* y2 T2 N5 f5 i% Z+ jtf4.getText().toLowerCase().trim() + "and UNIT="
+ jtf5.getText().toLowerCase().trim() + "and TEAM="
" c. {4 g; r; F4 ?0 E) A7 ~1 b  f+ jtf6.getText().toLowerCase().trim() + "and Phone="
7 L1 c6 {; [5 h4 _6 t- w4 B+ jtf7.getText().toLowerCase().trim() + "and region="
$ u% C% K3 U! ]' G6 z: Q+ jtf8.getText().toLowerCase().trim() + "and busStation="
+ jtf9.getText().toLowerCase().trim();

int i = 0;
try {
6 h0 g6 C" \& Rstmt.executeUpdate(sql);
i = stmt.getUpdateCount();
# N4 `  S: _, q/ Z- L& f1 F} catch (SQLException e) {
e.printStackTrace();
}
jta10.setText("修改操作成功" + i + "条");
4 H( _0 v$ S4 u2 R9 R- _9 A$ @: q}

public void createGUI() {
' L% N& U2 J% k; m, D$ ZJFrame jf = new JFrame("员工信息管理系统");
jf.setLayout(new GridLayout(2, 1));
// jf.setLayout(new GridLayout(10,2));
+ w$ U6 a: [6 sJPanel jp00 = new JPanel(new GridLayout(5, 4));

JPanel jp1 = new JPanel();
  B. K3 ~1 _- m; o* DJButton jb11 = new JButton("查询");
. r$ C! M! H  g* Y0 \jb11.addActionListener(this);
' H" E& z2 q) @2 GJButton jb12 = new JButton("增加");
jb12.addActionListener(this);
jp1.add(jb11);
: o; L" [3 q7 `$ g  w0 K7 @2 H1 H; ajp1.add(jb12);
jp00.add(jp1);
JPanel jp11 = new JPanel();
JButton jb111 = new JButton("修改");
7 ^0 f% t/ E+ f9 k7 M$ ^jb111.addActionListener(this);
8 ^$ |' @: H2 UJButton jb112 = new JButton("撤除");
jb112.addActionListener(this);
jp11.add(jb111);
1 [# }$ u& a* `5 j( \6 Djp11.add(jb112);
jp00.add(jp11);
, m7 B) Z/ h3 W5 `. }: q) ]2 OJPanel jp2 = new JPanel();
+ y/ @0 _5 F9 o4 }JLabel jl2 = new JLabel("中 文 名 * ");
' Q' j) D7 [4 P8 w0 tjp2.add(jl2);
jp2.add(jtf2);
jp00.add(jp2);
JPanel jp3 = new JPanel();
7 o' T. e- k; u; p3 RJLabel jl3 = new JLabel("工 号 ");
0 E$ j! A5 r7 S- f1 tjp3.add(jl3);
  e& M9 e. C) L- K& x: yjp3.add(jtf3);
0 y8 {7 i- I' c- _jp00.add(jp3);
JPanel jp4 = new JPanel();
JLabel jl4 = new JLabel("EngName*");
: i- [6 d. ?' ]6 G4 Tjp4.add(jl4);
% C2 u- ]/ u9 _' ]+ L. k8 djp4.add(jtf4);
jp00.add(jp4);
JPanel jp5 = new JPanel();
JLabel jl5 = new JLabel("UNIT ");
! g" @& K  o6 A; G1 x7 C0 kjp5.add(jl5);
- W- W/ x; c. B" Jjp5.add(jtf5);
$ [6 Z9 h( j. f# X- ~jp00.add(jp5);
JPanel jp6 = new JPanel();
) D: B* c- d1 PJLabel jl6 = new JLabel("TEAM* ");
2 K; O; L1 N: B2 K% ajp6.add(jl6);
( V6 K9 _- i, U+ u/ \: q! a' @" qjp6.add(jtf6);
jp00.add(jp6);
3 [; Y+ b5 L# H7 T* d6 [) fJPanel jp7 = new JPanel();
JLabel jl7 = new JLabel("Phone* ");
1 n+ Y0 z7 I' @$ c( hjp7.add(jl7);
jp7.add(jtf7);
jp00.add(jp7);
JPanel jp8 = new JPanel();
JLabel jl8 = new JLabel("区域 ");
jp8.add(jl8);
  u' g* D9 r0 u! l* {6 z- M3 j8 N9 e2 ejp8.add(jtf8);
jp00.add(jp8);
JPanel jp9 = new JPanel();
( H1 Y/ I* A4 [! K+ ?' @/ t) {- cJLabel jl9 = new JLabel("公交站 ");
  `1 G# [1 N( Y! Wjp9.add(jl9);
jp9.add(jtf9);
jp00.add(jp9);
  K. F5 r' E- njf.add(jp00);
4 D: B8 F) o# w" I$ v9 CJPanel jp01 = new JPanel();
jta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
% D9 w: _0 @8 g% ]8 {" w3 ]jp01.add(jta10);
" W" s' }6 t+ b; b' E# fjf.add(jp01);
  c2 S+ P! e1 h! Pjf.setSize(700, 500);
jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jf.setVisible(true);

}

public static void main(String[] args) {
new EmpManageSys();
; K( X9 d3 m/ u% `+ f) p}
2 v$ J3 f: @6 a; E0 f4 I6 r}

蕾蕾

//---------------------------------------------------------------------
: U2 L' I- \& C4 t, cSQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
import java.sql.*;
public class JdbcUtil
5 z/ o& h# L) V& M" u{
//load driver from file
static{
try{
$ U) A& X* n* ^; K( wString driverName =
$ i7 |. n, w& A0 G) u! t: F"oracle.jdbc.driver.OracleDriver";
( |2 j; `( Y8 L8 O2 o4 JClass.forName(driverName);
}catch(Exception e){
e.printStackTrace();
}
4 {: N$ m( M) O6 k) b$ A) `" s}
//establish connection
; y( ]6 X6 s3 X* X$ S8 ~$ xpublic static Connection getConnection(){
Connection con = null;
try{
String url =
8 l2 ~8 W  Q$ k0 g5 J2 x0 s/ E"jdbcracle:thin192.168.0.26:1521:tarena";
String usr = "openlab";
! S6 b, w8 }  aString pwd = "open123";
2 T/ c6 {# V0 _  n3 I1 L" P. dcon = DriverManager.getConnection(
1 a* m7 X6 R# h9 G0 Y/ M5 Eurl,usr,pwd);
- f( Q" L7 n  c' d1 F}catch(Exception e){
( i7 t; y8 v/ F8 S; C/ Me.printStackTrace();
- Q6 V5 i  ~9 N6 c6 h, I! G- l: |}
+ _% \/ d3 k1 y2 I5 K, P8 ]4 Zreturn con;
}
; F9 G/ X! l( R6 L! T
//close resultSet,statement and connection
6 H1 H  K/ J$ }  I* Y8 `' n2 Apublic static void close(ResultSet rs,Statement stmt,Connection con){
, W( }7 j6 s8 ztry{
& ^6 E: H. `# ^  [* vif(rs!=null) rs.close();
}catch(Exception ex){
ex.printStackTrace();
  G8 E" y3 u0 l# v}
0 I& [4 I% J5 p( [4 xtry{
if(stmt!=null) stmt.close();
}catch(Exception ex){
ex.printStackTrace();
+ ~$ o' s2 J3 P2 Y$ |}
try{
if(con!=null) con.close();
2 G$ u1 H& K9 i& {  J}catch(Exception ex){
7 O* s5 \, O) T6 z8 zex.printStackTrace();
( m+ m4 H4 S. A" ]" T}
}
% ~7 |. e) @& H9 m}