Java+Swing+mysql员工工资管理系统

package salary; import javax.swing.*; import javax.swing.table.DefaultTableModel; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.util.List; public class MainFrame extends JFrame { JLabel jLabel = new JLabel("请输入员工姓名"); JTextField jtextField = new JTextField(); JButton selBtn = new JButton("查询"); JButton addBtn = new JButton("添加"); JButton modBtn = new JButton("修改"); JButton delBtn = new JButton("删除"); DefaultTableModel model = new DefaultTableModel(); JTable jTable = new JTable(model); JScrollPane jScrollPane = new JScrollPane(jTable,20,30); SalaryDao salaryDao = new SalaryDao(); MainFrame frame = this; public void btnAlistener(){ selBtn.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { String text = jtextField.getText(); List<Salary> list; if (text.equals("")){ list = salaryDao.findAll(); }else{ list = salaryDao.selectName(text); } Object [][] objectes = new Object[list.size()][6]; for (int i = 0; i < list.size(); i++) { objectes[i][0] = list.get(i).id; objectes[i][1] = list.get(i).name; objectes[i][2] = list.get(i).dep; objectes[i][3] = list.get(i).position; objectes[i][4] = list.get(i).salary; objectes[i][5] = list.get(i).sentdate; } Object [][] data1 = objectes; Object [] table = {"员工号","姓名","部门","职位","工资","发放日期"}; model.setDataVector(data1,table); } }); addBtn.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { new addFrame(frame); } }); modBtn.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { int i = jTable.getSelectedRow(); if(i>=0) { int index1 = jTable.getSelectedRow();//获取选中的行 int id = (Integer) jTable.getValueAt(index1, 0); String name = (String) jTable.getValueAt(i, 1); String dep = (String) jTable.getValueAt(i, 2); String position = (String) jTable.getValueAt(i, 3); String salary = (String) jTable.getValueAt(i, 4); String sentdate = (String) jTable.getValueAt(i, 5); System.out.print(id); updateFrame modFrame= new updateFrame(frame); modFrame.jTextField0.setText(id+""); modFrame.jTextField1.setText(name); modFrame.jTextField2.setText(dep); modFrame.jTextField3.setText(position); modFrame.jTextField4.setText(salary); modFrame.jTextField5.setText(sentdate); }else { JOptionPane.showMessageDialog(null,"请选择要修改的记录"); } } }); delBtn.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { int i = jTable.getSelectedRow(); if(i>=0) { int index1 = jTable.getSelectedRow();//获取选中的行 int id = (Integer) jTable.getValueAt(index1, 0); System.out.print(id); int j = salaryDao.Del(id); if(j>0) { JOptionPane.showMessageDialog(null,"删除记录成功"); setJSP(); } }else { JOptionPane.showMessageDialog(null,"请选择要删除的记录"); } } }); } public void setSizeCpn(){ jLabel.setBounds(100,20,200,100); jtextField.setBounds(315,50,200,40); selBtn.setBounds(530,50,80,40); addBtn.setBounds(250,500,80,40); modBtn.setBounds(350,500,80,40); delBtn.setBounds(450,500,80,40); jScrollPane.setBounds(40,120,700,380); } public void setJSP(){ Object [][] data = getTdata(); Object [] table = {"员工号","姓名","部门","职位","工资","发放日期"}; model.setDataVector(data,table); } public Object[][] getTdata(){ List<Salary> list = salaryDao.findAll(); Object [][] objects = new Object[list.size()][6]; for (int i = 0; i < list.size(); i++) { objects[i][0] = list.get(i).id; objects[i][1] = list.get(i).name; objects[i][2] = list.get(i).dep; objects[i][3] = list.get(i).position; objects[i][4] = list.get(i).salary; objects[i][5] = list.get(i).sentdate; } return objects; } public void addCpn(){ add(jLabel); add(jtextField); add(selBtn); add(addBtn); add(modBtn); add(delBtn); add(jScrollPane); } public void setFont(){ Font font = new Font("黑体",Font.BOLD,25); jLabel.setFont(font); Font font1 = new Font("黑体",Font.BOLD,20); selBtn.setFont(font1); addBtn.setFont(font1); modBtn.setFont(font1); delBtn.setFont(font1); } public void login(){ setFont(); setSizeCpn(); addCpn(); setJSP(); btnAlistener(); } public MainFrame() { setLayout(null); login(); setTitle("员工工资管理系统"); setSize(800,600); setLocationRelativeTo(null); setVisible(true); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } public static void main(String[] args) { new MainFrame(); } }