@RequestMapping(value = "/findBySqlUser") public String findBySqlUser(Prescription prescription, Model model, HttpServletRequest request, HttpServletResponse response){ //分页查询 String sql = "SELECT * FROM prescription WHERE 1=1 ";//and isDelete = 0 if(!isEmpty(prescription.getName())){ sql += " and name like '%"+prescription.getName()+"%'"; } if(!isEmpty(prescription.getElement())){ sql += " and element like '%"+prescription.getElement()+"%'"; } if(!isEmpty(prescription.getEffect())){ sql += " and effect like '%"+prescription.getEffect()+"%'"; } if(!isEmpty(prescription.getSource())){ sql += " and source like '%"+prescription.getSource()+"%'"; } sql += " ORDER BY ID DESC "; Pager<Prescription> pagers = prescriptionService.findBySqlRerturnEntity(sql); model.addAttribute("pagers", pagers); //存储查询条件 model.addAttribute("obj", prescription); return"prescription/prescriptionUser"; }
@Controller @RequestMapping("/medicinalMaterials") publicclassMedicinalMaterialsControllerextendsBaseController{ /** * 依赖注入 start dao/service/=== */ @Autowired private MedicinalMaterialsService medicinalMaterialsService; @RequestMapping(value = "/findBySql") public String findBySql(MedicinalMaterials medicinalMaterials, Model model, HttpServletRequest request, HttpServletResponse response){ //分页查询 String sql = "SELECT * FROM medicinal_materials WHERE 1=1 and isDelete = 0 ";// if(!isEmpty(medicinalMaterials.getCode())){ sql += " and code like '%"+medicinalMaterials.getCode()+"%'"; } if(!isEmpty(medicinalMaterials.getName())){ sql += " and name like '%"+medicinalMaterials.getName()+"%'"; } if(!isEmpty(medicinalMaterials.getType())){ sql += " and type like '%"+medicinalMaterials.getType()+"%'"; } if(!isEmpty(medicinalMaterials.getTaste())){ sql += " and taste like '%"+medicinalMaterials.getTaste()+"%'"; } if(!isEmpty(medicinalMaterials.getEffect())){ sql += " and effect like '%"+medicinalMaterials.getEffect()+"%'"; } if(!isEmpty(medicinalMaterials.getUseAmount())){ sql += " and useAmount like '%"+medicinalMaterials.getUseAmount()+"%'"; } if(!isEmpty(medicinalMaterials.getAlias())){ sql += " and alias like '%"+medicinalMaterials.getAlias()+"%'"; } if(!isEmpty(medicinalMaterials.getUsages())){ sql += " and usage like '%"+medicinalMaterials.getUsages()+"%'"; } if(!isEmpty(medicinalMaterials.getIsDelete())){