Hibernate的增删改查(基于getCurrentSession)-蒲公英云

Hibernate的增删改查(基于getCurrentSession)

博主在学习到hibernate的时候对原本的sql增删改查有一点疑问,特别是了解到getcurrentsession的时候,对查询单个数据,修改数据方面很困惑,今天查到一篇文章,特地转载到博客,和大家分享!

public class UserDaoImpl implements UserDao {
    @Autowired
    private SessionFactory sessionFactory;
    //登录
    public User selectUser(User user) throws Exception {
        Query query = sessionFactory.getCurrentSession().createQuery("from User u where u.name=? and u.password=?");
        query.setString(0, user.getName());
        query.setString(1, user.getPassword());
        List list = query.list();
        if(list==null||list.size()==0){
            throw new RuntimeException("查询失败");
        }
        return list.get(0);
    }
    //查询所有
    public List getAllUsers() throws Exception {
        Query query = sessionFactory.getCurrentSession().createQuery("from User");
        List list = query.list();
        return list;
    }
    //单个查询
    public User getUser(Integer id) throws Exception {
        return (User) sessionFactory.getCurrentSession().createQuery("from User u where u.id ="+id).uniqueResult();
    }
    //添加用户
    public void addUser(User user) throws Exception {
        System.out.println("11111111111111111"+user.getName());
        sessionFactory.getCurrentSession().save(user);
    }
    //删除用户
    public void delUser(Integer id) throws Exception {
        sessionFactory.getCurrentSession().createQuery("delete User u where u.id="+id).executeUpdate();           
    }
    //修改用户
    public void updateUser(User user) throws Exception {
         Session session = sessionFactory.getCurrentSession();
         session.beginTransaction();
         String hql = ("update User u set u.name = ?,u.password = ?,u.loginDate = ? where u.id = ?");  
         Query query = session.createQuery(hql);
         query.setParameter(0, user.getName());
         query.setParameter(1, user.getPassword());
         query.setParameter(2, user.getLoginDate());
         query.setParameter(3, user.getId());
         query.executeUpdate();
         session.getTransaction().commit();             
    }
}