MyBatis使用视图

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