java中的增删改查代码
时间: 2023-05-11 18:06:09 浏览: 424
增删改查代码是指对数据库进行增加、删除、修改、查询操作的代码。以下是Java中的增删改查代码示例:
增加数据:
```
String sql = "INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...)";
Statement statement = connection.createStatement();
statement.executeUpdate(sql);
```
删除数据:
```
String sql = "DELETE FROM table_name WHERE condition";
Statement statement = connection.createStatement();
statement.executeUpdate(sql);
```
修改数据:
```
String sql = "UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition";
Statement statement = connection.createStatement();
statement.executeUpdate(sql);
```
查询数据:
```
String sql = "SELECT column1, column2, ... FROM table_name WHERE condition";
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()) {
// 处理查询结果
}
```
注意:以上代码仅为示例,实际应用中需要根据具体情况进行修改。