最近一直有朋友在问，最新版的Spring、Struts、Hibernate整合老是有问题，昨晚大概看了一下。从Hibernate 4 开始，本身已经很好的实现了数据库事务模块，而Spring也把Hibernate4之后的HibernateDaoSupport去掉了，Spring建议使用官方的HibernateAPI进行操作。这样一来，以前习惯使用HibernateDaoSupport来操作的人来说刚刚开始可能有些不习惯。我根据官方的说明，大概的整合一下，高手可以路过，给刚上路的朋友们。
现在把主要的代码和配置贴出来，供大家参考，我本人不会发完整的项目，其它配置文件和代码和以前没有什么大变化，直接就能用，主要就是Dao。
之前发过的几篇文章都被人转了N千次，但是我发现被转的文章都没有标明原作者，有的还把自己的大名写上去了。用我同事的一句说：“没文化真可怕！” 那些转载不留名的朋友，你们不羞愧吗？做人要厚道，转载请留名！
更新增加C3P0和EhCache配置
Web.xml
Spring配置文件（applicationContext-common.xml）更新增加C3P0和EhCache配置：
<?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:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:p="http://www.springframework.org/schema/p" xmlns:util="http://www.springframework.org/schema/util" xmlns:tool="http://www.springframework.org/schema/tool" xmlns:context="http://www.springframework.org/schema/context" 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/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd http://www.springframework.org/schema/tool http://www.springframework.org/schema/tool/spring-tool.xsd" default-lazy-init="true" default-autowire="byName"> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>classpath:/dataBaseInfo.properties</value> </list> </property> </bean> <!-- <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean" p:jndiName="java:comp/env/jdbc/MySSH" /> --> <!-- BoneCP --> <!-- <bean id="dataSource" class="com.jolbox.bonecp.BoneCPDataSource" --> <!-- p:driverClass="${jdbc.driver}" p:jdbcUrl="${jdbc.url}" p:username="${jdbc.username}" --> <!-- p:password="${jdbc.password}" p:idleConnectionTestPeriodInMinutes="${bonecp.idleConnectionTestPeriodInMinutes}" --> <!-- p:idleMaxAgeInMinutes="${bonecp.idleMaxAgeInMinutes}" --> <!-- p:maxConnectionsPerPartition="${bonecp.maxConnectionsPerPartition}" --> <!-- p:minConnectionsPerPartition="${bonecp.minConnectionsPerPartition}" --> <!-- p:partitionCount="${bonecp.partitionCount}" p:acquireIncrement="${bonecp.acquireIncrement}" --> <!-- p:statementsCacheSize="${bonecp.statementsCacheSize}" --> <!-- p:disableConnectionTracking="${bonecp.disableConnectionTracking}" --> <!-- p:releaseHelperThreads="${bonecp.releaseHelperThreads}" destroy-method="close" /> --> <!-- C3P0 --> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" p:driverClass="${jdbc.driver}" p:jdbcUrl="${jdbc.url}" p:user="${jdbc.username}" p:password="${jdbc.password}" p:acquireIncrement="${c3p0.acquireIncrement}" p:initialPoolSize="${c3p0.initialPoolSize}" p:minPoolSize="${c3p0.minPoolSize}" p:maxPoolSize="${c3p0.maxPoolSize}" p:maxIdleTime="${c3p0.maxIdleTime}" p:idleConnectionTestPeriod="${c3p0.idleConnectionTestPeriod}" p:maxStatements="${c3p0.maxStatements}" p:numHelperThreads="${c3p0.numHelperThreads}" p:checkoutTimeout="${c3p0.checkoutTimeout}" destroy-method="close" /> <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean" p:dataSource-ref="dataSource" p:mappingLocations="classpath*:/com/eriloan/web/**/**/bo/*.hbm.xml"> <property name="hibernateProperties"> <props> <!-- C3P0 方式 (此节点配置是可选项，可以不用配置，有的配置覆盖了原生的配置，只是给出可以配置的项，使用 BoneCP配置的时候请注释掉) Begin--> <prop key="hibernate.connection.pool_size">${hibernate.connection.pool_size}</prop> <prop key="hibernate.c3p0.min_size">${hibernate.c3p0.min_size}</prop> <prop key="hibernate.c3p0.max_size">${hibernate.c3p0.max_size}</prop> <prop key="hibernate.c3p0.max_statements">${hibernate.c3p0.max_statements}</prop> <prop key="hibernate.c3p0.timeout">${hibernate.c3p0.timeout}</prop> <prop key="hibernate.c3p0.idle_test_period">${hibernate.c3p0.idle_test_period}</prop> <prop key="hibernate.c3p0.acquire_increment">${hibernate.c3p0.max_statements}</prop> <!-- C3P0 方式 End--> <prop key="hibernate.dialect">${hibernate.dialect}</prop> <prop key="hibernate.show_sql">${hibernate.show_sql}</prop> <prop key="hibernate.format_sql">${hibernate.format_sql}</prop> <prop key="hibernate.use_sql_comments">${hibernate.use_sql_comments}</prop> <prop key="hibernate.max_fetch_depth">${hibernate.max_fetch_depth}</prop> <prop key="hibernate.jdbc.batch_size">${hibernate.jdbc.batch_size}</prop> <prop key="hibernate.jdbc.fetch_size">${hibernate.jdbc.fetch_size}</prop> <!-- EhCache --> <prop key="hibernate.cache.use_query_cache">${hibernate.cache.use_query_cache}</prop> <prop key="hibernate.cache.provider_class">${hibernate.cache.provider_class}</prop> <prop key="hibernate.cache.region.factory_class">${hibernate.cache.region.factory_class}</prop> <prop key="hibernate.order_updates">${hibernate.order_updates}</prop> <prop key="hibernate.query.factory_class">${hibernate.query.factory_class}</prop> <prop key="hibernate.cache.use_second_level_cache">${hibernate.cache.use_second_level_cache}</prop> <prop key="hibernate.current_session_context_class">${hibernate.current_session_context_class}</prop> <!-- <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop> --> </props> </property> </bean> <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager" /> <bean id="transactionInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor" p:transactionManager-ref="transactionManager"> <property name="transactionAttributes"> <props> <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop> <prop key="find*">PROPAGATION_REQUIRED,readOnly</prop> <prop key="select*">PROPAGATION_REQUIRED,readOnly</prop> <prop key="query*">PROPAGATION_REQUIRED,readOnly</prop> <prop key="sync*">PROPAGATION_REQUIRED</prop> <prop key="finish*">PROPAGATION_REQUIRED</prop> <prop key="add*">PROPAGATION_REQUIRED</prop> <prop key="insert*">PROPAGATION_REQUIRED</prop> <prop key="edit*">PROPAGATION_REQUIRED</prop> <prop key="update*">PROPAGATION_REQUIRED</prop> <prop key="save*">PROPAGATION_REQUIRED</prop> <prop key="remove*">PROPAGATION_REQUIRED</prop> <prop key="delete*">PROPAGATION_REQUIRED</prop> <prop key="*">PROPAGATION_REQUIRED,-java.lang.Exception</prop> </props> </property> </bean> <bean id="ProxyCreator" class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator" p:beanNames="*Service,*ServiceImpl" p:interceptorNames="transactionInterceptor" /> <!-- 数据库操作Bean --> <bean id="dao" class="dao.DaoImpl" scope="singleton" /> <!-- 分页对象 --> <bean id="page" class="bo.PageEntity" scope="prototype" /> <!--Service 原始Bean --> <bean id="baseService" class="service.BaseServiceImpl" scope="singleton" /> <!--Action 原始Bean --> <bean id="baseAction" class="action.BaseAction" scope="prototype" /> </beans>SpringBean配置文件（applicationContext-beans.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:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:p="http://www.springframework.org/schema/p" xmlns:util="http://www.springframework.org/schema/util" xmlns:tool="http://www.springframework.org/schema/tool" xmlns:context="http://www.springframework.org/schema/context" 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/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd http://www.springframework.org/schema/tool http://www.springframework.org/schema/tool/spring-tool.xsd" default-lazy-init="true" default-autowire="byName" > <!-- Test Bean By Eric Shi --> <bean id="testService" class="com.eriloan.web.test.service.impl.TestServiceImpl" scope="singleton" /> <bean id="testAction" class="com.eriloan.web.test.action.TestAction" scope="prototype" /> </beans>
Struts2 配置主配置文件（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> <include file="struts-default.xml" /> <!-- 默认的配置包 --> <package name="defaultPackage" extends="struts-default,json-default,jfreechart-default,spring-default"> <global-results> <!-- 公用返回页面 --> <result name="error" type="dispatcher">/errorPage/index.jsp</result> <result name="login" type="dispatcher">/login.jsp</result> <result name="defaultLogin" type="redirect">/quitSys.jsp</result> <result name="loginOut" type="redirect">/loginAction!loginPage.action </result> <result name="ajaxJson" type="json"> <param name="contentType">text/html</param> <param name="root">ajax_json</param> </result> <!-- 异常返回页面 --> <result name="actionException" type="dispatcher">/WEB-INF/errorPage/ServiceException.jsp </result> <result name="serviceException" type="dispatcher">/WEB-INF/errorPage/ServiceException.jsp </result> <result name="daoException" type="dispatcher">/WEB-INF/errorPage/ServiceException.jsp </result> <result name="exception" type="dispatcher">/WEB-INF/errorPage/ServiceException.jsp </result> </global-results> <!-- 异常处理 --> <global-exception-mappings> <!-- Action 层异常处理 --> <exception-mapping result="actionException" exception="system.exception.ActionException" /> <!-- Service 层异常处理 --> <exception-mapping result="serviceException" exception="system.exception.ServiceException" /> <!-- DAO 层异常处理 --> <exception-mapping result="daoException" exception="system.exception.DaoException" /> <!-- 未知的系统异常，后台没有对此信息进行归类 --> <exception-mapping result="exception" exception="java.lang.Exception" /> </global-exception-mappings> </package> <!--前台调用静态方法--> <!-- <constant name="struts.ognl.allowStaticMethodAccess" value="true"></constant> --> <!-- Test by Eric --> <include file="/struts-config/test/test_Struts.xml" /> </struts>
Struts 2业务配置文件（test_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> <package name="testPackage" extends="defaultPackage"> <action name="testAction" class="testAction"> <!--Test Path--> <result name="gotoTestPage" type="dispatcher">/page/test/testPage.jsp</result> </action> </package> </struts>
Struts2 属性配置文件（struts.properties）： struts.devMode=true struts.action.extension=action struts.objectFactory = spring struts.objectFactory.spring.autoWire = name struts.objectFactory.spring.useClassCache = true struts.objectFactory.spring.autoWire.alwaysRespect = true struts.configuration.xml.reload=true struts.i18n.encoding = utf-8 struts.tag.altSyntax=true struts.custom.i18n.resources=Eriloan_Text struts.locale=zh_CN struts.ui.theme = simple struts.ognl.allowStaticMethodAccess=true struts.multipart.maxSize=10000000000 #struts2.sslplugin.httpPort=8080 #struts2.sslplugin.httpsPort=8443 #struts2.sslplugin.annotations=true #struts.multipart.parser=cos #struts.multipart.parser=pell struts.multipart.parser=jakarta struts.multipart.saveDir=tempUpload
数据库配置文件 更新增加C3P0和EhCache配置：
#MySQL配置 hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect #hibernate.dialect=org.hibernate.dialect.MySQL5Dialect #hibernate.dialect=org.hibernate.dialect.MySQLDialect jdbc.url=jdbc:mysql://localhost:3306/app_eriloan?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull jdbc.driver=com.mysql.jdbc.Driver jdbc.username=root jdbc.password=eric hibernate.show_sql=true hibernate.format_sql=false hibernate.use_sql_comments=false hibernate.cache.use_second_level_cache=false #EhCache hibernate.cache.use_query_cache=false hibernate.cache.provider_class=net.sf.ehcache.hibernate.EhCacheProvider hibernate.cache.region.factory_class=org.hibernate.cache.ehcache.EhCacheRegionFactory hibernate.hbm2ddl.auto=update hibernate.order_updates=true hibernate.jdbc.batch_size=30 hibernate.jdbc.fetch_size=100 hibernate.max_fetch_depth=2 #Hibernate4 C3P0 hibernate.connection.pool_size=5 hibernate.c3p0.min_size=5 hibernate.c3p0.max_size=200 hibernate.c3p0.timeout=2000 hibernate.c3p0.idle_test_period=10 hibernate.c3p0.acquire_increment=5 hibernate.c3p0.max_statements=50 #hibernate4.0事务的模式 #1:org.hibernate.context.internal.ThreadLocalSessionContext - 当前session通过当前执行的线程来跟踪和界定。 #2:org.hibernate.context.internal.JTASessionContext - 当前session根据JTA来跟踪和界定。这和以前的仅支持JTA的方法是完全一样的。 #3:org.hibernate.context.internal.ManagedSessionContext #4:org.springframework.orm.hibernate4.SpringSessionContext - spring的事务管理。 hibernate.current_session_context_class=org.springframework.orm.hibernate4.SpringSessionContext #Hibernate4.0的查询翻译器： hibernate.query.factory_class=org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory #Hibernate3.0的查询翻译器： #hibernate.query.factory_class=org.hibernate.hql.ast.ASTQueryTranslatorFactory #Hibernate2.1的查询翻译器 #hibernate.query.factory_class=org.hibernate.hql.classic.ClassicQueryTranslatorFactory #Connection Pooling #acquireIncrement: 当连接池中的连接耗尽的时候一次同时获取的连接数。Default: 3 #idleConnectionTestPeriod:检查数据库连接池中控线连接的间隔时间，单位是分，默认值：240，如果要取消则设置为0 #idleMaxAge:连接池中未使用的链接最大存活时间，单位是分，默认值：60，如果要永远存活设置为0 #maxConnectionsPerPartition:每个分区最大的连接数 #minConnectionsPerPartition:每个分区最小的连接数 #partitionCount:分区数，默认值2，最小1，推荐3-4，视应用而定 #acquireIncrement:每次去拿数据库连接的时候一次性要拿几个，默认值：2 #statementsCacheSize:缓存prepared statements的大小，默认值：0 #releaseHelperThreads:每个分区释放链接助理进程的数量，默认值：3，除非你的一个数据库连接的时间内做了很多工作，不然过多的助理进程会影响你的性能 #BoneCP bonecp.minPoolSize=5 bonecp.maxPoolSize=20 bonecp.maxIdleTime=1800 bonecp.idleConnectionTestPeriodInMinutes=240 bonecp.maxStatements=0 bonecp.idleMaxAgeInMinutes=240 bonecp.maxConnectionsPerPartition=30 bonecp.minConnectionsPerPartition=5 bonecp.partitionCount=3 bonecp.acquireIncrement=5 bonecp.statementsCacheSize=50 bonecp.releaseHelperThreads=2 bonecp.disableConnectionTracking=true #C3P0 c3p0.acquireIncrement=10 c3p0.initialPoolSize=15 c3p0.minPoolSize=30 c3p0.maxPoolSize=120 c3p0.maxIdleTime=30 c3p0.idleConnectionTestPeriod=30 c3p0.maxStatements=0 c3p0.numHelperThreads=100 c3p0.checkoutTimeout=0 c3p0.validate=true
Dao代码：
IHqlProviderSet实现：
517
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
