java数据库增删改查
时间: 2023-10-02 15:08:45 浏览: 30
Java 中操作数据库的增删改查可以通过 JDBC API 来实现,以下是一个简单的示例:
1. 导入需要的库
```java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
```
2. 配置数据库连接信息
```java
String url = "jdbc:mysql://localhost:3306/test";
String user = "root";
String password = "123456";
```
3. 连接数据库
```java
Connection conn = DriverManager.getConnection(url, user, password);
```
4. 插入数据
```java
String sql = "INSERT INTO student (name, age, sex) VALUES (?, ?, ?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, "Tom");
ps.setInt(2, 18);
ps.setString(3, "male");
int result = ps.executeUpdate();
```
5. 查询数据
```java
String sql = "SELECT id, name, age, sex FROM student";
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
String sex = rs.getString("sex");
// 处理查询结果
}
```
6. 更新数据
```java
String sql = "UPDATE student SET age = ? WHERE name = ?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, 20);
ps.setString(2, "Tom");
int result = ps.executeUpdate();
```
7. 删除数据
```java
String sql = "DELETE FROM student WHERE name = ?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, "Tom");
int result = ps.executeUpdate();
```
8. 关闭连接
```java
rs.close();
ps.close();
conn.close();
```
以上就是 Java 中使用 JDBC API 进行数据库增删改查的基本操作流程。需要注意的是,以上示例仅供参考,实际应用中还需要根据具体情况进行适当调整。