dzhh-backend/.svn/pristine/4c/4c1c72587ab0967c136df1059a1871bab8332a32.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.jeecg.modules.demo.hzz.hlxx.mapper.RmRiverMapper">
    <select id="countriver1" resultType="int">
      SELECT count(*)  from rm_river where lymj>300
    </select>
    <select id="countriver2" resultType="int">
        select count(*) from rm_river where lymj between 50 and 300
    </select>
    <select id="countriver3" resultType="int">
        select count(*) from rm_river where lymj between 0.0001 and 50
    </select>
    <select id="countriver4" resultType="int">
         select count(*) from rm_river where lymj is null or lymj=0
    </select>

</mapper>