整合Struts2.3.20 Spring4.1.3 Hibernate4.3.7 配置文件

applicationContext.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:context="http://www.springframework.org/schema/context"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-4.1.xsd    http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsd">  <!-- 自动扫描与装配bean --><context:component-scan base-package="david"></context:component-scan><!-- 加载外部的properties配置文件 --><context:property-placeholder location="classpath:jdbc.properties" /><!-- 配置数据库连接池（c3p0） --><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><!-- 基本信息 --><property name="jdbcUrl" value="${db.jdbcUrl}"></property><property name="driverClass" value="${db.driverClass}"></property><property name="user" value="${db.username}"></property><property name="password" value="${db.password}"></property><!-- 其他配置 --><!--初始化时获取三个连接，取值应在minPoolSize与maxPoolSize之间。Default: 3 --><property name="initialPoolSize" value="3"></property><!--连接池中保留的最小连接数。Default: 3 --><property name="minPoolSize" value="3"></property><!--连接池中保留的最大连接数。Default: 15 --><property name="maxPoolSize" value="5"></property><!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 --><property name="acquireIncrement" value="3"></property><!-- 控制数据源内加载的PreparedStatements数量。如果maxStatements与maxStatementsPerConnection均为0，则缓存被关闭。Default: 0 --><property name="maxStatements" value="8"></property><!-- maxStatementsPerConnection定义了连接池内单个连接所拥有的最大缓存statements数。Default: 0 --><property name="maxStatementsPerConnection" value="5"></property><!--最大空闲时间,1800秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 --><property name="maxIdleTime" value="1800"></property></bean><!-- 配置SessionFactory --><bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"><property name="dataSource" ref="dataSource"></property><property name="configLocation" value="classpath:hibernate.cfg.xml"></property></bean><!-- 配置Hibernate事务管理器 --><bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager"><property name="sessionFactory" ref="sessionFactory" /></bean><tx:annotation-driven transaction-manager="transactionManager" /><!-- 配置声明式事务：方法二，使用tx/aop命名空间的配置（其实还有方法三，由于快要过时不推荐使用了，这里就不给出方法三的配置了） --><!-- <tx:advice id="txAdvice" transaction-manager="transactionManager"><tx:attributes><tx:method name="insert*" propagation="REQUIRED" /><tx:method name="update*" propagation="REQUIRED" /><tx:method name="edit*" propagation="REQUIRED" /><tx:method name="save*" propagation="REQUIRED" /><tx:method name="add*" propagation="REQUIRED" /><tx:method name="new*" propagation="REQUIRED" /><tx:method name="set*" propagation="REQUIRED" /><tx:method name="remove*" propagation="REQUIRED" /><tx:method name="delete*" propagation="REQUIRED" /><tx:method name="change*" propagation="REQUIRED" /><tx:method name="get*" propagation="REQUIRED" read-only="true" /><tx:method name="find*" propagation="REQUIRED" read-only="true" /><tx:method name="load*" propagation="REQUIRED" read-only="true" /><tx:method name="search*" propagation="REQUIRED" read-only="true" /><tx:method name="*" propagation="REQUIRED" read-only="true" /></tx:attributes></tx:advice><aop:config><aop:pointcut id="mypointcut" expression="execution(* com.**.service..*.*(..))" /><aop:advisor advice-ref="txAdvice" pointcut-ref="mypointcut" /></aop:config> -->  <!-- 下面三个Bean的配置可有可无，但配置后用处更大，通常用于BaseDao类、其他Dao类或特殊工具类中 --><!-- <bean id="hibernateTemplate" class="org.springframework.orm.hibernate4.HibernateTemplate"p:sessionFactory-ref="sessionFactory" /><bean id="hibernateDaoSupport" class="org.springframework.orm.hibernate4.support.HibernateDaoSupport"p:hibernateTemplate-ref="hibernateTemplate" abstract="true"/><bean id="sessionFactoryUtils" class="org.springframework.orm.hibernate4.SessionFactoryUtils" abstract="true"/> --></beans>

hibernate.cfg.xml

