SQL异常修复

郑永安

2023-06-20 7a9fd36cadbd5f0d8737955f0edd79e38ef19eaf

SQL异常修复

 src/main/java/com/nanometer/smartlab/dao/SysAlarmDao.xml

@@ -44,13 +44,13 @@
</select>

<select id="getSysAlarmTotalCount" parameterType="java.util.Map" resultType="int">
    select count(1) from sys_alarm
    select count(1) from sys_alarm as sw where 1=1 
    <include refid="queryWhereSql"/>
  </select>
    <select id="selectOne" resultType="java.lang.Integer">
        select count(0)
        from sys_alarm
        where container_code = #{containerCode}
        where 1=1 and container_code = #{containerCode}
        and warning_id = #{warningId}
        and controller_code =#{controllerCode}
        and warning_time = #{warningTime}