spring-springmvc-mabatis 添加

1.下篇将会把现在的配置文件汇总一下，本篇将spring和mabatis的整合

1.1添加maven jar

pom文件添加 mybatis-spring mybatis ，使用阿里的druid控制，mysql

      <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis-spring</artifactId>
          <version>1.2.3</version>
      </dependency>
      <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis</artifactId>
          <version>3.2.8</version>
      </dependency>
      <dependency>
          <groupId>com.alibaba</groupId>
          <artifactId>druid</artifactId>
          <version>1.1.3</version>
      </dependency>
      <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>5.1.36</version>
      </dependency>

1.2按自己的要求看自己是不是需要吧spring-mabtis的配置文件抽出来，如果不需要的话，在spring-config.xml添加就可以

        <context:property-placeholder location="classpath:jdbc.properties"/>
        <!-- 数据源 -->
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
              init-method="init" destroy-method="close">
                <!-- 数据库基本信息配置 -->
                <property name="url" value="${druid.url}" />
                <property name="username" value="${druid.username}" />
                <property name="password" value="${druid.password}" />
                <property name = "driverClassName" value = "${druid.driverClassName}" />

                <!-- 初始化连接数量 -->
                <property name="initialSize" value="${druid.initialSize}" />
                <!-- 最小空闲连接数 -->
                <property name="minIdle" value="${druid.minIdle}" />
                <!-- 最大并发连接数 -->
                <property name="maxActive" value="${druid.maxActive}" />
                <!-- 配置获取连接等待超时的时间 -->
                <property name="maxWait" value="${druid.maxWait}" />

                <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
                <property name="timeBetweenEvictionRunsMillis" value="${druid.timeBetweenEvictionRunsMillis}" />

                <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
                <property name="minEvictableIdleTimeMillis" value="${druid.minEvictableIdleTimeMillis}" />
                <property name="validationQuery" value="${druid.validationQuery}" />
                <property name="testWhileIdle" value="${druid.testWhileIdle}" />
                <property name="testOnBorrow" value="${druid.testOnBorrow}" />
                <property name="testOnReturn" value="${druid.testOnReturn}" />

                <!-- 打开PSCache，并且指定每个连接上PSCache的大小 如果用Oracle，则把poolPreparedStatements配置为true，mysql可以配置为false。 -->
                <property name="poolPreparedStatements" value="${druid.poolPreparedStatements}" />
                <property name="maxPoolPreparedStatementPerConnectionSize"
                          value="${druid.maxPoolPreparedStatementPerConnectionSize}" />

                <!-- 配置监控统计拦截的filters -->
                <property name="filters" value="${druid.filters}" />
         </bean>
       <!--创建sessionFactoryBean -->
        <bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sessionFactory">
                <property name="dataSource" ref="dataSource"/>
                <property name="mapperLocations" value="classpath:com/ecloud/mapper/*.xml"/>
                <!--<property name="configLocation" value="classpath:mybatis-config.xml"/>-->
        </bean>

        <!--检测，该包下的接口自动注入-->
        <mybatis:scan base-package="com.ecloud.dao"/>

        <!--事物-->
        <bean class="org.springframework.jdbc.datasource.DataSourceTransactionManager" id="dataSourceTransactionManager">
                <property name="dataSource" ref="dataSource" />
        </bean>
        <tx:annotation-driven transaction-manager="dataSourceTransactionManager" />

1.3编写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.ecloud.dao.UserDao" >
    <select id="getUsers" resultType="com.ecloud.entity.User" >
        SELECT * FROM users;
    </select>
</mapper>

import java.util.List;
public interface UserDao {
    @Select("SELECT * FROM users;")
    List<User> getUsers();
}