除了连接数据库,还有java增删改数据库
时间: 2023-10-17 21:07:04 浏览: 39
是的,Java可以使用JDBC(Java Database Connectivity)API来增删改数据库。下面是一个简单的示例代码:
```
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class DatabaseOperations {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";
try {
Connection connection = DriverManager.getConnection(url, username, password);
// Insert data into table
String insertQuery = "INSERT INTO mytable (column1, column2, column3) VALUES (?, ?, ?)";
PreparedStatement insertStatement = connection.prepareStatement(insertQuery);
insertStatement.setString(1, "value1");
insertStatement.setString(2, "value2");
insertStatement.setString(3, "value3");
int rowsInserted = insertStatement.executeUpdate();
System.out.println(rowsInserted + " rows inserted.");
// Update data in table
String updateQuery = "UPDATE mytable SET column1 = ? WHERE column2 = ?";
PreparedStatement updateStatement = connection.prepareStatement(updateQuery);
updateStatement.setString(1, "newvalue");
updateStatement.setString(2, "value2");
int rowsUpdated = updateStatement.executeUpdate();
System.out.println(rowsUpdated + " rows updated.");
// Delete data from table
String deleteQuery = "DELETE FROM mytable WHERE column3 = ?";
PreparedStatement deleteStatement = connection.prepareStatement(deleteQuery);
deleteStatement.setString(1, "value3");
int rowsDeleted = deleteStatement.executeUpdate();
System.out.println(rowsDeleted + " rows deleted.");
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
```
在这个示例中,我们使用JDBC连接到MySQL数据库,并执行了插入、更新和删除操作。您需要根据自己的数据库和表结构修改代码。