Mybatis映射文件配置

<?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>

1.主键相关属性

2.select相关属性

posted @ 2023-03-06 12:07  lwx_R  阅读(29)  评论(0)    收藏  举报