mybatis 3.2.7 与 spring mvc 3.x、logback整合

github上有一个Mybatis-Spring的项目，专门用于辅助完成mybatis与spring的整合，大大简化了整合难度，使用步骤：

准备工作：

maven依赖项：

mybatis 3.2.7 与 spring mvc 3.x、logback整合

  1 <properties>
  2         <java-version>1.6</java-version>
  3         <spring.version>3.2.8.RELEASE</spring.version>                
  4     </properties>
  5     <dependencies>
  6 
  7         <!-- Spring -->
  8         <dependency>
  9             <groupId>org.springframework</groupId>
 10             <artifactId>spring-core</artifactId>
 11             <version>${spring.version}</version>
 12         </dependency>
 13 
 14         <dependency>
 15             <groupId>org.springframework</groupId>
 16             <artifactId>spring-expression</artifactId>
 17             <version>${spring.version}</version>
 18         </dependency>
 19 
 20         <dependency>
 21             <groupId>org.springframework</groupId>
 22             <artifactId>spring-beans</artifactId>
 23             <version>${spring.version}</version>
 24         </dependency>
 25 
 26         <dependency>
 27             <groupId>org.springframework</groupId>
 28             <artifactId>spring-context</artifactId>
 29             <version>${spring.version}</version>
 30         </dependency>
 31         <dependency>
 32             <groupId>org.springframework</groupId>
 33             <artifactId>spring-context-support</artifactId>
 34             <version>${spring.version}</version>
 35         </dependency>
 36         <dependency>
 37             <groupId>org.springframework</groupId>
 38             <artifactId>spring-web</artifactId>
 39             <version>${spring.version}</version>
 40         </dependency>
 41 
 42         <dependency>
 43             <groupId>org.springframework</groupId>
 44             <artifactId>spring-webmvc</artifactId>
 45             <version>${spring.version}</version>
 46         </dependency>
 47 
 48         <dependency>
 49             <groupId>org.springframework</groupId>
 50             <artifactId>spring-oxm</artifactId>
 51             <version>${spring.version}</version>
 52         </dependency>
 53 
 54         <dependency>
 55             <groupId>org.springframework</groupId>
 56             <artifactId>spring-jdbc</artifactId>
 57             <version>${spring.version}</version>
 58         </dependency>
 59 
 60         <dependency>
 61             <groupId>org.springframework</groupId>
 62             <artifactId>spring-tx</artifactId>
 63             <version>${spring.version}</version>
 64         </dependency>
 65 
 66         <dependency>
 67             <groupId>org.springframework</groupId>
 68             <artifactId>spring-aop</artifactId>
 69             <version>${spring.version}</version>
 70         </dependency>
 71 
 72 
 73         <dependency>
 74             <groupId>org.aspectj</groupId>
 75             <artifactId>aspectjweaver</artifactId>
 76             <version>1.7.3</version>
 77         </dependency>
 78 
 79         <dependency>
 80             <groupId>aopalliance</groupId>
 81             <artifactId>aopalliance</artifactId>
 82             <version>1.0</version>
 83         </dependency>
 84 
 85         <!-- json -->
 86         <dependency>
 87             <groupId>org.codehaus.jackson</groupId>
 88             <artifactId>jackson-mapper-asl</artifactId>
 89             <version>1.9.3</version>
 90         </dependency>
 91 
 92         <dependency>
 93             <groupId>org.codehaus.jackson</groupId>
 94             <artifactId>jackson-jaxrs</artifactId>
 95             <version>1.9.9-redhat-2</version>
 96         </dependency>
 97 
 98         <!-- logback -->
 99         <dependency>
