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
