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();
}
查询
- 全部查询
@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;
}
- 通过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;
}