ibatIS中的parameterClass，一般分类两种，1种为传model，另一种为传map[亲测有效]-

ibatIS中的parameterClass，一般分类两种，1种为传model，另一种为传map[亲测有效]ibatIS中的parameterClass，一般分类两种，1种为传model，另一种为传map一、parameterClass传model参数Java代码 “queryModel”  parameterClass=”com.hanpeng.base.phone.model.TDictionary” resultClass=”com.hanpeng.base.ph

ibatIS中的parameterClass，一般分类两种，1种为传model，另一种为传map

一、parameterClass传model参数

Java代码

<selectid=“queryModel”parameterClass=“com.hanpeng.base.phone.model.TDictionary”resultClass=“com.hanpeng.base.phone.model.TDictionary”>SELECTD_CODEasdCode,D_NAMEasdName,D_INFOasdInfo,D_SERVER_NAMEasdServerName,D_CLIENT_NAMEasdClientName,REMARKasremark,D_SHORTasdShort,D_SERVER_COLORasdServerColor,D_CLIENT_COLORasdClientColorFROMT_DICTIONARY<dynamicprepend=“WHERE”><isNotEmptyprepend=”AND“property=“dCode”>D_CODE=#dCode#</isNotEmpty><isNotEmptyprepend=”AND“property=“dName”>D_NAME=#dName#</isNotEmpty><isNotEmptyprepend=”AND“property=“dInfo”>D_INFO=#dInfo#</isNotEmpty><isNotEmptyprepend=”AND“property=“dServerName”>D_SERVER_NAME=#dServerName#</isNotEmpty><isNotEmptyprepend=”AND“property=“dClientName”>D_CLIENT_NAME=#dClientName#</isNotEmpty><isNotEmptyprepend=”AND“property=“remark”>REMARK=#remark#</isNotEmpty><isNotEmptyprepend=”AND“property=“dShort”>D_SHORT=#dShort#</isNotEmpty><isNotEmptyprepend=”AND“property=“dServerColor”>D_SERVER_COLOR=#dServerColor#</isNotEmpty><isNotEmptyprepend=”AND“property=“dClientColor”>D_CLIENT_COLOR=#dClientColor#</isNotEmpty></dynamic></select>

二、parameterClass传map参数

1.

Java代码

/***快速备注*@paramrequest*@return*@authorsgdjava*@date2011-9-8下午05:00:14*/publicstaticListgetKuaiSuBeiZhu(HttpServletRequestrequest){Listresult=null;try{Stringsendtype=“”;if(request.getAttribute(“sendType”)!=null)sendtype=(String)request.getAttribute(“sendType”);Mapsearch=newHashMap();search.put(“wbType”,sendtype);result=selectUtilSerivce.queryKuaiSuBeiZhu(search);}catch(Exceptione){log.error(“SelectUtilReqgetKuaiSuBeiZhuErr”,e);}returnresult;}

2.daoImpl

Java代码

publicList<Map<String,Object>>queryKuaiSuBeiZhu(MapsearchMap){returngetSqlMapClientTemplate().queryForList(“TDictionary.queryKuaiSuBeiZhu”,searchMap);}

3.sqlMap

Xml代码

<selectid=“queryKuaiSuBeiZhu”parameterClass=“java.util.HashMap”resultClass=“java.util.HashMap”>SELECTT.WB_INFOAS“val”,T.WB_INFOAS“key”FROMT_WRITE_BACKT<dynamicprepend=“WHERE”><isNotEmptyprepend=”AND“property=“wbType”>T.WB_TYPE=#wbType#</isNotEmpty></dynamic>ORDERBYT.WB_NUMASC</select>