java（swing）+ mysql实现学生信息管理系统源码

import java.awt.BorderLayout;import java.awt.Color;import java.awt.Font;import java.awt.GridLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.List;import javax.swing.BorderFactory;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.JTextArea;import javax.swing.table.AbstractTableModel;import javax.swing.text.BadLocationException;/*  DROP DATABASE IF EXISTS `myproject`;  CREATE DATABASE myproject DEFAULT CHARSET utf8 COLLATE utf8_general_ci;  USE ABC;  SET NAMES utf8mb4;  SET FOREIGN_KEY_CHECKS = 0;  DROP TABLE IF EXISTS `student`;  CREATE TABLE `student` (  `id` varchar(36) NOT NULL,  `name` varchar(36) NOT NULL,  `age` varchar(36) NOT NULL  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;  SET FOREIGN_KEY_CHECKS = 1; *  * */public class Test extends JFrame { private static final long serialVersionUID = 1L; private JTable table; private JPanel panel; private JScrollPane scrollpane; private JButton button1, button2, button3; private JTextArea text1, text2, text3; private List<Student> stu; public Test() throws BadLocationException, SQLException { super("学生信息"); this.setSize(500, 340); this.add(getJScrollPane(stu), BorderLayout.CENTER); this.add(getJPanel(), BorderLayout.SOUTH); this.setResizable(true); this.setLocation(300, 300); this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } // 设置JScrollPane方法 private JScrollPane getJScrollPane(List<Student> stu) throws SQLException { if (scrollpane == null) {  scrollpane = new JScrollPane();  scrollpane.setViewportView(getJTable(stu)); } return scrollpane; } // 设置JPanel方法 private JPanel getJPanel() { if (panel == null) {  panel = new JPanel();  panel.setLayout(new GridLayout(2, 3));  text1 = new JTextArea();  text2 = new JTextArea();  text3 = new JTextArea();  button1 = new JButton("添加");  button2 = new JButton("删除");  button3 = new JButton("更新");  button1.addActionListener(new insert());  button2.addActionListener(new delete());  button3.addActionListener(new update());  text1.setBorder(BorderFactory.createLineBorder(Color.gray, 2));  text2.setBorder(BorderFactory.createLineBorder(Color.gray, 2));  text3.setBorder(BorderFactory.createLineBorder(Color.gray, 2));  text1.setFont(new Font("宋体", Font.BOLD, 16));  text2.setFont(new Font("宋体", Font.BOLD, 16));  text3.setFont(new Font("宋体", Font.BOLD, 16));  text1.setText("id");  text2.setText("name");  text3.setText("age");  panel.add(text1);  panel.add(text2);  panel.add(text3);  panel.add(button1);  panel.add(button2);  panel.add(button3); } return panel; } // 设置Jtable方法 private void setJTable(JTable table) { table.setFont(new Font("宋体", Font.BOLD, 18)); table.setRowHeight(30); } // 获取Jtable对象方法（该方法具体就是获得jtable对象的时候 一并从数据取出学生信息并放入Jtable表格中） private JTable getJTable(List<Student> stu) throws SQLException { if (table == null) {  JDBCDaoImpl jdbc = new JDBCDaoImpl();  ResultSet rs = jdbc.search();  stu = select(rs);  jdbc.closeConnection();  table = new JTable(new Table(stu));  setJTable(table); } return table; } // 设置学生信息方法（该方法是用户增加 删除 更新用户操作的具体实现方法 包含了完整性检查） private Student setStu() { if (text1.getText().equals("") || text2.getText().equals("") || text3.getText().equals("")) {  return null; } else {  Student sd = new Student();  sd.setId(text1.getText());  sd.setName(text2.getText());  sd.setAge(text3.getText());  return sd; } } // 重置输入框为空 private void resetText() { text1.setText(""); text2.setText(""); text3.setText(""); } // 刷新学生信息方法（该方法是重新读取数据库学生的信息 然后返回一个学生的集合 用于刷新Jtable表格对象中的数据） private List<Student> select(ResultSet rs) throws SQLException { List<Student> st = new ArrayList<Student>(); while (rs.next()) {  Student s = new Student();  s.setId(rs.getString(1));  s.setName(rs.getString(2));  s.setAge(rs.getString(3));  st.add(s); } return st; } // 添加按钮-监听器（该方法是对添加按钮实现的具体方法 ） class insert implements ActionListener { @Override public void actionPerformed(ActionEvent e) {  stu = new ArrayList<Student>();  Student sd = new Student();  JDBCDaoImpl jdbc = new JDBCDaoImpl();  sd = setStu();  if (sd != null) {  jdbc.insert(sd);  ResultSet rs = jdbc.search();  try {   stu = select(rs);  } catch (SQLException e1) {   e1.printStackTrace();  }  jdbc.closeConnection();  JTable table = new JTable(new Table(stu));//新建一个Jtable 对象 用来盛放增加后的学生信息  setJTable(table);//设置Jtable信息  Test.this.scrollpane.setViewportView(table);//把Jtable设置到Panel  resetText();  } else {  JOptionPane.showMessageDialog(Test.this, "输入数据不完整");  } } } // 删除按钮-监听器（该方法是对删除按钮实现的具体方法） class delete implements ActionListener { @Override public void actionPerformed(ActionEvent e) {  stu = new ArrayList<Student>();  Student sd = new Student();  JDBCDaoImpl jdbc = new JDBCDaoImpl();  sd = setStu();  if (sd != null) {  jdbc.delete(sd);  ResultSet rs = jdbc.search();  try {   stu = select(rs);  } catch (SQLException e1) {   e1.printStackTrace();  }  jdbc.closeConnection();  JTable table = new JTable(new Table(stu));//新建一个Jtable 对象 用来盛放增加后的学生信息  setJTable(table);//设置Jtable信息  Test.this.scrollpane.setViewportView(table);//把Jtable设置到Panel  resetText();  } else {  JOptionPane.showMessageDialog(Test.this, "输入数据不完整");  } } } // 更新按钮-监听器（该方法是对更新按钮实现的具体方法） class update implements ActionListener { @Override public void actionPerformed(ActionEvent e) {  stu = new ArrayList<Student>();  Student sd = new Student();  JDBCDaoImpl jdbc = new JDBCDaoImpl();  sd = setStu();  if (sd != null) {  jdbc.update(sd);  ResultSet rs = jdbc.search();  try {   stu = select(rs);  } catch (SQLException e1) {   e1.printStackTrace();  }  jdbc.closeConnection();  JTable table = new JTable(new Table(stu));//新建一个Jtable 对象 用来盛放增加后的学生信息  setJTable(table);//设置Jtable信息  Test.this.scrollpane.setViewportView(table);//把Jtable设置到Panel  resetText();  } else {  JOptionPane.showMessageDialog(Test.this, "输入数据不完整");  } } } // Student类 （用于封装数据信息和数据库表进行映射） public class Student { // 学生的id name age信息 private String id; private String name; private String age; // get&set方法 public String getId() {  return id; } public void setId(String id) {  this.id = id; } public String getName() {  return name; } public void setName(String name) {  this.name = name; } public String getAge() {  return age; } public void setAge(String age) {  this.age = age; } } // JTable 表模式类 （JTable对象 初始化的时候通过 这个Table获取表格的行数、列数、列标题、以及每个单元格存放的数据 具体使用原因放在开头的备注了） public class Table extends AbstractTableModel { List<Student> stu = new ArrayList<Student>(); public Table(List s) {  this.stu = s; } public List<Student> getStu() {  return stu; } public void setStu(List<Student> stu) {  this.stu = stu; } @Override // 获取行数 public int getRowCount() {  return stu.size(); } @Override // 获取列数 public int getColumnCount() {  // TODO Auto-generated method stub  return 3; } @Override public boolean isCellEditable(int rowIndex, int columnIndex) {  return true; } @Override // 获取列名字 public String getColumnName(int col) {  String res = "";  switch (col) {  case 0:  res = "ID";  break;  case 1:  res = "Name";  break;  case 2:  res = "Age";  break;  default:  break;  }  return res; } @Override // 获取具体值 public Object getValueAt(int rowIndex, int columnIndex) {  // TODO Auto-generated method stub  Object res = "";  Student temp = stu.get(rowIndex);  switch (columnIndex) {  case 0:  res = temp.getId();  break;  case 1:  res = temp.getName();  break;  case 2:  res = temp.getAge();  break;  default:  break;  }  return res; } } // JDBCDAO类 配置连接数据的信息，链接释放操作和基本增删改查操作 public class JDBCDaoImpl { String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/test1?useUnicode=true&characterEncoding=utf-8&useSSL=false"; String user = "root"; String passwd = "123456"; Connection conn = null; Statement stmt = null; ResultSet rs = null; // 数据库连接开始 public Connection getConnection() {  try {  Class.forName("com.mysql.jdbc.Driver");  conn = DriverManager.getConnection(url, user, passwd);  stmt = conn.createStatement();  } catch (Exception e) {  e.printStackTrace();  }  return conn; } // 数据库连接释放 public void closeConnection() {  if (rs != null) {  try {   rs.close();   stmt.close();   conn.close();  } catch (SQLException e) {   // TODO Auto-generated catch block   e.printStackTrace();  }  }  if (rs == null) {  try {   stmt.close();   conn.close();  } catch (SQLException e) {   e.printStackTrace();  }  } } // 查找操作 public ResultSet search() {  getConnection();  try {  String sql = "SELECT * FROM student";  rs = stmt.executeQuery(sql);  } catch (SQLException e) {  e.printStackTrace();  }  return rs; } // 添加操作 public void insert(Student sd) {  // TODO Auto-generated method stub  getConnection();  try {  String sql = "INSERT INTO student(id,name,age)" + "VALUES('" + sd.getId() + "','" + sd.getName() + "','"   + sd.getAge() + "')";  int count = stmt.executeUpdate(sql);  } catch (SQLException e) {  e.printStackTrace();  } } // 删除操作 public void delete(Student sd) {  // TODO Auto-generated method stub  getConnection();  try {  String sql = "DELETE FROM student WHERE id = '" + sd.getId() + "'";  int count = stmt.executeUpdate(sql);  } catch (SQLException e) {  e.printStackTrace();  } } // 更新操作 public void update(Student sd) {  // TODO Auto-generated method stub  getConnection();  try {  String sql = "UPDATE student SET name='" + sd.getName() + "',age= '" + sd.getAge() + "'WHERE id = '"   + sd.getId() + "'";  int count = stmt.executeUpdate(sql);  } catch (SQLException e) {  e.printStackTrace();  } } } // main 方法 public static void main(String[] args) throws BadLocationException, SQLException { new Test().setVisible(true); }}