resultMap作用:
1.当实体类的属性名和数据库表字段名不一致时,可以通过resultMap进行映射
2.支持mybatis进行复杂查询,一对一,一对多,多对多
一对一,一对多查询(association:关联)
mapper.java接口方法名
<select id="listPage1" parameterType="java.lang.Long"
resultMap="BaseResultMapOneToOne">
select
<include refid="Base_Column_List" />
from student
</select>
<resultMap id="BaseResultMapOneToOne"
type="com.mbyte.easy.admin.entity.Student">
<id column="id" jdbcType="BIGINT" property="id" />
<id column="class_id" jdbcType="BIGINT" property="classId" />
<id column="name" jdbcType="VARCHAR" property="name" />
<id column="img" jdbcType="VARCHAR" property="img" />
<id column="sex" jdbcType="INTEGER" property="sex" />
<id column="create_time" jdbcType="TIMESTAMP" property="createTime" />
<association property="classInfo" column="class_id"
select="com.mbyte.easy.admin.mapper.ClassInfoMapper.getClassInfoById">
</association>
</resultMap>
<select id="getClassInfoById" parameterType="java.lang.Long"
resultMap="BaseResultMapTest">
select
<include refid="Base_Column_List" />
from class_info
where id = #{id,jdbcType=BIGINT}
</select>
一对多(collections 集合)
mapper.java内容
mapper.xml内容