MyBatis基本用法及其配置

MyBatis

1.xml配置

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> 核心配置文件-->
   <configuration>
   
       <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/mybatis?useSSL=false&amp;useUnicode=true&amp;characterEncoding=utf-8&amp;serverTimezone=UTC"/>
                   <property name="username" value="root"/>
                   <property name="password" value="wjlroot"/>
               </dataSource>
           </environment>
       </environments>
   
       <mappers>
           <mapper resource="com/qilin/dao/UserMapper.xml"/>
       </mappers>
   </configuration>
   

2. Mapper.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">
   

3. MyBatisUtils

   package com.qilin.utils;
   
   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.IOException;
   import java.io.InputStream;
   
   //sqlSessionFactory  构建sqlSession
   public class MyBatisUtils {
   
       private static SqlSessionFactory sqlSessionFactory;
   
       static{
           //获取mybatisFactory对象
           String resource = "mybatis-config.xml";
           InputStream inputStream = null;
           try {
               inputStream = Resources.getResourceAsStream(resource);
           } catch (IOException e) {
               e.printStackTrace();
           }
           sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
       }
   
   //      既然有了 SqlSessionFactory，顾名思义，我们可以从中获得 SqlSession 的实例。
   //      SqlSession 提供了在数据库执行 SQL 命令所需的所有方法
   
       public static SqlSession getSqlSession(){
           return sqlSessionFactory.openSession();
       }
   }