目录
1.1环境搭建
1.1.1准备jar包
#1 Spring框架所需要的包
- aopalliance-.jar(aop联盟包)
- aspectjweaver-1.8.7.jar(切入点表达式所用的包)
- spring-aop-4.3.6.RELEASE.jar(AOP 切面编程包)
- spring-aspects-4.3.6.RELEASE.jar(切面编程包)
- spring-beans-4.3.6.RELEASE.jar(bean包)
- spring-context-4.3.6.RELEASE.jar(上下文包)
- spring-core-4.3.6.RELEASE.jar(核心包)
- spring-expression-4.3.6.RELEASE.jar(表达式包)
- spring-jdbc-4.3.6.RELEASE.jar(数据库包)
- spring-test-4.3.6.RELEASE.jar(测试包)
- spring-tx-4.3.6.RELEASE.jar(事务管理包)
#2 Mybatis框架所需要的包
- ant-launcher-1.9.6.jar
- ant.jar
- asm-5.1.jar
- aspectjweaver-1.8.7.jar
- cglib-3.2.4.jar
- javassist-3.21.0-GA.jar
- log4j-1.2.17.jar
- log4j-api-2.3.jar
- log4j-core-2.3.jar
- mybatis-3.4.2.jar
- ognl-3.1.12.jar
- slf4j-api-1.7.22.jar
- slf4j-log4j12-1.7.22.jar
更多的jar包解释请看:https://blog.csdn.net/STUDENTstudent123/article/details/86761382
#3.Mybatis与Spring整合的中间jar
数据库驱动包
- mybatis-spring-1.3.1.jar
#4 数据库驱动JAR包
- mysql-connector-java-5.1.40-bin.jar
#5 数据源所需JAR包
- commoms-dbcp2.2.1.1.jar
- commoms-pool2-2.4.2.jar
1.1.2 编写配置文件
db.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatis
jdbc.username=root
jdbc.password=root
jdbc.maxTotal=30
jdbc.maxIDle=10
jdbc.initialSize=5
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:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop"
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://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd">
<!-- 读取db.properties -->
<context:property-placeholder
location="db.properties" />
<!-- 配置数据源 -->
<bean id="dataSource"
class="org.apache.commons.dbcp2.BasicDataSource">
<property name="driverClassName" value="${jdbc.driver}" />
<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="${maxIDle}" />
<property name="initialSize" value="${jdbc.initialSize}" />
</bean>
<!-- 事务管理,依赖数据源 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy">
<property name="dataSource" ref="dataSource" />
</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>
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.itheima.po" />
</typeAliases>
<!-- 配置mapper的位置 -->
<mappers>
<mapper class="123" />
</mappers>
</configuration>
声明:本博文作为本人我学习笔记,欢迎大家吐槽,共同进步!