Hibernate进行增删改查

Hibernate进行CRUD

增加

    @Override
    public void addUser(User user) {
        SessionFactory sessionfactory = HibernateUtil.getSessionfactory();
        Session session = sessionfactory.openSession();
        Transaction tx = session.beginTransaction();
        session.save(user);
        tx.commit();
        session.close();
        sessionfactory.close();
    }

修改

   @Override
    public void updateUser(User user) {
        SessionFactory sessionfactory = HibernateUtil.getSessionfactory();
        Session session = sessionfactory.openSession();
        Transaction tx = session.beginTransaction();
        session.update(user);
        tx.commit();
        session.close();
        sessionfactory.close();
    }

删除

    @Override
    public void delUser(int id) {
        SessionFactory sessionfactory = HibernateUtil.getSessionfactory();
        Session session = sessionfactory.openSession();
        Transaction tx = session.beginTransaction();
        User user = session.get(User.class, id);
        session.delete(user);
        tx.commit();
        session.close();
        sessionfactory.close();
    }

查询

1. 全部查询

      @Override
       public List<User> queryAllUser() {
           SessionFactory sessionfactory = HibernateUtil.getSessionfactory();
           Session session = sessionfactory.openSession();
           Transaction tx = session.beginTransaction();
   
           Query query = session.createQuery("from User");
           List<User> list = query.list();
           tx.commit();
           session.close();
           sessionfactory.close();
           return list;
       }
   

2. 通过id查询

      @Override
       public User queryById(int id) {
           SessionFactory sessionfactory = HibernateUtil.getSessionfactory();
           Session session = sessionfactory.openSession();
           Transaction tx = session.beginTransaction();
   
           Query query = session.createQuery("select * from User where id = " + id);
           User user = (User) query.uniqueResult();
           tx.commit();
           session.close();
           sessionfactory.close();
           return user;
       }