ssm mysql多条件查询_SSM整合 mybatis多条件查询与分页

1 package com.etc.controller;2

3 import com.etc.Vo.HouseSearchVO;4 import com.etc.Vo.HouseVO;5 import com.etc.common.Constant;6 import com.etc.converter.HouseConverter;7 import com.etc.entity.House;8 import com.etc.entity.HouseSearch;9 import com.etc.entity.User;10 import com.etc.servise.HouseService;11 import com.github.pagehelper.PageHelper;12 import com.github.pagehelper.PageInfo;13 import org.apache.commons.io.IOUtils;14 import org.springframework.beans.factory.annotation.Autowired;15 import org.springframework.stereotype.Controller;16 import org.springframework.ui.Model;17 import org.springframework.util.StringUtils;18 import org.springframework.web.bind.annotation.ModelAttribute;19 import org.springframework.web.bind.annotation.RequestMapping;20

21 import javax.servlet.http.HttpServletResponse;22 import javax.servlet.http.HttpSession;23 import java.io.File;24 import java.io.FileInputStream;25 import java.io.IOException;26 import java.util.List;27

28 @Controller29 @RequestMapping("/house")30 public class HouseController {31

32 public static final String UPLOAD_DIR = "D:\\images\\";33

34 @RequestMapping("/images")35 public String images(String imgName, HttpServletResponse response) throws IOException {36 //将图片的输入流，复制到response的输出流中，37 IOUtils.copy(new FileInputStream(UPLOAD_DIR+imgName),response.getOutputStream());38 return null;39 }40

41

42 @Autowired43 private HouseService houseService;44

45 @RequestMapping("/add")46 public String add(HouseVO houseVO, HttpSession session) throws IOException {47 //获取session中的user对象48 User user = (User) session.getAttribute("user");49 //拿到user对象的id50 int userId = user.getUserId();51 //设置文件上传的路径52 houseVO.getHImg().transferTo(new File(UPLOAD_DIR + houseVO.getHImg().getOriginalFilename()));53 //建立house对象54 House house = HouseConverter.convert(houseVO, houseVO.getHImg().getOriginalFilename(), userId);55 //调用添加方法56 houseService.add(house);57 return "list";58 }59

60 @RequestMapping("/serach")61 public String serach(@ModelAttribute("vo") HouseSearchVO houseSearchVO, Model model, Integer pageNum) {62

63 HouseSearch houseSearch = getHouseSearch(houseSearchVO);64

65 if (pageNum == null) {66 pageNum = 1;67 }68

69 PageHelper.startPage(pageNum, Constant.PAGE_SIZE);70 Listserach = houseService.serach(houseSearch);71 PageInfo pageInfo = new PageInfo<>(serach);72

73 model.addAttribute("pageInfo", pageInfo);74 return "list";75 }76

77 private HouseSearch getHouseSearch(HouseSearchVO houseSearchVO) {78 HouseSearch houseSearch = new HouseSearch();79 if (!StringUtils.isEmpty(houseSearchVO.getHouseName())) {80 houseSearch.setHouseName(houseSearchVO.getHouseName());81 }82 if (!StringUtils.isEmpty(houseSearchVO.getFloorage())) {83 String[] split = houseSearchVO.getFloorage().split("-");84 houseSearch.setMinRect(Double.valueOf(split[0]));85 houseSearch.setMaxRect(Double.valueOf(split[1]));86 }87 return houseSearch;88 }89

90 }