Mybatis入门

 Maven库：

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.5.2</version>
</dependency>
 

文章目录

• 前言
• 一、编写mybatis的核心文件
• 二、使用步骤
  • 1.引入库
  • 2.读入数据
• 总结

---

前言

Mybatis 3文档

mybatis – MyBatis 3 | 入门https://mybatis.org/mybatis-3/zh/getting-started.html

---

一、配置mybatis-config.xml配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "https://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="org/mybatis/example/BlogMapper.xml"/>
  </mappers>
</configuration>

。

二、编写mybatis

1.编写工具类

//sqlSessionFactory --> sqlSession

public class MybatisUtils {

    private static SqlSessionFactory sqlSessionFactory;
    static{
        try {
            //使用Mybatis 第一步:获取sqlSessionFactory对象
        String resource = "mybatis-config.xml";
        InputStream inputStream = null;
        inputStream = Resources.getResourceAsStream(resource);
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    
    public static SqlSession getSqlSession(){
        SqlSession sqlSession = sqlSessionFactory.openSession();
        return sqlSession;
    }

}

2.、编写代码

步骤说明

1. 配置Maven
2. 编写工具类
3. mybatis-config.xml配置文件
4. 编写Dao/Mapper
5. 编写UserMapper.xml配置文件绑定一个Mapper
6. 测试 

遇到的问题

1. 1.maven配置文件无法被导出
2. resource绑定mapper,需要使用路径
3. 配置文件必须符合规范
4. NullPointException没有注册到资源

Maven无法导出解决方法:手动配置<build>

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