上海网站建设免费推百度seo通科

注释：代码大多来自 GitHub  AI 。

学生信息管理系统，包含登录注册界面，使用Java Swing和MySQL数据库

注意：配置驱动 

mysql

    -- -- 创建数据库CREATE DATABASE student_management;USE student_management;-----用户表（用于登录）CREATE TABLE users (id INT AUTO_INCREMENT PRIMARY KEY,username VARCHAR(50) NOT NULL UNIQUE,password VARCHAR(50) NOT NULL,role ENUM('admin', 'teacher') DEFAULT 'teacher');-- -- 学生表CREATE TABLE students (id INT AUTO_INCREMENT PRIMARY KEY,name VARCHAR(100) NOT NULL,gender ENUM('Male', 'Female', 'Other'),age INT,major VARCHAR(100),email VARCHAR(100),phone VARCHAR(20),created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP);

AuthController.java

package controller;import dao.UserDAO;
import model.User;public class AuthController {private final UserDAO userDAO = new UserDAO();// 用户注册public boolean register(User user) {return userDAO.registerUser(user);}// 用户登录public User login(String username, String password) {return userDAO.authenticate(username, password);}// 检查用户名是否存在public boolean usernameExists(String username) {return userDAO.usernameExists(username);}
}

StudentController.java

package controller;import dao.StudentDAO;
import model.Student;
import java.sql.SQLException;
import java.util.List;public class StudentController {private final StudentDAO studentDAO = new StudentDAO();public void addStudent(Student student) throws SQLException {studentDAO.addStudent(student);}public void updateStudent(Student student) throws SQLException {studentDAO.updateStudent(student);}public void deleteStudent(int id) throws SQLException {studentDAO.deleteStudent(id);}public List<Student> getAllStudents() throws SQLException {return studentDAO.getAllStudents();}public List<Student> searchStudents(String keyword) throws SQLException {return studentDAO.searchStudents(keyword);}
}

StudentDAO.java

package dao;import model.Student;
import util.DBUtil;
import java.sql.*;
import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.List;public class StudentDAO {// 添加学生public void addStudent(Student student) throws SQLException {String sql = "INSERT INTO students (name, gender, age, major, email, phone) VALUES (?, ?, ?, ?, ?, ?)";try (Connection conn = DBUtil.getConnection();PreparedStatement pstmt = conn.prepareStatement(sql)) {setStudentParameters(pstmt, student);pstmt.executeUpdate();}}// 更新学生public void updateStudent(Student student) throws SQLException {String sql = "UPDATE students SET name=?, gender=?, age=?, major=?, email=?, phone=? WHERE id=?";try (Connection conn = DBUtil.getConnection();PreparedStatement pstmt = conn.prepareStatement(sql)) {setStudentParameters(pstmt, student);pstmt.setInt(7, student.getId());pstmt.executeUpdate();}}// 删除学生public void deleteStudent(int id) throws SQLException {String sql = "DELETE FROM students WHERE id=?";try (Connection conn = DBUtil.getConnection();PreparedStatement pstmt = conn.prepareStatement(sql)) {pstmt.setInt(1, id);pstmt.executeUpdate();}}// 获取所有学生public List<Student> getAllStudents() throws SQLException {List<Student> students = new ArrayList<>();String sql = "SELECT * FROM students";try (Connection conn = DBUtil.getConnection();Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery(sql)) {while (rs.next()) {students.add(mapStudent(rs));}}return students;}// 搜索学生public List<Student> searchStudents(String keyword) throws SQLException {List<Student> students = new ArrayList<>();String sql = "SELECT * FROM students WHERE name LIKE ? OR major LIKE ?";try (Connection conn = DBUtil.getConnection();PreparedStatement pstmt = conn.prepareStatement(sql)) {pstmt.setString(1, "%" + keyword + "%");pstmt.setString(2, "%" + keyword + "%");try (ResultSet rs = pstmt.executeQuery()) {while (rs.next()) {students.add(mapStudent(rs));}}}return students;}private void setStudentParameters(PreparedStatement pstmt, Student student) throws SQLException {pstmt.setString(1, student.getName());pstmt.setString(2, student.getGender());pstmt.setInt(3, student.getAge());pstmt.setString(4, student.getMajor());pstmt.setString(5, student.getEmail());pstmt.setString(6, student.getPhone());}private Student mapStudent(ResultSet rs) throws SQLException {Student student = new Student();student.setId(rs.getInt("id"));student.setName(rs.getString("name"));student.setGender(rs.getString("gender"));student.setAge(rs.getInt("age"));student.setMajor(rs.getString("major"));student.setEmail(rs.getString("email"));student.setPhone(rs.getString("phone"));student.setCreatedAt(rs.getTimestamp("created_at").toLocalDateTime());return student;}
}

