Mybatis外内连接的crud（含demo）（未写完）

查询

1.将需要查询的属性封装成pojo类

 2.mapper文件就按照正常sql写，如果需要参数查询，就加@Param注解，

<mapper namespace="com.xiaosuda.boot.Dao.StudentDao">
    <select id="SearchInf" resultType="com.xiaosuda.boot.Pojo.StudentInf">
        SELECT  student.sname as name,
                student.sbirth as birthday,
                student.sgender as gender,
                f1.Chinese,
                f1.ChineseScore,
                f1.Math,
                f1.MathScore
        FROM
            (
            SELECT
            t1.sid,t1.course as chinese,t1.score as chinesescore,t2.course as math,t2.score as mathscore
            FROM
                (
                    SELECT result.sid,class.course,result.score FROM class INNER JOIN result ON class.cid = result.cid WHERE class.cid = 1
                ) t1
            INNER JOIN
                (
                    SELECT result.sid,class.course,result.score FROM class INNER JOIN result ON class.cid = result.cid WHERE class.cid = 2
                ) t2
            WHERE
                t1.sid = t2.sid
            )f1
        INNER JOIN
            student
        ON
            f1.sid = student.sid
        where
        mathscore > chinesescore
    </select>
</mapper>

修改

UPDATE aa_user
INNER JOIN aa_order ON aa_user.u_id = aa_order.u_id 
SET aa_order.to_tal = 100 
WHERE
	aa_user.user_name = '李四'