房地产项目

1.学习使用SQL的语句

<?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.bw.dao.IHouseDao">    <!--//login验证-->    <select id="findPerson" parameterType="Person" resultType="Person">        select * from t_person  where person_name=#{personName } and person_pwd=#{personPwd}    </select>    <!--//房屋信息的列表展示 及分页查询 及模糊查询-->    <select id="findHouseAll" parameterType="Map" resultType="HolderHouse">        select * from t_house h,t_holder ho where h.person_id=ho.id        <if test="begin!=null and pageSize!=null">             limit #{begin},#{pageSize}        </if>        <if test="houseName!=null and houseName!=''">        AND h.house_name LIKE concat(concat('%',#{houseName}),'%')        </if>        <if test="holderName!=null and holderName!=''">            and ho.holder_name=#{holderName}        </if>    </select>    <!--//查询户主信息-->    <select id="selHolder" resultType="Holder">        select * from t_holder    </select>    <!--//添加房屋信息-->    <insert id="addHouse" parameterType="House" useGeneratedKeys="true">        INSERT INTO t_house VALUES        (null,#{houseName},#{houseImg},#{houseArea},#{housePrice},#{houseTotal},#{personId},NOW(),NOW())    </insert>    <!--//删除房屋信息-->    <delete id="delHouse" parameterType="int">        delete from t_house where id =#{id}    </delete>    <!--//批量删除房屋信息-->    <delete id="delBatchHouse" parameterType="String">        delete from t_house where id IN(#{ids})    </delete>    <!--//修改房屋信息-->    <update id="updateHouse" parameterType="House">      UPDATE  t_house set house_name=#{houseName},house_area=#{houseArea},      house_price=#{housePrice},house_total=#{houseTotal},buy_date=NOW()      where id=#{id}    </update>    <!--//根据条件查询房屋信息-->    <select id="selHouseById" parameterType="House" resultType="HolderHouse">        select * from t_house h,t_holder ho        <where>            h.person_id=ho.id            <if test="id!=0">                and h.id=#{id}            </if>            <if test="personId!=0">                and h.person_id=#{personId}            </if>            <if test="houseName!=null and houseName!=''">                and h.house_name=#{houseName}            </if>        </where>    </select></mapper>

2.mapper文件对应的dao层方法

