|
<?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> |
|
|