jdbc批量插入数据
//插入很多书(批量插入用法) public void insertBooks(List<Book> book) { ??final List<Book> tempBook=book; ??String sql="insert into book(name,pbYear) values(?,?)"; ??jdbcTemplate.batchUpdate(sql,new BatchPreparedStatementSetter() ??{ ???public void setValues(PreparedStatement ps,int i)throws SQLException ???{ ????String name=tempBook.get(i).getName(); ????int pbYear=tempBook.get(i).getPbYear(); ????ps.setString(1,name); ????ps.setInt(2,pbYear); ???} ???public int getBatchSize() ???{ ????return tempBook.size(); ???} ??}); ??? } (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |