<?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="com.zxwl.drug.data.Province">
 
    <resultMap type="Province" id="provinceResultMap">
        <id property="id" column="ID"/>
        <result property="code" column="CODE"/>
        <result property="name" column="NAME"/>
        <collection property="citys" column="CODE" select="searchCity"></collection>
    </resultMap>
    <resultMap type="City" id="cityResultMap">
        <id property="id" column="ID"/>
        <result property="provinceId" column="PROVINCEID"/>
        <result property="code" column="CODE"/>
        <result property="name" column="NAME"/>
        <collection property="areas" column="CODE" select="searchArea"></collection>
    </resultMap>
    <resultMap type="Area" id="areaResultMap">
        <id property="id" column="ID"/>
        <result property="cityId" column="CITYID"/>
        <result property="code" column="CODE"/>
        <result property="name" column="NAME"/>
    </resultMap>
     
    <resultMap type="CityPoint" id="cityPointResultMap">
        <id property="id" column="ID"/>
        <result property="cityId" column="CITYID"/>
        <result property="code" column="CODE"/>
        <result property="name" column="NAME"/>
    </resultMap>
     
    <select id="searchProvince" resultMap="provinceResultMap">
    <![CDATA[
        SELECT ID,CODE,NAME FROM PROVINCE
    ]]>
    </select>
    <select id="searchCity" resultMap="cityResultMap" parameterType="java.lang.Integer">
    <![CDATA[
        SELECT ID,PROVINCEID,CODE,NAME FROM CITY WHERE PROVINCEID = #{CODE}
    ]]>
    </select>   
    <select id="searchArea" resultMap="areaResultMap" parameterType="java.lang.Integer">
    <![CDATA[
        SELECT ID,CITYID,CODE,NAME FROM AREA WHERE CITYID = #{CODE}
    ]]>
    </select>   
   <select id="searchCityPoint" resultMap="cityPointResultMap">
    <![CDATA[
        SELECT CITYNAME,LAT,LNG FROM CITYPOINT
    ]]>
    </select>
</mapper>