MyBtis后台打印sql语句
sqlMapConfig.xml中加
<settings> <!-- 打印查询语句 --> <setting name="logImpl" value="STDOUT_LOGGING" /> </settings>
Course
public class Course { private String cId; private String cName; private Teacher teacher;
Teacher
private String tId; private String tName;
CourseMapper.xml
<resultMap id="selectCourseTeacher" type="com.learn.pojo.Course"> <id column="c_id" property="cId" jdbcType="VARCHAR" /> <id column="c_name" property="cName" jdbcType="VARCHAR" /> <!--<id column="t_id" property="tId" jdbcType="VARCHAR" />--> <association property="teacher" column="t_id" javaType="com.learn.pojo.Teacher" select="com.learn.mapper.TeacherMapper.selectAll"></association> </resultMap>
<select id="selectCourseTeacher" resultMap="selectCourseTeacher"> select * from course where c_id=#{id} </select>
TeacherMapper.xml
<select id="selectAll" resultMap="BaseResultMap"> select * from teacher where t_id=#{tId} </select>