package com.bw.dao;import com.bw.pojo.Holder;import com.bw.pojo.HolderHouse;import com.bw.pojo.House;import com.bw.pojo.Person;import java.util.List;import java.util.Map;public interface IHouseDao {    //login验证    Person findPerson(Person person);    //房屋信息的列表展示 及分页查询 及模糊查询    List<HolderHouse> findHouseAll(Map<String,Object> map);    //查询户主信息    List<Holder>  selHolder();    //添加房屋信息    int addHouse(House house);    //删除房屋信息    int delHouse(int id);    //pi批量删除房屋信息    int delBatchHouse(String ids);    //修改房屋信息    int updateHouse(House house);    //根据条件查询房屋信息    List<HolderHouse> selHouseById(House house);}

3.impl,Service实现类的redis使用

    /**     * TODO redis  缓存     * @return     */    @Override    public List<Holder> selHolder(HttpSession session) {      RedisPool redis= RedisUtil.getRedisPool("friendHu");        List<Holder> holderNameList=new ArrayList<>();        List<Holder> holders=  iHouseDao.selHolder();        for (Holder ho: holders) {            holderNameList.add(ho);        }      redis.set("holderNameList",holderNameList);        List<Holder> holderList=(List)JSONArray.parseArray(redis.get("holderNameList"));       /* redis.lpush("holderList",holderNameList);       redis.lpop();        List<Holder> holderList=(List<Holder>) redis.lrange("holderList",30,5000,Holder.class);*/        System.out.println("Impl:"+holderList);        session.setAttribute("holderNameList",holderList);        return null;    }

4.控制层的业务交互

package com.bw.controller;import com.bw.pojo.HolderHouse;import com.bw.pojo.House;import com.bw.pojo.Person;import com.bw.service.IHouseService;import com.bw.util.FileUtil;import org.springframework.stereotype.Controller;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 org.springframework.web.servlet.ModelAndView;import javax.annotation.Resource;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpSession;import java.util.HashMap;import java.util.List;import java.util.Map;@Controller@RequestMapping("/house")public class HouseController {    @Resource    private IHouseService iHouseService;    //login验证 和 根据户主名查询    @RequestMapping(value = "/findPerson",method = RequestMethod.POST)    @ResponseBody    public  Map<String,Object> findPerson(Person person,HttpSession session,String holderName ){        Map<String,Object> map=new HashMap<>();        session.setAttribute("holderName",holderName);        Person person1=  iHouseService.findPerson(person);        if(person1!=null){            map.put("flag",1);        }        map.put("flag2","查询成功！");        return map;    }    //房屋信息的列表展示 及分页查询 及模糊查询    @RequestMapping(value = "/findHouseAll",method = RequestMethod.POST)    public ModelAndView   findHouseAll(ModelAndView modelAndView,Integer begin,Integer pageSize,String houseName){        Map<String,Object> map=new HashMap<>();        map.put("begin",begin);        map.put("pageSize",pageSize);        map.put("houseName",houseName);    List<HolderHouse> houseList=iHouseService.findHouseAll(map);        modelAndView.addObject("houseList",houseList);        modelAndView.setViewName("show");        return modelAndView;    }    //根据户主名查询    @RequestMapping(value = "/fuzzyHouseAll",method = RequestMethod.GET)    public ModelAndView   fuzzyHouseAll(ModelAndView modelAndView,HttpSession session){        Map<String,Object> map=new HashMap<>();          map.put("holderName",session.getAttribute("holderName"));        List<HolderHouse> houseList=iHouseService.findHouseAll(map);        modelAndView.addObject("houseList",houseList);        modelAndView.setViewName("show");        return modelAndView;    }    //房屋信息的列表展示get请求    @RequestMapping(value = "/findAllHouse",method = RequestMethod.GET)    public ModelAndView   findAllHouse(ModelAndView modelAndView,HttpSession session){        Map<String,Object> map=new HashMap<>();        iHouseService.selHolder(session);        List<HolderHouse> houseList=iHouseService.findHouseAll(map);        modelAndView.addObject("houseList",houseList);        modelAndView.setViewName("show");        return modelAndView;    }    /*//根据户主查询信息 跳转页面    @RequestMapping(value = "/findHouseByName",method = RequestMethod.GET)    @ResponseBody    public Map<String,Object>   findHouseByName(HttpSession session,int personId){        Map<String,Object> map=new HashMap<>();        map.put("flag","查询成功！");        session.setAttribute("psersonId",personId);        return map;    }*/    //查询户主信息    @RequestMapping(value = "/selHolder",method = RequestMethod.GET)    public ModelAndView   selHolder(ModelAndView modelAndView, HttpSession session){        iHouseService.selHolder(session);        modelAndView.setViewName("insert");        return modelAndView;    }    //验证房产名称不能为空    @RequestMapping(value = "/selHouseByName",method = RequestMethod.POST)    @ResponseBody    public  Map<String,Object> selHouseByName(String houseName){       House house= new House();       house.setHouseName(houseName);        Map<String,Object> map=new HashMap<>();      List<HolderHouse> holderHouses=  iHouseService.selHouseById(house);     if(holderHouses.size()==0){         map.put("flag",1);     }        return map;    }    //添加房屋信息 注意上传文件    @RequestMapping(value = "/addHouse",method = RequestMethod.POST)    public ModelAndView   addHouse(@RequestParam(value = "file",required = false) MultipartFile file,HttpServletRequest request, ModelAndView modelAndView, House house)throws  Exception{        //判断文件上传是否为空        if (!file.isEmpty()){            //把上传的路径转为字符串存入路径            String picture= FileUtil.uploadFile(file,request);            //把路径存入            house.setHouseImg(picture);        }else {            house.setHouseImg("");        }        house.setHouseTotal(house.getHousePrice()*house.getHouseArea());        iHouseService.addHouse(house);        modelAndView.setViewName("redirect:/house/findAllHouse.action");        return modelAndView;    }    //删除房屋信息    @RequestMapping(value = "/delHouse",method = RequestMethod.GET)    public ModelAndView   delHouse(ModelAndView modelAndView,int id){        iHouseService.delHouse(id);        modelAndView.setViewName("redirect:/house/findAllHouse.action");        return modelAndView;    }    //批量删除房屋信息 sql 可$也可#    @RequestMapping(value = "/delBatchHouse",method = RequestMethod.POST)    @ResponseBody    public  Map<String,Object> delBatchHouse(String ids){        Map<String,Object> map=new HashMap<>();         iHouseService.delBatchHouse(ids);            map.put("flag","批量删除成功！");        return map;    }    //修改房屋信息    @RequestMapping(value = "/updateHouse",method = RequestMethod.POST)    public ModelAndView  updateHouse(ModelAndView modelAndView,House house){        house.setHouseTotal(house.getHousePrice()*house.getHouseArea());//总价      iHouseService.updateHouse(house);        modelAndView.setViewName("redirect:/house/findAllHouse.action");        return modelAndView;    }    //根据id查询房产信息返回修改页面    @RequestMapping(value = "/selHouseById",method = RequestMethod.GET)    public ModelAndView   selHouseById(ModelAndView modelAndView,int id){        House house=new House();        house.setId(id);        List<HolderHouse> holderHouses=  iHouseService.selHouseById(house);        modelAndView.addObject("houses",holderHouses.get(0));        modelAndView.setViewName("update");        return modelAndView;    }}