StringBoot+jeefast模式一对一表连接

StringBoot+jeefast模式一对一

实体类中链表

    @TableField(exist = false)
    private Classes classes;

    public Classes getClasses() {
        return classes;
    }

    public void setClasses(Classes classes) {
        this.classes = classes;
    }

xml中

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="cn.jeefast.modules.platform.entity.Student">
        <id column="id" property="id" />
        <result column="name" property="name" />
        <result column="age" property="age" />
        <result column="ccid" property="ccid" />
        //主表数据
        <association property="classes" javaType="Classes">//副表名称
            <id property="cid" column="cid"/>
            <result property="cname" column="cname"/>
            <result property="ssid" column="ssid"/>
            //副表数据
        </association>
    </resultMap>

    <select id="queryPageList" resultMap="BaseResultMap">
    //此处resultMap=""与查询映射属性值一致
        SELECT * FROM student inner JOIN classes ON student.ccid=classes.cid
        <where>
            <if test="title != null and title.trim() != ''">
                and name like concat('%',#{title},'%')
            </if>

        </where>
        <choose>
            <when test="idx != null and idx.trim() != ''">
                order by student.${idx} ${order}
            </when>
            <otherwise>
                order by student.id desc
            </otherwise>
        </choose>