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>