关于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 ="QBXX_YWXT_XCTBB" >

     < resultMap  id ="ywxtTzbResult"
        class ="com.sclh.servicebase.ywxttzb.bean.YwxtTzb" >
         <!--
            WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
            This element was generated on Thu Sep 21 11:29:11 CST 2006.
         -->
         < result  column ="ZBH"  property ="zbh"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="FSDW"  property ="fsdw"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="TZNR"  property ="tznr"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="FSSJ"  property ="fssj"  jdbcType ="DATETIME"   />
         < result  column ="JSDW"  property ="jsdw"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="FSDWLXR"  property ="fsdwlxr"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="FSDWLXDH"  property ="fsdwlxdh"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="YDBS"  property ="ydbs"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="QSBS"  property ="qsbs"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="QSSJ"  property ="qssj"  jdbcType ="DATETIME"   />
         < result  column ="ZXSJ"  property ="zxsj"  jdbcType ="DATETIME"   />
         < result  column ="ZXBS"  property ="zxbs"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="ZXR"  property ="zxr"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="ZXYY"  property ="zxyy"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="BZ"  property ="bz"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="QSYJ"  property ="qsyj"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="TZLX"  property ="tzlx"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="GLBH"  property ="glbh"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="TZLB"  property ="tzlb"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="FWCS"  property ="fwcs"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="QT1"  property ="qt1"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="QT2"  property ="qt2"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="TBDW"  property ="tbdw"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="TBR"  property ="tbr"  jdbcType ="VARCHAR"
            nullValue =""   />
         < result  column ="TBSJ"  property ="tbsj"  jdbcType ="DATETIME"   />
         < result  column ="XZDS"  property ="xzds"  jdbcType ="VARCHAR"
            nullValue =""   />
     </ resultMap >


     < insert  id ="insertYwxtTzb"
        parameterClass ="com.sclh.servicebase.ywxttzb.bean.YwxtTzb" >
         <!--
            WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
            This element was generated on Thu Sep 21 11:29:11 CST 2006.
         -->
        insert into YWXT_TZB ( ZBH, FSDW, TZNR, FSSJ, JSDW, FSDWLXR,
        FSDWLXDH, YDBS, QSBS, QSSJ,ZXSJ, ZXBS, ZXR, ZXYY, BZ, QSYJ,
        TZLX, GLBH, TZLB, FWCS, QT1, QT2, TBDW, TBR, TBSJ, XZDS) values
        ( #zbh:VARCHAR#, #fsdw:VARCHAR#, #tznr:VARCHAR#, #fssj#,
        #jsdw:VARCHAR#, #fsdwlxr:VARCHAR#, #fsdwlxdh:VARCHAR#,
        #ydbs:VARCHAR#, #qsbs:VARCHAR#, #qssj#, #zxsj#, #zxbs:VARCHAR#,
        #zxr:VARCHAR#, #zxyy:VARCHAR#, #bz:VARCHAR#, #qsyj:VARCHAR#,
        #tzlx:VARCHAR#, #glbh:VARCHAR#, #tzlb:VARCHAR#, #fwcs:VARCHAR#,
        #qt1:VARCHAR#, #qt2:VARCHAR#, #tbdw:VARCHAR#, #tbr:VARCHAR#,
        #tbsj#, #xzds:VARCHAR#)
     </ insert >

     < update  id ="updateByZbh"
        parameterClass ="com.sclh.servicebase.ywxttzb.bean.YwxtTzb" >
        update YWXT_TZB set
         < dynamic >
             < isNotEmpty  property ="fsdw"  close ="," >
                FSDW = #fsdw:VARCHAR#
             </ isNotEmpty >
         </ dynamic >
         < dynamic >
             < isNotEmpty  property ="tznr"  close ="," >
                TZNR = #tznr:VARCHAR#
             </ isNotEmpty >
         </ dynamic >
         < dynamic >
             < isNotNull  property ="fssj"  close ="," >
                FSSJ = #fssj#
             </ isNotNull >
         </ dynamic >
         < dynamic >
             < isNotEmpty  property ="jsdw"  close ="," >
                JSDW = #jsdw:VARCHAR#
             </ isNotEmpty >
         </ dynamic >
         < dynamic >
             < isNotEmpty  property ="fsdwlxr"  close ="," >
                FSDWLXR = #fsdwlxr:VARCHAR#
             </ isNotEmpty >
         </ dynamic >
         < dynamic >
             < isNotEmpty  property ="fsdwlxdh"  close ="," >
                FSDWLXDH = #fsdwlxdh:VARCHAR#
             </ isNotEmpty >
         </ dynamic >
         < dynamic >
             < isNotEmpty  property ="ydbs"  close ="," >
                YDBS = #ydbs:VARCHAR#
             </ isNotEmpty >
         </ dynamic >
         < dynamic >
             < isNotEmpty  property ="qsbs"  close ="," >
                QSBS = #qsbs:VARCHAR#
             </ isNotEmpty >
         </ dynamic >
         < dynamic >
             < isNotNull  property ="fssj"  close ="," >
                FSSJ = #fssj#
             </ isNotNull >
         </ dynamic >
         < dynamic >
             < isNotNull  property ="qssj"  close ="," >
                ZXSJ = #qssj#
             </ isNotNull >
         </ dynamic >
         < dynamic >
             < isNotEmpty  property ="zxbs"  close ="," >
                ZXBS = #zxbs:VARCHAR#
             </ isNotEmpty >
         </ dynamic >
         < dynamic >
             < isNotEmpty  property ="zxr"  close ="," >
                ZXR = #zxr:VARCHAR#
             </ isNotEmpty >
         </ dynamic >
         < dynamic >
             < isNotEmpty  property ="zxyy"  close ="," >
                ZXYY = #zxyy:VARCHAR#
             </ isNotEmpty >
         </ dynamic >
         < dynamic >
             < isNotEmpty  property ="bz"  close ="," >
                BZ = #bz:VARCHAR#
             </ isNotEmpty >
         </ dynamic >
         < dynamic >
             < isNotEmpty  property ="qsyj"  close ="," >
                QSYJ = #qsyj:VARCHAR#
             </ isNotEmpty >
         </ dynamic >
         < dynamic >
             < isNotEmpty  property ="tzlx"  close ="," >
                TZLX = #tzlx:VARCHAR#
             </ isNotEmpty >
         </ dynamic >
         < dynamic >
             < isNotEmpty  property ="glbh"  close ="," >
                GLBH = #glbh:VARCHAR#
             </ isNotEmpty >
         </ dynamic >
         < dynamic >
             <