Java+mysql人事管理系统

package net.myManage.System; import javax.swing.*; import java.awt.*; import java.awt.event.*; import javax.swing.table.*; import java.sql.*; import java.util.*; import java.io.*; public class Attend extends JPanel implements ActionListener { private JSplitPane jsp=new JSplitPane(JSplitPane.VERTICAL_SPLIT); private JPanel jpt=new JPanel(); String[] str=new String[8]; DataBase db; String sql; Vector<String[]> v; int count=0; private JLabel[] jlArray = { new JLabel(" 职 工 ID"), new JLabel(" 姓 名"), new JLabel(" 年 月"), new JLabel(" 迟 到"), new JLabel(" 早 退"), new JLabel(" 公 休 假"), new JLabel(" 病 假"), new JLabel(" 事 假") }; private JLabel jl=new JLabel("(查询请输入职工ID或年月)"); private JTextField[] jtxtArray=new JTextField[] { new JTextField(), new JTextField(), new JTextField(), new JTextField(), new JTextField(), new JTextField(), new JTextField(), new JTextField() }; //设置JButton按钮的文本 private JButton[] jbArray = { new JButton("最前"), new JButton("上一个"), new JButton("下一个"), new JButton("最后"), new JButton("添加记录"), new JButton("修改记录"), new JButton("查询"), new JButton("清空") }; //创建标题 Vector<String> head = new Vector<String>(); { head.add("职工ID"); head.add("姓名"); head.add("年月"); head.add("迟到"); head.add("早退"); head.add("公休假"); head.add("病假"); head.add("事假"); } //在下部子窗口中设置表格 Vector<Vector> data=new Vector<Vector>(); //创建表格模型 DefaultTableModel dtm=new DefaultTableModel(data,head); //创建Jtable对象 JTable jt=new JTable(dtm); //将JTable封装到滚动窗格 JScrollPane jspn=new JScrollPane(jt); public Attend() { this.setLayout(new GridLayout(1,1)); //设置面板的上部分为空布局管理器 jpt.setLayout(null); //设置jspt中分割条的初始位置 jsp.setDividerLocation(210); //设置分隔条的宽度 jsp.setDividerSize(4); jsp.setTopComponent(jpt); jsp.setBottomComponent(jspn); for(int i=0;i<8;i++) { jpt.add(jtxtArray[i]); jpt.add(jlArray[i]); if(i<4) { jlArray[i].setBounds(15+i*160,20,70,20); jtxtArray[i].setBounds(85+i*160,20,90,20); jtxtArray[i].addActionListener(this); } else { jlArray[i].setBounds(15+(i-4)*160,60,70,20); jtxtArray[i].setBounds(85+(i-4)*160,60,90,20); jtxtArray[i].addActionListener(this); } } this.add(jsp); jpt.add(jl); jl.setBounds(325,170,150,20); //设置下部子窗格 jsp.setBottomComponent(jspn); //将JButton添加进jpt,设置监听器 for(int i=0;i<8;i++) { jpt.add(jbArray[i]); if(i<4) { jbArray[i].setBounds(55+150*i,100,100,25); } else { jbArray[i].setBounds(55+150*(i-4),140,100,25); } jbArray[i].addActionListener(this); } db = new DataBase(); v=db.getMessage(); db.dbClose(); //设置窗体的大小位置及可见性 this.setBounds(5,5,600,500); this.setVisible(true); } public void actionPerformed(ActionEvent e) { /*if(e.getSource()==jtxtArray[0]) { jtxtArray[1].requestFocus(); } if(e.getSource()==jtxtArray[1]) { jtxtArray[2].requestFocus(); } if(e.getSource()==jtxtArray[2]) { jtxtArray[3].requestFocus(); } if(e.getSource()==jtxtArray[3]) { jtxtArray[4].requestFocus(); } if(e.getSource()==jtxtArray[4]) { jtxtArray[5].requestFocus(); } if(e.getSource()==jtxtArray[5]) { jtxtArray[6].requestFocus(); } if(e.getSource()==jtxtArray[6]) { jtxtArray[7].requestFocus(); } */ if(e.getSource()==jbArray[4]) { this.insert(); } if(e.getSource()==jbArray[5]) { this.update(); } if(e.getSource()==jbArray[6]) { this.select(); } if(e.getSource()==jbArray[7]) { for(int i=0;i<8;i++) { jtxtArray[i].setText(""); } } if(e.getSource()==jbArray[0]) { this.first(); } if(e.getSource()==jbArray[1]) { if(count==0) { count=v.size()-1; } else { count--; } String[] str = v.get(count); for(int i=0;i<8;i++) { jtxtArray[i].setText(str[i]); } } if(e.getSource()==jbArray[2]) { if(count==(v.size()-1)) { count=0; } else { count++; } String[] str= v.get(count); for(int i=0;i<8;i++) { jtxtArray[i].setText(str[i]); } } if(e.getSource()==jbArray[3]) { this.last(); } } public void select() { String s1=jtxtArray[0].getText().trim(); String s2=jtxtArray[2].getText().trim(); if(s1.equals("")&&s2.equals("")) { JOptionPane.showMessageDialog(this,"请输入职工ID或年月！！！", "信息",JOptionPane.INFORMATION_MESSAGE); return; } if(!s1.equals("")&&s2.equals("")) { sql="select * from Attend where EmployeeID="+Integer.parseInt(s1); db=new DataBase(); db.selectDb(sql); try { Vector <Vector> v=new Vector<Vector>(); while(db.rs.next()) { Vector <String> vtemp = new Vector<String>(); for(int i=0;i<8;i++) { String str1=new String(db.rs.getString(i+1).getBytes(),"gbk"); vtemp.add(str1); } v.add(vtemp); } if(v.size()==0) { JOptionPane.showMessageDialog(this,"您所查询的职工信息不存在！！","提示", JOptionPane.INFORMATION_MESSAGE); db.dbClose() ; return; } //更新table dtm.setDataVector(v,head); jt.updateUI(); jt.repaint(); JOptionPane.showMessageDialog(this,"您已经成功查询该职工信息！！","提示", JOptionPane.INFORMATION_MESSAGE); jtxtArray[0].setText(""); db.dbClose() ; return; } catch(Exception ep) { ep.printStackTrace(); } } if(s1.equals("")&&!s2.equals("")) { sql="select * from Attend where Time='"+s2+"'"; db=new DataBase(); db.selectDb(sql); try { Vector <Vector> v=new Vector<Vector>(); while(db.rs.next()) { Vector <String> vtemp = new Vector<String>(); for(int i=0;i<8;i++) { String str1=new String(db.rs.getString(i+1).getBytes(),"gbk"); vtemp.add(str1); } v.add(vtemp); } if(v.size()==0) { JOptionPane.showMessageDialog(this,"您所查询的职工信息不存在！！","提示", JOptionPane.INFORMATION_MESSAGE); db.dbClose() ; return; } //更新table dtm.setDataVector(v,head); jt.updateUI(); jt.repaint(); JOptionPane.showMessageDialog(this,"您已经成功查询该职工信息！！","提示", JOptionPane.INFORMATION_MESSAGE); jtxtArray[2].setText(""); db.dbClose() ; return; } catch(Exception e) { e.printStackTrace(); } } if(!s1.equals("")&&!s2.equals("")) { sql="select * from Attend where Time='"+s2+" and Attend.EmployeeID="+Integer.parseInt(s1); db=new DataBase(); db.selectDb(sql); try { Vector <Vector> v=new Vector<Vector>(); while(db.rs.next()) { Vector <String> vtemp = new Vector<String>(); for(int i=0;i<8;i++) { String str1=new String(db.rs.getString(i+1).getBytes(),"gbk"); vtemp.add(str1); } v.add(