1、Java课程设计人事管理系统的设计与实现课 程 设 计 课程名称 Java语言课程设计 题目名称 人事管理系统的设计与实现 学生学院 专业班级_ _ _学 号 学生姓名 指导教师 2012年6月8日一、 设计内容自学Swing图形界面设计和数据库程序设计。开发用于某单位的人事管理系统。该系统要求实现以下功能：员工信息管理（包括：员工信息一览表、新员工的建立、修改、删除）二、 设计方案1、使用Netbeans IDE 7.1和SQL Server2000进行编译。2、代码如下：登录按钮代码： private void jTextField1ActionPerformed(java.awt.eve
2、nt.ActionEvent evt) private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) String user = jTextField1.getText().trim(); String password = jTextField2.getText().trim(); if (user.equals(wsm) & password.equals(wsm) new yuangongxinxiguanli().setVisible(true); setVisible(false); else JOption
3、Pane.showMessageDialog(null, 请正确输入！); public static void main(String args) java.awt.EventQueue.invokeLater(new Runnable() public void run() new denglu().setVisible(true); ); 员工信息关系系统界面：package 人事管理系统;public class yuangongxinxiguanli extends javax.swing.JFrame public yuangongxinxiguanli() initCompone
4、nts(); setLocation(450,220); SuppressWarnings(unchecked) / private void initComponents() jButton1 = new javax.swing.JButton(); jButton2 = new javax.swing.JButton(); jButton3 = new javax.swing.JButton(); jLabel1 = new javax.swing.JLabel(); jButton4 = new javax.swing.JButton(); jButton5 = new javax.sw
5、ing.JButton(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jButton1.setText(查询员工信息); jButton1.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent evt) jButton1ActionPerformed(evt); ); jButton2.setText(添加员工信息); jButton2
6、.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent evt) jButton2ActionPerformed(evt); ); jButton3.setText(删除员工信息); jButton3.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent evt) jBu
7、tton3ActionPerformed(evt); ); jLabel1.setFont(new java.awt.Font(宋体, 0, 24); / NOI18N jLabel1.setText(员工信息管理系统); jButton4.setText(修改员工信息); jButton4.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent evt) jButton4ActionPerformed(evt); ); jButto
8、n5.setText(退出系统); jButton5.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent evt) jButton5ActionPerformed(evt); ); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane(); getContentPane().setLayout(layout); layout.setH
9、orizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(91, 91, 91) .addGroup(layout.createParallelG
10、roup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jButton1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addCompone
11、nt(jButton2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.Gro
12、upLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGroup(layout.createSequentialGroup() .addGap(47, 47, 47) .addComponent(jLabel1) .addContainerGap(52, Short.MAX_VALUE) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup()
13、 .addGap(14, 14, 14) .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 37, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.Com
14、ponentPlacement.UNRELATED) .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PR
15、EFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jButton5, javax.swing.
16、GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(36, Short.MAX_VALUE) ); pack(); / private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) chaxun ch=new chaxun(); ch.setVisible(true); ch.setLocation(400,220); setVisible(false); private void jButto
17、n2ActionPerformed(java.awt.event.ActionEvent evt) tianjia ti=new tianjia(); ti.setVisible(true); ti.setLocation(400,220); setVisible(false);/ TODO add your handling code here: private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) xiugai xi=new xiugai(); xi.setVisible(true); xi.setLoca
18、tion(400,220); setVisible(false);/ TODO add your handling code here: private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) shanchu sh=new shanchu(); sh.setVisible(true); sh.setLocation(400,220); setVisible(false); private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) Sy
19、stem.exit(0); public static void main(String args) java.awt.EventQueue.invokeLater(new Runnable() public void run() new yuangongxinxiguanli().setVisible(true); ); / Variables declaration - do not modify private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.J
20、Button jButton3; private javax.swing.JButton jButton4; private javax.swing.JButton jButton5; private javax.swing.JLabel jLabel1; / End of variables declaration 查询按钮代码：可选择项查询按钮代码： private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) try String xuanze= jComboBox1.getSelectedItem().toSt
21、ring().trim(); String tianxie=jTextField1.getText().trim(); Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver); String url=jdbc:microsoft:sqlserver: + /127.0.0.1:1433;DatabaseName=员工信息管理库; Connection con=DriverManager.getConnection(url,sa,900526); java.sql.Statement stmt=con.createStatement
22、(); ResultSet rs=stmt.executeQuery(select * from 员工 where +xuanze+=+tianxie+); DefaultTableModel dt=(DefaultTableModel) jTable1.getModel(); dt.getDataVector().clear(); dt.fireTableDataChanged(); while(rs.next () Vector v1=new Vector(); v1.add(rs.getString(1); v1.add(rs.getString(2); v1.add(rs.getStr
23、ing(3); v1.add(rs.getString(4); v1.add(rs.getString(5); v1.add(rs.getString(6); v1.add(rs.getString(7); dt.addRow(v1); dt.fireTableDataChanged(); rs.close(); stmt.close(); con.close(); catch (ClassNotFoundException ex) ex.getMessage(); catch(SQLException ex) ex.getMessage(); 查询全部信息按钮代码： private void
24、 jButton3ActionPerformed(java.awt.event.ActionEvent evt) try Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver); String url=jdbc:microsoft:sqlserver: + /127.0.0.1:1433;DatabaseName=员工信息管理库; Connection con=DriverManager.getConnection(url,sa,900526); java.sql.Statement stmt=con.createStatemen
25、t(); ResultSet rs=stmt.executeQuery(select * from 员工); DefaultTableModel dt=(DefaultTableModel) jTable1.getModel(); dt.getDataVector().clear(); while(rs.next () Vector v1=new Vector(); v1.add(rs.getString(1); v1.add(rs.getString(2); v1.add(rs.getString(3); v1.add(rs.getString(4); v1.add(rs.getString
26、(5); v1.add(rs.getString(6); v1.add(rs.getString(7); dt.addRow(v1); dt.fireTableDataChanged(); rs.close(); stmt.close(); con.close(); catch (ClassNotFoundException ex) Logger.getLogger(chaxun.class.getName().log(Level.SEVERE, null, ex); catch(SQLException ex) ex.getMessage(); public static void main
27、(String args) java.awt.EventQueue.invokeLater(new Runnable() public void run() new chaxun().setVisible(true); ); 添加界面代码： private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) try String yuangonghao = jtf_yuangonghao.getText().trim(); String phonenumber = jtf_phonenumber.getText().trim
28、(); String name = jtf_name.getText().trim(); String age = jtf_age.getText().trim(); String sex = jtf_sex.getText().trim(); String post = jtf_post.getText().trim(); String pay = jtf_pay.getText().trim(); Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver); String url = jdbc:microsoft:sqlserve
29、r: + /127.0.0.1:1433;DatabaseName=员工信息管理库; Connection con = DriverManager.getConnection(url, sa, 900526); String str=insert into 员工 values(?,?,?,?,?,?,?); PreparedStatement stmt = con.prepareStatement(str); stmt.setString(1,yuangonghao); stmt.setString(2,name); stmt.setString(3,age); stmt.setString(
30、4,sex); stmt.setString(5,post); stmt.setString(6,phonenumber); stmt.setString(7,pay); ResultSet rs=stmt.executeQuery(); rs.close(); stmt.close(); con.close(); catch (ClassNotFoundException ex) catch (SQLException ex) if (ex.getSQLState().equals(HY000) JOptionPane.showMessageDialog(null, 添加成功); if(ex.getSQLState().e
