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);
0 0
原创粉丝点击