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