BIT校园失物招领系统

    <ul class="nav nav-tabs" style="font-weight:bold;font-family:微软雅黑;font-size:16px;background:white;">
                    <li class="active">
                        <a id="shia" onclick="this.style.backgroundColor='whiteSmoke';xuna.style.backgroundColor='white';" 
                        onmouseover="this.style.backgroundColor='whiteSmoke';xuna.style.backgroundColor='white';" 
                        style="background:whiteSmoke;" href="${path}/index.html#find" data-toggle="tab">
                        <i class="icon-picture"></i> 
                        <h2 style="font-size:16px;display:inline;line-height:16px;">最新招领信息</h2>
                        </a>
                    </li>
                    <li>
                        <a id="xuna" onclick="this.style.backgroundColor='whiteSmoke';shia.style.backgroundColor='white';" 
                        onmouseover="this.style.backgroundColor='whiteSmoke';shia.style.backgroundColor='white';" 
                        href="${path}/index.html#lost" data-toggle="tab"><i class="icon-zoom-in"></i>
                        <h2 style="font-size:16px;display:inline;line-height:16px;">最新寻物信息</h2>
                        </a>
                    </li>
                </ul>

     // 丢失东西发帖
    	@SystemControllerLog(description = "发寻物贴")
    	@Token(remove=true)
    	@RequestMapping(value = { "/lost-publish.html" }, method = RequestMethod.POST)
    	public String publishPickThings(LostThings lostThings, @RequestParam(value = "Img", required = false) MultipartFile multipartFile,
    			HttpServletRequest request) {
    		lostThings.setPublishTime(new Date());
    		lostThings.setStatus(Constants.THINGS_STATE_PUBLISHED);
    		System.out.println("lost-publish.html..." + lostThings);
    		// 通过上下文取获取我们的虚拟路径的实际地址
    		String basePath = super.getUploadBasePath(request) + "/lost";
    		basePath = MakeFolderUtil.makeDir(basePath, new Date(), lostThings.getUserName());
    		
    		String fileName = "";
    		if (multipartFile.getOriginalFilename() != null
    				&& !"".equals(multipartFile.getOriginalFilename()))
    			fileName = super.upload(multipartFile, request, basePath);
    
    		if (fileName == null) {
    			request.setAttribute("lostThings", lostThings);
    			request.setAttribute("upErr", "图片上传失败!");
    			
    			return "user/lost-publish";
    		}
    
    		if(!"".equals(fileName)) {
    			String savePath = basePath.substring(basePath.indexOf("static"));
    			savePath = savePath + "/" + fileName;
    			lostThings.setThingsImg(savePath);
    		}
    
    		if (!lostThingsService.add(lostThings)) {
    			request.setAttribute("lostThings", lostThings);
    			request.setAttribute("saveErr", "发帖失败!");
    
    			return "user/lost-publish";
    		}
    
    		return "user/user-center";
    	}

     // 捡到东西发帖
    	@SystemControllerLog(description = "发招领贴")
    	@Token(remove=true)
    	@RequestMapping(value = { "/find-publish.html" }, method = RequestMethod.POST)
    	public String publishPickThings(PickThings pickThings, @RequestParam(value = "Img", required = false) MultipartFile multipartFile,
    			HttpServletRequest request) {
    		pickThings.setPublishTime(new Date());
    		pickThings.setStatus(Constants.THINGS_STATE_PUBLISHED);
    		System.out.println("find-publish..." + pickThings);
    		// 通过上下文取获取我们的虚拟路径的实际地址
    		String basePath = super.getUploadBasePath(request) + "/find";
    		basePath = MakeFolderUtil.makeDir(basePath, new Date(), pickThings.getUserName());
    
    		String fileName = "";
    		if (multipartFile.getOriginalFilename() != null
    				&& !"".equals(multipartFile.getOriginalFilename()))
    			fileName = super.upload(multipartFile, request, basePath);
    
    		if (fileName == null) {
    			request.setAttribute("pickThings", pickThings);
    			request.setAttribute("upErr", "图片上传失败!");
    			
    			return "user/find-publish";
    		}
    
    		if(!"".equals(fileName)){
    			String savePath = basePath.substring(basePath.indexOf("static"));
    			savePath = savePath + "/" + fileName;
    			pickThings.setThingsImg(savePath);
    		}
    
    		if (!pickThingsService.add(pickThings)) {
    			request.setAttribute("pickThings", pickThings);
    			request.setAttribute("saveErr", "发帖失败!");
    			
    			return "user/find-publish";
    		}
    
    		return "user/user-center";
    	}

     // 查询所有
    	@SuppressWarnings("unchecked")
    	@Override
    	public List<ExpressThanks> findAll(String key, Integer pageIndex,
    			Integer pageSize, String sortField, String sortOrder) {
    		Session session = super.getSession();
    		String hql = "from ExpressThanks thanks ";
    		if (key != null && key != "")
    			hql += "where thanks.title like '%" + key + "%'  or thanks.userName like '%" + key + "%'";
    
    		if (StringUtil.isNullOrEmpty(sortField) == false) {
    			if ("desc".equals(sortOrder) == false) {
    				sortOrder = "asc";
    			}
    			hql += " order by " + sortField + " " + sortOrder;
    		} else {
    			hql += " order by thanks.leaveTime desc";
    		}
    
    		Query query = session.createQuery(hql);
    		query.setFirstResult(pageIndex * pageSize).setMaxResults(pageSize);
    		return query.list();
    	}

      // 批量导入用户
    	@RequestMapping(value = { "/user-import.do" }, method = RequestMethod.POST)
    	public @ResponseBody Map<String, String> toImportUser(HttpServletRequest request, HttpServletResponse respons) throws InvalidFormatException {
    
    		Map<String, String> map = new HashMap<String, String>();
    		MultipartHttpServletRequest mulRequest = (MultipartHttpServletRequest) request;
    		MultipartFile file = mulRequest.getFile("excelFile");
    		String filename = file.getOriginalFilename();
    		String extension = filename.substring(filename.lastIndexOf("."));
    		if(!".xls".equals(extension) && !".xlsx".equals(extension)) {
    			map.put("mesg", "请选择excel格式的文件!");
    			return map;
    		}
    		
    		// 如果文件名为空则什么都不做
    		if (filename != null && !"".equals(filename)) {
    			try {
    				InputStream in = file.getInputStream();
    				Workbook workBook = null;
    				if (!in.markSupported()) {
    					in = new PushbackInputStream(in, 8);
    				}
    				// 读写xls和xlsx格式时，HSSFWorkbook针对xls，XSSFWorkbook针对xlsx
    				if (POIFSFileSystem.hasPOIFSHeader(in)) {
    					workBook = new HSSFWorkbook(in);
    				} else if (POIXMLDocument.hasOOXMLHeader(in)) {
    					workBook = new XSSFWorkbook(OPCPackage.open(in));
    				}
    				
    				List<User> userList = ExcelImportUtil.exportListFromExcel(workBook);
    				userService.addUser(userList);
    				//System.out.println("获取到的数据：" + userList.size());
    			} catch (IOException e) {
    				e.printStackTrace();
    				map.put("mesg", "导入数据失败!");
    				return map;
    			}
    		}
    		map.put("mesg", "导入数据成功!");
    		
    		return map;
    	}