Beispiel #1
0
 public boolean isExist(Room room) {
   // TODO 是否存在相同的房源信息
   if (StringUtils.isBlank(room.getRoom_name())) {
     return true;
   }
   String sql = "select count(*) from " + Room.TABLENAME + " where room_name = ?";
   if (room.getId() != null && room.getId() > 0) {
     sql += " and id != " + room.getId();
   }
   System.out.println("SQL :" + sql);
   int count = jdbcTemplate.queryForInt(sql, new Object[] {room.getRoom_name()});
   System.out.println("room_name:" + room.getRoom_name() + "count :" + count);
   return (count > 0 ? true : false);
 }
Beispiel #2
0
  public Map<String, Object> save(Room room) {
    // 保存或修改房源
    Map<String, Object> result = new HashMap<String, Object>();
    if (room == null) {
      result.put("error", "房源信息为空...");
    }
    if (!isExist(room)) { // 如果不存在 房源名称是否重复
      if (room.getId() != null && room.getId() > 0) // 修改的情况
      {
        /*
         * 新增的字段 bed; wardrobe; air_conditioning;tv; kitchen; bashroom
         */
        String[] updateFields =
            new String[] {
              "room_name = ?",
              "address = ?",
              "price = ?",
              "rental_start_time = ?",
              "rental_end_time = ?",
              "status = ?",
              "`desc` = ?",
              "size = ?",
              "kind = ?",
              "floor = ?",
              "orient = ?",
              "occupancy = ?",
              "metro=?",
              "comm_id = ?",
              "bed=?",
              "wardrobe=?",
              "air_conditioning=?",
              "tv=?",
              "gasstove=?",
              "washing=?",
              "heater = ?",
              "refrigerator = ?",
              " microwaveOven= ?",
              "room_host= ?",
              "recommend=?",
              "recommendTarget=?",
              "cityid=?,decoration = ?,rent_type = ?,company_id=?,smartlock=?",
              "isRecommend=?"
            };
        Object[] fieldsValue =
            new Object[] {
              room.getRoom_name(),
              room.getAddress(),
              room.getPrice(),
              room.getRental_start_time(),
              room.getRental_end_time(),
              room.getStatus(),
              room.getDesc(),
              room.getSize(),
              room.getKind(),
              room.getFloor(),
              room.getOrient(),
              room.getOccupancy(),
              room.getMetro(),
              room.getComm_id(),
              room.getBed(), // 床
              room.getWardrobe(), // 衣柜
              room.getAir_conditioning(), // 空调
              room.getTv(), // 电视
              room.getGasstove(), // 燃气灶
              room.getWashing(), // 洗衣机
              room.getHeater(), // 热水器
              room.getRefrigerator(), // 冰箱
              room.getMicrowaveOven(), // 微波炉
              room.getRoom_host(),
              room.getRecommend(),
              room.getRecommendTarget(),
              room.getCityid(),
              room.getDecoration(),
              room.getRent_type(),
              room.getCompany_id(),
              room.getSmartlock(),
              room.getIsRecommend()
            };
        /*
         * for( int i = 0; i < updateFields.length; i++ ){
         * System.out.println(updateFields[i] + ":" + String.valueOf(
         * fieldsValue[i] )); }
         */

        String sql =
            "update "
                + Room.TABLENAME
                + " set "
                + StringUtils.join(updateFields, ",")
                + " where id ="
                + room.getId().toString();
        // System.out.println(sql );
        int affected = jdbcTemplate.update(sql, fieldsValue);
        if (affected > 0) {
          result.put("success", "修改成功");
        } else {
          result.put("success", "修改失败");
        }
      } else { // 新增

        String sql =
            "insert into "
                + Room.TABLENAME
                + " (room_name,"
                + "address,price,"
                + "rental_start_time,"
                + "rental_end_time,"
                + "status,size,"
                + "kind,floor,"
                + "orient,occupancy,"
                + "metro,`desc`,"
                + "comm_id,"
                + " bed,wardrobe,"
                + "air_conditioning,"
                + "tv,gasstove,"
                + "washing,heater,refrigerator,microwaveOven,room_host,"
                + "recommend,"
                + "recommendTarget,cityid,createtime,decoration,rent_type,company_id, smartlock, isRecommend) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        System.out.println(sql);

        int affected =
            jdbcTemplate.update(
                sql,
                new Object[] {
                  room.getRoom_name(),
                  room.getAddress(),
                  room.getPrice(),
                  room.getRental_start_time(),
                  room.getRental_end_time(),
                  room.getStatus(),
                  room.getSize(),
                  room.getKind(),
                  room.getFloor(),
                  room.getOrient(),
                  room.getOccupancy(),
                  room.getMetro(),
                  room.getDesc(),
                  room.getComm_id(),
                  room.getBed(),
                  room.getWardrobe(),
                  room.getAir_conditioning(),
                  room.getTv(),
                  room.getGasstove(), // 燃气灶
                  room.getWashing(), // 洗衣机
                  room.getHeater(), // 热水器
                  room.getRefrigerator(), // 冰箱
                  room.getMicrowaveOven(), // 微波炉
                  room.getRoom_host(),
                  room.getRecommend(),
                  room.getRecommendTarget(),
                  room.getCityid(),
                  CalendarUtil.getInstance().getCurrentTime(),
                  room.getDecoration(),
                  room.getRent_type(),
                  room.getCompany_id(),
                  room.getSmartlock(),
                  room.getIsRecommend()
                });
        // 获得id,再更新房源编号

        if (affected > 0) {
          String query = "select last_insert_id() as id from " + Image.TABLENAME + " limit 1";
          System.out.println("图片id查询语句:" + query);
          int id = jdbcTemplate.queryForInt(query);
          String roomSeq = room.getRoomSeq() + StringUtils.leftPad(id + "", 5, "0");
          affected =
              jdbcTemplate.update(
                  "update " + Room.TABLENAME + " set roomSeq = ? where id = ?",
                  new Object[] {roomSeq, id});
          if (affected > 0) {
            System.out.println("房源保存成功,且房源编号更新成功...");
          }
          result.put("success", "保存成功");
        } else {
          result.put("success", "保存失败");
        }
      }
    } else {
      result.put("error", "房源名称已存在");
    }

    return result;
  }