易居项目

最新推荐文章于 2023-09-04 21:19:53 发布

gkkkxin

最新推荐文章于 2023-09-04 21:19:53 发布

阅读量179

点赞数

本文链接：https://blog.csdn.net/weixin_45615656/article/details/102664805

版权

项目文件位置
在这里插入图片描述对项目进行了图片显示，点击查询新页面

@Controller
@RequestMapping("house")
public class HouseViewController {

    @Autowired
    private IHouseViewService houseViewService;

   @RequestMapping("findFourHouse.do")
   public ModelAndView findFourHouse(){
       ModelAndView mv=new ModelAndView();
       List<HouseView> newHouses = houseViewService.findFourHouseByType(0);
       List<HouseView> oldHouse = houseViewService.findFourHouseByType(1);
       List<HouseView> rentHouses =houseViewService.findFourHouseByType(2);
       mv.addObject("newHouses",newHouses);
       mv.addObject("oldHouse",oldHouse);
       mv.addObject("rentHouses",rentHouses);
       mv.setViewName("../main");
       return mv;
   }

   @RequestMapping("findHouseById.do")
    public ModelAndView findHouseById(int houseId){
       HouseView house = houseViewService.findHouseByHouseId(houseId);
       ModelAndView mv=new ModelAndView();
       mv.addObject("houseInfo",house);
       mv.setViewName("details");
       return mv;
   }

    @RequestMapping("findHouse.do")
    public ModelAndView findHouse(@RequestParam(defaultValue = "1") int currentPage, int houseType){
        ModelAndView mv=new ModelAndView();
        List<HouseView> houses = houseViewService.findHouseByType(currentPage,houseType);
        List<HouseView> fh = houseViewService.findFourHouseByType(houseType);
        PageInfo<HouseView> pageInfo=new PageInfo<>(houses);
        mv.addObject("pageInfo",pageInfo);
        mv.addObject("fh",fh);
        if(houseType==0){
            mv.setViewName("newhouse");
        }else if(houseType==1){
            mv.setViewName("oldhouse");
        }else {
            mv.setViewName("renthouse");
        }
        return mv;
    }
    @RequestMapping("toHousePost2.do")
    public ModelAndView toHousePost2(@Param(value = "houseTitle") String houseTitle,
                                     @Param(value = "houseAddress") String houseAddress,
                                     @Param(value = "housePrice") BigDecimal housePrice,
                                     @Param(value = "priceUnit") String priceUnit,
                                     @Param(value = "houseHeadimg") MultipartFile houseHeadimg,
                                     @Param(value = "housePlanimg1") MultipartFile housePlanimg1,
                                     @Param(value = "housePlanimg2") MultipartFile housePlanimg2,
                                     @Param(value = "houseImg1") MultipartFile houseImg1,
                                     @Param(value = "houseImg2") MultipartFile houseImg2,
                                     @Param(value = "houseImg3") MultipartFile houseImg3,
                                     @Param(value = "houseImg4") MultipartFile houseImg4,
                                     @Param(value = "houseImg5") MultipartFile houseImg5,
                                     @Param(value = "houseImg6") MultipartFile houseImg6) throws IOException {
       House house=new House();
       house.setHouseTitle(houseTitle);
       house.setHouseAddress(houseAddress);
       house.setHousePrice(housePrice);
       house.setPriceUnit(priceUnit);
       house.setUserId(10005);

        Map<String, MultipartFile> images=new HashMap<>();

        if (houseHeadimg.getSize()!=0){
            String picName = YijuUtil.getPicName();
            house.setHouseHeadimg(picName);
            images.put(picName,houseHeadimg);
        }

        if (housePlanimg1.getSize()!=0){
            String picName = YijuUtil.getPicName();
            house.setHouseHeadimg(picName);
            images.put(picName,housePlanimg1);
        }

        if (housePlanimg2.getSize()!=0){
            String picName = YijuUtil.getPicName();
            house.setHouseHeadimg(picName);
            images.put(picName,housePlanimg2);
        }

        if (houseImg1.getSize()!=0){
            String picName = YijuUtil.getPicName();
            house.setHouseHeadimg(picName);
            images.put(picName,houseImg1);
        }
        if (houseImg2.getSize()!=0){
            String picName = YijuUtil.getPicName();
            house.setHouseHeadimg(picName);
            images.put(picName,houseImg2);
        }
        if (houseImg3.getSize()!=0){
            String picName = YijuUtil.getPicName();
            house.setHouseHeadimg(picName);
            images.put(picName,houseImg3);
        }
        if (houseImg4.getSize()!=0){
            String picName = YijuUtil.getPicName();
            house.setHouseHeadimg(picName);
            images.put(picName,houseImg4);
        }
        if (houseImg5.getSize()!=0){
            String picName = YijuUtil.getPicName();
            house.setHouseHeadimg(picName);
            images.put(picName,houseImg5);
        }
        if (houseImg6.getSize()!=0){
            String picName = YijuUtil.getPicName();
            house.setHouseHeadimg(picName);
            images.put(picName,houseImg6);
        }
        Set<String> keys = images.keySet();
        for(String key:keys){
           MultipartFile file = images.get(key);
           YijuUtil.upload(file.getBytes(),key);
        }
        houseViewService.postHouse(house);
        return null;
    }
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.yiju.dao.IHouseViewDao">
    <select id="findFourHouseByType" parameterType="int" resultType="com.yiju.pojo.HouseView">
        select * from tb_house a,tb_house_info b where a.house_id=b.house_id and a.is_delete=0
        and a.house_type=#{houseType} order by rand() limit 4
    </select>

