dzhh-backend/.svn/pristine/a5/a577f07456c3def6bf99978ac9fba3612ee99d2e.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.dfgc.mapper.RmDfgcMapper">
    <insert id="insertshxm" parameterType="Object">
        insert into rm_shxmxxb(id, xmmc, jszt, xmid, xmlx, gldw, kgny, jcny, szhl, geoinfo)
        values (#{id}, #{xmmc}, #{jszt}, #{xmid}, #{xmlx}, #{gldw}, #{kgny}, #{jcny}, #{szhl} ,#{geoinfo})
    </insert>
    <delete id="deshxm" parameterType="String">
        delete
        from rm_shxmxxb
        where xmid = #{xmid}
    </delete>
    <update id="updateshxm" parameterType="String">
        update rm_shxmxxb
        set xmmc=#{xmmc},
            jszt=#{jszt},
            gldw=#{gldw},
            kgny=#{kgny},
            jcny=#{jcny},
            szhl=#{szhl},
            geoinfo=#{geoinfo}
            where xmid=#{id}
    </update>
    <select id="selectdfcd" resultType="hashmap">
        SELECT dfmc, dfcd, szhlmc, rm_river.hlcd * 1000 as hlcd
        from rm_dfgc
                 JOIN rm_river on rm_dfgc.szhlmc = rm_river.hlmc
        where dfcd!=''and szhlmc!=''
        ORDER BY dfcd desc limit 7;
--        let  SELECT dfmc,dfcd,szhlmc,rm_river.hlcd*1000 as hlcd from rm_dfgc JOIN rm_river on rm_dfgc.szhlmc=rm_river.hlmc where dfcd!=''and szhlmc!='' limit 10
    </select>

</mapper>