优化查询小区多条是报错问题

java110

2020-06-01 7e3a731b960455b16016c3c4e2e727caa8190bb0

 CommunityService/src/main/java/com/java110/community/dao/impl/RoomServiceDaoImpl.java

@@ -1,9 +1,9 @@
package com.java110.community.dao.impl;

import com.alibaba.fastjson.JSONObject;
import com.java110.common.constant.ResponseConstant;
import com.java110.common.exception.DAOException;
import com.java110.common.util.DateUtil;
import com.java110.utils.constant.ResponseConstant;
import com.java110.utils.exception.DAOException;
import com.java110.utils.util.DateUtil;
import com.java110.community.dao.IRoomServiceDao;
import com.java110.core.base.dao.BaseServiceDao;
import org.slf4j.Logger;
@@ -131,6 +131,42 @@
    }

    @Override
    public int queryRoomsByCommunityIdCount(Map info) {
        logger.debug("查询小区房屋数据 入参 info : {}", info);

        List<Map> businessRoomInfos = sqlSessionTemplate.selectList("roomServiceDaoImpl.queryRoomsByCommunityIdCount", info);
        if (businessRoomInfos.size() < 1) {
            return 0;
        }

        return Integer.parseInt(businessRoomInfos.get(0).get("count").toString());
    }

    @Override
    public int queryRoomsWithOutSellByCommunityIdCount(Map info) {
        logger.debug("查询小区房屋数据 入参 info : {}", info);

        List<Map> businessRoomInfos = sqlSessionTemplate.selectList("roomServiceDaoImpl.queryRoomsWithOutSellByCommunityIdCount", info);
        if (businessRoomInfos.size() < 1) {
            return 0;
        }

        return Integer.parseInt(businessRoomInfos.get(0).get("count").toString());
    }

    @Override
    public int queryRoomsWithSellByCommunityIdCount(Map info) {
        logger.debug("查询小区房屋数据 入参 info : {}", info);

        List<Map> businessRoomInfos = sqlSessionTemplate.selectList("roomServiceDaoImpl.queryRoomsWithSellByCommunityIdCount", info);
        if (businessRoomInfos.size() < 1) {
            return 0;
        }

        return Integer.parseInt(businessRoomInfos.get(0).get("count").toString());
    }

    @Override
    public List<Map> getRoomInfoByCommunityId(Map info) {
        logger.debug("查询小区房屋信息 入参 info : {}", info);

@@ -139,5 +175,34 @@
        return businessRoomInfos;
    }

    @Override
    public List<Map> getRoomInfoByOwner(Map info) {
        logger.debug("查询小区房屋信息 入参 info : {}", info);

        List<Map> businessRoomInfos = sqlSessionTemplate.selectList("roomServiceDaoImpl.getRoomInfoByOwner", info);

        return businessRoomInfos;
    }

    @Override
    public List<Map> getRoomInfoWithOutSellByCommunityId(Map info) {
        logger.debug("查询小区房屋信息 入参 info : {}", info);

        List<Map> businessRoomInfos = sqlSessionTemplate.selectList("roomServiceDaoImpl.getRoomInfoWithOutSellByCommunityId", info);

        return businessRoomInfos;
    }


    @Override
    public List<Map> getRoomInfoWithSellByCommunityId(Map info) {
        logger.debug("查询小区房屋信息 入参 info : {}", info);

        List<Map> businessRoomInfos = sqlSessionTemplate.selectList("roomServiceDaoImpl.getRoomInfoWithSellByCommunityId", info);

        return businessRoomInfos;
    }



}