ibatis resultclass java.util.list_ibatis中动态查询表返回用resultClass=”java.util.HashMap” 的问题 | 学步园...

1.Map作为parameterClass

映射文件：

select * from t_product

where prd_id=#id# and prd_description=#description#

]]>

?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

映射文件：

select * from t_product

]]>

select * from t_product

]]>

?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