java链接mysql的学生管理系统代码
时间: 2023-11-11 17:06:46 浏览: 31
好的,这里是一个简单的Java链接MySQL的学生管理系统代码示例:
```java
import java.sql.*;
public class Student {
private int id;
private String name;
private int age;
private String gender;
private String studentId;
public Student(int id, String name, int age, String gender, String studentId) {
this.id = id;
this.name = name;
this.age = age;
this.gender = gender;
this.studentId = studentId;
}
// 省略getter和setter方法
public static void main(String[] args) {
try {
// 加载MySQL驱动程序
Class.forName("com.mysql.cj.jdbc.Driver");
// 创建数据库连接
String url = "jdbc:mysql://localhost:3306/student?useSSL=false&serverTimezone=UTC";
String user = "root";
String password = "123456";
Connection conn = DriverManager.getConnection(url, user, password);
// 创建Statement
Statement stmt = conn.createStatement();
// 插入学生信息
String insertSql = "INSERT INTO student (name, age, gender, student_id) VALUES ('张三', 18, '男', '2018001')";
stmt.executeUpdate(insertSql);
// 查询学生信息
String selectSql = "SELECT * FROM student";
ResultSet rs = stmt.executeQuery(selectSql);
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
String gender = rs.getString("gender");
String studentId = rs.getString("student_id");
Student student = new Student(id, name, age, gender, studentId);
System.out.println(student);
}
// 更新学生信息
String updateSql = "UPDATE student SET age = 19 WHERE id = 1";
stmt.executeUpdate(updateSql);
// 删除学生信息
String deleteSql = "DELETE FROM student WHERE id = 1";
stmt.executeUpdate(deleteSql);
// 关闭资源
rs.close();
stmt.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
@Override
public String toString() {
return "Student{" +
"id=" + id +
", name='" + name + '\'' +
", age=" + age +
", gender='" + gender + '\'' +
", studentId='" + studentId + '\'' +
'}';
}
}
```
这段代码演示了如何创建数据库连接、执行SQL查询和操作数据库。您可以根据自己的需求和技术水平来进行具体实现。