易居住房信息1031之收藏夹

package com.yiju.bean;

/**

• 收藏类
  */
  public class Collect {

  private int collId; //收藏记录的唯一标识ID
  private int userId; //用户ID
  private int houseId; //用户收藏的房源ID
  private int isDelete; //是否删除 0-未删除 1-已删除
  private long createTime; //创建时间
  private long updateTime; //更新时间

  public int getCollId() {
  return collId;
  }

  public void setCollId(int collId) {
  this.collId = collId;
  }

  public int getUserId() {
  return userId;
  }

  public void setUserId(int userId) {
  this.userId = userId;
  }

  public int getHouseId() {
  return houseId;
  }

  public void setHouseId(int houseId) {
  this.houseId = houseId;
  }

  public int getIsDelete() {
  return isDelete;
  }

  public void setIsDelete(int isDelete) {
  this.isDelete = isDelete;
  }

  public long getCreateTime() {
  return createTime;
  }

  public void setCreateTime(long createTime) {
  this.createTime = createTime;
  }

  public long getUpdateTime() {
  return updateTime;
  }

  public void setUpdateTime(long updateTime) {
  this.updateTime = updateTime;
  }

  @Override
  public String toString() {
  return “Collect{” +
  “collId=” + collId +
  “, userId=” + userId +
  “, houseId=” + houseId +
  “, isDelete=” + isDelete +
  “, createTime=” + createTime +
  “, updateTime=” + updateTime +
  ‘}’;
  }
  }

package com.yiju.pojo;

import java.math.BigDecimal;

