Swing JDBC程序

package edu; import java.awt.BorderLayout; import java.awt.Container; import java.awt.Dimension; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.awt.event.MouseListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.awt.event.WindowListener; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import javax.swing.*; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableModel; import javax.swing.text.html.MinimalHTMLWriter; import javax.swing.text.rtf.RTFEditorKit; import org.omg.CORBA.OBJ_ADAPTER; import dbconn.SQLServer; public class EmpMain implements MouseListener { public static void main(String[] args) { new EmpMain(); } public JTable table = new JTable();// 数据显示 JPanel panel = new JPanel(); JFrame frame = new JFrame(); JTextField txtId; JTextField txtName; JTextField txtPwd; JTextField txtSex; JTextField txtAge; JTextField txtAddress; JTextField txtCompany; JCheckBox checkBox = new JCheckBox(); public static SQLServer server = new SQLServer(); public ResultSet resultSet; public PreparedStatement ps = null; String[] temp = new String[100]; private JButton bthNextPage, bthBackPage, bthSelect;// 上一页，下一页 private JButton bthAddEmp, bthDelEmp, bthUpdate;// 编辑,添加 private static DefaultTableModel tableModel = new DefaultTableModel(); private DefaultTableModel currenTableModel = new DefaultTableModel(); public EmpMain() { this.addWindowListener(new WindowAdapter() { @Override public void windowClosing(WindowEvent e) { // TODO Auto-generated method stub System.exit(0); } }); bthNextPage = new JButton("下一页"); bthBackPage = new JButton("上一页"); bthSelect = new JButton("查询"); bthAddEmp = new JButton("添加"); bthDelEmp = new JButton("删除"); bthUpdate = new JButton("修改"); txtId = new JTextField(3); txtName = new JTextField(6); txtPwd = new JTextField(6); txtSex = new JTextField(6); txtAge = new JTextField(6); txtAddress = new JTextField(6); txtCompany = new JTextField(6); // getContentPane().add(panel); panel.add(txtId); panel.add(txtName); panel.add(txtPwd); panel.add(txtSex); panel.add(txtAge); panel.add(txtAddress); panel.add(txtCompany); panel.add(bthBackPage); panel.add(bthNextPage); panel.add(bthAddEmp); panel.add(bthDelEmp); panel.add(bthUpdate); panel.add(bthSelect); frame.add(panel, BorderLayout.SOUTH); frame.setTitle("表格"); frame.setVisible(true); frame.pack(); frame.setBounds(400, 600, 950, 350); JScrollPane scrollPane = new JScrollPane(); scrollPane.setSize(new Dimension(20, 20)); scrollPane.setViewportView(table); frame.add(scrollPane, BorderLayout.CENTER); frame.add(scrollPane, BorderLayout.CENTER); // 鼠标单击jtable的事件,将选中的值传到JTextFile table.addMouseListener(new MouseAdapter() { public void mouseReleased(MouseEvent e) { // TODO Auto-generated method stub // 获取被选中行的第一个下标 int selectRow = table.getSelectedRow(); if (table.getValueAt(table.getSelectedRow(), 0) != null) { if (e.getClickCount() == 2) { System.out.println("你双击的jtable"); String information = "编号：" + txtId.getText() + "\n姓名 : " + txtName.getText() + "\n密码：" + txtPwd.getText() + "\n性别 : " + txtSex.getText() + "\n年龄 ：" + txtAge.getText() + "\n住址 ：" + txtAddress.getText() + "\n公司 ：" + txtCompany.getText(); JOptionPane.showMessageDialog(null, information); } if (e.getClickCount() == 1) { System.out.println("你单击了jtable"); currenTableModel = (DefaultTableModel) table.getModel(); System.out.println("你选择的行数据下标是：" + selectRow); Object oa = currenTableModel.getValueAt(selectRow, 0); Object ob = currenTableModel.getValueAt(selectRow, 1); Object oc = currenTableModel.getValueAt(selectRow, 2); Object od = currenTableModel.getValueAt(selectRow, 3); Object oe = currenTableModel.getValueAt(selectRow, 4); Object of = currenTableModel.getValueAt(selectRow, 5); Object og = currenTableModel.getValueAt(selectRow, 6); txtId.setEnabled(false); txtId.setText(oa.toString()); txtName.setText(ob.toString()); txtPwd.setText(oc.toString()); txtSex.setText(od.toString()); txtAge.setText(oe.toString()); txtAddress.setText(of.toString()); txtCompany.setText(og.toString()); // // 对翻页前的数据后和翻页后的数据进行判断 // 选中测试 System.out.println(txtId.getText()); System.out.println(txtName.getText()); System.out.println(txtPwd.getText()); System.out.println(txtSex.getText()); System.out.println(txtAge.getText()); System.out.println(txtAddress.getText()); System.out.println(txtCompany.getText()); } } } }); // 查询的事件 bthSelect.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub selectEmp(); } }); // 添加员工 bthAddEmp.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent arg0) { // TODO Auto-generated method stub new addEmployee(); } }); // 更新数据 bthUpdate.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub if (!txtId.getText().equals("") && !txtName.getText().equals("") && !txtPwd.getText().equals("") && !txtSex.getText().equals("") && !txtAge.getText().equals("") && !txtAddress.getText().equals("") && !txtCompany.getText().equals("")) { Employee emplpyee = new Employee(); emplpyee.setId((Integer.parseInt(txtId.getText()))); emplpyee.setEmpName(txtName.getText()); emplpyee.setEmpPassword(txtPwd.getText()); emplpyee.setEmpSex(txtSex.getText()); emplpyee.setAge(Integer.parseInt(txtAge.getText())); emplpyee.setAddress(txtAddress.getText()); emplpyee.setCompany(txtCompany.getText()); boolean flag = EmpMain.updateEmp(emplpyee); if (flag) { JOptionPane.showMessageDialog(null, "更新成功"); selectEmp(); System.out.println("更新后的重新加载的当前页：" + index); // selectEmp(); } else { JOptionPane.showMessageDialog(null, "更新失败"); } } else { JOptionPane.showMessageDialog(null, "请填写相应的信息"); } } }); bthDelEmp.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub if (e.getSource() == bthDelEmp) { if (!txtId.getText().equals("")) { String key = txtId.getText(); boolean flag = EmpMain.delEmployee(key); if (flag) { System.out.println("删除成功！"); JOptionPane.showMessageDialog(null, "删除成功"); selectEmp(); } else { JOptionPane.showMessageDialog(null, "删除失败"); } } } } }); // 下一页 bthNextPage.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub // 当前数据可分的页数 int pageCount = tableModel.getRowCount() % 5 == 0 ? tableModel .getRowCount() / 5 : tableModel.getRowCount() / 5 + 1; index++; // 如果当前页码<= 数据可分的页数