<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="messageInfo">
<resultMap id="MessageResult" class="com.huawei.test.ibatis.dto.MessageInfo">
<result property="id" column="id" jdbcType="INTEGER" />
<result property="message_name" column="message" jdbcType="VARCHAR" />
</resultMap>
<!-- 查询对象列表-->
<select id="getAllMessages" resultMap="MessageResult">
SELECT
id,
message
FROM Message
</select>
</sqlMap>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="messageInfo">
<resultMap id="MessageResult" class="com.huawei.test.ibatis.dto.MessageInfo">
<result property="id" column="id" jdbcType="INTEGER" />
<result property="message_name" column="message" jdbcType="VARCHAR" />
</resultMap>
<!-- 查询对象列表-->
<select id="getAllMessages" resultMap="MessageResult">
SELECT
id,
message
FROM Message
</select>
</sqlMap>