public class HouseView {

private int houseId; //房源ID
private String trueName; //发布人
private String houseTitle; //房源标题
private String houseHeadimg; //房源帖子头像
private BigDecimal housePrice; //房屋价格
private String priceUnit; //售价单位:元/每月 元/套 元/年
private int houseFloor; //楼层
private int floorAll; //全部楼层
private String houseAddress; //房源地址
private String houseLayout; //几室几厅几卫
private String houseDecorate; //精装,简装
private String houseArea; //房间面积
private long createTime; //创建时间
private String houseTurn; //房屋朝向
private String houseNature; //房屋性质
private String houseModel; //房屋类型
private String houseYear; //建造年份
private String houseValid; //有效期
private int houseLift; //是否有电梯
private String housePlanimg1;
private String housePlanimg2;
private String houseImg1; //房源室内图1
private String houseImg2; //房源室内图2
private String houseImg3; //房源室内图3
private String houseImg4; //房源室内图4
private String houseImg5; //房源室内图5
private String houseImg6; //房源室内图6
private String date; //获取年月日
private int bed; //床：0无 1有
private int washing; //洗衣机：0无 1有
private int air; //空调: 0无 1有
private int balcony; //阳台：0无 1有
private int ice; //冰箱：0无 1有
private int toilet; //卫生间：0无 1有
private int kitchen; //厨房：0无 1有
private int tv; //电视：0无 1有
private int heater; //热水器：0无 1有
private int wardrobe; //衣柜：0无 1有
private int heating; //暖气：0无 1有
private int internet; //宽带：0无 1有
private int sofa; //沙发：0无 1有
private int houseType;

public int getHouseType() {
    return houseType;
}

public void setHouseType(int houseType) {
    this.houseType = houseType;
}

public int getHouseId() {
    return houseId;
}

public void setHouseId(int houseId) {
    this.houseId = houseId;
}

public String getTrueName() {
    return trueName;
}

public void setTrueName(String trueName) {
    this.trueName = trueName;
}

public String getHouseTitle() {
    return houseTitle;
}

public void setHouseTitle(String houseTitle) {
    this.houseTitle = houseTitle;
}

public String getHouseHeadimg() {
    return houseHeadimg;
}

public void setHouseHeadimg(String houseHeadimg) {
    this.houseHeadimg = houseHeadimg;
}

public BigDecimal getHousePrice() {
    return housePrice;
}

public void setHousePrice(BigDecimal housePrice) {
    this.housePrice = housePrice;
}

public String getPriceUnit() {
    return priceUnit;
}

public void setPriceUnit(String priceUnit) {
    this.priceUnit = priceUnit;
}

public int getHouseFloor() {
    return houseFloor;
}

public void setHouseFloor(int houseFloor) {
    this.houseFloor = houseFloor;
}

public int getFloorAll() {
    return floorAll;
}

public void setFloorAll(int floorAll) {
    this.floorAll = floorAll;
}

public String getHouseAddress() {
    return houseAddress;
}

public void setHouseAddress(String houseAddress) {
    this.houseAddress = houseAddress;
}

public String getHouseLayout() {
    return houseLayout;
}

public void setHouseLayout(String houseLayout) {
    this.houseLayout = houseLayout;
}

public String getHouseDecorate() {
    return houseDecorate;
}

public void setHouseDecorate(String houseDecorate) {
    this.houseDecorate = houseDecorate;
}

public String getHouseArea() {
    return houseArea;
}

public void setHouseArea(String houseArea) {
    this.houseArea = houseArea;
}

public long getCreateTime() {
    return createTime;
}

public void setCreateTime(long createTime) {
    this.createTime = createTime;
}

public String getHouseTurn() {
    return houseTurn;
}

public void setHouseTurn(String houseTurn) {
    this.houseTurn = houseTurn;
}

public String getHouseNature() {
    return houseNature;
}

public void setHouseNature(String houseNature) {
    this.houseNature = houseNature;
}

public String getHouseModel() {
    return houseModel;
}

public void setHouseModel(String houseModel) {
    this.houseModel = houseModel;
}

public String getHouseYear() {
    return houseYear;
}

public void setHouseYear(String houseYear) {
    this.houseYear = houseYear;
}

public String getHouseValid() {
    return houseValid;
}

public void setHouseValid(String houseValid) {
    this.houseValid = houseValid;
}

public int getHouseLift() {
    return houseLift;
}

public void setHouseLift(int houseLift) {
    this.houseLift = houseLift;
}

public String getHousePlanimg1() {
    return housePlanimg1;
}

public void setHousePlanimg1(String housePlanimg1) {
    this.housePlanimg1 = housePlanimg1;
}

public String getHousePlanimg2() {
    return housePlanimg2;
}

public void setHousePlanimg2(String housePlanimg2) {
    this.housePlanimg2 = housePlanimg2;
}

public String getHouseImg1() {
    return houseImg1;
}

public void setHouseImg1(String houseImg1) {
    this.houseImg1 = houseImg1;
}

public String getHouseImg2() {
    return houseImg2;
}

public void setHouseImg2(String houseImg2) {
    this.houseImg2 = houseImg2;
}

public String getHouseImg3() {
    return houseImg3;
}

public void setHouseImg3(String houseImg3) {
    this.houseImg3 = houseImg3;
}

public String getHouseImg4() {
    return houseImg4;
}

public void setHouseImg4(String houseImg4) {
    this.houseImg4 = houseImg4;
}

public String getHouseImg5() {
    return houseImg5;
}

public void setHouseImg5(String houseImg5) {
    this.houseImg5 = houseImg5;
}

public String getHouseImg6() {
    return houseImg6;
}

public void setHouseImg6(String houseImg6) {
    this.houseImg6 = houseImg6;
}

public String getDate() {
    return date;
}

public void setDate(String date) {
    this.date = date;
}

public int getBed() {
    return bed;
}

public void setBed(int bed) {
    this.bed = bed;
}

public int getWashing() {
    return washing;
}

public void setWashing(int washing) {
    this.washing = washing;
}

public int getAir() {
    return air;
}

public void setAir(int air) {
    this.air = air;
}

public int getBalcony() {
    return balcony;
}

public void setBalcony(int balcony) {
    this.balcony = balcony;
}

public int getIce() {
    return ice;
}

public void setIce(int ice) {
    this.ice = ice;
}

public int getToilet() {
    return toilet;
}

public void setToilet(int toilet) {
    this.toilet = toilet;
}

public int getKitchen() {
    return kitchen;
}

public void setKitchen(int kitchen) {
    this.kitchen = kitchen;
}

public int getTv() {
    return tv;
}

public void setTv(int tv) {
    this.tv = tv;
}

public int getHeater() {
    return heater;
}

public void setHeater(int heater) {
    this.heater = heater;
}

public int getWardrobe() {
    return wardrobe;
}

public void setWardrobe(int wardrobe) {
    this.wardrobe = wardrobe;
}

public int getHeating() {
    return heating;
}

public void setHeating(int heating) {
    this.heating = heating;
}

public int getInternet() {
    return internet;
}

public void setInternet(int internet) {
    this.internet = internet;
}

public int getSofa() {
    return sofa;
}

public void setSofa(int sofa) {
    this.sofa = sofa;
}

@Override
public String toString() {
    return "HouseView{" +
            "houseId=" + houseId +
            ", trueName='" + trueName + '\'' +
            ", houseTitle='" + houseTitle + '\'' +
            ", houseHeadimg='" + houseHeadimg + '\'' +
            ", housePrice=" + housePrice +
            ", priceUnit='" + priceUnit + '\'' +
            ", houseFloor=" + houseFloor +
            ", floorAll=" + floorAll +
            ", houseAddress='" + houseAddress + '\'' +
            ", houseLayout='" + houseLayout + '\'' +
            ", houseDecorate='" + houseDecorate + '\'' +
            ", houseArea='" + houseArea + '\'' +
            ", createTime=" + createTime +
            ", houseTurn='" + houseTurn + '\'' +
            ", houseNature='" + houseNature + '\'' +
            ", houseModel='" + houseModel + '\'' +
            ", houseYear='" + houseYear + '\'' +
            ", houseValid='" + houseValid + '\'' +
            ", houseLift=" + houseLift +
            ", housePlanimg1='" + housePlanimg1 + '\'' +
            ", housePlanimg2='" + housePlanimg2 + '\'' +
            ", houseImg1='" + houseImg1 + '\'' +
            ", houseImg2='" + houseImg2 + '\'' +
            ", houseImg3='" + houseImg3 + '\'' +
            ", houseImg4='" + houseImg4 + '\'' +
            ", houseImg5='" + houseImg5 + '\'' +
            ", houseImg6='" + houseImg6 + '\'' +
            ", date='" + date + '\'' +
            ", bed=" + bed +
            ", washing=" + washing +
            ", air=" + air +
            ", balcony=" + balcony +
            ", ice=" + ice +
            ", toilet=" + toilet +
            ", kitchen=" + kitchen +
            ", tv=" + tv +
            ", heater=" + heater +
            ", wardrobe=" + wardrobe +
            ", heating=" + heating +
            ", internet=" + internet +
            ", sofa=" + sofa +
            ", houseType=" + houseType +
            '}';
}

}