<!DOCTYPE hibernate-configuration PUBLIC"-//Hibernate/Hibernate Configuration DTD 3.0//EN""http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"><hibernate-configuration><session-factory><!-- <property name="javax.persistence.validation.mode">none</property>--><!-- 数据库配置信息 --><property name="dialect">org.hibernate.dialect.MySQL5Dialect</property><!-- <property name="connection.url">jdbc:mysql:///oa20141219</property><property name="connection.username">root</property><property name="connection.password">root</property><property name="connection.driver_class">com.mysql.jdbc.Driver</property>--><property name="show_sql">true</property><property name="hbm2ddl.auto">update</property><mapping resource="david/oa/domain/Department.hbm.xml" /><mapping resource="david/oa/domain/Role.hbm.xml" /><mapping resource="david/oa/domain/User.hbm.xml" /></session-factory></hibernate-configuration>

struts.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE struts PUBLIC"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN""http://struts.apache.org/dtds/struts-2.3.dtd"><struts><!-- 指定Web应用的默认编码，相当于调用request的setCharacterEncoding方法 --><constant name="struts.i18n.encoding" value="UTF-8" /><!-- 设置浏览器是否缓存静态内容，默认值为true(生产环境下使用)，开发阶段最好关闭 --><constant name="struts.serve.static.browserCache" value="false" /><!-- 当Struts2的配置文件修改后，系统是否自动重新加载配置文件，默认值为false(生产环境下使用)，开发阶段最好打开 --><constant name="struts.configuration.xml.reload" value="true" /><!-- 开发模式下使用，这样可以打印出更详细的日志信息 --><constant name="struts.devMode" value="true" /><!-- 默认的视图主题 --><constant name="struts.ui.theme" value="simple" /><!-- 把Action对象交给Spring创建和管理 --><constant name="struts.objectFactory" value="spring" /><!-- Struts2处理的请求后缀,默认值是action --><constant name="struts.action.extension" value="do" /><!-- 国际化资源文件<constant name="struts.custom.i18n.resources" value="globalMessages" /> --><package name="default" namespace="/" extends="struts-default"><action name="roleAction" class="roleAction"><result name="success">listUI.jsp</result></action></package></struts>

web.xml

<?xml version="1.0" encoding="UTF-8"?><web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"><display-name>OA</display-name><!-- Spring 容器初始化 --><context-param><param-name>contextConfigLocation</param-name><param-value>classpath:applicationContext*.xml</param-value></context-param><listener><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><listener><listener-class>org.springframework.web.context.request.RequestContextListener</listener-class></listener><!-- log4配置 --><context-param><param-name>log4jConfigLocation</param-name><param-value>classpath:log4j.properties</param-value></context-param><listener><listener-class>org.springframework.web.util.Log4jConfigListener</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><!-- 解决Hibernate懒加载问题 --><filter><filter-name>hibernate4Filter</filter-name><filter-class>org.springframework.orm.hibernate4.support.OpenSessionInViewFilter</filter-class></filter><filter-mapping><filter-name>hibernate4Filter</filter-name><url-pattern>/*</url-pattern></filter-mapping><!-- Struts2配置 --><filter><filter-name>struts2Filter</filter-name><filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class></filter><filter-mapping><filter-name>struts2Filter</filter-name><url-pattern>/*</url-pattern></filter-mapping><context-param><param-name>webAppRootKey</param-name><param-value>oa.root</param-value></context-param><welcome-file-list><welcome-file>index.html</welcome-file><welcome-file>index.htm</welcome-file><welcome-file>index.jsp</welcome-file><welcome-file>default.html</welcome-file><welcome-file>default.htm</welcome-file><welcome-file>default.jsp</welcome-file></welcome-file-list></web-app>

jdbc.properties

db.jdbcUrl= jdbc:mysql:///oa20141219db.driverClass= com.mysql.jdbc.Driverdb.username= rootdb.password=root

注意jdbc.properties文件的key一定要以xx.xxx这样的形式书写才能正常读取，在Spring3没有要求，但是更新到Spring4后jdbc.properties 中如果出现username= root 这样的格式在applicationContext.xml中读取不了，会包连接池错误信息

最后改成db.username 这样的格式就一切正常，当然 在applicationContext.xml中也要做相应的改变。

所用到的jar包下载地址

链接: http://pan.baidu.com/s/1mgEAhGs 密码: ybbw