建立MyBatis项目

一、在pom中导入Mybatisy依赖

    <dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
    </dependencies>

从XML中构建SqlSessionFactory

配置文件放在资源文件夹下resouse
1.配置数据源

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/`数据库的名字`?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC
jdbc.username=root
jdbc.password=123456

2.配置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>
    <!--引入外部数据源-->
    <properties resource="database.properties"></properties>

    <!--    如果数据库中的字段有下划线（user_name）则自动转换为userName
            取别名有三种方式
                1.直接给类取别名
                2.给包取别名
                3.注解取别名  @Alias     优先级最高
    -->
    <settings>
    	<!--设置驼峰命名规则-->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>

    <!--    给包取别名-->
    <typeAliases>
        <package name="pojo包的全路径"/>
        <package name="model包的全路径"/>
    </typeAliases>

		<!--将配置的数据源内容引入设置中-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <!--直接配置包名，则包名底下的xml都不需要再进行手动配置-->
        <package name="com.software.mapper"/>
    </mappers>

</configuration>

XML中构建SqlSessionFactory

需要导入Junit依赖

package com.software;

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 org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;

public class test {
    private SqlSessionFactory sqlSessionFactory;
    private SqlSession sqlSession;

    @Before
    public void before(){
        InputStream inputStream = null;
        try {
            inputStream = Resources.getResourceAsStream("mybatis-config.xml");
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                if (inputStream != null) {
                    inputStream.close();
                }
            } catch (IOException e) {
                e.printStackTrace();
            }
        }

    }

    @Test
    public void text01(){
        sqlSession = sqlSessionFactory.openSession(true);
//        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
    }

    @After
    public void after(){
        if (sqlSession != null) {
            sqlSession.close();
        }
    }
}

映射Mapper(写sql语句)

1. 首先创建一个mapper接口

package com.software.mapper;

import com.software.pojo.Student;

public interface StudentMapper {
    Student selectById(int id);
}

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">
<mapper namespace="com.software.mapper.StudentMapper">

    <select id="selectById" resultType="Student">
        SELECT * FROM student WHERE id=#{id}
    </select>
</mapper>