07 输出映射
7.1resultType
输出基本数据类型
注意,对简单数据类型的结果映射也是有要求的,查询的列必须是一列,才能映射为简单类型
简单数据类型
- 一个参数,多个参数
- 对象
- 多个参数
- Map
7.2resultMap
<resultMap id="ReturnMap" type="com.freshtest.mybatis.model.House">
<!--主键-->
<id property="id" column="id"></id>
<result property="title" column="title"></result>
<result property="logo" column="logo"></result>
<result property="price" column="price"></result>
<result property="area" column="area"></result>
<result property="city" column="city"></result>
<result property="district" column="district"></result>
<result property="createTime" column="create_time"></result>
<result property="updateTime" column="update_time"></result>
</resultMap>
ReturnMap名称要相同s
<select id="getById" parameterType="java.lang.Integer" resultMap="ReturnMap">
SELECT * FROM house WHERE id= #{id}
</select>