一个简单的Spring4和MyBatis事务的例子（很详细）

根据维基百科，数据库事务应该具有all-or-nothing原则，无论何时，数据库中的任何工作单元要么全部完成，要么没有任何影响。进一步来说，系统必须将每个事务与其他事务隔离开来，结果必须遵循现有的限制，并且成功完成的事务必须被写入到持久储存中。

在这个例子中我试图创建一个Spring Framework管理的简单的MyBatis数据库事务。

这是我的pom文件，我用的是4.1.2 版本的Spring。

001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083 084 085 086 087 088 089 090 091 092 093 094 095 096 097 098 099 100 101

< 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.edw.springmybatis</ groupId >    < artifactId >SpringMyBatisIntegration</ artifactId >    < packaging >war</ packaging >    < version >1.0</ version >      < name >SpringMyBatisIntegration</ name >    < url >http://maven.apache.org</ url >      < dependencies >          < dependency >              < groupId >javax</ groupId >              < artifactId >javaee-web-api</ artifactId >              < version >6.0</ version >              < scope >provided</ scope >          </ dependency >          <!-- Spring 4 dependencies -->          < dependency >              < groupId >org.springframework</ groupId >              < artifactId >spring-core</ artifactId >              < version >4.1.2.RELEASE</ version >          </ dependency >          < dependency >              < groupId >org.springframework</ groupId >              < artifactId >spring-web</ artifactId >              < version >4.1.2.RELEASE</ version >          </ dependency >          < dependency >              < groupId >org.springframework</ groupId >              < artifactId >spring-webmvc</ artifactId >              < version >4.1.2.RELEASE</ version >          </ dependency >          < dependency >              < groupId >org.springframework</ groupId >              < artifactId >spring-tx</ artifactId >              < version >4.1.2.RELEASE</ version >          </ dependency >          < dependency >              < groupId >org.springframework</ groupId >              < artifactId >spring-orm</ artifactId >              < version >4.1.2.RELEASE</ version >          </ dependency >          < dependency >              < groupId >cglib</ groupId >              < artifactId >cglib</ artifactId >              < version >2.2</ version >          </ dependency >                    < dependency >              < groupId >log4j</ groupId >              < artifactId >log4j</ artifactId >              < version >1.2.17</ version >          </ dependency >          < dependency >              < groupId >mysql</ groupId >              < artifactId >mysql-connector-java</ artifactId >              < version >5.1.6</ version >          </ dependency >          < dependency >              < groupId >org.mybatis</ groupId >              < artifactId >mybatis</ artifactId >              < version >3.2.2</ version >          </ dependency >          < dependency >              < groupId >org.mybatis</ groupId >              < artifactId >mybatis-spring</ artifactId >              < version >1.1.0</ version >          </ dependency >                    < dependency >              < groupId >commons-dbcp</ groupId >              < artifactId >commons-dbcp</ artifactId >              < version >1.2.2</ version >          </ dependency >                    <!-- json request -->                 < dependency >              < groupId >org.codehaus.jackson</ groupId >              < artifactId >jackson-mapper-asl</ artifactId >              < version >1.9.11</ version >          </ dependency >                </ dependencies >      < build >      < plugins >        < plugin >          < groupId >org.apache.maven.plugins</ groupId >          < artifactId >maven-compiler-plugin</ artifactId >          < version >2.0.2</ version >          < configuration >            < source >1.5</ source >            < target >1.5</ target >          </ configuration >        </ plugin >      </ plugins >    </ build > </ project >

这是我的数据库结构

1 2 3 4 5 6 7

CREATE TABLE `testing` (    `Id`  int (11)  NOT NULL AUTO_INCREMENT,    ` name `  varchar (30)  NOT NULL DEFAULT '' ,    `address`  varchar (255)  NOT NULL DEFAULT '' ,    PRIMARY KEY (`Id`),    UNIQUE KEY `ix` (` name `) )

我将我的“testing”表映射到一个xml和java文件。

01 02 03 04 05 06 07 08 09 10

<? 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.edw.springmybatis.mapper.TestingMapper" >          < select id = "insert" parameterType = "com.edw.springmybatis.bean.Testing" >          insert into testing (name, address)          values ( #{name,jdbcType=VARCHAR}, #{address,jdbcType=VARCHAR} )      </ select >     </ mapper >

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

