java连接数据库创建学生管理系统
时间: 2023-12-22 08:04:25 浏览: 24
以下是使用Java连接数据库创建学生管理系统的步骤:
1. 导入所需的库和包:
```java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;```
2. 建立数据库连接:
```java
String url = "jdbc:mysql://localhost:3306/database_name";
String username = "your_username";
String password = "your_password";
try {
Connection connection = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
e.printStackTrace();
}
```
3. 创建表格:
```java
String createTableQuery = "CREATE TABLE students (id INT PRIMARY KEY, name VARCHAR(50), age INT)";
try {
Statement statement = connection.createStatement();
statement.executeUpdate(createTableQuery);} catch (SQLException e) {
e.printStackTrace();
}
```
4. 插入数据:
```java
String insertQuery = "INSERT INTO students (id, name, age) VALUES (1, 'John', 20)";
try {
Statement statement = connection.createStatement();
statement.executeUpdate(insertQuery);
} catch (SQLException e) {
e.printStackTrace();
}
```
5. 查询数据:
```java
String selectQuery = "SELECT * FROM students";
try {
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(selectQuery);
while (resultSet.next()) {
int id = resultSet.getInt("id");
String name = resultSet.getString("name");
int age = resultSet.getInt("age");
System.out.println("ID: " + id + ", Name: " + name + ", Age: " + age);
}
} catch (SQLException e) {
e.printStackTrace();
}
```
6. 更新数据:
```java
String updateQuery = "UPDATE students SET age = 21 WHERE id = 1";
try {
Statement statement = connection.createStatement(); statement.executeUpdate(updateQuery);
} catch (SQLException e) {
e.printStackTrace();
}
```
7. 删除数据:
```java
String deleteQuery = "DELETE FROM students WHERE id = 1";
try {
Statement statement = connection.createStatement();
statement.executeUpdate(deleteQuery);
} catch (SQLException e) {
e.printStackTrace();
}
```
8. 关闭数据库连接:
```java
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
```