一、使用MyBatis的mapper接口调用时有哪些要求?
① Mapper接口方法名和mapper.xml中定义的每个sql的id相同;
② Mapper接口方法的输入参数类型和mapper.xml中定义的每个sql 的parameterType的类型相同;
③ Mapper接口方法的输出参数类型和mapper.xml中定义的每个sql的resultType的类型相同;
④ Mapper.xml文件中的namespace即是mapper接口的类路径。
<mapper namespace="com.operation.TeacherOperation">
<select id="selectTeacherByID" resultType="teacher2">
select * from tb_Teacher2 where dep_id=#{dep_id}
</select>
</mapper>
package com.operation;
public interface TeacherOperation {
public teacher2 selectTeacherByID(int id);
}
二、mapper编写方式有哪几种
①使用相对于类路径的资源引用
<mapper resource="com/MapperXML/DepartmentMapper.xml"></mapper>