hibernate 使用jdbc批量插入数据

来源:互联网 发布:淘宝客服晚上几点下班 编辑:程序博客网 时间:2024/05/22 03:33
   @Autowired           @Qualifier("sessionFactory")           protected SessionFactory sessionFactor           Session session = sessionFactory.openSession();Transaction tx = session.beginTransaction();session.doWork(new Work() {int count = 0;@Overridepublic void execute(Connection conn) throws SQLException {String sql = "INSERT INTO terminalxmltemp (tsn, orgId, typeId, flag, isEnable, errorMsg) VALUES (?, ?, ?, ?, ?, ?)";PreparedStatement ps = conn.prepareStatement(sql);for (TerminalXmlForm terminalXmlForm : terminals) {ps.setString(1, terminalXmlForm.getTsn());ps.setLong(2, terminalXmlForm.getGroupId());ps.setLong(3, terminalXmlForm.getTypeId());ps.setString(4, terminalXmlForm.getFlag());ps.setString(5, terminalXmlForm.getIsEnable());ps.setString(6, terminalXmlForm.getErrorMsg());ps.addBatch();if (++count % 1000 == 0) {ps.executeBatch();}}ps.executeBatch();}});tx.commit();session.close();


sessionFactory  在spring配置文件中配置

<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">

0 0
原创粉丝点击