ibatis 返回结果集
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);