java批量更新

最新推荐文章于 2025-11-08 08:15:00 发布

原创最新推荐文章于 2025-11-08 08:15:00 发布 · 383 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java

web开发同时被 2 个专栏收录

29 篇文章

订阅专栏

java

12 篇文章

订阅专栏

public void updateDoublePoints(final String[] games,final String[] servers,final Integer statu) {
String sql ="UPDATE dim.dim_game_server SET is_double_points_game_server=? WHERE game=? AND game_server = ?";

super.getJdbcTemplate().batchUpdate(sql, new BatchPreparedStatementSetter(){

public int getBatchSize(){
return games.length;
}
@Override
public void setValues(java.sql.PreparedStatement ps, int i)
throws SQLException {
ps.setInt(1, statu);
ps.setString(2, games[i]);
ps.setString(3, servers[i]);
}
});
}

@Override
public void deleteTableCategory(List<TableCategory> tableCategoryList){
  String sql="DELETE FROM metadata.table_category WHERE db_name=:dbName AND table_category=:tableCategory AND table_name=:tableName";
  SqlParameterSource[] params = SqlParameterSourceUtils.createBatch(tableCategoryList.toArray());
  tableCategoryJdbcTemplate.batchUpdate(sql, params);
}