完整的javaSSM管理系统项目实例ssm.zip

package cn.pw.ssm.controller; import java.io.File; import java.io.IOException; import java.io.OutputStream; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.ServletOutputStream; import org.apache.commons.io.FileUtils; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.propertyeditors.CustomDateEditor; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.WebDataBinder; import org.springframework.web.bind.annotation.InitBinder; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.multipart.MultipartFile; import cn.pw.ssm.constrant.Const; import cn.pw.ssm.pojo.Standard; import cn.pw.ssm.service.StandardService; import cn.pw.ssm.util.PageBean; import cn.pw.ssm.util.PageSupport; @Controller public class StandardController { @Autowired private StandardService standardService; @RequestMapping("/index") public String index() { return "index"; } @InitBinder public void initBinder(WebDataBinder binder) { SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); dateFormat.setLenient(false); binder.registerCustomEditor(Date.class, new CustomDateEditor(dateFormat, true)); } @RequestMapping(value="/x") public String x() { return "x"; } @RequestMapping(value="/draw") public String draw() { return "draw"; } @RequestMapping(value="/ppt") public String ppt() { return "ppt"; } @RequestMapping(value="/schedule") public String schedule() { return "schedule"; } @RequestMapping(value="/word") public String word() throws IOException { Runtime.getRuntime().exec("notepad.exe"); return "x"; } @RequestMapping(value="/list") public String list(@RequestParam(name="queryCondition",required=false) String queryCondition, @RequestParam(name="pageIndex",defaultValue="1") String pageIndex,Model model) { PageBean<Standard> standards=standardService.getStandardList(queryCondition, Integer.parseInt(pageIndex)); model.addAttribute("standards", standards); model.addAttribute("queryCondition", queryCondition); return "list"; } @RequestMapping(value="/add") public String add() { return "add"; } @RequestMapping(value="judge") @ResponseBody public boolean judgeStandard(String stdNum) { return standardService.haveStandardStdNum(stdNum); } @RequestMapping(value="save",method=RequestMethod.POST) public String save(Standard standard,@RequestParam MultipartFile packagePath,HttpServletRequest request) { try { if(!packagePath.isEmpty()) { String pathName=request.getSession().getServletContext().getRealPath(File.separatorChar+Const.UPLOAD_PATH); String fileName=packagePath.getOriginalFilename(); String fileEx=fileName.substring(fileName.lastIndexOf("."),fileName.length()); fileName=System.currentTimeMillis()+fileEx; File destFile=new File(pathName+File.separatorChar+fileName); FileUtils.copyInputStreamToFile(packagePath.getInputStream(), destFile); standard.setPackagePath(fileName); } if(standardService.saveStandard(standard)) { request.getSession().setAttribute("hint", "增加成功"); }else { request.getSession().setAttribute("hint", "增加失败"); } } catch (Exception e) { e.printStackTrace(); request.getSession().setAttribute("hint", "增加失败"); } return "redirect:list"; } @RequestMapping(value="/{id}/update",method=RequestMethod.GET) public String update(@PathVariable int id,HttpServletRequest request) { Standard standard=standardService.getStandardById(id); request.setAttribute("standard", standard); return "update"; } @RequestMapping(value="update",method=RequestMethod.POST) public String update(Standard standard,@RequestParam MultipartFile pic,HttpServletRequest request) { try { if(!pic.isEmpty()) { String pathName=request.getSession().getServletContext().getRealPath(File.separatorChar+Const.UPLOAD_PATH); String fileName=pic.getOriginalFilename(); String fileEx=fileName.substring(fileName.lastIndexOf("."),fileName.length()); fileName=System.currentTimeMillis()+fileEx; File destFile=new File(pathName+File.separatorChar+fileName); FileUtils.copyInputStreamToFile(pic.getInputStream(), destFile); standard.setPackagePath(fileName); } if(standardService.updateStandard(standard)) { request.getSession().setAttribute("hint", "修改成功"); }else { request.getSession().setAttribute("hint", "修改失败"); } } catch (Exception e) { e.printStackTrace(); request.getSession().setAttribute("hint", "增加失败"); } return "redirect:list"; } @RequestMapping(value="delete/{id}") public String delete(@PathVariable int id,HttpServletRequest request) { if(standardService.deleteStandard(id)) { request.getSession().setAttribute("hint", "删除成功"); }else { request.getSession().setAttribute("hint", "删除失败"); } return "redirect:../list"; } PageSupport page=new PageSupport(); @RequestMapping(value="/excel") public void excel(HttpServletResponse response) throws IOException{ response.setCharacterEncoding("UTF-8"); List<Standard> list = standardService.queryExcelInfo(); System.out.println(list); //创建excel文件 HSSFWorkbook wb = new HSSFWorkbook(); //创建sheet页 HSSFSheet sheet = wb.createSheet("项目表"); //创建标题行 HSSFRow titleRow = sheet.createRow(0); titleRow.createCell(0).setCellValue("项目号"); titleRow.createCell(1).setCellValue("名称"); titleRow.createCell(2).setCellValue("类型"); titleRow.createCell(3).setCellValue("状态"); titleRow.createCell(4).setCellValue("开始时间"); titleRow.createCell(5).setCellValue("完成时间"); for (Standard standard: list) { HSSFRow dataRow = sheet.createRow(sheet.getLastRowNum()+1); dataRow.createCell(0).setCellValue(standard.getStdNum()); dataRow.createCell(1).setCellValue(standard.getZhName()); dataRow.createCell(2).setCellValue(standard.getWords()); dataRow.createCell(3).setCellValue(standard.getVersion()); dataRow.createCell(4).setCellValue(standard.getReleaseDate()); dataRow.createCell(5).setCellValue(standard.getImplDate()); } response.setContentType("application/octet-stream;charset=utf-8"); response.setHeader("Content-Disposition", "attachment;filename=" + new String("Project".getBytes(),"iso-8859-1") + ".xls"); OutputStream ouputStream = response.getOutputStream(); wb.write(ouputStream); ouputStream.flush(); ouputStream.close(); } public static void main(String[] args) { System.out.println("ok"); } }