object
别名映射 -> 实体类: resultClass
<select id=" selectAll" resultClass="AppLog">
select ID as id, TYPE as type, DESCR as descr from APP_LOG where ID = #id#
</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 类: resultClass
<select id=" selectAll" resultClass="java.util.HashMap"> select ID as id, TYPE as type, DESCR as descr from APP_LOG where ID = #id#
</select>
List list = sqlMapper.queryForList("selectAll");
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");
//add your code here;}
显式映射 -> 实体类: resultMap
<resultMap id="AppLogResult" class="AppLog">
<result property="id" column="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" class="java.util.HashMap">
<result property="id" 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" resultClass="java.util.HashMap">
select * from APP_LOG</select>
List list = sqlMapper.queryForList("selectAll3");
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");}
xmlxml
<select id="selectxml" parameterClass="java.lang.String" resultClass="xml" xmlResultName="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);
Ibaits返回结果集【转载】
最新推荐文章于 2024-10-18 14:09:45 发布