當想通過hibernate進行批量增加記錄的時候,或者到數據的時候會用到SQL語句。處理如下:
public Integer batchSave(final String sql){
Session session = this.getSession();
Transaction tx = session.beginTransaction();
Integer result = -1;
try {
tx.begin();
result = session.createSQLQuery(sql).executeUpdate();
session.flush();
tx.commit();
} catch (DataAccessException e) {
e.printStackTrace();
if (tx != null) {
tx.rollback();
}
} finally {
session.close();
}
return result;
}