1.Map作为parameterClass
映射文件:
<!--use Map type as parameterClass-->
<select id="getProduct-Map" parameterClass="java.util.Map" resultMap="get-product-result">
<![CDATA[
select * from t_product
where prd_id=#id# and prd_description=#description#
]]>
</select>
DAO层:
/**
* java.util.Map作为parameterClass
*/
public Product getProductMap(Map map) throws SQLException {
init();
Product product = (Product)sqlMapClient.queryForObject("getProduct-Map", map);
return product;
}
Test类:
public void getProductMap() throws SQLException{
Map map = new HashMap();
map.put("id", new Integer(1));
map.put("description", "basketball");
Product product = productDao.getProductMap(map);
System.out.println(product);
}
结果:
id:1
description:basketball
price206.99
2.Map作为resultClass
映射文件:
<resultMap id="get-product-map" class="java.util.HashMap">
<result property="id" column="prd_id"/>
<result property="description" column="prd_description"/>
<result property="price" column="prd_price"/>
</resultMap>
<!--START use Map type as resultClass,MUST use java.util.HashMap instead java.util.Map-->
<select id="getProdcut-MapResult" resultClass="java.util.HashMap
">
<![CDATA[
select * from t_product
]]>
</select>
<select id="getProductUseMap-resultMap" resultMap="get-product-map">
<![CDATA[
select * from t_product
]]>
</select>
<!-- END -->
DAO层:
/**
* java.util.Map作为resultClass
*/
public List getProductMapResult() throws SQLException {
init();
List list = sqlMapClient.queryForList("getProdcut-MapResult");
return list;
}
public List getProductUseMapByResultMap() throws SQLException {
init();
List list = sqlMapClient.queryForList("getProductUseMap-resultMap");
return list;
}
Test类:
public void getProductMapResult() throws SQLException{
Map map = null;
List list = productDao.getProductMapResult();
for(Iterator it=list.iterator(); it.hasNext();) {
//List里存放的是java.util.Map类型
Object obj = (Object)it.next();
System.out.println(obj.getClass());
System.out.println(obj);
}
}
public void getProductUseMapByResultMap() throws SQLException {
Map map = null;
List list = productDao.getProductUseMapByResultMap();
for(Iterator it=list.iterator(); it.hasNext();) {
//List里存放的是java.util.Map类型
Object obj = (Object)it.next();
System.out.println(obj.getClass());
System.out.println(obj);
}
}
结果:
class java.util.HashMap
{prd_id=1, prd_price=206.99, prd_description=basketball}
class java.util.HashMap
{prd_id=2, prd_price=106.99, prd_description=football}
class java.util.HashMap
{price=206.99, description=basketball, id=1}
class java.util.HashMap
{price=106.99, description=football, id=2}
注意:
Map作为resultClass时,必须指定具体的实现类,比如java.util.HashMap,否则会报错
Caused by: java.lang.RuntimeException: JavaBeansDataExchange could not instantiate result class. Cause: java.lang.InstantiationException: java.util.Map
分享到:
相关推荐
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
IBatisNet.Common.1.6.2、IBatis.DataAccess.1.9.2、IBatis.DataMapper.1.6.2
IBatis.DataMapper.1.6.2 和 IBatis.DataMapper.1.9 开发包
ibatis 用HashMap解决Ibatis未知列名和列数的查询结果的resultClass映射
包含IBatis.net 开发所需的Castle.DynamicProxy.dll,IBatisNet.Common.dll,IBatisNet.DataAccess.dll,IBatisNet.Common.dll以及相关配置文件
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
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...
提供两个版本的ibatis jar包下载。
提供ibatis2.3.4.8.jar包下载.
ibatis-2.3.2.715.jar包
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"/> ...
│ Dao.java │ GeneratorDemo.java │ hibernate.cfg.xml │ HibernateDaoImpl.java │ HibernateSessionFactory.java │ HibernateUtil.java │ JsonUtil.java │ list.txt │ log4j.properties │ ...
ibatis-2.3.0.677-sources.jar 值得学习的源码资源,不容错过。
ibatis-2.3.4.732.jar