Ibaits返回结果集[转]
object
别名映射?->?实体类：?resultClass?
<select id=" selectAll" resultselectAll" resultcolumn="ID"/>????
<result property="type" column="Type"/>????
<result property="descr" column="DESCR"/>???
</resultMap>
<select id="selectAll" resultMap="AppLogResult">????
select * from APP_LOG</select>?
List list = sqlMapper.queryForList("selectAll");
for (int i = 0; i < list.size(); i ) {????
AppLog log = (AppLog) list.get(i);?
//add your code here;}?
显式映射?->Map?类：?resultMap?
<resultMap id="map-result" column="ID"/>????
<result property="type" column="Type"/>????
<result property="descr" column="DESCR"/>????
</resultMap><select id="selectAll2" resultMap="map-result">????
select * from APP_LOG</select>?
List list = sqlMapper.queryForList("selectAll2");???????
for (int i = 0; i < list.size(); i ) {??????????
Map map = (Map) list.get(i);???????????
String id = (String) map.get("id");???????????
String type = (String) map.get("type");???????????
String descr = (String) map.get("descr");???????????????
}?
无映射?
<select id="selectAll3" resultparameterresultxmlResultName="log">????
select????? ID as id,????? TYPE as type,????? DESCR as descr??? from APP_LOG??? where ID = #id#</select>?
String o=(String) sqlMapper.queryForObject("selectxml", id);
System.out.println(o);
