Java 使用JDBC参数化IN子句的最佳方法是什么？

在JDBC中，确实没有直接的方法可以做到这一点。某些 JDBC驱动程序似乎支持

PreparedStatement#setArray()

你可以仅使用带有

String#join()

Collections#nCopies()

PreparedStatement#setObject()

public static String preparePlaceHolders(int length) {    return String.join(",", Collections.nCopies(length, "?"));}public static void setValues(PreparedStatement preparedStatement, Object... values) throws SQLException {    for (int i = 0; i < values.length; i++) {        preparedStatement.setObject(i + 1, values[i]);    }}

使用方法如下：

private static final String SQL_FIND = "SELECT id, name, value FROM entity WHERe id IN (%s)";public List<Entity> find(Set<Long> ids) throws SQLException {    List<Entity> entities = new ArrayList<Entity>();    String sql = String.format(SQL_FIND, preparePlaceHolders(ids.size()));    try (        Connection connection = dataSource.getConnection();        PreparedStatement statement = connection.prepareStatement(sql);    ) {        setValues(statement, ids.toArray());        try (ResultSet resultSet = statement.executeQuery()) { while (resultSet.next()) {     entities.add(map(resultSet)); }        }    }    return entities;}private static Entity map(ResultSet resultSet) throws SQLException {    Enitity entity = new Entity();    entity.setId(resultSet.getLong("id"));    entity.setName(resultSet.getString("name"));    entity.setValue(resultSet.getInt("value"));    return entity;}

请注意，某些数据库在该

IN