SpringJDBC批量处理数据代码示例

List<Map> paramMaps = new ArrayList<Map>();

for ( int i = 0 ; i < 100 ; i++ ){

     Map paramMap = new HashMap();

     paramMap.put( "param1" , "param1" );

     paramMap.put( "param2" , "param2" );

     paramMap.put( "param3" , "param3" );

     paramMap.put( "param4" , "param4" );

     paramMap.put( "param5" , "param5" );

     paramMaps.add(paramMap);

}

Map[] paramMap = paramMaps.toArray( new HashMap[paramMaps.size()]);

public void saveSpringJDBC(Map[] paramMap) throws Exception {

     NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(jdbcTemplate);

     StringBuffer sql = new StringBuffer();

     sql.append( "Insert into 表名 " );

     sql.append( "  (param1, param2, param3, param4) " );

     sql.append( " Values " );

     sql.append( "  (:param1, :param2, :param3, :param4 " );

     namedParameterJdbcTemplate.batchUpdate(sql.toString(), paramMap);

}

public void ticketIssueCusInfo(Map[] paramMap) throws Exception{

     NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(jdbcTemplate);

     StringBuffer sql = new StringBuffer();

     sql.append( " UPDATE 表名 " );

     sql.append( " SET param1= :param1, param2 = :param2 " );

     sql.append( " WHERE param3 = :param3" );

     namedParameterJdbcTemplate.batchUpdate(sql.toString(), paramMap);

}