package com.edw.springmybatis.bean;   import java.io.Serializable;   public class Testing  implements Serializable  {        private Integer id;      private String name;      private String address;        public Integer getId() {          return id;      }        public void setId(Integer id) {          this .id = id;      }            // other setter and getter        public Testing() {      }        public Testing(String name, String address) {          this .name = name;          this .address = address;      } }

这是我的mybatis配置文件：configuration.xml

01 02 03 04 05 06 07 08 09 10

<? 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 >    < mappers >      < mapper resource = "TestingMapper.xml" />           </ mappers > </ configuration >

我的spring xml 文件： applicationContext.xml 和 dispatcher-servlet.xml

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

<? 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:p = "http://www.springframework.org/schema/p"         xmlns:context = "http://www.springframework.org/schema/context"         xmlns:tx = "http://www.springframework.org/schema/tx"         xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd          http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd          http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd          http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd          http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">        < context:annotation-config />            < tx:annotation-driven transaction-manager = "transactionManager" />            < context:component-scan base-package = "com.edw.springmybatis.service" />            <!-- middleware datasource  -->      < bean id = "dataSource" class = "org.apache.commons.dbcp.BasicDataSource" destroy-method = "close"            p:driverClassName = "com.mysql.jdbc.Driver" p:url = "jdbc:mysql://localhost/test"            p:username = "root" p:password = ""            p:initialSize = "2"            p:maxActive = "30"            p:maxIdle = "10"            p:minIdle = "3"            p:maxWait = "30000"            p:removeAbandoned = "true"            p:removeAbandonedTimeout = "30"            p:validationQuery = "SELECT 1" />        < bean id = "sqlSessionFactory" class = "org.mybatis.spring.SqlSessionFactoryBean" >          < property name = "dataSource" ref = "dataSource" />          < property name = "configLocation" value = "/WEB-INF/configuration.xml" />      </ bean >            < bean class = "org.mybatis.spring.mapper.MapperScannerConfigurer" >          < property name = "basePackage" value = "com.edw.springmybatis.mapper" />      </ bean >            < bean id = "transactionManager"            class = "org.springframework.jdbc.datasource.DataSourceTransactionManager" >          < property name = "dataSource" ref = "dataSource" />      </ bean >    </ beans >

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16

<? 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:p = "http://www.springframework.org/schema/p"         xmlns:context = "http://www.springframework.org/schema/context"         xmlns:mvc = "http://www.springframework.org/schema/mvc"         xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd          http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd          http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd">          < context:component-scan base-package = "com.edw.springmybatis.controller" />            < mvc:annotation-driven />      < mvc:default-servlet-handler /> </ beans >

最后，我的 web.xml 文件 

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

<? xml version = "1.0" encoding = "UTF-8" ?> < web-app version = "3.0" xmlns = "http://java.sun.com/xml/ns/javaee" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation = "http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" >      < context-param >          < param-name >contextConfigLocation</ param-name >          < param-value >/WEB-INF/applicationContext.xml</ param-value >      </ context-param >      < listener >          < listener-class >org.springframework.web.context.ContextLoaderListener</ listener-class >      </ listener >      < servlet >          < servlet-name >dispatcher</ servlet-name >          < servlet-class >org.springframework.web.servlet.DispatcherServlet</ servlet-class >          < load-on-startup >2</ load-on-startup >      </ servlet >      < servlet-mapping >          < servlet-name >dispatcher</ servlet-name >          < url-pattern >/</ url-pattern >      </ servlet-mapping >      < session-config >          < session-timeout >              30          </ session-timeout >      </ session-config > </ web-app >

我的 log4j 文件

01 02 03 04 05 06 07 08 09 10

# Global logging configuration log4j.rootLogger=WARN,stdout log4j.logger.com.edw=DEBUG   log4j.rootLogger=WARN,stdout   # Console output... log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=%d [%c{1}] %-5p %c:%L - %m%n

OK,现在开始列出我的java类：

第一个是MyBatis mapper文件

1 2 3 4 5 6 7

package com.edw.springmybatis.mapper;   import com.edw.springmybatis.bean.Testing;   public interface TestingMapper {      public void insert(Testing testing);    }

接下来是Service文件

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22

package com.edw.springmybatis.service;   import com.edw.springmybatis.bean.Testing; import com.edw.springmybatis.mapper.TestingMapper; import java.util.Random; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Propagation; import org.springframework.transaction.annotation.Transactional;   @Service @Transactional (propagation = Propagation.REQUIRED, rollbackFor = Exception. class ) public class TestingService {        @Autowired      private TestingMapper testingMapper;        public void insert()  throws Exception {          testingMapper.insert( new Testing( "" +  new Random().nextInt(),  "" +  new Random().nextInt()));          testingMapper.insert( new Testing());  // this will throw an exception      } }

最后，我的Controller文件

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

package com.edw.springmybatis.controller;   import com.edw.springmybatis.service.TestingService; import org.apache.log4j.Logger; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.ResponseBody;   @Controller public class IndexController {        @Autowired      private TestingService testingService;            private final Logger logger = Logger.getLogger( this .getClass());            @RequestMapping (value =  "/" , method = RequestMethod.GET)      public @ResponseBody Integer index() {          try {              testingService.insert();              return 1 ;          }  catch (Exception e) {              logger.error(e);          }          return 0 ;      }    }

运行效果：

我的netbeans控制台输出：

正如你看到的，我的上一次插入操作回滚了，所以我的testing表中没有新的记录。

这是我的netbeans工程结构