使用JDBC实现学生成绩管理
时间: 2023-07-15 10:14:07 浏览: 77
好的,以下是使用JDBC实现学生成绩管理的基本步骤:
1. 配置数据库连接
首先需要在项目中添加数据库驱动包,并在代码中配置数据库连接信息。例如:
```
String url = "jdbc:mysql://localhost:3306/students";
String user = "root";
String password = "123456";
Connection conn = DriverManager.getConnection(url, user, password);
```
2. 创建数据表
在数据库中创建用于存储学生成绩信息的数据表。例如:
```
CREATE TABLE student (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(20) NOT NULL,
gender VARCHAR(5) NOT NULL,
age INT NOT NULL,
score DECIMAL(5,2) NOT NULL
);
```
3. 实现增删改查功能
使用JDBC实现学生成绩管理的主要功能包括增加学生信息、删除学生信息、修改学生信息和查询学生信息。以下是这些功能的代码示例:
增加学生信息:
```
public void addStudent(Student student) throws SQLException {
String sql = "INSERT INTO student (name, gender, age, score) VALUES (?, ?, ?, ?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, student.getName());
pstmt.setString(2, student.getGender());
pstmt.setInt(3, student.getAge());
pstmt.setBigDecimal(4, student.getScore());
pstmt.executeUpdate();
}
```
删除学生信息:
```
public void deleteStudent(int id) throws SQLException {
String sql = "DELETE FROM student WHERE id=?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, id);
pstmt.executeUpdate();
}
```
修改学生信息:
```
public void updateStudent(Student student) throws SQLException {
String sql = "UPDATE student SET name=?, gender=?, age=?, score=? WHERE id=?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, student.getName());
pstmt.setString(2, student.getGender());
pstmt.setInt(3, student.getAge());
pstmt.setBigDecimal(4, student.getScore());
pstmt.setInt(5, student.getId());
pstmt.executeUpdate();
}
```
查询学生信息:
```
public List<Student> queryStudents() throws SQLException {
String sql = "SELECT * FROM student";
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
List<Student> students = new ArrayList<>();
while (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.setScore(rs.getBigDecimal("score"));
students.add(student);
}
return students;
}
```
以上就是使用JDBC实现学生成绩管理的基本步骤和代码示例。需要注意的是,以上代码仅为示例,实际应用中还需要进行参数校验、异常处理等操作。