Java - 批量插入用法(jdbcTemplate)

最新推荐文章于 2024-10-04 07:15:00 发布

chenyi0834

最新推荐文章于 2024-10-04 07:15:00 发布

阅读量4.2k

点赞数

文章标签： java string insert sql list join

本文链接：https://blog.csdn.net/chenyi0834/article/details/7518129

版权

一个List类型的：

public void insertBooks(List<Book>book)
{
final List<Book>tempBook=book;
String sql="insert into book(name,pbYear)values(?,?)";
jdbcTemplate.batchUpdate(sql, newBatchPreparedStatementSe tter()
{
public voidsetValues(PreparedStatement ps,int i)throws SQLException
{
Stringname=tempBook.get(i).getName();
intpbYear=tempBook.get(i).getPbYear();
ps.setString(1, name);
ps.setInt(2,pbYear);
}
public intgetBatchSize()
{
returntempBook.size();
}
});

}

两个数组类型的：

public int[] updateCompanyType(String[] unitIds, String[] unitType) {

           final List<String> list=new ArrayList<String>();
           for (int i = 0; i < unitIds.length; i++) {
               for (int j = 0; j < unitType.length; j++) {
                   list.add(unitIds[i]+","+unitType[j]);
               }
           }
       String sql="insert into map_unit_join_type (parentId,unitId,typeId,firstId,secondId,thirdId) values(?,?,?,?,?,?)";

       int[] counts=jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter(){
           public int getBatchSize() {
               return list.size();
           }
           public void setValues(PreparedStatement ps, int i)throws SQLException {
               String[] args=list.get(i).split(",");

               ps.setInt(1, Integer.parseInt(args[1]));
               ps.setInt(2, Integer.parseInt(args[0]));
               ps.setInt(3, Integer.parseInt(args[2]));
               ps.setInt(4, Integer.parseInt(args[3]));
               ps.setInt(5, Integer.parseInt(args[4]));
               ps.setInt(6, Integer.parseInt(args[5]));
           }
       });

}