    <select id="findHouseByHouseId" parameterType="int" resultType="com.yiju.pojo.HouseView">
        select * from tb_house a,tb_house_info b where a.house_id=b.house_id and a.is_delete=0
        and  a.house_id=#{houseId}
    </select>

    <select id="findHouseByType" parameterType="int" resultType="com.yiju.pojo.HouseView">
        select * from tb_house a,tb_house_info b where a.house_id=b.house_id and a.is_delete=0
        and a.house_type=#{houseType}
    </select>

    <insert id="postHouse" parameterType="com.yiju.bean.House">
        insert into tb_house(user_id, house_type, house_title, house_headimg, house_planimg1, house_planimg2, house_img1, house_img2, house_img3, house_img4, house_img5, house_img6, house_price, price_unit, house_address, is_delete, create_time, update_time)
        values (#{userId}, #{houseType}, #{houseTitle}, #{houseHeadimg}, #{housePlanimg1}, #{housePlanimg2}, #{houseImg1}, #{houseImg2}, #{houseImg3}, #{houseImg4}, #{houseImg5}, #{houseImg6}, #{housePrice}, #{priceUnit}, #{houseAddress}, #{isDelete}, #{createTime}, #{updateTime})
    </insert>
</mapper>

导入七牛云把图片放在七牛云上面

 public static String getPicName() {
        SimpleDateFormat sf=new SimpleDateFormat("yyyyMMdd");
        String picName=sf.format(new Date())+ UUID.randomUUID().toString();
        return picName;
    }

    public static void upload(byte[] file,String upload){
        final String  AK="V86-ao-ntbpWZrtv7QF4YQ-8CM6sA_TSx1qB8Gyc";
        final String  SK="4C2-dUzRqQJ7-LEKR7ON4ey5GKVZw83QyGf4gWQE";
        final String BUCKET="hualili1021";

        Configuration cfg=new Configuration(Zone.zone1()) ;
        UploadManager uploadManager=new UploadManager(cfg);
        Auth auth=Auth.create(AK,SK);
        String uptake = auth.uploadToken(BUCKET);
        try {
            Response response = uploadManager.put(file, upload, uptake);
            System.out.println(response);
        } catch (QiniuException e) {
            e.printStackTrace();
        }
    }

}