100             <groupId>org.slf4j</groupId>
101             <artifactId>slf4j-api</artifactId>
102             <version>1.7.7</version>
103         </dependency>
104 
105         <dependency>
106             <groupId>ch.qos.logback</groupId>
107             <artifactId>logback-core</artifactId>
108             <version>1.1.2</version>
109         </dependency>
110 
111         <dependency>
112             <groupId>ch.qos.logback</groupId>
113             <artifactId>logback-classic</artifactId>
114             <version>1.1.2</version>
115         </dependency>
116 
117         <dependency>
118             <groupId>commons-logging</groupId>
119             <artifactId>commons-logging</artifactId>
120             <version>1.1.3</version>
121         </dependency>
122 
123         <!-- Servlet -->
124         <dependency>
125             <groupId>javax.servlet</groupId>
126             <artifactId>servlet-api</artifactId>
127             <version>2.5</version>
128             <scope>provided</scope>
129         </dependency>
130 
131         <!-- oracle -->
132         <dependency>
133             <groupId>com.oracle</groupId>
134             <artifactId>ojdbc6</artifactId>
135             <version>11.2.0.3</version>
136         </dependency>
137 
138         <!-- mybatis -->
139         <dependency>
140             <groupId>org.mybatis</groupId>
141             <artifactId>mybatis-spring</artifactId>
142             <version>1.2.2</version>
143         </dependency>
144 
145         <dependency>
146             <groupId>org.mybatis</groupId>
147             <artifactId>mybatis</artifactId>
148             <version>3.2.7</version>
149         </dependency>
150 
151 
152     </dependencies>

View Code

一、先创建entity类

 1 package com.cnblogs.yjmyzz.entity;
 2 
 3 import java.io.Serializable;
 4 
 5 public class BasCarrierEntity implements Serializable {
 6 
 7     private static final long serialVersionUID = -971818065984481747L;
 8 
 9     private int recId;
10     private int cyear;
11     private String carrier;
12 
13     public int getRecId() {
14         return recId;
15     }
16 
17     public void setRecId(int recId) {
18         this.recId = recId;
19     }
20 
21     public int getCyear() {
22         return cyear;
23     }
24 
25     public void setCyear(int cyear) {
26         this.cyear = cyear;
27     }
28 
29     public String getCarrier() {
30         return carrier;
31     }
32 
33     public void setCarrier(String carrier) {
34         this.carrier = carrier;
35     }
36 
37     public String toString() {
38         return "recid:" + recId + ",cyear:" + cyear + ",carrier:" + carrier;
39     }
40 
41 }

View Code

这是一个POJO类，没有任何花头.

二、创建Mapper接口

 1 package com.cnblogs.yjmyzz.mybatis.mapper;
 2 
 3 import com.cnblogs.yjmyzz.entity.BasCarrierEntity;
 4 
 5 public interface CarrierMapper {
 6     
 7     BasCarrierEntity getCarrierById(int recId);
 8 
 9     void insertCarrier(BasCarrierEntity entity);
10 
11     void deleteCarrier(BasCarrierEntity entity);
12 
13 }

View Code

相当于传统ORM数据库应用里的DAO层接口

三、定义sql映射文件 BasCarrier.xml

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
 3 "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 4 
 5 <mapper namespace="com.cnblogs.yjmyzz.mybatis.mapper.CarrierMapper">
 6 
 7     <cache />
 8 
 9     <select id="getCarrierById" resultType="BasCarrierEntity"
