搭建Struts2+Spring+Ibatis框架

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>security</display-name> <context-param> <param-name>contextConfigLocation</param-name> <param-value> classpath:com/xxx/xxx/conf/application_context.xml, classpath:com/xxx/xxx/conf/applicationContext-spring-security.xml </param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <filter> <filter-name>encodingFilter</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> <init-param> <param-name>forceEncoding</param-name> <param-value>true</param-value> </init-param> </filter> <filter-mapping> <filter-name>encodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <filter> <filter-name>struts2</filter-name> <filter-class>org.apache.struts2.dispatcher.FilterDispatcher</filter-class> </filter> <filter-mapping> <filter-name>struts2</filter-name> <url-pattern>/*</url-pattern> <dispatcher>REQUEST</dispatcher> <dispatcher>FORWARD</dispatcher> </filter-mapping> <welcome-file-list> <welcome-file>views/home/home/index.jsp</welcome-file> </welcome-file-list> <session-config> <session-timeout>-1</session-timeout> </session-config> <!-- --> </web-app>

 

 

spring xml:application_context.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" xmlns:jee="http://www.springframework.org/schema/jee" xmlns:p="http://www.springframework.org/schema/p" xsi:schemaLocation=" http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.5.xsd"> <context:component-scan base-package="com.byd.mes.dev,com.byd.mes.bussiness.service" /> <!--=================================================================================== 指定Spring配置中用到的属性文件 ====================================================================================--> <bean id="propertyConfigurer" class="com.xxx.mes.util.PropertyConfigurer"> <property name="locations" > <list> <value>classpath:com/xxx/xxx/conf/jdbc@bmes_dev.properties</value> <value>classpath:com/xxx/xxx/conf/system_conf.properties</value> </list> </property> </bean> <!--=================================================================================== 数据源 ====================================================================================--> <!-- 业务数据库 --> <bean id="dataSourceORG" class="org.apache.commons.dbcp.BasicDataSource" destroy-method ="close" p:driverClassName="${mes.org.jdbc.driver}" p:url="${mes.org.jdbc.connectionURL}" p:username="${mes.org.jdbc.username}" p:password="${mes.org.jdbc.password}" /> <!-- 归档数据库 --> <bean id="dataSourceODS" class="org.apache.commons.dbcp.BasicDataSource" destroy-method ="close" p:driverClassName="${mes.ods.jdbc.driver}" p:url="${mes.ods.jdbc.connectionURL}" p:username="${mes.ods.jdbc.username}" p:password="${mes.ods.jdbc.password}" /> <!-- 动态数据源 --> <bean id="dataSource" class="com.xxx.mes.util.datasource.DynamicDataSource"> <property name="targetDataSources"> <map> <entry key="orgdb" value-ref="dataSourceORG"/> <entry key="odsdb" value-ref="dataSourceODS"/> </map> </property> <property name="defaultTargetDataSource" ref="dataSourceORG" /> </bean> <!--=================================================================================== ibatis配置 ====================================================================================--> <bean id="lobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler"/> <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <property name="dataSource" ref="dataSource"></property> <property name="configLocation"> <value>classpath:com/xxx/xxx/conf/sqlMapConfig_mes.xml</value> </property> <property name="lobHandler" ref="lobHandler"/> </bean> <!--=================================================================================== 定义事务管理器（声明式的事务） ====================================================================================--> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource"> <ref local="dataSource" /> </property> </bean> <tx:advice id="txAdvice" transaction-manager="transactionManager"> <tx:attributes> <tx:method name="add*" propagation="REQUIRED" timeout="60" read-only="false" rollback-for="Throwable" /> <tx:method name="send*" propagation="REQUIRED" timeout="60" read-only="false" rollback-for="Throwable" /> <tx:method name="save*" propagation="REQUIRED" timeout="60" read-only="false" rollback-for="Throwable" /> <tx:method name="delete*" propagation="REQUIRED" timeout="60" read-only="false" rollback-for="Throwable" /> <tx:method name="update*" propagation="REQUIRED" timeout="60" read-only="false" rollback-for="Throwable" /> <tx:method name="imp*" propagation="REQUIRED" timeout="180" read-only="false" rollback-for="Throwable" /> <tx:method name="execute*" propagation="REQUIRED" timeout="60" read-only="false" rollback-for="Throwable" /> </tx:attributes> </tx:advice> <aop:config> <aop:pointcut id="interceptorPointCuts" expression="(execution(* com.xxx.xxx..*ServiceImpl.*(..)))" /> <aop:advisor advice-ref="txAdvice" pointcut-ref="interceptorPointCuts" /> </aop:config> <!--=================================================================================== ACTION XML ====================================================================================--> <!-- 主数据 action --> <import resource="action_mes_main.xml"/> <!--=================================================================================== DAO XML =====================================================================================--> <!-- 主数据 dao--> <import resource="dao_mes_main.xml" /> <!--=================================================================================== SERVICE XML =====================================================================================--> <!-- 主数据 service--> <import resource="service_mes_main.xml" /> <!--=================================================================================== OTHER XML =====================================================================================--> <!-- Applicationcontext应用Bean --> <bean id="beanFactory" class="com.xxx.xxx.util.BeanFactory" p:propertyConfigurer-ref ="propertyConfigurer"/> </beans>

 

PropertyConfigurer.java

 

import java.io.IOException; import java.util.Map; import java.util.Properties; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.springframework.beans.factory.config.PropertyPlaceholderConfigurer; public class PropertyConfigurer extends PropertyPlaceholderConfigurer{ private static final Log log = LogFactory.getLog(PropertyConfigurer.class); private Properties property; public Properties getProperties(){ if(property == null){ try { property = this.mergeProperties(); } catch (IOException e) { log.error(e); } } return property; } }

 

BeanFactory.java

 

import java.io.Serializable; import java.util.HashMap; import java.util.Map; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.springframework.beans.BeanUtils; import org.springframework.beans.BeansException; import org.springframework.context.ApplicationContext; import org.springframework.context.ApplicationContextAware; public class BeanFactory implements ApplicationContextAware { private static final Log log = LogFactory.getLog(BeanFactory.class); private static ApplicationContext applicationContext; private static Map<String, String> systemParamters; private static PropertyConfigurer propertyConfigurer; public static final String INSTANCE_SINGLETON = "singleton"; public static final String INSTANCE_PROTOTYPE = "prototype"; public static Object getBean(String beanName) { return applicationContext.getBean(beanName); } @Override public void setApplicationContext(ApplicationContext applicationContext)throws BeansException { log.info("set applicationContext to static>>>"+applicationContext); BeanFactory.applicationContext = applicationContext; } public static ApplicationContext getApplicationContext() { return applicationContext; } public static Map<String, String> getSystemParamters() { return (Map)propertyConfigurer.getProperties(); } public void setPropertyConfigurer(PropertyConfigurer propertyConfigurer) { BeanFactory.propertyConfigurer = propertyConfigurer; } }

 

jdbc@bmes_dev.properties 数据库连接文件

 

mes.org.jdbc.driver=oracle.jdbc.OracleDriver mes.org.jdbc.connectionURL =jdbc:oracle:thin:@192.168.100.32:1521:MES mes.org.jdbc.username=用户名 mes.org.jdbc.password=密码

 

struts.xml

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN" "http://struts.apache.org/dtds/struts-2.0.dtd"> <struts> <!-- 把action对象交给spring创建 --> <constant name="struts.objectFactory" value="spring" /> <!-- 指定Web应用的默认编码集,相当于调用HttpServletRequest的setCharacterEncoding方法 --> <constant name="struts.i18n.encoding" value="UTF-8" /> <!-- 设置浏览器是否缓存静态内容,默认值为true(生产环境下使用),开发阶段最好关闭 --> <constant name="struts.serve.static.browserCache" value="false" /> <!-- 当struts的配置文件修改后,系统是否自动重新加载该文件,默认值为false(生产环境下使用),开发阶段最好打开 --> <constant name="struts.configuration.xml.reload" value="true" /> <!-- 开发模式下使用,这样可以打印出更详细的错误信息 --> <constant name="struts.devMode" value="false" /> <!-- 默认的视图主题 --> <constant name="struts.ui.theme" value="simple" /> <!-- 默认的国际化资源文件 --> <constant name="struts.custom.i18n.resources" value="ApplicationResources" /> <!-- 允许上传文件的大小 --> <constant name="struts.multipart.maxSize" value="20000000" /> <!-- ================================================================== Struts 主数据映射文件 =================================================================== --> <include file="com/xxx/xxx/conf/struts_mes_main.xml"/> </struts>

 

struts_mes_main.xml

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN" "http://struts.apache.org/dtds/struts-2.0.dtd"> <struts> <!--测试范例--> <package name="test" namespace="/test" extends="struts-default"> <action name="base" class="testCustomer"> </action> </package> <!--客户维护 --> <package name="customerMaintenance" namespace="/views/masterData/customer/customerMaintenance" extends="struts-default"> <action name="customerMaintenanceAction" class="customerMaintenance"> </action> </package> </struts>

 

action_mes_main.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:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd"> <!--testCase--> <bean id="testCustomer" class="test.com.byd.mes.view.action.BaseAction"> <property name="customerService" ref="customerService" /> </bean> <!-- 客户 --> <bean id="customerMaintenance" class="com.byd.mes.view.action.main.CustomerMaintenanceAction"> <property name="customerService" ref="customerService" /> </bean> <!-- 客户订单 维护--> <bean id="customerOrderMaintenance" class="com.byd.mes.view.action.main.CustomerOrderMaintenanceAction"> <property name="customerOrderService" ref="customerOrderService" /> <property name="customerOrderItemService" ref="customerOrderItemService" /> <property name="customerService" ref="customerService" /> </bean> <!-- 供应商 --> <bean id="vendorMaintenance" class="com.byd.mes.view.action.main.VendorMaintenanceAction"> <property name="vendorService" ref="vendorService" /> <property name="vendorComponentService" ref="vendorComponentService" /> </bean> </beans>

 

 

service_mes_main.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:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd"> <!--=============================================================================== SERVICE =========================================== <!-- 物料清单--> <bean id="bomService" class="com.byd.mes.bussiness.service.main.impl.BomServiceImpl" p:bomDAO-ref="bomDAO" p:bomHandle-ref="bomHandle" p:customDataHandle-ref="customDataHandle" p:statusService-ref="statusService" p:listKindService-ref="listKindService" p:maskGroupService-ref="maskGroupService" p:mesLocksService-ref="mesLocksService" p:statusGrant="1"/> </beans>

 

dao_mes_main.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:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd"> <!--============================================================================= 常用JDBC操作 ===============================================================================--> <bean id="jdbcDAO" class="com.xxx.xxx.persistent.dao.JdbcDAOImpl" p:dataSource-ref="dataSource"> <property name="totalCountSqlTemplate"> <value> <!--[CDATA[ SELECT COUNT(*) FROM( :SQL_STATEMENT ) ]]> </value> </property> <property name="paginatorSqlTemplate"> <value> <![CDATA[ SELECT * FROM ( SELECT t.*,rownum rownum_ FROM ( :SQL_STATEMENT ) t WHERE rownum <= :END_INDEX ) t WHERE t.rownum_ >= :START_INDEX ]]--> </value> </property> </bean> <!--============================================================================= DAO ===============================================================================--> <!-- 物料清单 --> <bean id="bomDAO" class="com.xxx.xxx.persistent.dao.main.impl.BomDAOImpl"> <constructor-arg ref="sqlMapClient" /> </bean> </beans>