UserDAO.java

package dao;import model.User;
import util.DBUtil;import java.sql.*;public class UserDAO {// 注册用户public boolean registerUser(User user) {String sql = "INSERT INTO users (username, password, role) VALUES (?, ?, ?)";try (Connection conn = DBUtil.getConnection();PreparedStatement pstmt = conn.prepareStatement(sql)) {pstmt.setString(1, user.getUsername());pstmt.setString(2, user.getPassword());pstmt.setString(3, user.getRole());int affectedRows = pstmt.executeUpdate();return affectedRows > 0;} catch (SQLException e) {e.printStackTrace();return false;}}// 用户登录验证public User authenticate(String username, String password) {String sql = "SELECT * FROM users WHERE username = ? AND password = ?";try (Connection conn = DBUtil.getConnection();PreparedStatement pstmt = conn.prepareStatement(sql)) {pstmt.setString(1, username);pstmt.setString(2, password);try (ResultSet rs = pstmt.executeQuery()) {if (rs.next()) {User user = new User();user.setId(rs.getInt("id"));user.setUsername(rs.getString("username"));user.setPassword(rs.getString("password"));user.setRole(rs.getString("role"));return user;}}} catch (SQLException e) {e.printStackTrace();}return null;}// 检查用户名是否已存在public boolean usernameExists(String username) {String sql = "SELECT COUNT(*) FROM users WHERE username = ?";try (Connection conn = DBUtil.getConnection();PreparedStatement pstmt = conn.prepareStatement(sql)) {pstmt.setString(1, username);try (ResultSet rs = pstmt.executeQuery()) {if (rs.next()) {return rs.getInt(1) > 0;}}} catch (SQLException e) {e.printStackTrace();}return false;}
}

Student.java

package model;import java.time.LocalDateTime;public class Student {private int id;private String name;private String gender;private int age;private String major;private String email;private String phone;private LocalDateTime createdAt;public Student() {}// Getters and Setterspublic int getId() {return id;}public void setId(int id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getGender() {return gender;}public void setGender(String gender) {this.gender = gender;}public int getAge() {return age;}public void setAge(int age) {this.age = age;}public String getMajor() {return major;}public void setMajor(String major) {this.major = major;}public String getEmail() {return email;}public void setEmail(String email) {this.email = email;}public String getPhone() {return phone;}public void setPhone(String phone) {this.phone = phone;}public LocalDateTime getCreatedAt() {return createdAt;}public void setCreatedAt(LocalDateTime createdAt) {this.createdAt = createdAt;}
}

User

package model;import java.time.LocalDateTime;public class Student {private int id;private String name;private String gender;private int age;private String major;private String email;private String phone;private LocalDateTime createdAt;public Student() {}// Getters and Setterspublic int getId() {return id;}public void setId(int id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getGender() {return gender;}public void setGender(String gender) {this.gender = gender;}public int getAge() {return age;}public void setAge(int age) {this.age = age;}public String getMajor() {return major;}public void setMajor(String major) {this.major = major;}public String getEmail() {return email;}public void setEmail(String email) {this.email = email;}public String getPhone() {return phone;}public void setPhone(String phone) {this.phone = phone;}public LocalDateTime getCreatedAt() {return createdAt;}public void setCreatedAt(LocalDateTime createdAt) {this.createdAt = createdAt;}
}

