基于Java+Swing+mysql用户信息管理系统

package view; import java.awt.Dimension; import java.awt.EventQueue; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JScrollPane; import javax.swing.JPanel; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.WindowConstants; import java.awt.BorderLayout; import java.awt.CardLayout; import java.awt.Color; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.SQLException; import java.util.List; import javax.swing.table.DefaultTableCellRenderer; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableColumn; import dao.UserDao; import entity.User; public class UserFrame extends JFrame { // 定义布局 BorderLayout mainLayout = new BorderLayout(); CardLayout layout = new CardLayout(); JFrame bamFrame; MainPanel mainPanel = new MainPanel();// 主面板 JPanel upPanel = new JPanel();// 主面板中的---上面板 JPanel downPanel = new JPanel();// 主面板中的---下面板 AddUserPanel addUserPanel = new AddUserPanel(); UpdateUserPanel updateUserPanel = new UpdateUserPanel(); final Object[] columnNames = {"编号", "用户名", "密码"}; //列名最好用final修饰 UserDao userdao = new UserDao(); Object[][] rowData = queryUser(""); DefaultTableModel model = new DefaultTableModel(rowData,columnNames); JTable dataTable = new JTable (model); JScrollPane pane1; JScrollPane pane2; JScrollPane pane3; public UserFrame() { downPanel.setLayout(layout); //dataTable.setPreferredScrollableViewportSize(new Dimension(650, 100));//设置表格的大小 dataTable.setRowHeight (30);//设置每行的高度为20 dataTable.setRowHeight (0, 20);//设置第1行的高度为15 dataTable.setRowMargin (5);//设置相邻两行单元格的距离 dataTable.setSelectionBackground (Color.white);//设置所选择行的背景色 dataTable.setSelectionForeground (Color.blue);//设置所选择行的前景色 //friends.setGridColor (Color.black);//设置网格线的颜色 dataTable.selectAll ();//选择所有行 //dataTable.setRowSelectionInterval (1,2);//设置初始的选择行,这里是1到3行都处于选择状态 dataTable.clearSelection ();//取消选择 dataTable.setDragEnabled (false);//不懂这个 dataTable.setShowGrid (false);//是否显示网格线 dataTable.setShowHorizontalLines (false);//是否显示水平的网格线 dataTable.setShowVerticalLines (true);//是否显示垂直的网格线 //friends.setValueAt ("tt", 0, 0);//设置某个单元格的值,这个值是一个对象 dataTable.doLayout (); dataTable.setBackground (Color.lightGray); // 设置表格中的数据居中显示 DefaultTableCellRenderer r=new DefaultTableCellRenderer(); r.setHorizontalAlignment(JLabel.CENTER); dataTable.setDefaultRenderer(Object.class,r); pane1 = new JScrollPane (addUserPanel);//JTable最好加在JScrollPane上 pane1.setPreferredSize(new Dimension (450,300)); pane2 = new JScrollPane (updateUserPanel);//JTable最好加在JScrollPane上 pane2.setPreferredSize(new Dimension (450,300)); //JScrollPane pane2 = new JScrollPane (example2); pane3 = new JScrollPane (dataTable); pane3.setPreferredSize(new Dimension (450,300)); downPanel.add("cardSelect", pane3);// 卡片一 (查询) downPanel.add("cardUpdate", pane2);// 卡片一 (修改) downPanel.add("cardAdd", pane1);// 卡片一 (添加) upPanel.add(mainPanel); //downPanel.add(addCoursePanel); //downPanel.add(pane1); // 定义主窗体 bamFrame = new JFrame("用户信息管理"); bamFrame.setLayout(mainLayout); bamFrame.setSize(550, 400);// 设定窗体大小 // 给窗体加面板 bamFrame.add(upPanel, BorderLayout.NORTH); bamFrame.add(downPanel, BorderLayout.SOUTH); addListeners();// 调用监听方法 bamFrame.setDefaultCloseOperation(WindowConstants.HIDE_ON_CLOSE); //bamFrame.pack(); bamFrame.setVisible(true); //设置窗口居中 bamFrame.setLocationRelativeTo(null); } // 窗体中部分对象监听方法 private void addListeners() { // 查询按钮 mainPanel.getSelectButton().addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String username = mainPanel.getUserNameField().getText(); System.out.print(username); Object[][] rowData2 = queryUser(username); model.setDataVector(rowData2, columnNames); layout.show(downPanel, "cardSelect"); } }); // 添加按钮 mainPanel.getAddButton().addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { layout.show(downPanel, "cardAdd"); } }); // 添加按钮 mainPanel.getUpdateButton().addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { int i = dataTable.getSelectedRow(); if(i>=0) { String uuid = (String) dataTable.getValueAt(i, 0); String username = (String) dataTable.getValueAt(i, 1); String password = (String) dataTable.getValueAt(i, 2); updateUserPanel.getUuidText().setText(uuid); updateUserPanel.getUsernameText().setText(username); updateUserPanel.getPasswordText().setText(password); layout.show(downPanel, "cardUpdate"); }else { JOptionPane.showMessageDialog(downPanel, "请选择要修改的用户信息！"); return; } } }); // 点击《提交》按钮 addUserPanel.getOkButton().addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String uuid = addUserPanel.getUuidText().getText(); String username = addUserPanel.getUsernameText().getText(); String password = addUserPanel.getPasswordText().getText(); if(uuid.equals("")) { JOptionPane.showMessageDialog(downPanel, "编号不能为空！"); return; } if(username.equals("")) { JOptionPane.showMessageDialog(downPanel, "用户名不能为空！"); return; } if(password.equals("")) { JOptionPane.showMessageDialog(downPanel, "密码不能为空！"); return; } int j= userdao.addUser(uuid,username,password); if(j>0) { JOptionPane.showMessageDialog(downPanel, "用户信息添加成功！"); addUserPanel.getUuidText().setText(""); addUserPanel.getUsernameText().setText(""); addUserPanel.getPasswordText().setText(""); }else{ JOptionPane.showMessageDialog(downPanel, "用户信息添加失败！"); } } }); // 点击《返回》按钮 addUserPanel.getBackButton().addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { Object[][] rowData2 = queryUser(""); model.setDataVector(rowData2, columnNames); layout.show(downPanel, "cardSelect"); } }); // 点击《提交》按钮 updateUserPanel.getOkButton().addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String uuid = updateUserPanel.getUuidText().getText(); String username = updateUserPanel.getUsernameText().getText(); String password = updateUserPanel.getPasswordText().getText(); int i= userdao.updateUser(uuid, username, password); if(i>0) { JOptionPane.showMessageDialog(downPanel, "用户信息修改成功！"); Object[][] rowData2 = queryUser(""); model.setDataVector(rowData2, columnNames); layout.show(downPanel, "cardSelect"); }else{ JOptionPane.showMessageDialog(downPanel, "用户信息修改失败！"); } } }); // 点击《返回》按钮 updateUserPanel.getBackButton().addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { Object[][] rowData2 = queryUser(""); model.setDataVector(rowData2, columnNames); layout.show(downPanel, "cardSelect"); } }); // 点击《删除》按钮 mainPanel.getDelButton().addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { int i = dataTable.getSelectedRow(); if(i>=0) { String uuid = (String) dataTable.getValueAt(i, 0); int j