第3天 Spring、SpringMVC、MyBatis集成
学习目标
SSM集成
-
集成流程理解
-
集成SpringMVC
-
集成Spring
-
集成MyBatis
-
事务测试
第1章 搭建环境
1.1 整合流程
整合说明:SSM整合可以使用多种方式,咱们会选择XML + 注解的方式
三层架构中,控制层调用Service层,Service层调用Dao层,控制层会将Bean对象注入到SpringMVCIOC容器中,Service和Dao层会将Bean对象注入到SpringIOC容器中,而SpringMVCIOC容器的父容器正好是SpringIOC容器,子容器可以使用父容器的Bean对象,所以可以实现三大框架集成。
整合的思路
-
先搭建整合的环境
-
再搭建SpringMVC,只搭建控制层
-
再搭建Service层,集成Spring
-
最后使用Spring整合MyBatis框架
1.2 工程搭建
(1)创建表结构
create table account( id int primary key auto_increment, name varchar(20), money double );
(2)工程中搭建
创建一个工程名字叫ssm,并引入pom.xml依赖
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.qf</groupId> <artifactId>ssm</artifactId> <version>1.0-SNAPSHOT</version> <packaging>war</packaging> <properties> <spring.version>5.0.2.RELEASE</spring.version> <slf4j.version>1.6.6</slf4j.version> <log4j.version>1.2.12</log4j.version> <mysql.version>5.1.6</mysql.version> <mybatis.version>3.4.5</mybatis.version> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding> </properties> <!--依赖jar包--> <dependencies> <!-- spring --> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjweaver</artifactId> <version>1.6.8</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aop</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-web</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-test</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>compile</scope> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>${mysql.version}</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> <version>2.5</version> <scope>provided</scope> </dependency> <dependency> <groupId>javax.servlet.jsp</groupId> <artifactId>jsp-api</artifactId> <version>2.0</version> <scope>provided</scope> </dependency> <dependency> <groupId>jstl</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <!-- log start --> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>${log4j.version}</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>${slf4j.version}</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-log4j12</artifactId> <version>${slf4j.version}</version> </dependency> <!-- log end --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>${mybatis.version}</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.3.0</version> </dependency> <dependency> <groupId>c3p0</groupId> <artifactId>c3p0</artifactId> <version>0.9.1.2</version> <type>jar</type> <scope>compile</scope> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.apache.tomcat.maven</groupId> <artifactId>tomcat7-maven-plugin</artifactId> <version>2.2</version> <configuration> <port>18081</port> <path>/</path> </configuration> </plugin> </plugins> </build> </project>
(3)创建JavaBean
创建com.itheima.model.Account对象,代码如下:
public class Account { private Integer id; private String name; private Double money; //..set..get..toString 略 }
第2章 集成SpringMVC
2.1 集成步骤回顾
我们首先集成SpringMVC,集成SpringMVC的步骤我们回顾一下
1.web.xml中配置SpringMVC核心控制器 2.web.xml中配置SpringMVC的POST编码过滤器 3.创建SpringMVC的核心配置文件springmvc.xml 4.在SpringMVC的核心配置文件中配置注解驱动、包扫描、视图解析器、静态资源过滤等
2.2 准备工作
先创建一下控制层和对应的页面。
2.2.1 创建控制层
创建com.itheima.controller.AccountController,代码如下:
@Controller @RequestMapping(value = "/account") public class AccountController { /** * list集合查询 * @return */ @RequestMapping(value = "/list") public String list(){ System.out.println("AccountController.list"); return "list"; } /*** * 增加 * @return */ @RequestMapping(value = "/add") public String add(){ System.out.println("AccountController.add"); return "redirect:/account/list"; } }
2.2.2 创建页面
创建/WEB-INF/pages/list.jsp,代码如下:
<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>Title</title> </head> <body> list </body> </html>
创建index.jsp,代码如下:
<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>Title</title> </head> <body> <a href="/account/list">SSM集成</a> </body> </html>
2.3 集成SpringMVC
2.3.1 web.xml配置
web.xml中配置前端核心控制器和POST编码过滤器,代码如下:
<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" version="3.1"> <!-- 配置解决中文乱码的过滤器 --> <filter> <filter-name>characterEncodingFilter</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>UTF-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>characterEncodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- 配置前端控制器:服务器启动必须加载,需要加载springmvc.xml配置文件 --> <servlet> <servlet-name>dispatcherServlet</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <!-- 配置初始化参数,创建完DispatcherServlet对象,加载springmvc.xml配置文件 --> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:springmvc.xml</param-value> </init-param> <!-- 服务器启动的时候,让DispatcherServlet对象创建 --> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>dispatcherServlet</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> </web-app>
2.3.2 SpringMVC核心配置文件
在resources下创建springmvc.xml核心配置文件,代码如下:
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> <!-- 扫描controller的注解,别的不扫描 --> <context:component-scan base-package="com.itheima" /> <!-- 配置视图解析器 --> <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <!-- JSP文件所在的目录 --> <property name="prefix" value="/WEB-INF/pages/" /> <!-- 文件的后缀名 --> <property name="suffix" value=".jsp" /> </bean> <!-- 设置静态资源不过滤,如果目录不存在,会报红,这里不是程序问题,是idea检测到目录不存在--> <mvc:resources location="/css/" mapping="/css/**" /> <mvc:resources location="/images/" mapping="/images/**" /> <mvc:resources location="/js/" mapping="/js/**" /> <!-- 开启对SpringMVC注解的支持 --> <mvc:annotation-driven /> </beans>
2.4 测试
使用tomcat运行起来,端口号为18081,分别测试如下地址:
http://localhost:18081/account/list
http://localhost:18081/account/add
后台输出
AccountController.list AccountController.add AccountController.list
第3章 集成Spring
3.1 准备工作
(1)创建Service接口
创建com.itheima.service.AccountService接口,代码如下:
public interface AccountService { /*** * 集合 */ List<Account> list(); /*** * 增加 */ int add(Account account); }
(2)创建Service实现类
创建com.itheima.service.impl.AccountServiceImpl实现类,代码如下:
@Service public class AccountServiceImpl implements AccountService { /** * 集合 * @return */ @Override public List<Account> list() { System.out.println("AccountServiceImpl.list"); return null; } /** * 增加 * @param account * @return */ @Override public int add(Account account) { System.out.println("AccountServiceImpl.add"); return 0; } }
3.2 集成Spring
3.2.1 创建spring核心配置文件
创建spring.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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" 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/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <!-- 开启注解扫描--> <context:component-scan base-package="com.itheima" /> </beans>
==3.2.2 包扫描冲突解决==
问题说明:此时spring核心配置会扫描com.itheima的包及所有子包,会将所有对象的Bean交给SpringIOC容器管理,而前面springmvc也会扫描com.itheima的包及所有子包,会将所有对象的Bean交给SpringMVCIOC容器管理,此时会导致2个容器中的Bean冲突,会导致后续事务失效以及部分注解失效,所以我们需要将冲突问题解决下。
我们可以让springmvc只扫描@Controller注解,spring除了@Controller注解不扫描,其他注解都扫描。
(1)需改springmvc.xml包扫描
<!-- 扫描controller的注解,别的不扫描 --> <context:component-scan base-package="com.itheima" use-default-filters="false"> <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/> </context:component-scan>
(2)修改spring.xml包扫描
<!--开启注解扫描,要扫描的是service和dao层的注解,要忽略web层注解,因为web层让SpringMVC框架去管理--> <context:component-scan base-package="com.itheima"> <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/> </context:component-scan>
3.3 集成Spring、SpringMVC
集成Spring和SpringMVC,只需要创建SpringIOC容器即可,SpringMVCIOC容器会自动将SpringIOC容器设置为自己的父容器。
创建SpringIOC容器可以使用监听器来实现,所以我们需要在web.xml中配置监听器。
修改web.xml添加如下监听器,并指定spring的核心配置文件
<!-- 配置Spring的监听器 --> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <!-- 配置加载类路径的配置文件 --> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:spring.xml</param-value> </context-param>
3.4 集成测试
修改AccountController,在AccountController中调用Service,代码如下:
访问http://localhost:18081/account/list测试,后台输出如下:
AccountServiceImpl.list
第4章 集成MyBatis
4.1 环境准备
创建com.itheima.dao.AccountDao接口,代码如下:
public interface AccountDao { /*** * 保存账号 * @param account */ @Insert("insert into account(name,money)values(#{name},#{money})") int add(Account account); /*** * 查询所有 * @return */ @Select("select * from account") List<Account> list(); }
4.2 MyBatis使用回顾(SSM集成中不用)
在以前学习MyBatis的时候,会先创建一个MyBatis的SqlMapConfig.xml核心配置文件,然后在配置文件中配置数据库连接信息,映射文件配置等,再创建一个测试类,创建SqlSession,通过SqlSession创建Dao的代理对象,通过代理对象实现增删改查。
(1)创建SqlMapConfig.xml
在resources下创建SqlMapConfig.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> <environments default="mysql"> <environment id="mysql"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://127.0.0.1:3306/spring5"/> <property name="username" value="root"/> <property name="password" value="itcast"/> </dataSource> </environment> </environments> <!-- 使用的是注解 --> <mappers> <!-- <mapper class="cn.itcast.dao.AccountDao"/> --> <!-- 该包下所有的dao接口都可以使用 --> <package name="com.itheima.dao"/> </mappers> </configuration>
(2)测试类
创建MyBatisTest测试类,代码如下:
public class MyBatisTest { @Test public void testMyBatis() throws IOException { //获取SqlMapConfig.xml字节输入流 InputStream is = Resources.getResourceAsStream("SqlMapConfig.xml"); //获取SqlSessionFactoryBuilder对象 SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder(); //创建SqlSessionFactory SqlSessionFactory sqlSessionFactory = builder.build(is); //创建sqlSession SqlSession sqlSession = sqlSessionFactory.openSession(true); AccountDao accountDao = sqlSession.getMapper(AccountDao.class); //查询所有 List<Account> accounts = accountDao.list(); for (Account account : accounts) { System.out.println(account); } //关闭资源 sqlSession.close(); } }
测试完成后,可以将测试类MyBatisTest和SqlMapConfig.xml文件删掉了,这里只是回顾以前MyBatis的操作过程。
4.3 集成MyBatis
修改spring.xml在spring.xml中添加如下配置:
<!-- 配置的连接池对象 --> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://127.0.0.1:3306/spring5"/> <property name="username" value="root"/> <property name="password" value="itcast"/> </bean> <!-- 配置SqlSession的工厂 --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> </bean> <!-- 配置扫描dao的包 --> <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.itheima.dao"/> </bean>
SqlSessionFactoryBean
主要取代了之前SqlSessionFactory的相关操作。
MapperScannerConfigurer
主要是取代之前的SqlMapConfig.xml中mappers
配置,指定dao接口的包路径。
集成后,Spring会给每个Dao创建一个代理对象,相当于之前测试案例中的getMapper(Dao.class)创建代理对象一样,并将代理对象注入到SpringIOC容器中。
4.4 Spring集成MyBatis测试
创建SpringMyBatisTest测试类,测试SpringIOC容器中是否有AccountDao的代理对象在容器中,如果有,则表明集成成功!
public class SpringMyBatisTest { /*** * 测试Spring和MyBatis集成 * 如果给每个Dao生成了代理对象,则表示集成成功 */ @Test public void testSpringMyBatis(){ ApplicationContext act = new ClassPathXmlApplicationContext("spring.xml"); //获取容器中所有Bean的名字 String[] names = act.getBeanDefinitionNames(); for (String name : names) { System.out.println(name); } } }
测试结果如下:
accountServiceImpl org.springframework.context.annotation.internalConfigurationAnnotationProcessor org.springframework.context.annotation.internalAutowiredAnnotationProcessor org.springframework.context.annotation.internalRequiredAnnotationProcessor org.springframework.context.annotation.internalCommonAnnotationProcessor org.springframework.context.event.internalEventListenerProcessor org.springframework.context.event.internalEventListenerFactory dataSource sqlSessionFactory mapperScanner accountDao
用DEBUG模式的时候,能明显看到accountDao是个代理对象
4.5 三层对接测试
实现Controller调用Service,Service调用Dao,所以我们需要在Service中注入Dao,并调用Dao。
(1)修改AccountServiceImpl
(2)修改AccountController
(3)修改list.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>Title</title> </head> <body> <c:forEach items="${accounts}" var="account"> <div>${account}</div> </c:forEach> </body> </html>
测试效果如下:
http://localhost:18081/account/list
第5章 声明式事务配置
5.1 声明式事务配置
修改spring.xml,添加如下声明式事务配置
<!-- 配置事务管理器 --> <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource"/> </bean> <!-- 配置事务通知 --> <tx:advice id="txAdvice" transaction-manager="txManager"> <tx:attributes> <tx:method name="list*" read-only="true"/> <tx:method name="*" isolation="DEFAULT"/> </tx:attributes> </tx:advice> <!-- 配置AOP增强事务 --> <aop:config> <aop:advisor advice-ref="txAdvice" pointcut="execution(public * com.itheima.service.impl.*.*(..))"/> </aop:config>
5.2 事务测试
修改com.itheima.service.impl.AccountServiceImpl的add方法,添加异常代码,代码如下:
/** * 增加 * @param account * @return */ @Override public int add(Account account) { int count = accountDao.add(account); System.out.println("受影响行数:"+count); int q=10/0; return count; }
访问http://localhost:18081/account/add测试,效果如下: 页面报错
后台输出:
受影响行数:1
数据库数据并未增加
附录:
项目最终结构
项目完整配置文件
web.xml
<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" version="3.1"> <!-- 配置解决中文乱码的过滤器 --> <filter> <filter-name>characterEncodingFilter</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>UTF-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>characterEncodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- 配置前端控制器:服务器启动必须加载,需要加载springmvc.xml配置文件 --> <servlet> <servlet-name>dispatcherServlet</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <!-- 配置初始化参数,创建完DispatcherServlet对象,加载springmvc.xml配置文件 --> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:springmvc.xml</param-value> </init-param> <!-- 服务器启动的时候,让DispatcherServlet对象创建 --> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>dispatcherServlet</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> <!-- 配置Spring的监听器 --> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <!-- 配置加载类路径的配置文件 --> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:spring.xml</param-value> </context-param> </web-app>
springmvc.xml
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> <!-- 扫描controller的注解,别的不扫描 --> <context:component-scan base-package="com.itheima" use-default-filters="false"> <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/> </context:component-scan> <!-- 配置视图解析器 --> <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <!-- JSP文件所在的目录 --> <property name="prefix" value="/WEB-INF/pages/" /> <!-- 文件的后缀名 --> <property name="suffix" value=".jsp" /> </bean> <!-- 设置静态资源不过滤,如果目录不存在,会报红,这里不是程序问题,是idea检测到目录不存在--> <mvc:resources location="/css/" mapping="/css/**" /> <mvc:resources location="/images/" mapping="/images/**" /> <mvc:resources location="/js/" mapping="/js/**" /> <!-- 开启对SpringMVC注解的支持 --> <mvc:annotation-driven /> </beans>
spring.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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" 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/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <!-- 开启注解扫描,要扫描的是service和dao层的注解,要忽略web层注解,因为web层让SpringMVC框架去管理 --> <context:component-scan base-package="com.itheima"> <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/> </context:component-scan> <!-- 配置的连接池对象 --> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://127.0.0.1:3306/spring5"/> <property name="username" value="root"/> <property name="password" value="itcast"/> </bean> <!-- 配置SqlSession的工厂 --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> </bean> <!-- 配置扫描dao的包 --> <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.itheima.dao"/> </bean> <!-- 配置事务管理器 --> <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource"/> </bean> <!-- 配置事务通知 --> <tx:advice id="txAdvice" transaction-manager="txManager"> <tx:attributes> <tx:method name="list*" read-only="true"/> <tx:method name="*" isolation="DEFAULT"/> </tx:attributes> </tx:advice> <!-- 配置AOP增强事务 --> <aop:config> <aop:advisor advice-ref="txAdvice" pointcut="execution(public * com.itheima.service.impl.*.*(..))"/> </aop:config> </beans>
pom.xml
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.itheima</groupId> <artifactId>ssm</artifactId> <version>1.0-SNAPSHOT</version> <packaging>war</packaging> <properties> <spring.version>5.0.2.RELEASE</spring.version> <slf4j.version>1.6.6</slf4j.version> <log4j.version>1.2.12</log4j.version> <mysql.version>5.1.6</mysql.version> <mybatis.version>3.4.5</mybatis.version> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding> </properties> <!--依赖jar包--> <dependencies> <!-- spring --> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjweaver</artifactId> <version>1.6.8</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aop</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-web</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-test</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>compile</scope> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>${mysql.version}</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> <version>2.5</version> <scope>provided</scope> </dependency> <dependency> <groupId>javax.servlet.jsp</groupId> <artifactId>jsp-api</artifactId> <version>2.0</version> <scope>provided</scope> </dependency> <dependency> <groupId>jstl</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <!-- log start --> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>${log4j.version}</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>${slf4j.version}</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-log4j12</artifactId> <version>${slf4j.version}</version> </dependency> <!-- log end --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>${mybatis.version}</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.3.0</version> </dependency> <dependency> <groupId>c3p0</groupId> <artifactId>c3p0</artifactId> <version>0.9.1.2</version> <type>jar</type> <scope>compile</scope> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.apache.tomcat.maven</groupId> <artifactId>tomcat7-maven-plugin</artifactId> <version>2.2</version> <configuration> <port>18081</port> <path>/</path> </configuration> </plugin> </plugins> </build> </project>