List<Map<String, Object>> mapCity = tbAllCityService.findCustom("select * from tb_All_City where PRO = 72 and name=#{p[0]}", new Object[]{tbUserInfo.getCity()}); json.fluentPut("cityInfo", tbAllCityService.findCustom("select * from tb_All_City where CITY = #{p[0]}", new Object[]{mapCity.get(0).get("SEQID")})); 改为list不要map
时间: 2024-04-11 21:26:30 浏览: 17
如果你想将返回的结果从Map转换为List,可以使用Java的Stream API来实现。具体操作如下:
```java
List<Object> cityInfo = tbAllCityService.findCustom("select * from tb_All_City where CITY = #{p[0]}", new Object[]{mapCity.get(0).get("SEQID")})
.stream()
.map(m -> m.get("SEQID"))
.collect(Collectors.toList());
json.fluentPut("cityInfo", cityInfo);
```
这样,你将得到一个包含所有"SEQID"值的List对象,并将其赋值给"cityInfo"键。注意,这里假设"SEQID"值的类型为Object,你可以根据实际情况进行类型转换。
相关问题
将 List<Map<String, Object>> mapCity = tbAllCityService.findCustom("select * from tb_All_City where PRO = 72 and name=#{p[0]}", new Object[]{tbUserInfo.getCity()}); json.fluentPut("cityInfo", tbAllCityService.findCustom("select * from tb_All_City where CITY = #{p[0]}", new Object[]{mapCity.get(0).get("SEQID")})); 改成和着代码一样的TbUserInfo parentUserInfo = new TbUserInfo(); parentUserInfo.setUsername(tbUserInfo.getParentId()); parentUserInfo.setPhone(DBCipherUtil.zwAddText(tbUserInfo.getPhone())); List<TbUserInfo> findListParentUserInfo = tbUserInfoService.findList(parentUserInfo); json.fluentPut("parentUserInfo", findListParentUserInfo.get(0));
根据你提供的代码示例,你想将以下代码改写成类似的形式:
```java
TbUserInfo parentUserInfo = new TbUserInfo();
parentUserInfo.setUsername(tbUserInfo.getParentId());
parentUserInfo.setPhone(DBCipherUtil.zwAddText(tbUserInfo.getPhone()));
List<TbUserInfo> findListParentUserInfo = tbUserInfoService.findList(parentUserInfo);
json.fluentPut("parentUserInfo", findListParentUserInfo.get(0));
```
你可以使用类似的方式来修改第一段代码:
```java
String cityName = tbUserInfo.getCity();
List<Map<String, Object>> mapCity = tbAllCityService.findCustom("select * from tb_All_City where PRO = 72 and name=#{p[0]}", new Object[]{cityName});
String seqId = (String) mapCity.get(0).get("SEQID");
TbAllCity cityInfo = tbAllCityService.findCustom("select * from tb_All_City where CITY = #{p[0]}", new Object[]{seqId});
json.fluentPut("cityInfo", cityInfo);
```
请注意,修改的代码是基于你提供的信息进行推测的,如果有任何错误,请根据实际情况进行调整。