Hibernate-增删改查

通过姓名查找对象

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();
	}
}