10         parameterType="int">
11         select t.recid recId,t.cyear cyear,t.carrier carrier
12         from T_BAS_CARRIER t where
13         t.recid = #{recId}
14     </select>
15 
16     <insert id="insertCarrier" parameterType="BasCarrierEntity">
17         <selectKey keyProperty="recId" order="BEFORE" resultType="int">
18             select seq_t_bas_carrier.nextval as recId from dual
19         </selectKey>
20         insert into
21         t_bas_carrier(recid,cyear,carrier)
22         values(#{recId,jdbcType=NUMERIC},#{cyear,jdbcType=NUMERIC},#{carrier,jdbcType=VARCHAR})
23     </insert>
24 
25     <delete id="deleteCarrier" parameterType="BasCarrierEntity">
26         delete from
27         t_bas_carrier where 1=1
28         <if test="carrier != null">
29             and carrier like #{carrier}
30         </if>
31     </delete>
32 
33 </mapper>

View Code

以上这三板斧是必不可少的，注：xml中sql语句的id要与mapper接口中的方法名完全相同，这样不用其它任何额外配置，运行时，mybatis就能自动将接口中的方法与sql关联起来。

四、Spring-Database.xml 配置文件

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <beans xmlns="http://www.springframework.org/schema/beans"
 3     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
 4     xmlns:tx="http://www.springframework.org/schema/tx" xmlns:jdbc="http://www.springframework.org/schema/jdbc"
 5     xmlns:context="http://www.springframework.org/schema/context"
 6     xsi:schemaLocation="
 7      http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
 8      http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
 9      http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd
10      http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
11      http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd"
12     default-autowire="byName">
13 
14     <bean id="dataSource"
15         class="org.springframework.jdbc.datasource.DriverManagerDataSource">
16         <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
17         <property name="url" value="${db-url}" />
18         <property name="username" value="${db-username}" />
19         <property name="password" value="${db-password}" />
20     </bean>
21 
22     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
23         <!-- mybatis主配置文件，不能与后面的mapperLocations/typeAliasesPackage同时使用 -->
24         <!-- <property name="configLocation" value="classpath:mybatis-config.xml"></property> -->
25         <property name="dataSource" ref="dataSource" />
26         <!-- mapper中的类型别名 -->
27         <property name="typeAliasesPackage" value="com.cnblogs.yjmyzz.entity"></property>
28         <!-- mybatis 映射sql xml路径 -->
29         <property name="mapperLocations" value="classpath:mybatis/**/*.xml"></property>
30     </bean>
31 
32     <!-- 扫描指定包下的Mapper，自动创建mapper bean实例 -->
33     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
34         <property name="basePackage" value="com.cnblogs.yjmyzz.mybatis.mapper" />
35     </bean>
36 
37     <!-- 事务管理 -->
38     <bean id="transactionManager"
39         class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
40         <property name="dataSource" ref="dataSource" />
41     </bean>
42 
43     <tx:advice id="txAdvice" transaction-manager="transactionManager">
44         <tx:attributes>
45             <!-- 仅do开头的Service层方法，发生Exception异常时，才会事务回滚 -->
46             <tx:method name="do*" read-only="false" rollback-for="java.lang.Exception" />
47             <!-- 其它方法，只读事务，不回滚 -->
48             <tx:method name="*" propagation="SUPPORTS" read-only="true" />
49         </tx:attributes>
50     </tx:advice>
51 
52     <aop:config>
53         <!-- 仅拦截service层方法 -->
54         <aop:pointcut id="pc"
55             expression="execution(* com.cnblogs.yjmyzz.service..*.*(..))" />
56         <aop:advisor pointcut-ref="pc" advice-ref="txAdvice" />
57     </aop:config>
58 
59     <!-- <tx:annotation-driven /> -->
60 </beans>

View Code

真正属于mybatis专用的配置是22-35行，其它都是些db开发的常规配置。

事务这里有一个要特别注意的问题：因为Spring/SpringMVC的父子容器问题，默认情况下@Service的xxxService并不具备增加事务处理能力，需要做点特殊配置

a) spring-mvc servlet的配置文件里，参考下面配置：

1     <context:component-scan base-package="com.cnblogs.yjmyzz">
2         <context:exclude-filter type="annotation"
3             expression="org.springframework.stereotype.Service" />
4     </context:component-scan>

即：将@Service所对应的Service类排除掉，因为Spring-MVC compent-scan注入的只是普通的bean，不具备增加事务处理能力，所以要排除掉.

b) spring 主配置文件里，参考下面配置：

    <context:component-scan base-package="com.cnblogs.yjmyzz">        
    </context:component-scan>

这样处理后，compent-scan扫描到的Service类，就交由Spring，而非Spring-MVC来注入了。

另外还有一个事务自动提交的问题，虽然在配置中已经明确指定了仅Service层do开头的方法，才支持可写事务，其它方法都是只读事务，但如果你运行一下会发现，其它非do开头的方法如果执行一条insert语句，仍然会提交成功。

造成这个的原因在于datasource，这里我们采用的是org.springframework.jdbc.datasource.DriverManagerDataSource数据源，这种数据源不支持defaultAutoCommit属性，如果不想使用自动提交，可以把datasource节点换成

 1     <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
 2         destroy-method="close">
 3         <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
 4         <property name="url" value="${db-url}" />
 5         <property name="username" value="${db-username}" />
 6         <property name="password" value="${db-password}" />
 7         <property name="defaultAutoCommit" value="false" />
 8         <property name="initialSize" value="2" />
 9         <property name="maxActive" value="5" />
10         <property name="maxWait" value="60000" />
11     </bean>

