mybatis入门完美配置

Mybatis的配置

1. 在maven 找依赖

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

• 或github找jar包,码云找jar包

2. 导入后在resources创建mybatis-config.xml
   3. 这个是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">
<!--                上面的都默认-->
<!--                填写自己对应的 driver url username password -->
             <property name="driver" value="com.mysql.jdbc.Driver"/>
             <property name="url" value="jdbc:mysql://localhost:3306/zhou?useUnicode=true&amp;characterEncoding=utf-8&amp;useSSL=false"/>
             <property name="username" value="root"/>
             <property name="password" value="123456"/>
         </dataSource>
     </environment>
 </environments>
 <mappers>
<!--        填写映射的Mapper注册-->
     <mapper resource="com/zhou/dao/UserMapper.xml"/>
 </mappers>
</configuration>

4. 获取Sqlsession 这里可以封装成工具类

package com.zhou.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;

public class mybatisutils {
   private static InputStream inputStream;
   private static SqlSessionFactory sqlSessionFactory;
   static {
       try {
           String resource = "mybatis-config.xml";
           inputStream = Resources.getResourceAsStream(resource);
           sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
       } catch (IOException e) {
           e.printStackTrace();
       }
   }
   public static SqlSession getSqlSession(){
       return sqlSessionFactory.openSession();
   }
}

5.创建实体类

6.创建实体类对应Mapper接口与对应Mapper.xml文件

package com.zhou.dao;


import com.zhou.pojo.User;

import java.util.List;

public interface UserMapper {
    List<User> getUserList();
}

<?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="com.zhou.dao.UserMapper"><!--绑定类的类名-->
    <select id="getUserList" resultType="com.zhou.pojo.User"><!--resultType 写的是对应实体类的绝对地址，id里面填的是绑定类名的方法-->
    select * from zhou.user<!--需要操作的sql语句-->
  </select>
</mapper>

7. 注意写完Mapper.xml要去核新配置文件（mybatis-config）注册

 <mappers>
<!--        填写映射的Mapper注册-->
        <mapper resource="com/zhou/dao/UserMapper.xml"/>
    </mappers>

8.注册完后用maven的需要在pom.xml中进行约束解放不然由于maven的约定的大于配置会无法读取mybatis-config.xml文件

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

9.配置后便可以进行测试