Ejemplo n.º 1
0
 // _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
 // _/_/_/_/_/_/ 下面将产生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;
 }
Ejemplo n.º 2
0
 @RequestMapping(value = "/{id}", produces = "text/html")
 public String show(@PathVariable("id") String id, Model uiModel) {
   User user = userService.selectByPrimaryKey(id);
   uiModel.addAttribute("user", user);
   uiModel.addAttribute("itemId", id);
   return "view/user/user_show";
 }
Ejemplo n.º 3
0
 @RequestMapping(value = "/update")
 @ResponseBody
 public String update(
     @ModelAttribute User user,
     HttpServletRequest httpServletRequest,
     HttpServletResponse httpServletResponse) {
   userService.update(user);
   String id = user.getId();
   return id;
 }
Ejemplo n.º 4
0
 @RequestMapping(value = "updateForm")
 public String update(
     @Valid User user,
     BindingResult result,
     Model uiModel,
     HttpServletRequest httpServletRequest) {
   uiModel.asMap().clear();
   userService.update(user);
   populateEditForm(uiModel, user);
   return "redirect:edit/" + encodeUrlPathSegment(user.getId().toString(), httpServletRequest);
 }
Ejemplo n.º 5
0
 @RequestMapping(value = "createForm", method = RequestMethod.POST)
 public String create(
     @Valid User user,
     BindingResult result,
     Model uiModel,
     HttpServletRequest httpServletRequest) {
   if (result.hasErrors()) {
     populateEditForm(uiModel, user);
     return "view/user/user_create";
   }
   userService.insert(user);
   populateEditForm(uiModel, user);
   return "redirect:/user/new";
   // return "redirect:/user/"
   //		+ encodeUrlPathSegment(user.getId().toString(),
   //				httpServletRequest);
 }
Ejemplo n.º 6
0
  @RequestMapping(value = "/deleteById")
  @ResponseBody
  public int deleteById(
      @RequestParam(value = "idstring") String idstring,
      HttpServletRequest httpServletRequest,
      HttpServletResponse httpServletResponse)
      throws IOException {

    String[] ids = idstring.split(",");
    List<String> list = new ArrayList<String>();
    for (String idstr : ids) {
      list.add(idstr);
    }
    int result = userService.deleteBatch(list);

    return result;
  }
Ejemplo n.º 7
0
 @RequestMapping(value = "/edit/{id}")
 public String updateForm(@PathVariable("id") String id, Model uiModel) {
   User user = userService.selectByPrimaryKey(id);
   populateEditForm(uiModel, user);
   return "view/user/user_update";
 }
Ejemplo n.º 8
0
  /**
   * 全部导出Excel.
   *
   * @param user
   * @param httpServletRequest
   * @param httpServletResponse
   * @throws IOException
   */
  @RequestMapping(value = "/exportExcel")
  public void exportExcel(
      @ModelAttribute User user,
      HttpServletRequest httpServletRequest,
      HttpServletResponse httpServletResponse)
      throws IOException {
    httpServletResponse.setCharacterEncoding("UTF-8");
    String filename = new String("用户信息".getBytes("GBK"), "iso8859-1");

    List<User> list = userService.selectAll();

    List<Map<String, Object>> maps = createExcelRecord(list);

    String columnNames[] = {
      "Id",
      "Username",
      "Password",
      "Status",
      "Description",
      "Enabled",
      "CreateDate",
      "UpdateDate",
      "Ip",
      "Telephone",
      "Salt",
      "Locked",
      "Email",
      "Sex",
      "Address",
      "UserGroup_id"
    }; // 列名
    String keys[] = {
      "Id",
      "Username",
      "Password",
      "Status",
      "Description",
      "Enabled",
      "CreateDate",
      "UpdateDate",
      "Ip",
      "Telephone",
      "Salt",
      "Locked",
      "Email",
      "Sex",
      "Address",
      "UserGroup_id"
    }; // map中的key
    Workbook hwb = ExcelUtil.createWorkBook(maps, keys, columnNames);

    SimpleDateFormat sdf = new SimpleDateFormat("yyyy_MM_dd_HH_mm_ss"); // 等价于now.toLocaleString()
    filename += "_" + sdf.format(new Date()) + ".xls";
    httpServletResponse.setContentType("APPLICATION/OCTET-STREAM");
    httpServletResponse.setHeader(
        "Content-Disposition", "attachment; filename=\"" + filename + "\"");
    OutputStream os = httpServletResponse.getOutputStream();
    hwb.write(os);
    os.flush();
    os.close();
  }
Ejemplo n.º 9
0
 @RequestMapping(value = "/{id}", method = RequestMethod.DELETE, produces = "text/html")
 public String delete(@PathVariable("id") String id, Model uiModel) {
   userService.deleteByPrimaryKey(id);
   uiModel.asMap().clear();
   return "redirect:/user";
 }