Hql List Map 查找
来源:互联网 发布:国外怎么在淘宝买东西 编辑:程序博客网 时间:2024/06/07 23:10
// String hql = "select new Map(u.myCarPlateNo as myCarPlateNo, sm.dataId as dataId) From UserCarInfo u , StoreMember sm where 1=1 and u.memberId=sm.dataId and u.myCarPlateNo like:myCarPlateNo ";
// String hql = "select u.myCarPlateNo as myCarPlateNo , sm.dataId as dataId From UserCarInfo u , StoreMember sm where 1=1 and u.memberId=sm.dataId and u.myCarPlateNo like:myCarPlateNo ";
String hql = "select new List(u.myCarPlateNo as myCarPlateNo , sm.dataId as dataId ) From UserCarInfo u , StoreMember sm where 1=1 and u.memberId=sm.dataId and u.myCarPlateNo like:myCarPlateNo ";
// param.put("myCarPlateNo", "%粤CTEST1%");
param.put("myCarPlateNo", "%22%");
List list = super.find(hql, param); //query.list();
List llll= list;
System.out.println("OOOOOOOOOOOOOO"+llll.get(0));
System.out.println("========================================");
for(int kk=0; kk<llll.size();kk++){
String cccc = JSON.toJSONString( llll.get(kk) );
Map<String,Object> dataMap = JSON.parseObject(cccc);
System.out.println(dataMap.get("myCarPlateNo") +"====="+dataMap.get("dataId"));
}
System.out.println("========================================");
//dataMap.get("myCarPlateNo");
Object[] aa = list.toArray();
System.out.println(aa[0]);
Object oo = list.get(0);
System.out.println(oo);
// String hql = "select u.myCarPlateNo as myCarPlateNo , sm.dataId as dataId From UserCarInfo u , StoreMember sm where 1=1 and u.memberId=sm.dataId and u.myCarPlateNo like:myCarPlateNo ";
String hql = "select new List(u.myCarPlateNo as myCarPlateNo , sm.dataId as dataId ) From UserCarInfo u , StoreMember sm where 1=1 and u.memberId=sm.dataId and u.myCarPlateNo like:myCarPlateNo ";
// param.put("myCarPlateNo", "%粤CTEST1%");
param.put("myCarPlateNo", "%22%");
List list = super.find(hql, param); //query.list();
List llll= list;
System.out.println("OOOOOOOOOOOOOO"+llll.get(0));
System.out.println("========================================");
for(int kk=0; kk<llll.size();kk++){
String cccc = JSON.toJSONString( llll.get(kk) );
Map<String,Object> dataMap = JSON.parseObject(cccc);
System.out.println(dataMap.get("myCarPlateNo") +"====="+dataMap.get("dataId"));
}
System.out.println("========================================");
//dataMap.get("myCarPlateNo");
Object[] aa = list.toArray();
System.out.println(aa[0]);
Object oo = list.get(0);
System.out.println(oo);
0 0
- Hql List Map 查找
- hql查询返回list,map,自定义类型
- hql关联表、map/list查询
- 怎样用hibernate的hql查询查询成map或list
- hql语句中如果没有用Map,List分组的
- 怎样用hibernate的hql查询查询成map或list
- hql语句查询返回List<Map>
- Map与List查找性能比较
- 汉字得出对应的拼音;通过拼音查找map中的汉字,逆向map多个装成list
- List&Map
- list map
- hibernate项目的HQL(SQL区别、Select语句、返回list、map、object数组与单个对象)笔记整理
- list 查找
- Thymeleaf基础 遍历List、Map、List<map>、Map<List>
- Hql 查询map中key值?
- HQL总结 Select new map()
- hql中select new map的使用
- HQL 定制返回类型map ALIAS_TO_ENTITY_MAP
- Android5.1 之audiofocus学习总结
- Service Workers“早”知道?
- 读取流信息,转换成字符串并解决乱码问题
- Linux编译cximage生成动态链接库
- 关于BigDecimal在MySQL和Oracle中设计表的时候如何设计其类型的问题
- Hql List Map 查找
- Codeforces Round #331 (Div. 2)-Wilbur and Array(贪心模拟)
- CentOS6.5环境下使用镜像文件搭建本地yum源
- android pad上图片放在drawable文件夹下不正确的显示的讨巧的解决方法
- HTML文件中文乱码问题
- LeetCode Ugly Number || DP
- Socket中send函数的理解
- jQueryMobile快速入门
- C++重载,覆盖与隐藏