Mybatis入门 从 XML 中构建 SqlSessionFactory

一、前期准备

在idea中创建maven项目

在main/Java下创建文件夹com.mybatis.mapper和com.mybatis.pojo

在main下创建文件夹resources

二、配置编写

1.在pom.xml中导入mybatis、mysql、log4j、Junit

    <!--junit依赖-->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
    <!--mybatis-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.7</version>
    </dependency>
    <!--mysql-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.27</version>
    </dependency>
    <!-- 导入日志-->
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>1.2.17</version>
    </dependency>

2.编写实体类——路径main/java/com/mybatis/pojo/Book.java

package com.mybatis.pojo;

public class Book {
    private int id;
    private String name;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    @Override
    public String toString() {
        return "Book{" +
                "id=" + id +
                ", name='" + name + '\'' +
                '}';
    }
}

3.编写持久层接口——路径main/java/com/mybatis/mapper/Mapper.java

package com.mybatis.mapper;

import com.mybatis.pojo.Book;
import java.util.List;

//持久层接口
public interface Mapper {
    //根据id查找
    Book findById(Integer id);
    //查询全部
    List<Book> findAll();
}

4.编写映射文件——路径main/java/com/mybatis/mapper/BookMapper.xml

<?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">

<!--namespace指的是你的dao接口-->
<mapper namespace="com.mybatis.mapper.Mapper">
    <!--配置查询所有  其中id不能乱写必须是dao接口中的方法  resultType写的是实体类的全路径-->
    <select id="findAll" resultType="com.mybatis.pojo.Book">
        select * from book
    </select>
    <!--按照id查找-->
    <select id="findById" resultType="com.mybatis.pojo.Book">
        select * from book where id = #{id}
    </select>
</mapper>

5.编写配置文件——路径main/resources/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>
    <environments default="development">
        <!-- 数据库环境 -->
        <environment id="development">
            <!-- 数据库环境 -->
            <transactionManager type="JDBC"/>
            <!-- 数据库环境 -->
            <dataSource type="POOLED">
                <!-- 配置连接数据库的4个基本信息 -->
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
                <property name="username" value="root"/>
                <property name="password" value="aaaaaaaa"/>
            </dataSource>
        </environment>
    </environments>
    <!-- 指定映射配置文件的位置，映射配置文件指的是每个dao独立的配置文件 -->
    <mappers>
        <mapper resource="com/mybatis/mapper/BookMapper.xml"/>    
    </mappers>
</configuration>

6.编写测试——路径main/java/com/mybatis/MybatisTest

package com.mybatis;

import com.mybatis.mapper.Mapper;
import com.mybatis.pojo.Book;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.InputStream;
import java.util.List;

public class MybatisTest {
    public static void main(String[] args) {

        try  {
            //加载配置全局文件
            InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
            //创建SqlSessionFactory工厂
            SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
            SqlSessionFactory sqlSessionFactory = builder.build(inputStream);
            //使用工厂生产SqlSession对象
            SqlSession session = sqlSessionFactory.openSession();
            //从SQLSession中获取接口实现类对象
            Mapper mapper=session.getMapper(Mapper.class);
            //执行-查全部
            List<Book> books = mapper.findAll();
                System.out.println(books);
            System.out.println("按照id查");
            Book book=mapper.findById(1);
                System.out.println(book);
            //释放资源
            session.close();
            inputStream.close();
        }catch (Exception e){
            e.printStackTrace();
        }
    }
}

7.在resources文件下创建log4j.properties

没有配置此文件时会有下面的WARN：

log4j:WARN No appenders could be found for logger (org.apache.ibatis.logging.LogFactory).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.

# Global logging configuration
log4j.rootLogger=debug, stdout, R
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

# Pattern to output the caller's file name and line number.
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] (%F:%L) - %m%n

log4j.appender.R=org.apache.log4j.RollingFileAppender
log4j.appender.R.File=example.log

log4j.appender.R.MaxFileSize=100KB
# Keep one backup file
log4j.appender.R.MaxBackupIndex=5

log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%p %t %c - %m%n

8.测试结果如下：

9.代码运行出现如下错误

Error parsing SQL Mapper Configuration. Cause: java.io.IOException: Could not find resource com/mybatis/mapper/BookMapper.xml

 请在pom.xml文件中添加下面代码

<build>
    <!--   **.xml写在src找不到问题解决方案     -->
    <resources>
      <resource>
        <!-- directory：指定资源文件的位置 -->
        <directory>src/main/java</directory>
        <includes>
          <!-- “**” 表示任意级目录    “*”表示任意任意文件 -->
          <!-- mvn resources:resources　：对资源做出处理，先于compile阶段  -->
          <!--包括文件下的.properties,.xml 文件都会扫描到-->
          <include>**/*.properties</include>
          <include>**/*.xml</include>
        </includes>
      </resource>
    </resources>
</build>

详细请前往Mybatis官网

入门_MyBatis中文网https://mybatis.net.cn/getting-started.html