Hibernate HQL查询入门例子

//新增操作
public void  add(roletable role){
	 Session session=HibernateUtil.createSessionFac();
	 Transaction trans=session.beginTransaction();	
	  Serializable res = session.save(role);
	  trans.commit();
	  session.close();
	  System.out.println("新增成功");
	}

	//删除
	public void del(int roleid){
		Session session=HibernateUtil.createSessionFac();
		Transaction trans=session.beginTransaction();
	     Object role=session.get(roletable.class, roleid);
	     if(role!=null)
	    	 session.delete(role);
	     trans.commit();
	     session.close();
	     System.out.println("删除成功");
	}

	//改
	public void update(roletable mode){
		Session session=HibernateUtil.createSessionFac();
		Transaction trans = session.beginTransaction();
		session.update(mode);
		trans.commit();
		session.close();
		 System.out.println("修改成功");
	}
	

	public List<roletable> findAll(){
		List<roletable> list=null;
		Session session=HibernateUtil.createSessionFac();
		Transaction trans = session.beginTransaction();
		Query query = session.createQuery("from roletable");
		list=query.list();
		for (roletable roletable : list) {
			System.out.println("====id"+roletable.getRoleID()+"==== rolename="+roletable.getRoleText());
		}
		trans.commit();
		session.close();
		return list;
	}

	public List<roletable> findByName(String name){
		List<roletable> list=null;
		Session session=HibernateUtil.createSessionFac();
		Transaction trans = session.beginTransaction();
		Query query = session.createQuery("from roletable where roleText=?");
		query.setParameter(0, name);
		list=query.list();
		trans.commit();
		session.close();
	    return list;
	}

转载于:https://my.oschina.net/mclongyi/blog/742227