Spring3 整合 Mybatis3

這兩天，項目需要使用spring+ibatis，於是去網上下載了，結果發現和之前我用的版本變化不小，整了兩天才將功能實現，不敢怠慢，趕緊寫份博客記錄一下。

首先是依賴的庫:

接著是web.xml的配置，這裡，我使用的是Spring3 MVC

1. <?xmlversion="1.0"encoding="UTF-8"?>
2. <web-appxmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns="http://java.sun.com/xml/ns/javaee"xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"id="WebApp_ID"version="2.5">
3. <display-name>Log</display-name>
5. <welcome-file-list>
6. <welcome-file>welcome.html</welcome-file>
7. </welcome-file-list>
9. <!--日志配置文件的載入 -->
10. <context-param>
11. <param-name>log4jConfigLocation</param-name>
12. <param-value>/WEB-INF/classes/log4j.properties</param-value>
13. </context-param>
14. <!--Spring配置文件的載入 -->
15. <context-param>
16. <param-name>contextConfigLocation</param-name>
17. <param-value>classpath:applicationContext*.xml</param-value>
18. </context-param>
20. <!--Spring的ApplicationContext 載入 -->
21. <listener>
22. <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
23. </listener>
25. <!-- Spring字符集過濾 -->
26. <filter>
27. <filter-name>encodingFilter</filter-name>
28. <filter-class>org.springframework.web.filter.CharacterEncodingFilter </filter-class>
29. <init-param>
30. <param-name>encoding</param-name>
31. <param-value>utf8</param-value>
32. </init-param>
33. </filter>
35. <filter-mapping>
36. <filter-name>encodingFilter</filter-name>
37. <url-pattern>*.do</url-pattern>
38. </filter-mapping>
40. <!-- Server啟動時加載的應用 -->
42. <!-- Spring過濾器 -->
43. <servlet>
44. <servlet-name>dispatchServlet</servlet-name>
45. <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
46. <init-param>
47. <param-name>contextConfigLocation</param-name>
48. <param-value>classpath:servlet-config.xml</param-value>
49. </init-param>
50. <load-on-startup>1</load-on-startup>
51. </servlet>
53. <servlet-mapping>
54. <servlet-name>dispatchServlet</servlet-name>
55. <url-pattern>*.do</url-pattern>
56. </servlet-mapping>
58. </web-app>

然後是spring的servlet配置servlet-config.xml：

1. <?xmlversion="1.0"encoding="UTF-8"?>
2. <beansxmlns="http://www.springframework.org/schema/beans"
3. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4. xmlns:p="http://www.springframework.org/schema/p"
5. xmlns:context="http://www.springframework.org/schema/context"
6. xmlns:mvc="http://www.springframework.org/schema/mvc"
7. xsi:schemaLocation="http://www.springframework.org/schema/beans
8. http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
9. http://www.springframework.org/schema/context
10. http://www.springframework.org/schema/context/spring-context-3.0.xsd
11. http://www.springframework.org/schema/mvc
12. http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">
14. <!-- 自動掃描bean，把作了注��的類轉換為bean -->
15. <context:component-scanbase-package="com.log.bean.dao, com.log.report.controller"/>
17. <!-- 默認的注解映射的支持 -->
18. <mvc:annotation-driven/>
19. <!-- 支持JSON數據格式 -->
20. <beanclass="org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping"/>
21. <beanclass="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
22. <propertyname="messageConverters">
23. <list>
24. <beanclass="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">
25. <propertyname="supportedMediaTypes">
26. <list>
27. <value>text/html;charset=UTF-8</value>
28. </list>
29. </property>
30. </bean>
31. </list>
32. </property>
33. </bean>
35. <!-- 聲明viewResolver -->
36. <beanid="viewResolver"class="org.springframework.web.servlet.view.InternalResourceViewResolver">
37. <propertyname="prefix"value="/"/>
38. <propertyname="suffix"value=".html"/>
39. </bean>
42. </beans>

然後是Spring的Bean的配置文件applicationContext.xml：

1. <?xmlversion="1.0"encoding="UTF-8"?>
2. <beansxmlns="http://www.springframework.org/schema/beans"
3. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4. xmlns:context="http://www.springframework.org/schema/context"
5. xmlns:aop="http://www.springframework.org/schema/aop"
6. xmlns:tx="http://www.springframework.org/schema/tx"
7. xsi:schemaLocation="http://www.springframework.org/schema/beans
8. http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
9. http://www.springframework.org/schema/context
10. http://www.springframework.org/schema/context/spring-context-3.0.xsd
11. http://www.springframework.org/schema/aop
12. http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
13. http://www.springframework.org/schema/tx
14. http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">
16. <beanid="dataSource"class="org.apache.commons.dbcp.BasicDataSource">
17. <propertyname="maxActive"value="20"/>
18. <propertyname="maxIdle"value="20"/>
19. <propertyname="maxWait"value="3000"/>
20. <propertyname="testWhileIdle"value="true"/>
21. <propertyname="timeBetweenEvictionRunsMillis"value="3600000"/>
22. <propertyname="validationQuery"value="select 1"/>
23. <propertyname="removeAbandoned"value="true"/>
24. <propertyname="removeAbandonedTimeout"value="1"/>
25. <propertyname="driverClassName"value="com.mysql.jdbc.Driver"/>
26. <propertyname="url"value="jdbc:mysql://localhost:53306/search"/>
27. <propertyname="username"value="root"/>
28. <propertyname="password"value="8bewp2rJHfRGrl9VTQmc"/>
29. </bean>
31. <beanid="sqlSessionFactory"class="org.mybatis.spring.SqlSessionFactoryBean">
32. <propertyname="configLocation"value="classpath:ibatis-config.xml"/>
33. <propertyname="dataSource"ref="dataSource"/>
34. <!-- mapper和resultmap配置路徑 -->
35. <propertyname="mapperLocations">
36. <list>
37. <value>classpath:com/log/bean/mapper/*.xml</value>
38. </list>
39. </property>
40. </bean>
42. <!-- 通過掃描的模式，掃描目錄在com/log/bean/mapper目錄下，所有的mapper都繼承
43. SQLMapper接口的接口， 這樣一個bean就可以了 -->
44. <beanclass="org.mybatis.spring.mapper.MapperScannerConfigurer">
45. <propertyname="basePackage"value="com.log.bean.mapper"/>
46. <propertyname="markerInterface"value="com.log.bean.mapper.SQLMapper"/>
47. </bean>
49. <beanid="sqlSession"class="org.mybatis.spring.SqlSessionTemplate">
50. <constructor-argindex="0"ref="sqlSessionFactory"/>
51. </bean>
53. <!--事務配置-->
54. <tx:annotation-driventransaction-manager="transactionManager"/>
55. <beanid="transactionManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"autowire="byName"/>
57. </beans>