DBUtil.java

package model;public class User {private int id;private String username;private String password;private String role;public User() {}public User(String username, String password, String role) {this.username = username;this.password = password;this.role = role;}// Getters and Setterspublic int getId() {return id;}public void setId(int id) {this.id = id;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public String getRole() {return role;}public void setRole(String role) {this.role = role;}
}

LoginFrame

package view;import controller.AuthController;
import model.User;import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;public class LoginFrame extends JFrame {private JTextField usernameField;private JPasswordField passwordField;private AuthController authController;public LoginFrame() {setTitle("学生管理系统 - 登录");setSize(400, 300);setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);setLocationRelativeTo(null);setResizable(false);authController = new AuthController();initializeUI();}private void initializeUI() {JPanel mainPanel = new JPanel(new GridBagLayout());GridBagConstraints gbc = new GridBagConstraints();gbc.insets = new Insets(10, 10, 10, 10);gbc.fill = GridBagConstraints.HORIZONTAL;// 标题JLabel titleLabel = new JLabel("学生信息管理系统", SwingConstants.CENTER);titleLabel.setFont(new Font("微软雅黑", Font.BOLD, 24));gbc.gridx = 0;gbc.gridy = 0;gbc.gridwidth = 2;mainPanel.add(titleLabel, gbc);// 用户名gbc.gridwidth = 1;gbc.gridy = 1;gbc.gridx = 0;mainPanel.add(new JLabel("用户名:"), gbc);gbc.gridx = 1;usernameField = new JTextField(15);mainPanel.add(usernameField, gbc);// 密码gbc.gridy = 2;gbc.gridx = 0;mainPanel.add(new JLabel("密码:"), gbc);gbc.gridx = 1;passwordField = new JPasswordField(15);mainPanel.add(passwordField, gbc);// 按钮面板JPanel buttonPanel = new JPanel(new FlowLayout(FlowLayout.CENTER, 20, 10));JButton loginButton = new JButton("登录");loginButton.setPreferredSize(new Dimension(100, 30));loginButton.addActionListener(this::loginAction);JButton registerButton = new JButton("注册");registerButton.setPreferredSize(new Dimension(100, 30));registerButton.addActionListener(e -> openRegisterFrame());buttonPanel.add(loginButton);buttonPanel.add(registerButton);gbc.gridy = 3;gbc.gridx = 0;gbc.gridwidth = 2;mainPanel.add(buttonPanel, gbc);add(mainPanel);}private void loginAction(ActionEvent e) {String username = usernameField.getText().trim();String password = new String(passwordField.getPassword());if (username.isEmpty() || password.isEmpty()) {JOptionPane.showMessageDialog(this, "用户名和密码不能为空", "错误", JOptionPane.ERROR_MESSAGE);return;}User user = authController.login(username, password);if (user != null) {openMainFrame(user);dispose();} else {JOptionPane.showMessageDialog(this, "用户名或密码错误", "登录失败", JOptionPane.ERROR_MESSAGE);}}private void openRegisterFrame() {RegisterFrame registerFrame = new RegisterFrame(this);registerFrame.setVisible(true);}private void openMainFrame(User user) {SwingUtilities.invokeLater(() -> {MainFrame mainFrame = new MainFrame(user);mainFrame.setVisible(true);});}public static void main(String[] args) {SwingUtilities.invokeLater(() -> new LoginFrame().setVisible(true));}
}

MainFrame.java

