ibatis传入参数介绍

原型参数

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