ibatIS中的parameterClass,一般分类两种,1种为传model,另一种为传map
一、parameterClass传model参数
<select id="queryModel" parameterClass="com.hanpeng.base.phone.model.TDictionary" resultClass="com.hanpeng.base.phone.model.TDictionary">
SELECT
D_CODE as dCode ,
D_NAME as dName ,
D_INFO as dInfo ,
D_SERVER_NAME as dServerName ,
D_CLIENT_NAME as dClientName ,
REMARK as remark ,
D_SHORT as dShort ,
D_SERVER_COLOR as dServerColor ,
D_CLIENT_COLOR as dClientColor
FROM T_DICTIONARY
<dynamic prepend="WHERE">
<isNotEmpty prepend=" AND " 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" parameterClass="java.util.HashMap" resultClass="java.util.HashMap">
SELECT T.WB_INFO AS "val" , 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>
分享到:
相关推荐
ibatis 用HashMap解决Ibatis未知列名和列数的查询结果的resultClass映射
ibatis-2.3.4.726.jar,ibatis-2.3.0.677.jar,ibatis-2.3.3.720.jar下载,都已放入一个压缩包下。
ibatis.net官方组件 IBatis.net-IBatis.DataAccess.1.9.2/IBatis.DataMapper.1.6.2
import java.util.List; import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; import com.icss.model.Employee...
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> <sqlMap namespace="Account"> <typeAlias alias="Account" type="Account"/> <resultMap id...
IBatisNet.Common.1.6.2、IBatis.DataAccess.1.9.2、IBatis.DataMapper.1.6.2
包含IBatis.net 开发所需的Castle.DynamicProxy.dll,IBatisNet.Common.dll,IBatisNet.DataAccess.dll,IBatisNet.Common.dll以及相关配置文件
IBatis.DataMapper.1.6.2 和 IBatis.DataMapper.1.9 开发包
ibatis-2.3.3.720.jar
JAVA之ibatis2.3.X.ppt
ibatis2.3.4.726.jar ibatis2.3.4.726.jar ibatis2.3.4.726.jar ibatis2.3.4.726.jar
Manning.iBATIS.in.Action.Jan.2007.eBook-BBL.pdf Manning.iBATIS.in.Action.Jan.2007.eBook-BBL.pdf Manning.iBATIS.in.Action.Jan.2007.eBook-BBL.pdf
* 带参数的queryForMap用法 */ @SuppressWarnings("unchecked") public Map queryForMap(String sql_name, Object parameterObject, String keyProp,String valueProp) { Map map = null; try { map...
提供ibatis2.3.4.8.jar包下载.
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource = ERROR #log4j.logger.com.ibatis.common.jdbc.ScriptRunner = ERROR #log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate = ERROR #log4...
ibatis-2.3.2.715.jar包
提供两个版本的ibatis jar包下载。
│ │ │ frame-sourcefiles-org.apache.ibatis.executor.loader.cglib.html │ │ │ frame-sourcefiles-org.apache.ibatis.executor.loader.html │ │ │ frame-sourcefiles- org.apache.ibatis.executor.loader...