pom

<!-- Mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.2.8</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.6</version>
        </dependency>

web-dao.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mybatis="http://mybatis.org/schema/mybatis-spring"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd">
    <!--Database configuration,Path pointing database.properties-->
    <context:property-placeholder location="classpath:properties/jdbc.properties"/>
    <!--Configure the data source, which is used here druid-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driver}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />

        <!-- Initialize connection size -->
        <property name="initialSize" value="10" />
        <!-- Maximum number of connections used in connection pool -->
        <property name="maxActive" value="20" />
        <!-- Connection pool minimum idle -->
        <property name="minIdle" value="0" />
        <!-- Gets the maximum connection wait time -->
        <property name="maxWait" value="60000" />
        <!-- <property name="poolPreparedStatements" value="true" /> <property name="maxPoolPreparedStatementPerConnectionSize" value="33" /> -->

        <property name="validationQuery" value="${jdbc.validationQuery}" />
<!--        <property name="testOnBorrow" value="false" />-->
<!--        <property name="testOnReturn" value="false" />-->
<!--        <property name="testWhileIdle" value="true" />-->

        <!-- Configure how often to detect idle connections that need to be closed. The unit is milliseconds -->
        <property name="timeBetweenEvictionRunsMillis" value="60000" />
        <!-- Configure the minimum lifetime of a connection in the pool, in milliseconds -->
        <property name="minEvictableIdleTimeMillis" value="25200000" />

        <!-- open removeAbandoned function -->
        <property name="removeAbandoned" value="true" />
        <!-- 1800 Seconds, that is, 30 minutes -->
        <property name="removeAbandonedTimeout" value="1800" />
        <!-- close abanded Output error log when connecting -->
<!--        <property name="logAbandoned" value="false" />-->

        <!-- Monitoring database -->
        <!-- <property name="filters" value="stat" /> -->
<!--        <property name="filters" value="mergeStat" />-->
    </bean>
    <!--SqlSessionFactory to configure-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--The data source points to the previously configured dataSource-->
        <property name="dataSource" ref="dataSource"/>
        <!--binding Mybatis Configuration file for-->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
        <!--        appoint mapper.xml position-->
        <property name="mapperLocations" value="classpath*:maps/**/*.xml"/>
    </bean>
    <!--to configure Mapper mapping-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--        injection sqlSessionFactory-->
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
<!--        Auto scan package bean-->
        <property name="basePackage" value="com.qx.springmvcdemo.mapper"/>
    </bean>
</beans>

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>
    <settings>
        <!--        Field underline to hump-->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>
</configuration>

mybatis configuration item details