jdbc增刪改查代碼怎么寫

小億
84
2024-04-09 16:48:08
欄目: 編程語言

下面是一個(gè)簡(jiǎn)單的示例代碼，演示如何使用JDBC進(jìn)行增刪改查操作：

1、增加數(shù)據(jù)：

```java

Connection conn = DriverManager.getConnection(url, username, password);

String sql = "INSERT INTO table_name (column1, column2) VALUES (?, ?)";

PreparedStatement stmt = conn.prepareStatement(sql);

stmt.setString(1, "value1");

stmt.setString(2, "value2");

stmt.executeUpdate();

conn.close();

```

2、刪除數(shù)據(jù)：

```java

Connection conn = DriverManager.getConnection(url, username, password);

String sql = "DELETE FROM table_name WHERE column1 = ?";

PreparedStatement stmt = conn.prepareStatement(sql);

stmt.setString(1, "value1");

stmt.executeUpdate();

conn.close();

```

3、更新數(shù)據(jù)：

```java

Connection conn = DriverManager.getConnection(url, username, password);

String sql = "UPDATE table_name SET column1 = ? WHERE column2 = ?";

PreparedStatement stmt = conn.prepareStatement(sql);

stmt.setString(1, "new_value");

stmt.setString(2, "value2");

stmt.executeUpdate();

conn.close();

```

4、查詢數(shù)據(jù)：

```java

Connection conn = DriverManager.getConnection(url, username, password);

String sql = "SELECT * FROM table_name WHERE column1 = ?";

PreparedStatement stmt = conn.prepareStatement(sql);

stmt.setString(1, "value1");

ResultSet rs = stmt.executeQuery();

while (rs.next()) {

System.out.println(rs.getString("column1"));

System.out.println(rs.getString("column2"));

}

conn.close();

```

請(qǐng)注意，以上示例代碼是基于JDBC API，需要導(dǎo)入相應(yīng)的包，并且需要替換相應(yīng)的url、username、password、table_name、column和value等信息。

0 踩