原来发表在csdn的,移动到oschian
Spring SpringMvc 3.0 + MyBatis 整合
一、使用的jar包就不详细讲解了,下载了Mybatis 和 Spring 的jar包基本上都添加上去了、
一图概括:(这是我使用的ar包,有些不是Mybatis 和 Spring 的 )
二、 web.xml配置文件
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns: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">
<display-name>WeShare</display-name>
<welcome-file-list>
<welcome-file>/jumper.html</welcome-file>
</welcome-file-list>
<!-- 加载spring容器配置 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 设置Spring容器加载配置文件路径 (主要配置都在这里面) -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/applicationContext.xml
</param-value>
</context-param>
<!-- 配置Spring核心控制器 -->
<servlet>
<servlet-name>web</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 不指定 <init-param> 会自动找web.xml相同路径下 web-servlet.xml文件 -->
<!--
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/dispatcher.xml</param-value>
</init-param>
-->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>web</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>web</servlet-name>
<url-pattern>*.action</url-pattern>
</servlet-mapping>
<!-- 解决工程编码过滤器 -->
<filter>
<filter-name>characterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- dwr 添加配置 -->
<servlet>
<servlet-name>dwr-invoker</servlet-name>
<servlet-class>org.directwebremoting.servlet.DwrServlet</servlet-class>
<init-param>
<description></description>
<param-name>debug</param-name>
<param-value>false</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>dwr-invoker</servlet-name>
<url-pattern>/dwr/*</url-pattern>
</servlet-mapping>
<error-page>
<exception-type>java.lang.Throwable</exception-type>
<location>/common/jsp/error.jsp</location>
</error-page>
<error-page>
<error-code>403</error-code>
<location>/common/jsp/error403.jsp</location>
</error-page>
<error-page>
<error-code>404</error-code>
<location>/common/jsp/error404.jsp</location>
</error-page>
</web-app>
三、 <!-- 配置Spring核心控制器 -->
<servlet>
<servlet-name>web</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 不指定 <init-param> 会自动找web.xml相同路径下 web-servlet.xml文件 -->
<!--
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/dispatcher.xml</param-value>
</init-param>
-->
<load-on-startup>1</load-on-startup>
</servlet> 这个我使用的是默认的 web-servlet.xml文件. 如下:
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.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
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd">
<!-- 启动Spring MVC的注解功能,完成请求和注解POJO的映射 -->
<bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"/>
<!-- 对模型视图名称的解析,即在模型视图名称添加前后缀 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver" >
<property name="prefix" value="/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
<context:component-scan base-package="com.weshare.**.web"/>
<!-- /hrtiaoxin/src/java/com/guohualife/ hr/pfc/ web/controller/HrDeptMarkController.java -->
</beans>
四: applicationContext.xml 文件:
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.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
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd">
<!-- properties配置文件 -->
<bean id="config"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<!-- 是否忽略不可解析的 -->
<property name="ignoreUnresolvablePlaceholders" value="true" />
<!-- 多个locations, 单个location <value> -->
<property name="locations">
<list>
<value>/WEB-INF/config/config.properties</value>
<value>/WEB-INF/config/urlAddress.properties</value>
<!--
<value>/WEB-INF/platform/config/config.properties</value>
<value>/WEB-INF/config/config.properties</value>
<value>/WEB-INF/hr/config/config.properties</value>
-->
</list>
</property>
</bean>
<!-- 文件上传 -->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver" p:defaultEncoding="UTF-8" ></bean>
<!-- 加载 其他xml文件 -->
<import resource="/config/aC-common.xml" />
<import resource="/config/aC-interceptor.xml" />
<import resource="/config/aC-properties.xml" />
<import resource="/config/aC-quartz-config.xml" />
</beans>
包含的其他4个xml文件:
4.1 : aC-common.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.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
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd">
<context:component-scan base-package="com.weshare.*.api.dao"></context:component-scan>
<context:component-scan base-package="com.weshare.*.api.service"></context:component-scan>
<context:component-scan base-package="com.weshare.common.utils"></context:component-scan>
<bean id="weshareDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${common.db.driver}" />
<property name="url" value="${common.db.url}" />
<property name="username" value="${common.db.username}" />
<property name="password" value="${common.db.password}" />
<!-- 最大连接数据库连接数 -->
<property name="maxActive" value="500" />
<!-- 最大等待连接中的数量 0标识没有限制 -->
<property name="maxIdle" value="10" />
<!-- 最大等待毫秒数 超时报错 -->
<property name="maxWait" value="500" />
<property name="defaultAutoCommit" value="true" />
<!-- 是否自我中断 -->
<property name="removeAbandoned" value="true" />
<property name="removeAbandonedTimeout" value="60" />
</bean>
<bean id="weshareSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" >
<property name="dataSource">
<ref bean="weshareDataSource" />
</property>
<!-- MyBatis 的 XML 配置文件路径 -->
<property name="configLocation" value="/WEB-INF/config/mybatisSqlMapConfig.xml" />
<!-- 扫描自动生成的xml文件 --><!-- Mybatis XML映射文件 -->
<property name="mapperLocations" >
<list><!-- Mybatis XML映射文件 -->
<value>classpath*:com/weshare/common/generated/xml/*.xml</value>
<!-- 扫描自己写的xml文件-->
<value>classpath*:com/weshare/*/api/xml/*.xml</value>
</list>
</property>
</bean>
<bean id="weshareSqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg index="0" ref="weshareSessionFactory"></constructor-arg>
</bean>
<!-- 注册单个 mybatisGenerator 自动生成的 接口文件-->
<!--
<bean id="TestMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
<property name="mapperInterface" value="com.weshare.common.generated.dao.TestMapper" />
<property name="sqlSessionTemplate" ref="weshareSqlSessionTemplate" ></property>
</bean>
-->
<!-- 扫描mybatisGenerator 自动生成的 所有接口-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer" >
<property name="basePackage" value="com.weshare.common.generated.dao" ></property>
</bean>
<!-- 数据库事务策略-->
<bean id="weshareTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
<ref bean="weshareDataSource" />
</property>
</bean>
<tx:advice id="weshareTxAdvice" transaction-manager="weshareTransactionManager">
<tx:attributes>
<!--
<tx:method name="save*" propagation="REQUIRED" />
<tx:method name="ins*" propagation="REQUIRED" />
<tx:method name="del*" propagation="REQUIRED" />
<tx:method name="update*" propagation="REQUIRED" />
<tx:method name="find*" read-only="true" />
<tx:method name="get*" read-only="true" />
<tx:method name="select*" read-only="true" />
-->
<tx:method name="*" propagation="REQUIRED" />
</tx:attributes>
</tx:advice>
<aop:config proxy-target-class="true">
<aop:advisor pointcut="execution( * com.weshare.*.api.service.*.*(..))" advice-ref="weshareTxAdvice" />
</aop:config>
</beans>
4.2 aC-interceptor.xml
这里拦截器只是拦截到controller , 具体拦截到action',后面会有写到, 这里的配置只是参考。
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:p="http://www.springframework.org/schema/p"
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/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
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd">
<mvc:interceptors>
<mvc:interceptor>
<!--设置拦截的路径 mvc:mapping指定到哪个action , 用mappingURL匹配方法-->
<mvc:mapping path="/dynamic/dynamic.do" />
<bean class="com.weshare.common.web.LoginInterceptorController">
<property name="mappingURL" value="^.*checklogin$" />
</bean>
</mvc:interceptor>
</mvc:interceptors>
</beans>
4.3 aC-properties.xml
这个xml作用是在启动项目的时候给org.springframework.beans.factory.config.PropertiesFactoryBean 赋值,这样在代码中可以使用下面方法获得这些值
@Resource
private Properties imageUrlProperties;
imageUrlProperties.getProperty("dynamicUrl")
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.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
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd">
<!-- platform properties -->
<bean id="imageUrlProperties"
class="org.springframework.beans.factory.config.PropertiesFactoryBean">
<property name="singleton" value="true" />
<property name="properties">
<props>
<prop key="aliyuming">${aliyuming}</prop>
<prop key="ACCESS_ID">${ACCESS_ID}</prop>
<prop key="ACCESS_KEY">${ACCESS_KEY}</prop>
<prop key="bucketDynamicAndHeadimages">${bucketDynamicAndHeadimages}</prop>
<prop key="faceurl.pre">${faceurl.pre}</prop>
<prop key="imagesUrl.pre">${imagesUrl.pre}</prop>
<prop key="dynamicUrl">${dynamicUrl}</prop>
<prop key="headUrl">${headUrl}</prop>
<prop key="edge.dynamic">${edge.dynamic}</prop>
<prop key="edge.small">${edge.small}</prop>
<prop key="edge.middle">${edge.middle}</prop>
<prop key="edge.big">${edge.big}</prop>
</props>
</property>
</bean>
</beans>
4aC-quartz-cofig.xml, 这个是批处理定时任务的xml配置方法, 在这里我并没有使用, 我使用的总是注解的方式, 后面会讲到。
<?xml version="1.0" encoding="UTF-8"?>
<beans
xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd http://www.springframework.org/schema/fex http://www.springframework.org/schema/fex/spring-fex-1.5.xsd http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd"
xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:task="http://www.springframework.org/schema/task"
xmlns="http://www.springframework.org/schema/beans">
<!-- 下面是使用注解配置的方法 -->
<context:component-scan base-package="com.weshare.*.api.batch" />
<task:executor pool-size="5" id="executor" />
<task:scheduler pool-size="10" id="scheduler" />
<task:annotation-driven scheduler="scheduler" executor="executor" />
<!-- 下面是 使用xml配置的方法 -->
<!-- <bean id="personBatch" class="com.weshare.person.api.batch.PersonBatch"
/> -->
<!-- 启动触发器的配置开始 -->
<!-- <bean name="startQuertz" lazy-init="false" autowire="no" class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
<property name="triggers"> <list> <ref bean="myJobTrigger" /> </list> </property>
</bean> -->
<!-- 启动触发器的配置结束 -->
<!-- quartz-2.x的配置 -->
<!-- <bean id="myJobTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
<property name="jobDetail"> <ref bean="myJobDetail" /> </property> <property
name="cronExpression"> <value>0/1 * * * * ?</value> </property> </bean> -->
<!-- 调度的配置结束 -->
<!-- job的配置开始 -->
<!-- <bean id="myJobDetail" class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
<property name="targetObject"> <ref bean="personBatch" /> </property> <property
name="targetMethod"> <value>testMethod</value> </property> </bean> -->
<!-- job的配置结束 -->
</beans>
五:注解方式
下面deleteDynamic方法的 调用地址为: localhost:8080/xx工程名/dynamic/admin.do?action=deleteDynamic
ps: 对于 properties文件的读取进行了优化, 见:
版权声明:本文为博主原创文章,未经博主允许不得转载。