pgsql java 删除
时间: 2023-10-03 19:09:32 浏览: 44
你可以使用Java中的JDBC驱动程序来连接到PostgreSQL数据库,并使用DELETE语句来删除数据。下面是一个简单的示例代码:
```
import java.sql.*;
public class PostgreSQLJDBC {
public static void main(String[] args) {
Connection c = null;
Statement stmt = null;
try {
Class.forName("org.postgresql.Driver");
c = DriverManager
.getConnection("jdbc:postgresql://localhost:5432/testdb",
"username", "password");
c.setAutoCommit(false);
System.out.println("Opened database successfully");
stmt = c.createStatement();
String sql = "DELETE from COMPANY where ID = 2;";
stmt.executeUpdate(sql);
c.commit();
ResultSet rs = stmt.executeQuery("SELECT * FROM COMPANY;");
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
String address = rs.getString("address");
float salary = rs.getFloat("salary");
System.out.println("ID = " + id);
System.out.println("NAME = " + name);
System.out.println("AGE = " + age);
System.out.println("ADDRESS = " + address);
System.out.println("SALARY = " + salary);
System.out.println();
}
rs.close();
stmt.close();
c.close();
} catch (Exception e) {
System.err.println(e.getClass().getName()+": "+e.getMessage());
System.exit(0);
}
System.out.println("Operation done successfully");
}
}
```
在这个例子中,我们连接到名为“testdb”的PostgreSQL数据库,然后使用DELETE语句删除ID为2的公司。最后,我们执行SELECT语句来检查是否已成功删除记录。