struts2查询的json格式的数据返回结果错误

2014-04-06 05:56:35 322 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Hibernate使用SQL语句多表查询，并返回类json键值对问题描述：在Hibernate5中，使用原生SQL进行多表查询，并将其结果通过Struts2返回给前台的ajax请求、bootstrap-table请求。 1. 数据库数据库的表格数据大致如下： Invest表： id projectname investorid investmoney 1 SSFW 1 100 2 Universe 1 150 3 Universe... 阅读详情

action中：
public String findAllUserJson(){
HttpServletRequest req = ServletActionContext.getRequest();
List<Map<String, Object>> rows=new ArrayList<Map<String,Object>>();
rows=userService.selectUser();
Map<String, Object> obj = new HashMap<String, Object>();
obj.put("total", rows.size());
obj.put("rows", rows);
result=JSONObject.fromObject(obj);
System.out.println("resultresult="+result);
//List<User> users = userService.selectUserByCondition(new User());
return "userListJson";
}
service中：
public List<Map<String, Object>> selectUser() {
return userDao.selectUser();
}
dao中：
public List<Map<String, Object>> selectUser() {

return this.getSqlSession().selectList("cn.itcast.mybatis.domain.User.selectUserByConditionForMap");
}
mybatis中：

<select id="selectUserByConditionForMap" resultType="hashmap">
select * from user
</select>
查询结果为：
{"total":2,"rows":[{"AGE":10,"age":10,"address":"address001","NAME":"zhangsan","name":"zhangsan","id":"001","ADDRESS":"address001","ID":"001"},{"AGE":20,"age":20,"address":"address002","NAME":"wangwu","name":"wangwu","id":"002","ADDRESS":"address002","ID":"002"}]}
问题：
数据中只有age,id,address,name字段的两行数据，现在查询结果怎么有重复的数据id，ID,ADDREDD,address等
补充：struts配置文件中：
<result name="userListJson" type="json">
<param name="root">result</param>
</result>

...全文