用Hibernate 3吗 ??? so easy !!! public int delNews(final List arr_id) { return ( (Integer)this.getHibernateTemplate().execute( new HibernateCallback() { public Object doInHibernate(Session session) throws SQLException, HibernateException { Query q = session.createQuery( "delete net.csdn.News where arrid in (:ids)"); q.setParameterList("ids", arr_id); return new Integer(q.executeUpdate()); } })).intValue(); }
public int delNews(final List arr_id) {
return ( (Integer)this.getHibernateTemplate().execute(
new HibernateCallback() {
public Object doInHibernate(Session session) throws SQLException,
HibernateException {
Query q = session.createQuery(
"delete net.csdn.News where arrid in (:ids)");
q.setParameterList("ids", arr_id);
return new Integer(q.executeUpdate());
}
})).intValue();
}
在load的时候报错,没有load到值,查到的值是空的。昏
使用getObject()方法,或者 直接给一个id值测试一下了
get会直接执行SQL,load会从缓存中取.
public List getNewsList(final int num) {
return (List) getHibernateTemplate().execute( new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
String hql = "FROM News n1 order by id desc" ;
Query query = session.createQuery( hql );
query.setMaxResults( num ) ;
List list = query.list();
if ( list.size() > 0 ) {
return list;
} else {
return null;
}
}
});
}