按照筛选条件查询数据库信息

lxw

2022-09-26 34c80cdb16483592c9846803406a8dd69c69638c

按照筛选条件查询数据库信息

 src/main/java/com/whyc/controller/FileParamController.java

@@ -25,6 +25,7 @@
    public Response getMonVolStd(){
        return service.getMonVolStd();
    }
    
    @ApiOperation("按照筛选条件查询数据库信息")
    @GetMapping("getDataByCondition")
    public Response getDataByCondition(@RequestParam(required = false ,defaultValue = "1982-01-01 00:00:00") String startTime

 src/main/java/com/whyc/pojo/FileParam.java

@@ -9,6 +9,7 @@

import java.io.Serializable;
import java.util.Date;
import java.util.List;

/**
 * <p>
@@ -137,5 +138,9 @@
    @TableField(exist = false)
    private String stationName;

    @TableField(exist = false)
    @ApiModelProperty(value = "电池组信息集合")
    private List<BattgroupInfo> battInfoList;


}

 src/main/resources/mapper/FileParamMapper.xml

@@ -15,7 +15,43 @@
    <select id="getMonVolStd" resultType="Integer">
        select distinct ROUND(batt_vol) from db_res_meter.tb_file_param
    </select>
    <select id="getDataByCondition" resultType="com.whyc.pojo.FileParam">
    <resultMap id="dataList" type="fileParam">
        <id column="num" property="num"></id>
        <result column="file_id" property="fileId"></result>
        <result column="test_time" property="testTime"></result>
        <result column="version" property="version"></result>
        <result column="upload_time" property="uploadTime"></result>
        <result column="upload_flag" property="uploadFlag"></result>
        <result column="sys_id" property="sysId"></result>
        <result column="batt_group_name" property="battGroupName"></result>
        <result column="batt_brand" property="battBrand"></result>
        <result column="batt_model" property="battModel"></result>
        <result column="batt_batch" property="battBatch"></result>
        <result column="batt_station" property="battStation"></result>
        <result column="battline_name" property="battlineName"></result>
        <result column="batt_tha" property="battTha"></result>
        <result column="batt_errFlag" property="battErrflag"></result>
        <result column="batt_testNum" property="battTestnum"></result>
        <result column="batt_faultNum" property="battFaultnum"></result>
        <result column="batt_cap" property="battCap"></result>
        <result column="batt_count" property="battCount"></result>
        <result column="batt_vol" property="battVol"></result>
        <result column="batt_res" property="battRes"></result>
        <result column="group_num" property="groupNum"></result>
        <result column="volLowCoeK1" property="volLowCoeK1"></result>
        <result column="volHighCoeK2" property="volHighCoeK2"></result>
        <result column="resGoodCoeK3" property="resGoodCoeK3"></result>
        <result column="resBadCoeK4" property="resBadCoeK4"></result>
        <result column="sample_percent" property="samplePercent"></result>
        <result column="highTempAlarm" property="highTempAlarm"></result>
        <result column="chainRes" property="chainRes"></result>
        <result column="evaluation_mode" property="evaluationMode"></result>
        <result column="factor_disabled" property="factorDisabled"></result>
        <result column="station_name" property="stationName"></result>
        <collection property="battInfoList" javaType="java.util.ArrayList" ofType="battgroupInfo" column="{fileId=file_id}" select="selectBattInfoByFileId">
        </collection>
    </resultMap>
    <select id="getDataByCondition" resultMap="dataList">
        select distinct tb_file_param.*,tb_station_info.station_name
                        from db_res_meter.tb_file_param,db_res_meter.tb_station_info,db_res_meter.tb_file_info
        where tb_station_info.station_id=tb_file_info.station_id
@@ -30,4 +66,19 @@
           and batt_vol=#{battVol}
        </if>
    </select>
    <resultMap id="InfoList" type="battgroupInfo">
        <id column="num" property="num"></id>
        <result column="battGroup_id" property="battgroupId"></result>
        <result column="station_id" property="stationId"></result>
        <result column="file_id" property="fileId"></result>
        <result column="battGroup_num" property="battgroupNum"></result>
        <result column="test_time" property="testTime"></result>
        <collection property="battDataList" javaType="java.util.ArrayList" ofType="battgroupData" column="{battgroupId=battGroup_id}" select="selectBattDataByBattGroupId"></collection>
    </resultMap>
    <select id="selectBattInfoByFileId" resultMap="InfoList">
        select * from tb_battgroup_info where file_id=#{fileId}
    </select>
    <select id="selectBattDataByBattGroupId" resultType="battgroupData">
        select * from tb_battgroup_data where battGroup_id=#{battgroupId}
   </select>
</mapper>