本文介绍了一个关于批量删除股票记录的方法实现及遇到的 ClassCastException 异常问题。该问题出现在使用 HQL 语句执行删除操作的过程中，涉及数据库连接与预编译语句设置。
//方法如下
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)
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)
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
