// _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
// _/_/_/_/_/_/ 下面将产生JSON格式的返回值
// _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
@RequestMapping(value = "/select")
@ResponseBody
public Page select(
@ModelAttribute Page page,
@ModelAttribute User user,
Model uiModel,
HttpServletRequest httpServletRequest,
HttpServletResponse httpServletResponse) {
super.select(page, uiModel, httpServletRequest, httpServletResponse);
UserCriteria userCriteria = new UserCriteria();
UserCriteria.Criteria criteria = userCriteria.createCriteria();
userCriteria.setPage(page);
userCriteria.setOrderByClause("id desc");
if (null != user.getId() && !"".equals(user.getId())) {
criteria.andIdLike("%" + user.getId() + "%");
}
if (null != user.getUsername() && !"".equals(user.getUsername())) {
criteria.andUsernameLike("%" + user.getUsername() + "%");
}
if (null != user.getPassword() && !"".equals(user.getPassword())) {
criteria.andPasswordLike("%" + user.getPassword() + "%");
}
page = userService.select(userCriteria);
return page;
}
private List<Map<String, Object>> createExcelRecord(List<User> list) {
List<Map<String, Object>> listmap = new ArrayList<Map<String, Object>>();
Map<String, Object> map = new HashMap<String, Object>();
map.put("sheetName", "sheet1");
listmap.add(map);
User user = null;
for (int j = 0; j < list.size(); j++) {
user = list.get(j);
Map<String, Object> mapValue = new HashMap<String, Object>();
mapValue.put("Id", user.getId());
mapValue.put("Username", user.getUsername());
mapValue.put("Password", user.getPassword());
mapValue.put("Status", user.getStatus());
mapValue.put("Description", user.getDescription());
mapValue.put("Enabled", user.getEnabled());
mapValue.put("CreateDate", user.getCreateDate());
mapValue.put("UpdateDate", user.getUpdateDate());
mapValue.put("Ip", user.getIp());
mapValue.put("Telephone", user.getTelephone());
mapValue.put("Salt", user.getSalt());
mapValue.put("Locked", user.getLocked());
mapValue.put("Email", user.getEmail());
mapValue.put("Sex", user.getSex());
mapValue.put("Address", user.getAddress());
listmap.add(mapValue);
}
return listmap;
}