Hibernate的增删改查(基于getCurrentSession)

我会带着你远行 2022-07-17 00:16 204阅读 0赞

博主在学习到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(); 			
    	}
    }