Java 类org.springframework.jdbc.core.BatchUpdateUtils 实例源码

@Override
public int[] batchUpdate(String sql, List<Object[]> batchArgs, int[] argTypes) {
    return BatchUpdateUtils.executeBatchUpdate(sql, batchArgs, argTypes, getJdbcOperations());
}

public void queryBatchUpdateUnsafe(String input) {
    String sql = "UPDATE Users SET name = '"+input+"' where id = 1";
    BatchUpdateUtils.executeBatchUpdate(sql, new ArrayList<Object[]>(),new int[] {Types.INTEGER}, jdbcOperations);
}

public void queryBatchUpdateSafe() {
    String sql = "UPDATE Users SET name = 'safe' where id = 1";
    BatchUpdateUtils.executeBatchUpdate(sql, new ArrayList<Object[]>(),new int[] {Types.INTEGER}, jdbcOperations);
}

public int[] batchUpdate(String sql, List<Object[]> batchArgs, int[] argTypes) {
    return BatchUpdateUtils.executeBatchUpdate(sql, batchArgs, argTypes, getJdbcOperations());
}