ibatis参数详解

<!-- /* Font Definitions */ @font-face {font-family:宋体; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-alt:SimSun; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} @font-face {font-family:"/@宋体"; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-justify:inter-ideograph; mso-pagination:none; font-size:10.5pt; mso-bidi-font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-fareast-font-family:宋体; mso-bidi-font-family:"Times New Roman"; mso-font-kerning:1.0pt;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; mso-ascii-font-family:Calibri; mso-fareast-font-family:宋体; mso-hansi-font-family:Calibri; mso-font-kerning:0pt;} /* Page Definitions */ @page {mso-page-border-surround-header:no; mso-page-border-surround-footer:no;} @page Section1 {size:595.3pt 841.9pt; margin:21.3pt 28.3pt 72.0pt 1.0cm; mso-header-margin:42.55pt; mso-footer-margin:49.6pt; mso-paper-source:0; layout-grid:15.6pt;} div.Section1 {page:Section1;} -->

ibatis 参数

2008-04-29 13:32

原型参数 < select id = "select1" parameterClass = "java.lang.String" resultClass = "AppLog" >     select       ID as id ,       TYPE as type ,       DESCR as descr     from APP_LOG     where ID = #id# </ select >    sqlMapper .queryForObject( "select0" , id);   Map 类参数 < select id = "select2" parameterClass = "java.util.HashMap" resultClass = "AppLog" >     select       ID as id ,       TYPE as type ,       DESCR as descr     from APP_LOG     where ID = #id# </ select >     map.put("id", id); AppLog log = (AppLog) sqlMapper.queryForObject("select0", map);   对象参数    < select id = "select3" parameterClass = "AppLog" resultClass = "AppLog" >     select       ID as id ,       TYPE as type ,       DESCR as descr     from APP_LOG     where ID = #id# </ select > AppLog p= new AppLog(); p.setId(id); AppLog log = (AppLog) sqlMapper .queryForObject( "select3" , p);   < select id = "select0" resultClass = "AppLog" >     select       ID as id ,       TYPE as type ,       DESCR as descr     from APP_LOG     where ID = #id# </ select > Map 参数 map.put("id", id); AppLog log = (AppLog) sqlMapper.queryForObject("select0", map); String 参数 AppLog log = (AppLog) sqlMapper.queryForObject("select0", id); 对象参数 AppLog p= new AppLog(); p.setId(id); AppLog log = (AppLog) sqlMapper .queryForObject( "select0" , p);   动态字段、表 < select id = "selectd" resultClass = "java.util.HashMap" parameterClass = "java.util.HashMap" remapResults = "true" >     select $fieldList$          from $ table $     where ID = #id# </ select > Map p = new HashMap(); p.put( "id" , id); p.put( "table" , "APP_LOG" ); p.put( "fieldList" , "ID,TYPE,DESCR" ); Map map = (Map) sqlMapper .queryForObject( "selectd" , p); String id1 = (String) map.get( "ID" ); String type = (String) map.get( "TYPE" ); String descr = (String) map.get( "DESCR" ); 参数映射方式 <parameterMap> 字段映射方式 < parameterMap id = ”insert-product-param” class = ”com.domain.Product” >     <parameter property= ”id” />     <parameter property= ”description” /> </ parameterMap > < insert id = ”insertProduct” parameterMap = ”insert-product-param” >     insert into PRODUCT (PRD_ID , PRD_DESCRIPTION) values (?,?) </ insert > < parameterMap id = ”insert-product-param” class = ”com.domain.Product” >     < parameter property = ”description” />     < parameter property = ”id” /> </ parameterMap > < insert id = ”insertProduct” parameterMap = ”insert-product-param” >     insert into PRODUCT (PRD_DESCRIPTION, PRD_ID ) values (?,?) </ insert > parameterMap 中属性的顺序与SQL 中参数的顺序对应   Inline Parameter Maps < insert id = ”insertProduct” parameterClass = ”com.domain.Product” >     insert into PRODUCT (PRD_ID, PRD_DESCRIPTION)     values (#id#, #description#) </ insert > < insert id = ”insertProduct” parameterClass = ”com.domain.Product” >     insert into PRODUCT (PRD_ID, PRD_DESCRIPTION)     values (#id:NUMERIC:-999999#, #description:VARCHAR:NO_ENTRY#) </ insert > 语法 #propertyName# - OR - #propertyName:jdbcType# - OR - #propertyName:jdbcType:nullValue# 高级语法 #propertyName,javaType=?,jdbcType=?,mode=?,nullValue=?,handler=?,numericScale=?# <procedure id=“callProcedure” parameterClass=”com.mydomain.MyParameter”> {call MyProcedure (#parm1,jdbcType=INTEGER,mode=IN#, #parm2,jdbcType=INTEGER,mode=IN#, #parm3,jdbcType=DECIMAL,mode=OUT,numericScale=2#)} </procedure>