org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.Persiste

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.lang.UnsupportedOperationException
### The error may exist in file [E:\IdeaProject\demo1\Api-module\target\classes\mapper\TeacherMapper.xml]
### The error may involve demo.mapperInterface.TeacherMapper.SelectTeacherByOrgId
### The error occurred while handling results

解决方法:
吧resultType="list"换成resultType="map"即可
因为resultType是一行的结果,每行结果是个map,其他不变,该是list是list

  <select id="SelectTeacherByOrgId"  resultType="map" parameterType="map">
  SELECT org.orgID,orgName,teacherID,teacherName,teacherSubject,orgStation
  FROM org LEFT JOIN teacher on org.orgID=teacher.orgID WHERE org.orgID= #{orgid,jdbcType=INTEGER}
  </select>

版权声明:本文为qq_31897241原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。