比如用户表user 评论表Comments
我根据评论表里的userid查询用户名字
我们要去评论表的配置文件 也就是CommentsMapper.xml文件里配置
添加配置
<sql id="usertable">userid,username</sql>
<resultMap type="com.appraise.test.pojo.Users" id="UsersMap">
<id column="userid" property="userid" jdbcType="INTEGER"/>
<result column="username" property="username" jdbcType="VARCHAR"/>
<result column="password" property="password" jdbcType="VARCHAR"/>
</resultMap>
<select id="getUsers" resultMap="UsersMap" parameterType="java.lang.Integer">
select <include refid="usertable"/> from users u where u.userid=#{userid,jdbcType=INTEGER}
</select>