Ibatis 增删改查语句

<?xml version="1.0" encoding="GBK"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
        " http://www.ibatis.com/dtd/sql-map-2.dtd ">
<sqlMap>
 <!-- 查询帮助 -->
 <resultMap id="querySourceSchoolMap" class="com.gosoft.nsr.track.po.SourceSchoolPo">
  <result column="ID" property="id" />
  <result column="SCHOOL_NAME" property="school_name"/>  
  <result column="S_ID" property="s_id"/>    
 </resultMap>
 <!-- 添加学校表 -->
   <insert id="saveSourceSchool" parameterClass="com.gosoft.nsr.common.po.T_source_school">    
    insert into T_SOURCE_SCHOOL    
    <dynamic prepend="(">
        <isNotNull prepend="," property="id">
          ID
        </isNotNull>        
        <isNotNull prepend="," property="school_name">
          SCHOOL_NAME
        </isNotNull>
      
       )
     </dynamic>
     values
     <dynamic prepend="(">
        <isNotNull prepend="," property="id">
          #id:VARCHAR#
        </isNotNull>        
        <isNotNull prepend="," property="school_name">
          #school_name:VARCHAR#
        </isNotNull>
      
       )
     </dynamic>
   </insert>
   <!-- 删除学校信息 -->
   <delete id="deleteSourceSchool" parameterClass="com.gosoft.nsr.common.po.T_source_school">
    delete from T_SOURCE_SCHOOL
     <dynamic prepend="where">
   <isNotNull prepend="," property="id">
          ID = #id:VARCHAR#
        </isNotNull>      
       </dynamic>
   </delete>
   <!--  修改学校信息 -->
   <update id="updateSourceSchool" parameterClass="com.gosoft.nsr.common.po.T_source_school">
    update T_SOURCE_SCHOOL
    <dynamic prepend="set">
        <isNotNull prepend="," property="id">
          ID = #id:VARCHAR#
        </isNotNull>
        <isNotNull prepend="," property="school_name">
          SCHOOL_NAME = #school_name:VARCHAR#
        </isNotNull>
      
    </dynamic>
    <dynamic prepend="where">
     <isNotEmpty prepend="and" property="id">
      <![CDATA[ ID = #id:VARCHAR# ]]>
     </isNotEmpty>
    </dynamic>
   </update>
   <!-- 查询学校表 -->
   <select id="querySourceSchool" resultMap="querySourceSchoolMap">
    select * from(
        select ROWNUM AS rowIndex,ID,SCHOOL_NAME,S_ID
        from (
        select s.ID,s.SCHOOL_NAME,t.S_ID
     from T_SOURCE_SCHOOL s
     left join T_TRACK_SCHOOL t on s.ID = t.S_ID 
     <dynamic prepend="where">
   <isNotEmpty prepend="and" property="id" >
          <![CDATA[ s.ID = #id:VARCHAR#  ]]>
         </isNotEmpty>
         <isNotEmpty prepend="and" property="school_name" >
    <![CDATA[ s.SCHOOL_NAME like '%'||#school_name:VARCHAR#||'%' ]]>
         </isNotEmpty>
         
        </dynamic>
       <![CDATA[ order by s.CREATE_DATE desc ) ]]>
  <dynamic prepend="WHERE">
            <isNotEmpty property="endRowNum">
                <![CDATA[ ROWNUM <= #endRowNum#) ]]>
            </isNotEmpty>
        </dynamic>
  <dynamic prepend="WHERE">
            <isNotEmpty property="startRowNum">
                <![CDATA[ rowIndex >= #startRowNum# ]]>
            </isNotEmpty>
        </dynamic>
   </select>
   
 <!-- 获取所有学校表数量  -->
   <select id="querySourceSchoolCount" parameterClass="com.gosoft.nsr.track.po.SourceSchoolPo" resultClass="java.lang.Long">
     select count(s.ID)
     from T_SOURCE_SCHOOL s
     left join T_TEACKER_RECORD t on s.ID = t.P_ID 
  <dynamic prepend="where">
   <isNotEmpty prepend="and" property="id" >
         </isNotEmpty>
         <isNotEmpty prepend="and" property="school_name" >
    <![CDATA[ s.SCHOOL_NAME like '%'||#school_name:VARCHAR#||'%' ]]>
         </isNotEmpty>
        </dynamic>
  </select>
  <!-- 获取学校名 -->
  <select id="selectSourceSchoolName" parameterClass="com.gosoft.nsr.track.po.SourceSchoolPo" resultClass="com.gosoft.nsr.track.po.SourceSchoolPo">
   select s.ID AS ID, s.SCHOOL_NAME AS SCHOOL_NAME from T_SOURCE_SCHOOL s
   <dynamic prepend="where">
    <isNotEmpty prepend="and" property="id" >
    <![CDATA[ s.ID = #id:VARCHAR#  ]]>
         </isNotEmpty>
    <isNotEmpty prepend="and" property="school_name" >
    <![CDATA[ s.SCHOOL_NAME = #school_name:VARCHAR#  ]]>
         </isNotEmpty> 
   </dynamic>
  </select>
   <!-- 获取最大ID -->
 <select id="selectSourceSchoolMax" resultClass="java.math.BigDecimal">
  select max(s.ID) from T_SOURCE_SCHOOL s
 </select>
</sqlMap>