调整语法不兼容

whycxzp

2024-11-12 1ec3f3d0dee46fc488e532712b18011a1d8bba95

调整语法不兼容

 src/main/resources/mapper/BatttestdataMapper.xml

@@ -8,7 +8,7 @@
    </delete>

    <select id="findhistory" resultType="com.whyc.pojo.BatttestdataId">
        select distinct * from db_batt_testdata.tb_batttestdata_#{battGroupId}
        select distinct * from db_batt_testdata.tb_batttestdata_${battGroupId}
        <where>
            test_record_count=#{testRecordCount}
            and (record_num%#{roteN}=0 or test_timelong>=#{maxtime} or test_timelong&lt;= #{mintime})
@@ -18,7 +18,7 @@

    <select id="serchMaxAndMintime" resultType="com.whyc.pojo.BatttestdataId">
        SELECT MAX(record_num) as recordNum, MAX(test_timelong) as num, MIN(test_timelong) as testType
        FROM db_batt_testdata.tb_batttestdata_#{battGroupId}
        FROM db_batt_testdata.tb_batttestdata_${battGroupId}
        WHERE test_record_count = #{testRecordCount}
          and data_available = 1 LIMIT 1
    </select>