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