用jdbc连接数据库建立一个寝室管理系统的工作台实现基本的增删改查
时间: 2024-04-04 07:35:54 浏览: 19
好的,下面是一个示例代码,用于演示如何使用JDBC连接MySQL数据库,并实现一个基本的寝室管理系统工作台,包括添加学生、查询学生信息、修改学生信息和删除学生信息等功能:
```java
import java.sql.*;
public class Main {
public static void main(String[] args) throws SQLException {
// 连接数据库
String url = "jdbc:mysql://localhost:3306/test?useSSL=false";
String username = "root";
String password = "password";
Connection conn = DriverManager.getConnection(url, username, password);
// 添加学生信息
String addStudentSql = "INSERT INTO students (name, gender, age, address) VALUES (?, ?, ?, ?)";
PreparedStatement addStudentStmt = conn.prepareStatement(addStudentSql);
addStudentStmt.setString(1, "张三");
addStudentStmt.setString(2, "男");
addStudentStmt.setInt(3, 20);
addStudentStmt.setString(4, "北京市海淀区");
addStudentStmt.executeUpdate();
System.out.println("Added student...");
// 查询学生信息
String queryStudentSql = "SELECT * FROM students WHERE name = ?";
PreparedStatement queryStudentStmt = conn.prepareStatement(queryStudentSql);
queryStudentStmt.setString(1, "张三");
ResultSet rs = queryStudentStmt.executeQuery();
while (rs.next()) {
System.out.println("id: " + rs.getInt("id"));
System.out.println("name: " + rs.getString("name"));
System.out.println("gender: " + rs.getString("gender"));
System.out.println("age: " + rs.getInt("age"));
System.out.println("address: " + rs.getString("address"));
}
System.out.println("Queried student...");
// 修改学生信息
String updateStudentSql = "UPDATE students SET age = ? WHERE name = ?";
PreparedStatement updateStudentStmt = conn.prepareStatement(updateStudentSql);
updateStudentStmt.setInt(1, 21);
updateStudentStmt.setString(2, "张三");
updateStudentStmt.executeUpdate();
System.out.println("Updated student...");
// 删除学生信息
String deleteStudentSql = "DELETE FROM students WHERE name = ?";
PreparedStatement deleteStudentStmt = conn.prepareStatement(deleteStudentSql);
deleteStudentStmt.setString(1, "张三");
deleteStudentStmt.executeUpdate();
System.out.println("Deleted student...");
// 关闭数据库连接
addStudentStmt.close();
queryStudentStmt.close();
updateStudentStmt.close();
deleteStudentStmt.close();
conn.close();
}
}
```
这段代码中,我们通过JDBC连接MySQL数据库,实现了添加、查询、修改和删除学生信息的功能。你可以根据具体需求修改SQL语句和实现代码,以实现你自己的寝室管理系统。希望这个示例可以帮助你开始工作。
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.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)