学生信息管理系统代码示例用idea和mysql数据库

以下是一个简单的学生信息管理系统的代码示例，使用了IDEA开发工具和MySQL数据库。

首先，创建一个名为"Student"的数据库，并在其中创建一个名为"student"的表，包含学生的ID、姓名和年龄字段。

CREATE DATABASE Student;

USE Student;

CREATE TABLE student (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50),
    age INT
);

接下来，创建一个名为"StudentManagementSystem"的Java项目，并添加MySQL连接器依赖。

在src目录下创建一个名为"Student"的包，并在该包下创建以下Java类：

Student.java - 学生类，包含ID、姓名和年龄属性。

public class Student {
    private int id;
    private String name;
    private int age;

    public Student(int id, String name, int age) {
        this.id = id;
        this.name = name;
        this.age = age;
    }

    public int getId() {
        return id;
    }

    public String getName() {
        return name;
    }

    public int getAge() {
        return age;
    }
}

StudentDAO.java - 数据访问对象接口，定义了对学生信息进行增删改查的方法。

import java.util.List;

public interface StudentDAO {
    List<Student> getAllStudents();
    Student getStudentById(int id);
    void addStudent(Student student);
    void updateStudent(Student student);
    void deleteStudent(int id);
}

StudentDAOImpl.java - 数据访问对象接口的实现类，使用JDBC连接MySQL数据库。

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class StudentDAOImpl implements StudentDAO {
    private static final String URL = "jdbc:mysql://localhost:3306/Student";
    private static final String USERNAME = "your_username";
    private static final String PASSWORD = "your_password";

    @Override
    public List<Student> getAllStudents() {
        List<Student> students = new ArrayList<>();

        try (Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
             Statement statement = connection.createStatement();
             ResultSet resultSet = statement.executeQuery("SELECT * FROM student")) {

            while (resultSet.next()) {
                int id = resultSet.getInt("id");
                String name = resultSet.getString("name");
                int age = resultSet.getInt("age");
                Student student = new Student(id, name, age);
                students.add(student);
            }

        } catch (SQLException e) {
            e.printStackTrace();
        }

        return students;
    }

    @Override
    public Student getStudentById(int id) {
        try (Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
             PreparedStatement statement = connection.prepareStatement("SELECT * FROM student WHERE id = ?")) {

            statement.setInt(1, id);
            ResultSet resultSet = statement.executeQuery();

            if (resultSet.next()) {
                String name = resultSet.getString("name");
                int age = resultSet.getInt("age");
                return new Student(id, name, age);
            }

        } catch (SQLException e) {
            e.printStackTrace();
        }

        return null;
    }

    @Override
    public void addStudent(Student student) {
        try (Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
             PreparedStatement statement = connection.prepareStatement("INSERT INTO student (name, age) VALUES (?, ?)")) {

            statement.setString(1, student.getName());
            statement.setInt(2, student.getAge());
            statement.executeUpdate();

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    @Override
    public void updateStudent(Student student) {
        try (Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
             PreparedStatement statement = connection.prepareStatement("UPDATE student SET name = ?, age = ? WHERE id = ?")) {

            statement.setString(1, student.getName());
            statement.setInt(2, student.getAge());
            statement.setInt(3, student.getId());
            statement.executeUpdate();

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    @Override
    public void deleteStudent(int id) {
        try (Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
             PreparedStatement statement = connection.prepareStatement("DELETE FROM student WHERE id = ?")) {

            statement.setInt(1, id);
            statement.executeUpdate();

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

Main.java - 主程序入口，演示如何使用学生信息管理系统。

import java.util.List;

public class Main {
    public static void main(String[] args) {
        StudentDAO studentDAO = new StudentDAOImpl();

        // 添加学生
        Student student1 = new Student(1, "Alice", 18);
        studentDAO.addStudent(student1);

        // 获取所有学生
        List<Student> students = studentDAO.getAllStudents();
        for (Student student : students) {
            System.out.println(student.getId() + " " + student.getName() + " " + student.getAge());
        }

        // 更新学生
        Student student2 = studentDAO.getStudentById(1);
        if (student2 != null) {
            student2.setName("Bob");
            student2.setAge(20);
            studentDAO.updateStudent(student2);
        }

        // 删除学生
        studentDAO.deleteStudent(1);
    }
}

以上是一个简单的学生信息管理系统的代码示例，使用了IDEA和MySQL数据库。你可以根据自己的需求进行修改和扩展