spring jdbcTemplate 批量执行SQL语句(update insert delete)
直接赋上案列代码

   
    public void saveObj(final List list)throws Exception{
        String sql = "insert into t_table(value1,value2,value3,value4,value5) values(?,?,?,?,?)";
        try{
            this.getJdbcTemplate().batchUpdate(sql, new BatchPreparedStatementSetter(){
                public int getBatchSize() {
                    return taInstswimwayList.size();
                }
                public void setValues(PreparedStatement pst, int i) throws SQLException {
                    Object obj = (Object ) list.get(i);
                    pst.setString(1, obj.Value1());
                    pst.setObject(2, obj.Value2());
                    pst.setString(3, obj.Value3());
                    pst.setString(4, obj.Value4());
                    pst.setString(5, obj.Value5());
                }
            });
        }catch(Exception e){
            e.printStackTrace();
            throw new Exception(e.getMessage());
        }
    }