编写Java代码实现学生和课程的增删改查功能,包括学生信息管理、课程信息管理和选课管理等。
时间: 2024-03-17 19:42:49 浏览: 21
好的,下面是一个简单的Java代码示例,用于实现学生和课程的增删改查功能,包括学生信息管理、课程信息管理和选课管理等。请注意,此示例代码只是为了帮助您了解如何实现这些功能,具体实现细节需要根据实际需求进行调整和完善。
```java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class StudentCourseManagementSystem {
private Connection conn;
private PreparedStatement stmt;
private ResultSet rs;
// 连接数据库
public void connect() throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/student_course_management_system";
String user = "root";
String password = "123456";
conn = DriverManager.getConnection(url, user, password);
}
// 关闭数据库连接
public void close() throws SQLException {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
}
// 添加学生信息
public void addStudent(Student student) throws SQLException {
String sql = "INSERT INTO student (name, gender, age, major) VALUES (?, ?, ?, ?)";
stmt = conn.prepareStatement(sql);
stmt.setString(1, student.getName());
stmt.setString(2, student.getGender());
stmt.setInt(3, student.getAge());
stmt.setString(4, student.getMajor());
stmt.executeUpdate();
}
// 修改学生信息
public void updateStudent(Student student) throws SQLException {
String sql = "UPDATE student SET name=?, gender=?, age=?, major=? WHERE id=?";
stmt = conn.prepareStatement(sql);
stmt.setString(1, student.getName());
stmt.setString(2, student.getGender());
stmt.setInt(3, student.getAge());
stmt.setString(4, student.getMajor());
stmt.setInt(5, student.getId());
stmt.executeUpdate();
}
// 删除学生信息
public void deleteStudent(int id) throws SQLException {
String sql = "DELETE FROM student WHERE id=?";
stmt = conn.prepareStatement(sql);
stmt.setInt(1, id);
stmt.executeUpdate();
}
// 查询学生信息
public Student getStudent(int id) throws SQLException {
String sql = "SELECT * FROM student WHERE id=?";
stmt = conn.prepareStatement(sql);
stmt.setInt(1, id);
rs = stmt.executeQuery();
if (rs.next()) {
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"));
return student;
} else {
return null;
}
}
// 添加课程信息
public void addCourse(Course course) throws SQLException {
String sql = "INSERT INTO course (name, teacher, credit) VALUES (?, ?, ?)";
stmt = conn.prepareStatement(sql);
stmt.setString(1, course.getName());
stmt.setString(2, course.getTeacher());
stmt.setInt(3, course.getCredit());
stmt.executeUpdate();
}
// 修改课程信息
public void updateCourse(Course course) throws SQLException {
String sql = "UPDATE course SET name=?, teacher=?, credit=? WHERE id=?";
stmt = conn.prepareStatement(sql);
stmt.setString(1, course.getName());
stmt.setString(2, course.getTeacher());
stmt.setInt(3, course.getCredit());
stmt.setInt(4, course.getId());
stmt.executeUpdate();
}
// 删除课程信息
public void deleteCourse(int id) throws SQLException {
String sql = "DELETE FROM course WHERE id=?";
stmt = conn.prepareStatement(sql);
stmt.setInt(1, id);
stmt.executeUpdate();
}
// 查询课程信息
public Course getCourse(int id) throws SQLException {
String sql = "SELECT * FROM course WHERE id=?";
stmt = conn.prepareStatement(sql);
stmt.setInt(1, id);
rs = stmt.executeQuery();
if (rs.next()) {
Course course = new Course();
course.setId(rs.getInt("id"));
course.setName(rs.getString("name"));
course.setTeacher(rs.getString("teacher"));
course.setCredit(rs.getInt("credit"));
return course;
} else {
return null;
}
}
// 学生选课
public void addStudentCourse(int studentId, int courseId) throws SQLException {
String sql = "INSERT INTO student_course (student_id, course_id) VALUES (?, ?)";
stmt = conn.prepareStatement(sql);
stmt.setInt(1, studentId);
stmt.setInt(2, courseId);
stmt.executeUpdate();
}
// 学生退课
public void deleteStudentCourse(int studentId, int courseId) throws SQLException {
String sql = "DELETE FROM student_course WHERE student_id=? AND course_id=?";
stmt = conn.prepareStatement(sql);
stmt.setInt(1, studentId);
stmt.setInt(2, courseId);
stmt.executeUpdate();
}
// 查询学生选课情况
public boolean hasSelectedCourse(int studentId, int courseId) throws SQLException {
String sql = "SELECT * FROM student_course WHERE student_id=? AND course_id=?";
stmt = conn.prepareStatement(sql);
stmt.setInt(1, studentId);
stmt.setInt(2, courseId);
rs = stmt.executeQuery();
return rs.next();
}
}
class Student {
private int id;
private String name;
private String gender;
private int age;
private String major;
public 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;
}
}
class Course {
private int id;
private String name;
private String teacher;
private int credit;
public 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 getTeacher() {
return teacher;
}
public void setTeacher(String teacher) {
this.teacher = teacher;
}
public int getCredit() {
return credit;
}
public void setCredit(int credit) {
this.credit = credit;
}
}
```
以上示例代码中,StudentCourseManagementSystem类包含了连接数据库、关闭数据库连接、添加学生信息、修改学生信息、删除学生信息、查询学生信息、添加课程信息、修改课程信息、删除课程信息、查询课程信息、学生选课、学生退课、查询学生选课情况等方法。
相关推荐
![application/x-rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![application/x-rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)