1首先创建视图
create view stu_class (sname,banjihao,banjidesc) as
select s.sname ,c.banjihao ,c.banjidesc from t_student s inner join t_class c on s.classid=c.banjihao
2在Mybatis的配置文件中直接调用视图
<!-- 测试 -->
<select id="getMyInfo" resultType="map">
select * from stu_class
</select>
3Controller层
//测试
@RequestMapping("testView")
public String testView(){
List<Map<Object,Object>> info= adminService.getMyInfo();
for (Map<Object, Object> map : info