package view;import controller.StudentController;
import model.Student;
import model.User;import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.sql.SQLException;
import java.util.List;public class MainFrame extends JFrame {private final StudentController controller = new StudentController();private DefaultTableModel tableModel;private JTable studentTable;private User currentUser;private JLabel userInfoLabel;public MainFrame(User user) {this.currentUser = user;setTitle("学生信息管理系统");setSize(900, 600);setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);setLocationRelativeTo(null);initializeUI();loadStudents();}private void initializeUI() {// 顶部面板 - 用户信息和标题JPanel topPanel = new JPanel(new BorderLayout());topPanel.setBorder(BorderFactory.createEmptyBorder(10, 10, 10, 10));JLabel titleLabel = new JLabel("学生信息管理系统", SwingConstants.CENTER);titleLabel.setFont(new Font("微软雅黑", Font.BOLD, 24));topPanel.add(titleLabel, BorderLayout.CENTER);userInfoLabel = new JLabel("用户: " + currentUser.getUsername() + " (" + currentUser.getRole() + ")");userInfoLabel.setFont(new Font("微软雅黑", Font.PLAIN, 14));topPanel.add(userInfoLabel, BorderLayout.EAST);// 工具栏JToolBar toolBar = new JToolBar();toolBar.setFloatable(false);JButton addButton = new JButton("添加学生");JButton editButton = new JButton("编辑学生");JButton deleteButton = new JButton("删除学生");JButton refreshButton = new JButton("刷新");JButton logoutButton = new JButton("退出登录");toolBar.add(addButton);toolBar.add(editButton);toolBar.add(deleteButton);toolBar.addSeparator();toolBar.add(refreshButton);toolBar.addSeparator();toolBar.add(logoutButton);// 搜索面板JPanel searchPanel = new JPanel(new FlowLayout(FlowLayout.RIGHT));JTextField searchField = new JTextField(20);JButton searchButton = new JButton("搜索");searchPanel.add(new JLabel("搜索:"));searchPanel.add(searchField);searchPanel.add(searchButton);// 表格tableModel = new DefaultTableModel(new Object[]{"ID", "姓名", "性别", "年龄", "专业", "邮箱", "电话", "创建时间"}, 0) {@Overridepublic boolean isCellEditable(int row, int column) {return false;}};studentTable = new JTable(tableModel);studentTable.setRowHeight(25);studentTable.getColumnModel().getColumn(7).setPreferredWidth(150); // 设置创建时间列宽度JScrollPane scrollPane = new JScrollPane(studentTable);scrollPane.setBorder(BorderFactory.createEmptyBorder(10, 10, 10, 10));// 状态栏JLabel statusLabel = new JLabel("总计: 0 名学生");JPanel statusPanel = new JPanel(new FlowLayout(FlowLayout.LEFT));statusPanel.add(statusLabel);// 事件处理addButton.addActionListener(e -> addStudent());editButton.addActionListener(e -> editStudent());deleteButton.addActionListener(e -> deleteStudent());refreshButton.addActionListener(e -> loadStudents());logoutButton.addActionListener(e -> logout());searchButton.addActionListener(e -> searchStudents(searchField.getText()));// 布局setLayout(new BorderLayout());add(topPanel, BorderLayout.NORTH);add(toolBar, BorderLayout.BEFORE_FIRST_LINE);add(searchPanel, BorderLayout.AFTER_LAST_LINE);add(scrollPane, BorderLayout.CENTER);add(statusPanel, BorderLayout.SOUTH);}private void loadStudents() {try {List<Student> students = controller.getAllStudents();updateTable(students);} catch (SQLException ex) {showError("加载学生信息失败: " + ex.getMessage());}}private void searchStudents(String keyword) {try {List<Student> students = controller.searchStudents(keyword);updateTable(students);} catch (SQLException ex) {showError("搜索失败: " + ex.getMessage());}}private void updateTable(List<Student> students) {tableModel.setRowCount(0);for (Student student : students) {tableModel.addRow(new Object[]{student.getId(),student.getName(),student.getGender(),student.getAge(),student.getMajor(),student.getEmail(),student.getPhone(),student.getCreatedAt().toString()});}// 更新状态栏JLabel statusLabel = (JLabel) ((JPanel) getContentPane().getComponent(4)).getComponent(0);statusLabel.setText("总计: " + students.size() + " 名学生");}private void addStudent() {StudentDialog dialog = new StudentDialog(this, "添加学生", null);dialog.setVisible(true);Student student = dialog.getStudent();if (student != null) {try {controller.addStudent(student);loadStudents();} catch (SQLException ex) {showError("添加学生失败: " + ex.getMessage());}}}private void editStudent() {int selectedRow = studentTable.getSelectedRow();if (selectedRow == -1) {JOptionPane.showMessageDialog(this, "请选择一名学生", "提示", JOptionPane.WARNING_MESSAGE);return;}int id = (int) tableModel.getValueAt(selectedRow, 0);try {List<Student> students = controller.getAllStudents();Student student = students.stream().filter(s -> s.getId() == id).findFirst().orElse(null);if (student != null) {StudentDialog dialog = new StudentDialog(this, "编辑学生信息", student);dialog.setVisible(true);Student updated = dialog.getStudent();if (updated != null) {controller.updateStudent(updated);loadStudents();}}} catch (SQLException ex) {showError("更新学生信息失败: " + ex.getMessage());}}private void deleteStudent() {int selectedRow = studentTable.getSelectedRow();if (selectedRow == -1) {JOptionPane.showMessageDialog(this, "请选择一名学生", "提示", JOptionPane.WARNING_MESSAGE);return;}int confirm = JOptionPane.showConfirmDialog(this,"确定要删除这名学生吗?","确认删除",JOptionPane.YES_NO_OPTION);if (confirm == JOptionPane.YES_OPTION) {int id = (int) tableModel.getValueAt(selectedRow, 0);try {controller.deleteStudent(id);loadStudents();} catch (SQLException ex) {showError("删除学生失败: " + ex.getMessage());}}}private void logout() {int confirm = JOptionPane.showConfirmDialog(this,"确定要退出登录吗?","确认退出",JOptionPane.YES_NO_OPTION);if (confirm == JOptionPane.YES_OPTION) {dispose();new LoginFrame().setVisible(true);}}private void showError(String message) {JOptionPane.showMessageDialog(this, message, "错误", JOptionPane.ERROR_MESSAGE);}
}

