<?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.test.list">
    <!--MyBatis 配置Ehcache 缓存-->
    <cache type="org.mybatis.caches.ehcache.EhcacheCache"/>
    
    <select id="getUserList" parameterType="string" resultType="com.test.Userlist">
	    select CODEKIND, CODEVALUE, CODENAME, PARENT_CODEVALUE
          from T_BASE
         where CODEKIND = #{kind,jdbcType=VARCHAR} 
           and VALID='1' 
      order by ORDERS
    </select>
    
</mapper>