Ibatis中SqlMap文件

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="Skin">
<typeAlias alias="skin" type="com.yc.eap.plugin.skin.domain.Skin"/>
<select id="getSkinTotal" resultClass="integer">
select count(*) from yc_skin_library where 1 = 1
<isNotEmpty prepend="AND" property="site_id">
site_id like '%$site_id$%'
</isNotEmpty>
</select>
<select id="getSkinListForBlock" resultClass="skin">
select * from yc_skin_library where 1 = 1
<isNotEmpty prepend="AND" property="site_id">
site_id like '%$site_id$%'
</isNotEmpty>
</select>
<select id="getSkinListForList" resultClass="skin">
select * from yc_skin_library where 1 = 1
<isNotEmpty prepend="AND" property="site_id">
site_id like '%$site_id$%'
</isNotEmpty>
</select>
<select id="SkinName" resultClass="skin">
select * from yc_skin_library where skin_name = '#skin_name#'
</select>
<select id="BlockId" parameterClass="java.lang.String" resultClass="skin">
select * from yc_skin_library where skin_name = (select skin_name from yc_module where block_id = #value#)
</select>
</sqlMap>