Hibernate进行CRUD
public class UserDaoImpl implements UserDao {
@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;
}
@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;
}
}