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> 
  • 1
  • 2
  • 下一页

相关内容