使用SpringBoot+MyBatis+MySQL，利用HTML和jQuery技术，实现单表增删改查、条件查询和分页、文件上传...

package cn.mydoll.standard.controller; import cn.mydoll.standard.constant.Const; import cn.mydoll.standard.pojo.Standard; import cn.mydoll.standard.service.StandardService; import cn.mydoll.standard.utility.PageBean; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.propertyeditors.CustomDateEditor; import org.springframework.web.bind.WebDataBinder; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletResponse; import java.io.BufferedInputStream; import java.io.File; import java.io.FileInputStream; import java.io.OutputStream; import java.text.SimpleDateFormat; import java.util.Date; @RestController public class StandardController { @Autowired private StandardService standardService; @InitBinder public void initBinder(WebDataBinder binder) { SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd"); simpleDateFormat.setLenient(false); binder.registerCustomEditor(Date.class,new CustomDateEditor(simpleDateFormat,true)); } @RequestMapping(value = "/list") public PageBean<Standard> list(String queryCondition,int pageIndex){ return standardService.getStandardList(queryCondition,pageIndex); } @RequestMapping(value = "/validate") public boolean validate(String stdNum){ return standardService.validateStandard(stdNum); } @RequestMapping(value = "/save") public boolean save(Standard standard,@RequestParam MultipartFile pic){ try{ boolean result=false; if(!pic.isEmpty()){ String fileName=pic.getOriginalFilename(); String fileExName=fileName.substring(fileName.lastIndexOf("."),fileName.length()); fileName=System.currentTimeMillis()+fileExName; File destFile=new File(Const.UPLOAD_PATH+fileName); pic.transferTo(destFile); standard.setPackagePath(fileName); result=standardService.saveStandard(standard); } return result; }catch (Exception e){ e.printStackTrace(); return false; } } @RequestMapping(value = "/get") public Standard get(int id){ return standardService.getStandardById(id); } @RequestMapping(value = "update") public boolean update(Standard standard,@RequestParam MultipartFile pic){ try{ boolean result=false; if(!pic.isEmpty()){ String fileName=pic.getOriginalFilename(); String fileExName=fileName.substring(fileName.lastIndexOf("."),fileName.length()); fileName=System.currentTimeMillis()+fileExName; File destFile=new File(Const.UPLOAD_PATH+fileName); //删除原文件 deleteFile(standard.getPackagePath()); pic.transferTo(destFile); standard.setPackagePath(fileName); } result=standardService.updateStandard(standard); return result; }catch (Exception e){ e.printStackTrace(); return false; } } private void deleteFile(String fileName){ File oldFile=new File(Const.UPLOAD_PATH+fileName); if(oldFile.exists()){ oldFile.delete(); } } @RequestMapping(value = "/delete") public boolean delete(String id){ try{ boolean result=false; String[] ids=id.split(","); int count=0; for(int i=0;i<ids.length;i++){ Standard standard=standardService.getStandardById(Long.parseLong(ids[i])); deleteFile(standard.getPackagePath()); if(standardService.deleteStandard(Long.parseLong(ids[i]))){ count+=1; } } if(count==ids.length){ result=true; } return result; }catch (Exception e){ e.printStackTrace(); return false; } } @RequestMapping(value = "/download/{fileName}") public void download(@PathVariable String fileName, HttpServletResponse response){ response.setHeader("content-type", "application/octet-stream"); response.setContentType("application/octet-stream"); response.setHeader("Content-Disposition", "attachment;filename=" + fileName); byte[] buffer = new byte[1024]; BufferedInputStream bis=null; OutputStream os=null; try{ os=response.getOutputStream(); bis=new BufferedInputStream(new FileInputStream(new File(Const.UPLOAD_PATH+fileName))); int i=bis.read(buffer); while(i!=-1){ os.write(buffer,0,buffer.length); os.flush(); i=bis.read(buffer); } }catch(Exception e){ e.printStackTrace(); }finally { try{ if(null!=bis){ bis.close(); } }catch (Exception e){ e.printStackTrace(); } } } }