主页 / 问题 / 924115
Accepted
The Prototype
Asked:2020-12-22 19:58:34 +0000 UTC2020-12-22 19:58:34 +0000 UTC

在一个 PreparedStatement 中执行多个查询

  • 772

有一定的集合，需要在此基础上进行N次查询。我想将它们组合成一个查询并执行。怎么做才对？

private static final String DELETE_PERMISSION_QUERY = "DELETE FROM `" + TABLE + "` WHERE permission = ? AND server = ?;";

public void deleteExpiredPermissions(Set<Permission> expiredPermissions) {

    for (Permission permission : expiredPermissions) {
        this.connection = getConnection();
        try (PreparedStatement ps = this.connection.prepareStatement(DELETE_PERMISSION_QUERY)) {
            ps.setString(1, permission.getPermission());
            ps.setString(2, this.server);
            ps.executeUpdate();
            flushLastExecute();
        } catch (SQLException ex) {
            this.logger.log(Level.SEVERE, "Could not delete permission: " + permission.getPermission(), ex);
        }
    }

}
java

1 个回答

  1. Best Answer
    connection = getConnection();
try (PreparedStatement ps = connection.prepareStatement(DELETE_PERMISSION_QUERY)) {
    for (Permission permission : expiredPermissions) {
        ps.setString(1, permission.getPermission());
        ps.setString(2, this.server);
        ps.addBatch();
    }
    ps.executeBatch();
} catch (SQLException exc) {
    this.logger.log(Level.SEVERE, "Could not delete permission", exc);
}
    • 2

相关问题