MyBatis与Spring的整合之整体环境搭建

1.Spring和MyBatis框架所需的JAR包

2 MyBatis与Spring整合的中间的JAR  mybatis-spring-1.3.1

   http://mvnrepository.com/artifact/org.mybatis/mybatis-spring/1.3.1

3. 数据库驱动JAR包

   mysql-connector-java-5.1.39-bin.jar

4. 数据源所需JAR包

  http://mvnrepository.com/artifact/org.apache.commons/commons-dbcp2/2.1.1

  http://mvnrepository.com/artifact/org.apache.commons/commons-pool2/2.4.2

5 编写配置文件

5.1 在src目录下创建 db.properties文件

jdbc.driver    = com.mysql.jdbc.Driver
jdbc.url       = jdbc:mysql://localhost:3306/asmybatis
jdbc.username  = root
jdbc.password  = kangxg198811
jdbc.maxTotal  = 30   最大连接数
jdbc.maxIdle   = 10   最大空闲数
jdbc.initialSize = 5  初始化连接数

5.2 在src目录下创建 applicationContext.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:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-4.3.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop-4.3.xsd">
     
     <!--  读取db.properties -->
     <context:property-placeholder location ="classpath:db.properties" />
     
     <!--  配置数据源-->
     <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
         <!-- 数据库驱动 -->
         <property name = "driverClassName" value = "${jdbc.driver}" />
         <!-- 连接数据库URL-->
         <property name = "url" value = "${jdbc.url}" />
         <!-- 连接数据库的用户名-->
         <property name = "username" value = "${jdbc.username}" />
         <!-- 连接数据库的密码-->
         <property name = "password" value = "${jdbc.password}" />
         
         <property name = "maxTotal" value = "${jdbc.maxTotal}" />
         <property name = "maxIdle" value = "${jdbc.maxIdle}" />
         <property name = "initialSize" value = "${jdbc.initialSize}" />
     </bean>
     
     <!-- 事务管理器 依赖于数据源-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
     
       <property name="dataSource" ref ="dataSource"></property>
       
    </bean>
    
    <!-- 开启事务注解 -->
    <tx:annotation-driven transaction-manager ="transactionManager"/>
    <!-- 配置MyBatis工厂 -->
    <bean id ="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
      <!-- 注入数据源 -->
      <property name="dataSource" ref ="dataSource"/>
      <!-- 指定核心配置文件位置 -->
      <property name="configLocation" value ="classpath:mybatis-config.xml"/>
    </bean>
    
</beans>

5.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>
  
  <!-- 配置别名 -->
  <typeAliases>
    <package name="com.kangxg.po"/>
  </typeAliases>
  
  <!-- 配置Mapper的位置-->
  <mappers>
    <mapper resource="com/kangxg/mapper/CustomerMapper.xml"/>
    <mapper resource="com/kangxg/mapper/UserMapper.xml"/>
  </mappers>
</configuration>

5.3 创建log4j.properties 文件

# Global logging configuration
log4j.rootLogger=ERROR, stdout
# MyBatis logging configuration...
#log4j.logger.com.itheima = DEBUG
log4j.logger.com.kangxg = DEBUG
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

项目：SpringMyBatis