<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="mapper.ArticleMapper">
<resultMap id="studentMap" type="student">
<!-- 构造方法-->
<constructor></constructor>
<!-- 主键-->
<id></id>
<!-- 列的映射关系-->
<result></result>
<!-- 一对一关联 外键-->
<association property=""></association>
<!-- 一对多关键-->
<collection property=""></collection>
<!-- 结果集处理方法-->
<discriminator javaType="">
<case value=""></case>
</discriminator>
</resultMap>
<select id="getArticleById" parameterType="Integer" resultType="Article">
select *
from article
where article_id = #{articleId}
</select>
<sql id="studentSql">
sid,name,age
</sql>
<select id="getStudent">
select <include refid="studentSql"></include>
from
</select>
</mapper>