FBO4815实时页面需要前一百比历史实时数据

lxw

2023-02-25 d3b8e8cfae4e10d4fa3b950dfa8d46cf038cab2e

FBO4815实时页面需要前一百比历史实时数据

 src/main/resources/mapper/BattRealdataMapper.xml

@@ -78,7 +78,7 @@
                   (select @i:=0) b) c
        where c.number%#{roteN}=0;
    </select>
    <resultMap id="batt4815List" type="batt4815HisData">
   <!-- <resultMap id="batt4815List" type="batt4815HisData">
        <result property="recrodTime" column="recrod_time"></result>
        <collection property="list" javaType="java.util.ArrayList" ofType="com.whyc.pojo.BattRealdata"
                    column="{recrodTime=recrod_time,tableName=tableName}" select="serchDate">
@@ -93,6 +93,11 @@
        select *
        from db_batt_history.tb_batt_realdata_${tableName}
        where recrod_time = #{recrodTime}
    </select>
    </select>-->

    <select id="serchDate100" resultType="BattRealdata">
        select distinct num, recrod_time, group_vol, online_vol, group_curr
        from db_batt_history.tb_batt_realdata_${table}
        order by recrod_time desc limit 0, 100
    </select>
</mapper>