RegisterFrame.java

package view;import controller.AuthController;
import model.User;import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;public class RegisterFrame extends JFrame {private JTextField usernameField;private JPasswordField passwordField;private JPasswordField confirmPasswordField;private JComboBox<String> roleCombo;private AuthController authController;private LoginFrame loginFrame;public RegisterFrame(LoginFrame loginFrame) {this.loginFrame = loginFrame;setTitle("学生管理系统 - 注册");setSize(400, 350);setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);setLocationRelativeTo(loginFrame);setResizable(false);authController = new AuthController();initializeUI();}private void initializeUI() {JPanel mainPanel = new JPanel(new GridBagLayout());GridBagConstraints gbc = new GridBagConstraints();gbc.insets = new Insets(10, 10, 10, 10);gbc.fill = GridBagConstraints.HORIZONTAL;// 标题JLabel titleLabel = new JLabel("用户注册", SwingConstants.CENTER);titleLabel.setFont(new Font("微软雅黑", Font.BOLD, 20));gbc.gridx = 0;gbc.gridy = 0;gbc.gridwidth = 2;mainPanel.add(titleLabel, gbc);// 用户名gbc.gridwidth = 1;gbc.gridy = 1;gbc.gridx = 0;mainPanel.add(new JLabel("用户名:"), gbc);gbc.gridx = 1;usernameField = new JTextField(15);mainPanel.add(usernameField, gbc);// 密码gbc.gridy = 2;gbc.gridx = 0;mainPanel.add(new JLabel("密码:"), gbc);gbc.gridx = 1;passwordField = new JPasswordField(15);mainPanel.add(passwordField, gbc);// 确认密码gbc.gridy = 3;gbc.gridx = 0;mainPanel.add(new JLabel("确认密码:"), gbc);gbc.gridx = 1;confirmPasswordField = new JPasswordField(15);mainPanel.add(confirmPasswordField, gbc);// 角色gbc.gridy = 4;gbc.gridx = 0;mainPanel.add(new JLabel("角色:"), gbc);gbc.gridx = 1;roleCombo = new JComboBox<>(new String[]{"teacher", "admin"});mainPanel.add(roleCombo, gbc);// 按钮面板JPanel buttonPanel = new JPanel(new FlowLayout(FlowLayout.CENTER, 20, 10));JButton registerButton = new JButton("注册");registerButton.setPreferredSize(new Dimension(100, 30));registerButton.addActionListener(this::registerAction);JButton cancelButton = new JButton("取消");cancelButton.setPreferredSize(new Dimension(100, 30));cancelButton.addActionListener(e -> dispose());buttonPanel.add(registerButton);buttonPanel.add(cancelButton);gbc.gridy = 5;gbc.gridx = 0;gbc.gridwidth = 2;mainPanel.add(buttonPanel, gbc);add(mainPanel);}private void registerAction(ActionEvent e) {String username = usernameField.getText().trim();String password = new String(passwordField.getPassword());String confirmPassword = new String(confirmPasswordField.getPassword());String role = (String) roleCombo.getSelectedItem();if (username.isEmpty() || password.isEmpty()) {JOptionPane.showMessageDialog(this, "用户名和密码不能为空", "错误", JOptionPane.ERROR_MESSAGE);return;}if (!password.equals(confirmPassword)) {JOptionPane.showMessageDialog(this, "两次输入的密码不一致", "错误", JOptionPane.ERROR_MESSAGE);return;}if (authController.usernameExists(username)) {JOptionPane.showMessageDialog(this, "用户名已存在", "错误", JOptionPane.ERROR_MESSAGE);return;}User user = new User(username, password, role);if (authController.register(user)) {JOptionPane.showMessageDialog(this, "注册成功！", "成功", JOptionPane.INFORMATION_MESSAGE);dispose();} else {JOptionPane.showMessageDialog(this, "注册失败，请重试", "错误", JOptionPane.ERROR_MESSAGE);}}
}

