hibernate map

最新推荐文章于 2019-05-24 20:39:13 发布

Mr.Z_z

最新推荐文章于 2019-05-24 20:39:13 发布

阅读量473

点赞数

分类专栏： hibernate 文章标签： hibernate

本文链接：https://blog.csdn.net/hety119/article/details/50497014

版权

hibernate 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

......

@Resource
SessionFactory sessionFactory;

.............

@Test
@Transactional
public void testCityList3(){
long accountId=4L;
String hql = "select r.roleKey from Role r left join r.accounts a where r.state=0 and a.id= ?";
List<String> list=sessionFactory.getCurrentSession().createQuery(hql).setParameter(0, accountId).list();
System.out.println("list:"+list);
int i=0;
for (String ss : list) {
System.out.println((++i)+":"+ss);
}
}

@Test
@Transactional
public void testCityList2(){
long accountId=4L;
String hql = "select new map(r.roleKey as roleKey,r.id as id ,r.name as name) from Role r left join r.accounts a where r.state=0 and a.id= ?";
List<Map<String,Object>> list = sessionFactory.getCurrentSession().createQuery(hql).setParameter(0, accountId).list();
System.out.println("====>>list.size:"+list.size()+" \nlist:"+list);
for (Map<String, Object> map : list) {
System.out.println("\t\trole:"+map.get("id")+"\t"+map.get("name")+"\t"+map.get("roleKey"));
}
}

...............