MyBatis 【连接查询】

1.一个结果类

public class StudentAndClassesName {

    private String sName;
    private String cName;

        ....

}

2.Dao中一个函数

public interface comboDao {
    
    public List<StudentAndClassesName> find_StudentAndClassesName();
   
    ...
}

3.Mapper中配置一个查询

<?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="com.dao.comboDao">
    <resultMap type="com.result.StudentAndClassesName" id="result_StudentClass">
        <result property="sName" column="sname"/>
        <result property="cName" column="cname"/>
    </resultMap>
    
    <select id="find_StudentAndClassesName" resultMap="result_StudentClass">
        SELECT s.name as sname,c.name as cname FROM student s,classes c WHERE s.classid = c.id 
    </select>
</mapper>