class UserController

@RequestMapping(“favorite.do”)
public ModelAndView favorite(HttpSession session){
UserInfo user= (UserInfo) session.getAttribute(“user”);
ModelAndView modelAndView=new ModelAndView();
List collcets = userService.getCollectViewByUser(user.getUserId());
modelAndView.addObject(“collcets”,collcets);
modelAndView.setViewName(“favorite”);
return modelAndView;
}

@RequestMapping("addToCollect.do")
@ResponseBody
public String addToCollect(HttpSession session,int houseId){
    UserInfo user= (UserInfo) session.getAttribute("user");
    JSONObject jsonObject = new JSONObject();
    Collect c = userService.findByHouseType(user.getUserId(), houseId);
    if(c!=null){
        jsonObject.put("result","0");
    }else {
        Collect collect=new Collect();
        collect.setUserId(user.getUserId());
        collect.setHouseId(houseId);
        collect.setUpdateTime(new Date().getTime());
        collect.setCreateTime(new Date().getTime());
        userService.addCollect(collect);
        jsonObject.put("result","1");
    }


    return jsonObject.toString();

}

IUserDao

List getCollectViewByUser(int userId);
void addCollect(Collect collect);
Collect findByHouseType(@Param(“userId”) int userId , @Param(“houseId”) int houseId);

IUserService

List<CollectView> getCollectViewByUser(int userId);
void addCollect(Collect collect);
Collect findByHouseType(int userId, int houseId);

UserServiceImpl

@Override
public List getCollectViewByUser(int userId) {
return userDao.getCollectViewByUser(userId);
}

@Override
public void addCollect(Collect collect) {
    userDao.addCollect(collect);
}

@Override
public Collect findByHouseType(int userId, int houseId) {
    return userDao.findByHouseType(userId,houseId);
}

UserInfoMapper.xml

<select id="getCollectViewByUser" parameterType="int" resultType="com.yiju.pojo.CollectView">
    select * from tb_collect a,tb_house b where a.house_id=b.house_id and a.user_id=#{userId}
</select>

<insert id="addCollect" parameterType="com.yiju.bean.Collect">
    insert into tb_collect (user_id,house_id,create_time,update_time) values(
    #{userId},#{houseId},#{createTime},#{updateTime})
</insert>

<select id="findByHouseType" resultType="com.yiju.bean.Collect" parameterType="int">
    select * from tb_collect where user_id=#{userId} and house_id=#{houseId}
</select>

details.jsp