和hibernate框架一个道理,mybatis也会给每个数据库连接创建一个session。在mybatis中,SqlSessionFactoryBuilder负责创建SqlSessionFactory,SqlSessionFactory负责创建SqlSession(这里很不理解问什么要引入SqlSessionFactoryBuilder这个东西),官方推荐SqlSessionFactoryBuilder在创建完SqlSessionFactory之后,就不再保留,保留起来也没有什么用处,SqlSessionFactory存在于整个应用程序的生命周期,SqlSession生命周期最好在请求或者方法。
基本使用流程:
SqlSession session = sqlSessionFactory.openSession();
try {
UserMapper mapper = session.getMapper(UserMapper.class);
} finally {
session.close();
}
常用标签:
properties标签:配置driver ,url,username,password等基本信息
setting标签:配置cache,延迟加载等信息
typealiases标签:这个很有用,取个别名,就不需要写那么长的名字了,eg:
<typeAliases> <typeAlias alias="User" type="com.test.admin.domain.User"/></typeAliases>
同时指出包别名,eg:
<typeAliases>
<package name="com.test.admin.domian"/>
</typeAliases>
typehandler标签:用于自定义类型装换器。
plugins标签:可以定义自己的advice,使用动态代理的方式
mappers标签:导入定义的mapper配置文件,eg:
<mappers>
<mapper class="org.mybatis.builder.AuthorMapper"/>
<mapper class="org.mybatis.builder.BlogMapper"/>
<mapper class="org.mybatis.builder.PostMapper"/>
</mappers>
mapper文件中的标签
select ,update ,delete, insert就不用多说了
resultMap很强大,定义对象和数据库字段的映射关系,eg:
<resultMap id="userResultMap" type="User">
<id property="id" column="user_id" />
<result property="username" column="user_name"/>
<result property="password" column="hashed_password"/>
</resultMap>
<select id="selectUsers" parameterType="int" resultMap="userResultMap">
select user_id, user_name, hashed_password
from some_table
where id = #{id}
</select>
有个sql标签,有点像宏定义,用于替换sql的,eg:
<sql id="userColumns"> id,username,password </sql>
<select id="selectUsers" parameterType="int" resultType="hashmap">
select <include refid="userColumns"/> from some_table where id = #{id}
</select>
最后,动态sql有几个内置的命令:
if命令:
<if test="title != null">
AND title like #{title}
</if>
choose,when,otherwise命令:
<choose>
<when test="title != null">
AND title like #{title}
</when>
<when test="author != null and author.name != null">
AND author_name like #{author.name}
</when>
<otherwise>
AND featured = 1
</otherwise>
</choose>
专用于where条件的命令:
<where>
<if test="state != null">
state = #{state}
</if>
<if test="title != null">
AND title like #{title}
</if>
<if test="author != null and author.name != null">
AND author_name like #{author.name}
</if>
</where>
可以用于in子句的foreach命令:
<select id="selectPostIn" resultType="domain.blog.Post">
SELECT *
FROM POST P
WHERE ID in
<foreach item="item" index="index" collection="list"
open="(" separator="," close=")">
#{item}
</foreach>
</select>