通过姓名查找对象
public static List<Student> findByName(String qName){
Session session = HibernateUtil.getSession();
List<Student> list = null;
try {
trans = session.beginTransaction();
Query q = session.createQuery("from Student where name = ?");
q.setParameter(0, qName);
list = q.list();
//提交事务
trans.commit();
} catch (HibernateException e) {
e.printStackTrace();
trans.rollback();
}
return list;
}
添加信息
public static void save(Student student){
Session session = HibernateUtil.getSession();
try {
trans = session.beginTransaction();
session.save(student);
//提交事务
trans.commit();
} catch (HibernateException e) {
e.printStackTrace();
trans.rollback();
}
}
修改信息
public static void update(Student student){
Session session = HibernateUtil.getSession();
try {
//开启事务
trans = session.beginTransaction();
session.update(student);
trans.commit();
} catch (HibernateException e) {
e.printStackTrace();
trans.rollback();
}
}
通过id查找
public static Student findById(Student student){
Session session = HibernateUtil.getSession();
Student stu = null;
try {
//开启事务
trans = session.beginTransaction();
stu = (Student)session.get(Student.class, student.getId());
trans.commit();
} catch (HibernateException e) {
e.printStackTrace();
trans.rollback();
}
return stu;
}
查询所有
public static List<Student> findAll(){
Session session = HibernateUtil.getSession();
List<Student> list = null;
try {
//开启事务
trans = session.beginTransaction();
Query q = session.createQuery("from Student");
list = q.list();
/*Criteria criteria = session.createCriteria(Student.class);
//添加条件
criteria.add(Restrictions.eq("id", 1));
list = criteria.list();*/
trans.commit();
} catch (HibernateException e) {
e.printStackTrace();
trans.rollback();
}
return list;
}
分页查询
public static List<Student> findAll(int index,int size){
Session session = HibernateUtil.getSession();
List<Student> list = null;
try {
//开启事务
trans = session.beginTransaction();
Query q = session.createQuery("from Student");
q.setFirstResult(index);
q.setMaxResults(size);
list = q.list();
trans.commit();
} catch (HibernateException e) {
e.printStackTrace();
trans.rollback();
}
return list;
}
通过id删除
public static void delete(Serializable id){
Session session = HibernateUtil.getSession();
try {
//开启事务
trans = session.beginTransaction();
Student obj = (Student)session.get(Student.class, id);
if (obj != null) {
session.delete(obj);
}
trans.commit();
} catch (HibernateException e) {
e.printStackTrace();
trans.rollback();
}
}