Mybatis环境搭建代码

Mybatis官方文档

https://mybatis.org/mybatis-3/zh/index.html

maven依赖

<dependencies>
        <!--mysql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.2</version>
        </dependency>
        <!--junit-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>      
        
        <!--<dependency>-->
        <!--    <groupId>log4j</groupId>-->
        <!--    <artifactId>log4j</artifactId>-->
        <!--    <version>1.2.17</version>-->
        <!--</dependency>-->

    </dependencies>

<!--在build中配置resources,来防止我们资源导出失败的问题-->
    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>

Mybatis核心配置文件
 

<?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>
    <!--引入外部配置文件-->
    <!--先读取property中的属性，然后读取外部文件中的属性，这个地方是外部文件的属性把property的属性给覆盖了-->
    <properties resource="db.properties">
        <property name="username" value="root"/>
        <property name="password" value="123"/>
    </properties>
    <!--配置日志-->
    <settings>
        <!--标准的日志工厂实现-->
        <setting name="logImpl" value="STDOUT_LOGGING"/>
        <!--log4j-->
        <!--<setting name="logImpl" value="LOG4J"/>-->
        <!--开启驼峰命名-->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>
    
    
    <!--可以给实体类起别名-->
    <typeAliases>
        <typeAlias type="com.song.pojo.User" alias="User"/>
        <typeAlias type="com.song.pojo.Role" alias="Role"/>
        <typeAlias type="com.song.pojo.Bill" alias="Bill"/>
        <typeAlias type="com.song.pojo.Provider" alias="Provider"/>
        <package name="com.song.pojo"/>
    </typeAliases>
    <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>
    <!--每一个Mapper.xml都需要在Mybatis核心配置文件中注册！-->
    <!--接口和他的Mapper文件必须同名-->
    <!--接口和它的Mapper配置文件必须在同一个包下-->
    <!--下面三种方式都可以-->
    <mappers>
        <!--<mapper resource="com/song/dao/UserMapper.xml"/>-->
        <!--<package name="com.song.dao"/>-->
        <mapper class="com.song.dao.RoleMapper"/>
        <mapper class="com.song.dao.UserMapper"/>
        <mapper class="com.song.dao.ProviderMapper"/>
        <mapper class="com.song.dao.BillMapper"/>
    </mappers>
</configuration>

Mybatis工具类

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 SqlSessionFactory sqlSessionFactory;

    static {
        try {
        //使用Mybatis第一步：获取sqlSessionFactory对象
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    //既然有了sqlSessionFactory,顾名思义，我们就可以从中获取sqlSession的实例了
    //sqlSession完全包含了面向数据库执行的SQL命令所需的全部方法
    //方法中的true代表开启了自动提交事务
    public static SqlSession getSqlSession(){
        return sqlSessionFactory.openSession(true);
    }
}

Mapper接口

import com.song.pojo.User;
import org.apache.ibatis.annotations.Param;

public interface UserMapper {
    //通过userCode获取User
    public User getLoginUser(@Param("userCode") String userCode);
}

接口实现类

<?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.song.dao.UserMapper">
    <!--通过userCode获取User-->
    <select id="getLoginUser" parameterType="String" resultType="User">
        select * from smbms.smbms_user where userCode = #{userCode}
    </select>
</mapper>