StudentDialog.java

package view;import model.Student;
import javax.swing.*;
import java.awt.*;public class StudentDialog extends JDialog {private JTextField nameField, ageField, majorField, emailField, phoneField;private JComboBox<String> genderCombo;private Student student;private boolean confirmed = false;public StudentDialog(Frame owner, String title, Student student) {super(owner, title, true);this.student = student;initializeUI();pack();setLocationRelativeTo(owner);}private void initializeUI() {JPanel panel = new JPanel(new GridLayout(6, 2, 10, 10));panel.setBorder(BorderFactory.createEmptyBorder(15, 15, 15, 15));panel.add(new JLabel("姓名:"));nameField = new JTextField(20);panel.add(nameField);panel.add(new JLabel("性别:"));genderCombo = new JComboBox<>(new String[]{"Male", "Female", "Other"});panel.add(genderCombo);panel.add(new JLabel("年龄:"));ageField = new JTextField(3);panel.add(ageField);panel.add(new JLabel("专业:"));majorField = new JTextField(20);panel.add(majorField);panel.add(new JLabel("邮箱:"));emailField = new JTextField(20);panel.add(emailField);panel.add(new JLabel("电话:"));phoneField = new JTextField(15);panel.add(phoneField);if (student != null) {nameField.setText(student.getName());genderCombo.setSelectedItem(student.getGender());ageField.setText(String.valueOf(student.getAge()));majorField.setText(student.getMajor());emailField.setText(student.getEmail());phoneField.setText(student.getPhone());}JButton saveButton = new JButton("保存");saveButton.addActionListener(e -> {confirmed = true;dispose();});JButton cancelButton = new JButton("取消");cancelButton.addActionListener(e -> dispose());JPanel buttonPanel = new JPanel(new FlowLayout(FlowLayout.RIGHT, 10, 10));buttonPanel.add(saveButton);buttonPanel.add(cancelButton);add(panel, BorderLayout.CENTER);add(buttonPanel, BorderLayout.SOUTH);}public Student getStudent() {if (!confirmed) return null;Student updated = (student != null) ? student : new Student();updated.setName(nameField.getText());updated.setGender((String) genderCombo.getSelectedItem());try {updated.setAge(Integer.parseInt(ageField.getText()));} catch (NumberFormatException e) {updated.setAge(0);}updated.setMajor(majorField.getText());updated.setEmail(emailField.getText());updated.setPhone(phoneField.getText());return updated;}
}