在hibernate 中如何转换JDBC的操作?
//方法如下
public void deleteBatch(int userid) throws Exception{
String hql = "DELETE FROM Stock AS stock WHERE stock.userid=?";
Connection conn = (Connection) session.connection();
PreparedStatement pstmt = conn.prepareStatement(hql);
pstmt.setInt(1, userid);
pstmt.executeUpdate();
pstmt.close();
conn.close();
}
//这是它所报的异常
java.lang.ClassCastException: $Proxy0
at com.icxq.impl.StockDAOImpl.deleteBatch(StockDAOImpl.java:51)
at com.test.Test.main(Test.java:12)Query q = session.createQuery( "delete Stock s where s.userId = :userid");q.setParameter("userid", userid, Integer);q.executeUpdate();
不过要注意批量操作直接更改数据库，没有更新Hibernate的一级、二级缓存
5 楼 卡拉阿风 2008-08-06 删除的时候。注意内存溢出 6 楼 movingboy 2008-08-06 <div class='quote_title'>卡拉阿风 写道</div>
<div class='quote_div'>删除的时候。注意内存溢出</div>
<p>为什么要注意这一点，能否详细说说？</p>