JavaEE（十）:Mybatis

一、简介

    Mybatis也是ORM数据库的一种框架。Mybatis容易掌握，可以进行更为细致的SQL优化，可以减少查询字段。

二、使用

1、mybatis-config.xml配置文件

<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE configuration PUBLIC   
    "-//mybatis.org//DTD Config 3.0//EN"  
    "http://mybatis.org/dtd/mybatis-3-config.dtd">  
<configuration>  
    <!-- 配置别名 -->  
    <typeAliases>  
        <typeAlias type="org.iMybatis.abc.dao.UserDao" alias="UserDao" />  
        <typeAlias type="org.iMybatis.abc.dto.UserDto" alias="UserDto" />  
    </typeAliases>  
       
    <!-- 配置环境变量 -->  
    <environments default="development">  
        <environment id="development">  
            <transactionManager type="JDBC" />  
            <dataSource type="POOLED">  
                <property name="driver" value="com.mysql.jdbc.Driver" />  
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/iMybatis?characterEncoding=GBK" />  
                <property name="username" value="iMybatis" />  
                <property name="password" value="iMybatis" />  
            </dataSource>  
        </environment>  
    </environments>  
      
    <!-- 配置mappers -->  
    <mappers>  
        <mapper resource="org/iMybatis/abc/dao/UserDao.xml" />  
    </mappers>  
      
</configuration>  

2、UserDao.xml

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">  
<mapper namespace="org.iMybatis.abc.dao.UserDao">  
    <select id="queryUsers" parameterType="UserDto" resultType="UserDto"  
        useCache="false">  
        <![CDATA[ 
        select * from t_user t where t.username = #{username} 
        ]]>  
    </select>  
</mapper>  

3、UserDao.java

public interface UserDao {  
    public List<UserDto> queryUsers(UserDto user) throws Exception;  
}  

4、业务调用

private static SqlSessionFactoryBuilder sqlSessionFactoryBuilder;  
private static SqlSessionFactory sqlSessionFactory;  
private static void init() throws IOException {  
    String resource = "mybatis-config.xml";  
    Reader reader = Resources.getResourceAsReader(resource);  
    sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();  
    sqlSessionFactory = sqlSessionFactoryBuilder.build(reader);  
    SqlSession session= sqlSessionFactory.openSession();  
    UserDao userDao = session.getMapper(UserDao.class);  
    UserDto user = new UserDto();  
    user.setUsername("iMybatis");  
    List<UserDto> users = userDao.queryUsers(user);  
}