ibatIS的parameterClass="java.util.HashMap"使用Map类型参数

?

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

?

一、parameterClass传model参数

<select id="queryModel"  parameterresultAND " property="dCode">D_CODE =  #dCode# </isNotEmpty><isNotEmpty prepend=" AND " property="dName">D_NAME =  #dName# </isNotEmpty><isNotEmpty prepend=" AND " property="dInfo">D_INFO =  #dInfo# </isNotEmpty><isNotEmpty prepend=" AND " property="dServerName">D_SERVER_NAME =  #dServerName# </isNotEmpty><isNotEmpty prepend=" AND " property="dClientName">D_CLIENT_NAME =  #dClientName# </isNotEmpty><isNotEmpty prepend=" AND " property="remark">REMARK =  #remark# </isNotEmpty><isNotEmpty prepend=" AND " property="dShort">D_SHORT =  #dShort# </isNotEmpty><isNotEmpty prepend=" AND " property="dServerColor">D_SERVER_COLOR =  #dServerColor# </isNotEmpty><isNotEmpty prepend=" AND " property="dClientColor">D_CLIENT_COLOR =  #dClientColor# </isNotEmpty></dynamic></select>

?

二、parameterClass传map参数

1.

/** * 快速备注 * @param request * @return * @author sgdjava * @date 2011-9-8 下午05:00:14 */public static List getKuaiSuBeiZhu(HttpServletRequest request) {List result = null;try {String sendtype="";if(request.getAttribute("sendType") != null)sendtype = (String)request.getAttribute("sendType");Map search = new HashMap();search.put("wbType", sendtype);result = selectUtilSerivce.queryKuaiSuBeiZhu(search);} catch (Exception e) {log.error("SelectUtilReq getKuaiSuBeiZhu Err",e);}return result;}

?2.daoImpl

public List<Map<String, Object>> queryKuaiSuBeiZhu(Map searchMap) {return getSqlMapClientTemplate().queryForList("TDictionary.queryKuaiSuBeiZhu", searchMap);}

?3.sqlMap

<select id="queryKuaiSuBeiZhu"  parameterresult, T.WB_INFO AS "key"  FROM T_WRITE_BACK T <dynamic prepend="WHERE"><isNotEmpty prepend=" AND " property="wbType">T.WB_TYPE=#wbType# </isNotEmpty></dynamic>ORDER BY T.WB_NUM ASC</select>