文章目录
相关文章
【mybatis】架构实现原理–1 基础概念和流程(Mapper接口原理)
【mybatis】架构实现原理–2 mybatis的几种写法(mapper接口用法)
1. mapper定义的两种写法
1.1 mapper接口+mapper.xml文件的方式
mapper接口如下:
package com.mapper;
import com.pojo.Teacher;
import java.util.List;
public interface TeacherMapper {
public List<Teacher> findAll();
}
mapper.xml如下:
注意:namespace的值一般为接口所在的包名加接口名"com.mapper.TeacherMapper"
<?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.mapper.TeacherMapper">
<resultMap id="teacherMap" type="Teacher">
<id property="id" column="id"/>
<result property="name" column="t_name"/>
</resultMap>
<select id="findAll" resultMap="teacherMap">
select * from tb_teacher
</select>
</mapper>
在整体的配置文件中,要写xml的全名:
<!--mapper/前缀为整体配置文件与mapper.xml的相对路径-->
<mapper resource="mapper/teacherMapper.xml"/>
1.2 mapper接口加注解的方式
直接将mapper.xml配置文件用注解的方式写在接口中,所以只有一个mapper的接口,其中result代表resultMap。
mapper接口:
package com.mapper;
import com.pojo.Teacher;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import java.util.List;
public interface TeacherMapper {
@Select("select * from tb_teacher")
@Results({
@Result(property = "id",column = "id"),
@Result(property = "name",column = "t_name")
})
public List<Teacher> findAll();
}
在整体的配置文件中,要写接口的全名:
<mapper class="com.mapper.TeacherMapper"/>
1.3 总结
配置虽然只有xml和java接口2种实现,但是在全局配置文件进行引入时,其实有4种用法:
<!-- 使用相对于类路径的资源引用 -->
<mappers>
<mapper resource="org/mybatis/builder/AuthorMapper.xml"/>
<mapper resource="org/mybatis/builder/BlogMapper.xml"/>
<mapper resource="org/mybatis/builder/PostMapper.xml"/>
</mappers>
<!-- 使用完全限定资源定位符(URL),用的少 -->
<mappers>
<mapper url="file:///var/mappers/AuthorMapper.xml"/>
<mapper url="file:///var/mappers/BlogMapper.xml"/>
<mapper url="file:///var/mappers/PostMapper.xml"/>
</mappers>
<!-- 使用映射器接口实现类的完全限定类名 -->
<mappers>
<mapper class="org.mybatis.builder.AuthorMapper"/>
<mapper class="org.mybatis.builder.BlogMapper"/>
<mapper class="org.mybatis.builder.PostMapper"/>
</mappers>
<!-- 将包内的映射器接口实现全部注册为映射器 -->
<mappers>
<package name="org.mybatis.builder"/>
</mappers>
2. 调用的两种写法
2.1 使用SqlSession的selectOne,selectList,selectMap方法
package com.dao;
import com.pojo.Teacher;
import com.util.MyBatisUtil;
import org.apache.ibatis.session.SqlSession;
import java.util.List;
public class UserDao {
private SqlSession sqlSession = MyBatisUtil.getSqlSession();
public List<Teacher> findAll(){
List<Teacher> list = sqlSession.selectList("com.mapper.TeacherMapper.findAll");
return list;
}
}
2.2 调用mapper接口的方法
package com.dao;
import com.mapper.TeacherMapper;
import com.pojo.Teacher;
import com.util.MyBatisUtil;
import org.apache.ibatis.session.SqlSession;
import java.util.List;
public class TeacherDao {
private SqlSession sqlSession = MyBatisUtil.getSqlSession();
public List<Teacher> findAll(){
TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
List<Teacher> list = mapper.findAll();
return list;
}
}
本质上,这种形式的调用,最后会转换为2.1形式,只不过通过代码进行了封装,方便我们调用。