dzhh-backend/.svn/pristine/e7/e799d61807a62edd6f4e8e1c836f9282ba19b23c.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.shjsgc.shxmxx.mapper.RmShxmxxbMapper">
    <select id="countter" resultType="String">
        select count(1) from rm_shxmxxb
    </select>
    <select id="yjcount" resultType="String">
        select count(1) from rm_shxmxxb where jszt='yj'
    </select>
    <select id="zjcount" resultType="int">
        select count(1) from rm_shxmxxb where jszt='zj'
    </select>
    <select id="njcount" resultType="int">
        select count(1) from rm_shxmxxb where jszt='nj'
    </select>
    <select id="findAllhlcd" resultType="java.util.HashMap">
        select hlmc, hlcd from rm_river where  length(hlmc) >= 3 and hlmc like '%河'  order by hlcd
        DESC limit 10
    </select>
    <select id="bzgccount" resultType="int">
        select count(1) from rm_shxmxxb where  xmlx='bzgc'
    </select>
    <select id="zbgccount" resultType="int">
        select count(1) from rm_shxmxxb where xmlx='zbgc'
    </select>
    <select id="dfgccount" resultType="int">
        select count(1) from rm_shxmxxb where xmlx='dfgc'
    </select>
    <select id="xjbgcount" resultType="int">
        select count(1) from rm_shxmxxb where xmlx='xjbgc'
    </select>
    <select id="skcount" resultType="int">
        select count(1) from rm_shxmxxb where xmlx='skgc'
    </select>
    <select id="lhbcount" resultType="int">
        select count(1) from rm_shxmxxb where xmlx='lhbgc'
    </select>
    <select id="gxcount" resultType="int">
        select count(1) from rm_shxmxxb where xmlx='gxgc'
    </select>
    <select id="qlcount" resultType="int">
        select count(1) from rm_shxmxxb where xmlx='qlgc'
    </select>
    <select id="szcount" resultType="int">
        select count(1) from rm_shxmxxb where xmlx='szgc'
    </select>
    <insert id="addxcjg" keyProperty="id">
        insert into rm_xcjgjl(id,jsxmmc) values(#{id},#{jsxmmc})
    </insert>
    <delete id="delxcjg">
        delete from rm_xcjgjl where id=#{id}
    </delete>
    <update id="updataxcjg">
        update rm_xcjgjl set jsxmmc=#{jsxmmc} where id=#{id}
    </update>
    <select id="selectjsqk" resultType="hashmap">
        SELECT substr(xzqh,4,6)AS xzqh,count(1) AS zj from rm_shxmxxb where jszt='zj'and xzqh!=''  GROUP BY substr(xzqh,4,6)ORDER BY  zj asc
        --       select replace(xzqh,'德州市','') AS xzqh,count(1) from rm_shxmxxb where xzqh like '%德州市%' and jszt='zj' GROUP BY xzqh
    </select>
    <select id="selectnjqk" resultType="hashmap">
          SELECT substr(xzqh,4,3)AS xzqh,count(1) AS nj from rm_shxmxxb where jszt='nj'and xzqh!=''  GROUP BY substr(xzqh,4,3) ORDER BY  nj asc
    </select>
    <select id="countxmlx" resultType="hashmap">
        SELECT xmlx,count(1) from rm_shxmxxb GROUP BY xmlx
    </select>
    <select id="countjg" resultType="hashmap">
        select jsxmmc, count(1) as num from rm_xcjgjl GROUP BY jsxmmc ORDER BY num ASC
    </select>

</mapper>