<?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.nbclass.szxgl.mapper.ListTypeMapper">
   <!--<resultMap id="BaseResultMap" type="com.nbclass.szxgl.model.ListType">-->
    <!--<id column="id" jdbcType="CHAR" property="id" />-->
    <!--<result column="_list_type" jdbcType="VARCHAR" property="" />-->
    <!--<result column="_list_value" jdbcType="VARCHAR" property="list_value" />-->
  <!--</resultMap> -->
 	
 	<select id="getList" resultType="com.nbclass.szxgl.model.ListType">
 	SELECT * FROM list_values lv WHERE list_type = #{listType}
	</select>
	
	<select id="getListValue" resultType="string">
 	SELECT list_value FROM list_values lv WHERE list_type = #{listType} and id= #{id}
	</select>

	<select id="getAreaIdByName" resultType="string">
 	SELECT id FROM list_values WHERE list_value = #{areaName}
	</select>
</mapper>