struts2查询的json格式的数据返回结果错误
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中:
<!-- 动态sql -->
<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>