springmvc+mybatis整合，springmvcmybatis

springmvc+mybatis整合，springmvcmybatis

maven 依賴

<!-- springmvc -->
<dependency>
　　<groupId>org.springframework</groupId>
　　<artifactId>spring-webmvc</artifactId>
　　<version>4.3.2.RELEASE</version>
</dependency>

<!-- mybatis -->
<dependency>
　　<groupId>org.mybatis</groupId>
　　<artifactId>mybatis-spring</artifactId>
　　<version>1.3.0</version>
</dependency>
<dependency>
　　<groupId>org.mybatis</groupId>
　　<artifactId>mybatis</artifactId>
　　<version>3.4.1</version>
</dependency>
<dependency>
　　<groupId>org.aspectj</groupId>
　　<artifactId>aspectjweaver</artifactId>
　　<version>1.9.0.BETA-1</version>
</dependency>


<dependency>
　　<groupId>org.springframework</groupId>
　　<artifactId>spring-context-support</artifactId>
　　<version>4.3.0.RELEASE</version>
</dependency>

<!-- 數據庫連接 -->
<dependency>
　　<groupId>com.alibaba</groupId>
　　<artifactId>druid</artifactId>
　　<version>1.0.26</version>
</dependency>
<dependency>
　　<groupId>mysql</groupId>
　　<artifactId>mysql-connector-java</artifactId>
　　<version>5.1.25</version>
</dependency>

<dependency>
　　<groupId>org.springframework</groupId>
　　<artifactId>spring-jdbc</artifactId>
　　<version>4.2.5.RELEASE</version>
</dependency>

<dependency>
　　<groupId>javax.servlet</groupId>
　　<artifactId>javax.servlet-api</artifactId>
　　<version>3.0.1</version>
　　<scope>provided</scope>
</dependency>
<dependency>
　　<groupId>javax.servlet.jsp</groupId>
　　<artifactId>jsp-api</artifactId>
　　<version>2.2</version>
</dependency>
<dependency>
　　<groupId>javax.servlet</groupId>
　　<artifactId>jstl</artifactId>
　　<version>1.2</version>
</dependency>

<dependency>
　　<groupId>commons-logging</groupId>
　　<artifactId>commons-logging</artifactId>
　　<version>1.2</version>
</dependency>
<dependency>
　　<groupId>org.apache.commons</groupId>
　　<artifactId>com.springsource.org.apache.commons.fileupload</artifactId>
　　<version>1.2.1</version>
</dependency>

web.xml

<context-param>
　　<param-name>contextConfigLocation</param-name>
　　<param-value>classpath:spring-mybatis.xml</param-value>
</context-param>

<listener>
　　<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>


<servlet>
　　<servlet-name>springmvc</servlet-name>
　　<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
　　<init-param>
　　　　<param-name>contextConfigLocation</param-name>
　　　　<param-value>classpath:spring-mvc.xml</param-value>
　　</init-param>
　　<load-on-startup>1</load-on-startup>
　　<async-supported>true</async-supported>
</servlet>
<servlet-mapping>
　　<servlet-name>springmvc</servlet-name>
　　<url-pattern>/</url-pattern>
</servlet-mapping>

spring-mvc.xml

<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.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd">

<!-- 注解掃描的范圍,多個用逗號隔開 -->
<context:component-scan base-package="com.xxx">
<context:include-filter type="annotation"
expression="org.springframework.stereotype.Controller" />
<context:include-filter type="annotation"
expression="org.springframework.web.bind.annotation.ControllerAdvice" />
</context:component-scan>

<mvc:annotation-driven />
<!-- 當在web.xml 中 DispatcherServlet使用 <url-pattern>/</url-pattern> 映射時，能映射靜態資源 -->
<mvc:default-servlet-handler />

<!-- 靜態資源映射 -->
<mvc:resources mapping="/static/**" location="/static/" />

<!-- 默認的視圖解析器 在上邊的解析錯誤時使用 (默認使用html)- -->
<bean id="defaultViewResolver"
class="org.springframework.web.servlet.view.InternalResourceViewResolver"
p:order="1">
<property name="viewClass"
value="org.springframework.web.servlet.view.JstlView" />
<property name="contentType" value="text/html" />
<property name="prefix" value="" />
<property name="suffix" value=".jsp" />
</bean>

<!-- 控制器異常處理 -->
<bean id="exceptionHandlerExceptionResolver"
class="org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver">
</bean>

<!-- SpringMVC上傳文件時，需要配置MultipartResolver處理器 -->
<bean id="multipartResolver"
class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<property name="defaultEncoding" value="UTF-8" />
</bean>
</beans>

spring-mybatis.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.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
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<!-- 基本屬性 url、user、password -->
<property name="url" value="jdbc:mysql://127.0.0.1:3306/springtest" />
<property name="username" value="root" />
<property name="password" value="123456" />
</bean>

<!-- <bean id="log-filter" class="com.alibaba.druid.filter.logging.Slf4jLogFilter"> -->
<!-- <property name="statementExecutableSqlLogEnable" value="true"/> -->
<!-- </bean> -->

<!-- (事務管理) -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>

<!-- 創建SqlSessionFactory，同時指定數據源 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<!-- <property name="configLocation" value="classpath:/mybatis.xml"/> -->
<property name="mapperLocations" >
<value>classpath:com/xxx/**/mapper/*.xml</value>
<!-- mapper.xml若果存在多個包下可如下配置 -->
<!-- <array> -->
<!-- <value></value> -->
<!-- <value></value> -->
<!-- </array> -->
</property>
</bean>

<!-- Mapper接口所在包名，Spring會自動查找其下的Mapper 如果包有多個,次類也可配置多個 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.xxx"/>
<property name="markerInterface" value="com.xxx.MybatisMapper"/>
</bean>

<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="get*" propagation="SUPPORTS" read-only="true"/><!--當只需要調用一次dao-->
<tx:method name="find*" propagation="SUPPORTS" read-only="true"/><!--當需要通過多個dao獲取數據時-->
<tx:method name="list*" propagation="SUPPORTS" read-only="true"/>
<tx:method name="*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
</tx:attributes>
</tx:advice>

<aop:config expose-proxy="true" proxy-target-class="true">
<!-- 只對業務邏輯層實施事務 有多個包可用 || 連接 -->
<aop:pointcut id="txPointcut" expression="execution(* com.xxx.*..service..*+.*(..))"/>
<aop:advisor id="txAdvisor" advice-ref="txAdvice" pointcut-ref="txPointcut"/>
</aop:config>

</beans>