注意第7行，defaultAutoCommit设置成false即可

如果使用Oracle，事务这里还有一个小坑，read-only不管设置成true/false，效果都是一样的，原因见：http://docs.oracle.com/cd/B19306_01/java.102/b14355/apxtips.htm

Transaction Isolation Levels and Access Modes

Read-only connections are supported by the Oracle server, but not by the Oracle JDBC drivers.

即：使用oracle jdbc驱动时，不支持read-only属性

五、mybatis在eclipse控制台显示sql语句的问题

mybatis支持多种日志组件，默认顺序如下：

• SLF4J
• Apache Commons Logging
• Log4j 2
• Log4j
• JDK logging

而上一篇刚学习的logback组件，正好是SLF4J的实现之一，所以如果采用logback来记录日志，mybatis不用做任何额外配置，将logback.xml扔在resource目录下即可

 1 <?xml version="1.0" encoding="UTF-8" ?>
 2 <configuration scan="true" scanPeriod="1800 seconds"
 3     debug="false">
 4 
 5     <property name="USER_HOME" value="logs" />
 6     <property scope="context" name="FILE_NAME" value="mybatis-logback" />
 7 
 8     <timestamp key="byDay" datePattern="yyyy-MM-dd" />
 9 
10     <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
11         <encoder>
12             <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n
13             </pattern>
14         </encoder>
15     </appender>
16 
17     <appender name="file"
18         class="ch.qos.logback.core.rolling.RollingFileAppender">
19         <file>${USER_HOME}/${FILE_NAME}.log</file>
20 
21         <rollingPolicy class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy">
22             <fileNamePattern>${USER_HOME}/${byDay}/${FILE_NAME}-${byDay}-%i.log.zip
23             </fileNamePattern>
24             <minIndex>1</minIndex>
25             <maxIndex>10</maxIndex>
26         </rollingPolicy>
27 
28         <triggeringPolicy
29             class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy">
30             <maxFileSize>5MB</maxFileSize>
31         </triggeringPolicy>
32         <encoder>
33             <pattern>%-4relative [%thread] %-5level %logger{35} - %msg%n
34             </pattern>
35         </encoder>
36 
37     </appender>
38 
39     <logger name="com.cnblogs.yjmyzz" level="debug" additivity="true">
40         <appender-ref ref="file" />
41         <!-- <appender-ref ref="STDOUT" /> -->
42     </logger>
43 
44     <root level="debug">
45         <appender-ref ref="STDOUT" />
46     </root>
47 </configuration>

View Code

注：log的level要设置成DEBUG。

logback与spring mvc整合的方法，上一篇已经讲过，就不再重复了，这里只给出web.xml的配置

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
 3     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 4     xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
 5     <context-param>
 6         <param-name>logbackConfigLocation</param-name>
 7         <param-value>classpath:logback.xml</param-value>
 8     </context-param>
 9     <listener>
10         <listener-class>com.cnblogs.yjmyzz.util.LogbackConfigListener</listener-class>
11     </listener>
12     
13     <context-param>
14         <param-name>contextConfigLocation</param-name>
15         <param-value>classpath:root-context.xml</param-value>
16     </context-param>
17     <filter>
18         <filter-name>CharacterEncodingFilter</filter-name>
19         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
20         <init-param>
21             <param-name>encoding</param-name>
22             <param-value>utf-8</param-value>
23         </init-param>
24     </filter>
25     <filter-mapping>
26         <filter-name>CharacterEncodingFilter</filter-name>
27         <url-pattern>/*</url-pattern>
28     </filter-mapping>
29     <listener>
30         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
31     </listener>
32     <servlet>
33         <servlet-name>appServlet</servlet-name>
34         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
35         <init-param>
36             <param-name>contextConfigLocation</param-name>
37             <param-value>classpath:servlet-context.xml</param-value>
38         </init-param>
39         <load-on-startup>0</load-on-startup>
40     </servlet>
41     <servlet-mapping>
42         <servlet-name>appServlet</servlet-name>
43         <url-pattern>/</url-pattern>
44     </servlet-mapping>
45 
46 </web-app>

View Code

示例源码：Spring-MVC-REST-MyBatis.zip

秒客网

mybatis 3.2.7 与 spring mvc 3.x、logback整合

相关文章