hql查询对象、查询属性

最新推荐文章于 2022-05-09 13:24:32 发布

iteye_16498

最新推荐文章于 2022-05-09 13:24:32 发布

阅读量339

点赞数

分类专栏： hibernate3.6 文章标签： hql查询对象、查询属性

本文链接：https://blog.csdn.net/iteye_16498/article/details/82567739

版权

hibernate3.6 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

    //查询整个对象集合
    public void testHqlFind(){
    	Configuration cfg = new Configuration().configure();
    	SessionFactory sessionFactory = cfg.buildSessionFactory();
    	Session session = sessionFactory.openSession();
    	Transaction ts = session.beginTransaction();
    	//注意下面hql是查询的整个实体集合
    	List persons = session.createQuery(
    			"from Person p where name like :myname")
    			.setString("myname", "lijuan%").list();
    	for(Iterator it = persons.iterator();it.hasNext();){
    		Person p = (Person)it.next();
    		System.out.println(p.getName() + "-" + p.getAge());
    	}
    	ts.commit();
    	session.flush();
    	sessionFactory.close();
    }

    //查询属性
    public void testHqlFindProperty(){
    	Configuration cfg = new Configuration().configure();
    	SessionFactory sessionFactory = cfg.buildSessionFactory();
    	Session session = sessionFactory.openSession();
    	Transaction ts = session.beginTransaction();
    	//注意查询属性的方式：使用 p.id  p.name  p.address
    	List persons = session.createQuery("select p.id,p.name,p.address from Person p where p.name like :myname ")
    			       .setString("myname", "%lijuan%").list();
    	for(Iterator it = persons.iterator(); it.hasNext();){
    		Object[] objs = (Object[])it.next();
    		System.out.println(java.util.Arrays.toString(objs));
    	}
    }