继续Java代码实现MySQL数据库连接和增删改查
时间: 2023-02-27 18:03:30 浏览: 79
好的,我来为您介绍如何在Java代码中实现MySQL数据库的连接和增删改查操作。
首先,需要使用JDBC驱动来连接MySQL数据库,需要在代码中加载该驱动,例如:
```
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
```
然后,可以使用DriverManager类来创建数据库连接,例如:
```
Connection connection = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/database_name",
"username",
"password"
);
```
接下来,就可以使用该连接来实现增删改查操作了。
- 增加:
```
String sql = "INSERT INTO table_name (column1, column2, column3) VALUES (?, ?, ?)";
PreparedStatement statement = connection.prepareStatement(sql);
statement.setString(1, value1);
statement.setString(2, value2);
statement.setString(3, value3);
statement.executeUpdate();
```
- 删除:
```
String sql = "DELETE FROM table_name WHERE column = ?";
PreparedStatement statement = connection.prepareStatement(sql);
statement.setString(1, value);
statement.executeUpdate();
```
- 修改:
```
String sql = "UPDATE table_name SET column1 = ? WHERE column2 = ?";
PreparedStatement statement = connection.prepareStatement(sql);
statement.setString(1, newValue1);
statement.setString(2, value2);
statement.executeUpdate();
```
- 查询:
```
String sql = "SELECT column1, column2, column3 FROM table_name WHERE column2 = ?";
PreparedStatement statement = connection.prepareStatement(sql);
statement.setString(1, value2);
ResultSet resultSet = statement.executeQuery();
while (resultSet.next()) {
String column1 = resultSet.getString("column1");
String column2 = resultSet.getString("column2");
String column3 = resultSet.getString("column3");
// 处理结果
}
```
希望这些代码示