Mybaties搭建

1.导入maven依赖

 <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
       <dependency>
           <groupId>org.mybatis</groupId>
           <artifactId>mybatis</artifactId>
           <version>3.4.6</version>
       </dependency>
       <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
       <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
           <version>5.1.47</version>
       </dependency>
       <dependency>
           <groupId>log4j</groupId>
           <artifactId>log4j</artifactId>
           <version>1.2.17</version>
       </dependency>

2.Mybaties配置文件mybaties-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>
    <!-- 引入database.properties文件-->
    <properties resource="database.properties"/>
    <!--配置mybaties 的log实现为log4j-->
    <settings>
        <setting name="logImpl" value="LOG4J"/>
    </settings>
    <!--配置mybaties多套运行环境-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${user}"/>
                <property name="password" value="${pwd}"/>
            </dataSource>
        </environment>
    </environments>
    <!--将mapper文件加入配置文件中-->
    <mappers>
        <mapper resource="dao/UserMapper.xml"/>
    </mappers>
</configuration>

idea 可以在setting 的File and Templates里先创建模板
3.建pojo类，可以使用idea自己生成
4.创建SQL映射文件，完成与pojo（实体类）的映射，该文件是一个xml文件
命名规则：以pojo的名称+Mapper的规则来命名
一般放在dao包下

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"
        "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="UsersDao">
    <!--查询用户表记录数-->
    <select id="count" resultType="int">
        select count(1) as count from users
    </select>

    <!--查询用户是否存在-->
    <select id="findLogin" resultType="int">
    </select>

</mapper>

在idea里发现找不到Mapper.xml文件，原因是IDEA不会编译src的java目录下的xml文件
解决办法：在pom.xml文件里加入

<build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
            </resource>
        </resources>
    </build>

具体依照自己的目录来

5。建测试类

  String resoures="/my-cfg.xml";
        InputStream is= Resources.class.getResourceAsStream(resoures);
        SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(is);
        int count=0;
        SqlSession sqlSession=null;
        sqlSession=factory.openSession();
        count=sqlSession.selectOne("UsersDao.count");
        System.out.println(count);
        sqlSession.close();