Mybatis入门

1.回顾JDBC

优点：底层操作，执行效率高，访问数据库简单，灵活性强

缺点：代码编写复杂，重复较多，数据库连接参数经常发生变化，修改不方便，SQL与代码耦合，不易维护，结果处理很不方便

解决思路：封装，分离解耦，反射

2.Mybatis框架

Mybatis是一个优秀的数据持久层框架，是一种半自动的ORM实现

特点：

(1)开源的优秀持久层框架

(2)面向配置编程

(3)SQL语句与代码分离，方便维护

(4)良好支持数据映射，结果处理方便

(5)支持动态SQL语句

3.配置Mybatis

添加mybatis依赖

新建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>
        <package name="entity"/>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url"
                          value="jdbc:mysql://localhost:3306/news?useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=UTC&amp;useSSL=false"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="mapper/smbmsProviderMapper.xml"/>
        <mapper resource="mapper/smbmsAddressMapper.xml"/>
        <mapper resource="mapper/smbmsUserMapper.xml"/>
        <mapper resource="mapper/NewsMapper.xml"/>
    </mappers>
</configuration>  

mappers里面对应sql映射文件

在UserMapper.xml中写sql语句

<?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="dao.UserDao">

<select id="findAllUser" resultType="entity.User">
		select * from user
</select>

</mapper>

在dao层写对应的方法

package dao;

import entity.User;

import java.util.List;

public interface UserDao {
  List<User> findAllUser();
}

用junit测试sql语句

public class UserMapperTest {
    @Test
    public void test1() throws IOException {
        InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
        SqlSessionFactory sqlSessionFactory=SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        UserDao userDao = sqlSession.getMapper(UserDao.class);
        List<User> users = userDao.selectUserWithRole();
        System.out.println(users);
        }
    }
}