Spring管理Hibernate以后Dao的操作

＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊DAO必须extends HibernateDaoSupport
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊1.在spring的dao层通过extends HibernateDaoSupport来使用save方法保存对象

return (Integer)this.getHibernateTemplate().save(user)

2.根据userId来查找User对象
public User getUserById(User user) {
return (User) this.getHibernateTemplate().load(User.class,user.getUserId());
}
3.插入User对象
public int saveUser(User user) {
return (Integer) this.getHibernateTemplate().save(user);
}
4.查询所有
@SuppressWarnings("unchecked")
public List<User> findAllUser(){
String hql = "from User";
return this.getHibernateTemplate().find(hql);
}
5.根据userId来查找User对象
public User findUserById(User user){
String hql = "from User u where u.userId=?";
return (User)this.getHibernateTemplate().find(hql,user.getUserId()).get(0);
}
6.删除与修改
public int deleteUserById(User user){
String hql = "delete from User where userId=?";
return this.getHibernateTemplate().bulkUpdate(hql,user.getUserId());
}

7.查询所有
@SuppressWarnings("unchecked")
public List<User> findAllUser1(){
return this.getHibernateTemplate().executeFind(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException {
String hql = "from User";
Query query = session.createQuery(hql);
return query.list();
}});
}
8.根据ID查询用户信息
public User findUserById1(final User user){
return (User)this.getHibernateTemplate().execute(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException {
String hql = "from User u where u.userId=:userId";
Query query = session.createQuery(hql);
query.setParameter("userId",user.getUserId() );
return query.uniqueResult();
}});
}
9.删除、修改
public int deleteUserById1(final User user){
return (Integer)this.getHibernateTemplate().execute(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException {
//session.save(arg0);
String hql = "delete from User where userId=:userId";
Query query = session.createQuery(hql);
query.setParameter("userId", user.getUserId());
return query.executeUpdate();
}});
}


【如果还有疑问，请联系 756326005(雨一直下),希望可以帮到你】