- 浏览: 48113 次
- 性别:
- 来自: 深圳
-
文章分类
最新评论
1、配置数据库文件dbconfig.properties
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost/mallDBE?useUnicode=true&characterEncoding=utf-8
jdbc.urlCenter=jdbc:mysql://localhost/mallDB?useUnicode=true&characterEncoding=utf-8
#jdbc.url=jdbc:mysql://220.231.152.176:3418/mallDBE?useUnicode=true&characterEncoding=utf-8
jdbc.username=dingDang
jdbc.password=dingdang
#jdbc.username=mall
#jdbc.password=d4#2dk*sd
jdbc.minConnections=10
jdbc.maxConnections=300
#jdbc.driverClassName=net.sourceforge.jtds.jdbc.Driver
#jdbc.url=jdbc:jtds:sqlserver://192.168.16.226:1433/dingDang;tds=8.0;lastupdatecount=true
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
hibernate.cache.use_second_level_cache=true
#hibernate.dialect=com.dingDang.mall.dao.dialect.SQLServerDialectInDingDang
#messageSource
messageSource.cacheSeconds=-1
2、依赖注入配置信息spring-resources.xml
<!-- Default DBCP datasource -->
<bean id="dbcpDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" lazy-init="false">
<property name="driverClassName" value="${jdbc.driverClassName}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<property name="initialSize" value="${jdbc.minConnections}"/>
<property name="maxActive" value="${jdbc.maxConnections}"/>
<property name="maxIdle" value="100"/>
<property name="minIdle" value="${jdbc.minConnections}"/>
<property name="maxWait" value="5000"/>
<property name="defaultAutoCommit" value="true"/>
<property name="removeAbandoned" value="true"/>
<property name="removeAbandonedTimeout" value="300"/>
<property name="logAbandoned" value="false"/>
<property name="poolPreparedStatements" value="true"/>
<property name="testWhileIdle" value="true"/>
<property name="validationQuery" value="select count(*) from app_role where 1=0"/>
</bean>
<bean id="dataSource" class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy" lazy-init="false">
<property name="targetDataSource" ref="dbcpDataSource" />
</bean>
<!-- the center of user database control -->
<bean id="ct_DbcpDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" lazy-init="false">
<property name="driverClassName" value="${jdbc.driverClassName}"/>
<property name="url" value="${jdbc.urlCenter}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<property name="initialSize" value="${jdbc.minConnections}"/>
<property name="maxActive" value="${jdbc.maxConnections}"/>
<property name="maxIdle" value="100"/>
<property name="minIdle" value="${jdbc.minConnections}"/>
<property name="maxWait" value="5000"/>
<property name="defaultAutoCommit" value="true"/>
<property name="removeAbandoned" value="true"/>
<property name="removeAbandonedTimeout" value="300"/>
<property name="logAbandoned" value="false"/>
<property name="poolPreparedStatements" value="true"/>
<property name="testWhileIdle" value="true"/>
<property name="validationQuery" value="select count(*) from app_role where 1=0"/>
</bean>
<bean id="ct_DataSource" class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy" lazy-init="false">
<property name="targetDataSource" ref="ct_DbcpDataSource" />
</bean>
3、hibernate配置文件spring-hibernate.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">
<beans>
<!-- Hibernate SessionFactory -->
<bean id="sessionFactory" class="com.dingDang.mall.core.hibernate.LocalSessionFactoryBean" lazy-init="false">
<property name="dataSource" ref="dataSource" />
<property name="lobHandler">
<bean class="org.springframework.jdbc.support.lob.DefaultLobHandler" lazy-init="true" />
</property>
<!-- I tried cacheableMappingLocations but it turned out to be more slow. -->
<property name="mappingLocations">
<list>
<value>classpath*:com/dingDang/mall/**/*.hbm.xml</value>
<!-- <value>classpath*:org/jbpm/**/*.hbm.xml</value> -->
</list>
</property>
<!-- Create/update the database tables automatically when the JVM starts up -->
<!-- <property name="schemaUpdate" value="true"/> -->
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.jdbc.batch_size">10</prop>
<prop key="hibernate.default_batch_fetch_size">10</prop>
<prop key="hibernate.jdbc.batch_versioned_data">true</prop>
<prop key="hibernate.jdbc.fetch_size">10</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.default_entity_mode">pojo</prop>
<prop key="hibernate.generate_statistics">false</prop>
<prop key="hibernate.max_fetch_depth">3</prop>
<prop key="hibernate.cache.provider_class">net.sf.ehcache.hibernate.EhCacheProvider</prop>
<prop key="net.sf.ehcache.configurationResourceName">conf/ehcache.xml</prop>
<!-- Note, you can turn off hibernate caching by setting it to be false -->
<prop key="hibernate.cache.use_second_level_cache">${hibernate.cache.use_second_level_cache}</prop>
<prop key="hibernate.cache.use_query_cache">false</prop>
</props>
</property>
<property name="entityCacheStrategies">
<props>
<prop key="com.dingDang.mall.common.model.system.Membership">nonstrict-read-write</prop>
<prop key="com.dingDang.mall.common.model.catalog.Attribute">nonstrict-read-write</prop>
<prop key="com.dingDang.mall.common.model.system.MetricType">nonstrict-read-write</prop>
<prop key="com.dingDang.mall.common.model.system.MetricUnit">nonstrict-read-write</prop>
<prop key="com.dingDang.mall.common.model.catalog.Department">nonstrict-read-write</prop>
<prop key="com.dingDang.mall.common.model.catalog.Manufacturer">nonstrict-read-write</prop>
<prop key="com.dingDang.mall.common.model.sales.CouponType">nonstrict-read-write</prop>
<prop key="com.dingDang.mall.common.model.sales.RecommendedType">nonstrict-read-write</prop>
</props>
</property>
</bean>
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
<property name="defaultTimeout" value="30" />
</bean>
<!-- Hibernate SessionFactory -->
<bean id="Ct_SessionFactory" class="com.dingDang.mall.core.hibernate.LocalSessionFactoryBean" lazy-init="false">
<property name="dataSource" ref="ct_DataSource" />
<property name="lobHandler">
<bean class="org.springframework.jdbc.support.lob.DefaultLobHandler" lazy-init="true" />
</property>
<property name="mappingLocations">
<list><value>classpath*:outSystem/mytest/*.hbm.xml</value></list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.jdbc.batch_size">10</prop>
<prop key="hibernate.default_batch_fetch_size">10</prop>
<prop key="hibernate.jdbc.batch_versioned_data">true</prop>
<prop key="hibernate.jdbc.fetch_size">10</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.default_entity_mode">pojo</prop>
<prop key="hibernate.generate_statistics">false</prop>
<prop key="hibernate.max_fetch_depth">3</prop>
<prop key="hibernate.cache.provider_class">net.sf.ehcache.hibernate.EhCacheProvider</prop>
<prop key="net.sf.ehcache.configurationResourceName">conf/ehcache.xml</prop>
<!-- Note, you can turn off hibernate caching by setting it to be false -->
<prop key="hibernate.cache.use_second_level_cache">${hibernate.cache.use_second_level_cache}</prop>
<prop key="hibernate.cache.use_query_cache">false</prop>
</props>
</property>
</bean>
<bean id="ct_TransactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="Ct_SessionFactory" />
<property name="defaultTimeout" value="30" />
</bean>
</beans>
5、配置sprinDAO文件spring-dao.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">
<beans default-lazy-init="true">
<!-- create two Hibernate based DAOs , that's refer two database -->
<bean id="hibernateGenericDao" class="com.dingDang.mall.core.dao.impl.HibernateGenericDaoImpl" abstract="true">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
<bean id="ct_HibernateGenericDao" class="com.dingDang.mall.core.dao.impl.HibernateGenericDaoImpl" abstract="true">
<property name="sessionFactory" ref="Ct_SessionFactory" />
</bean>
<!-- Add new DAOs here -->
<!-- ========================= Start of Normal DAO DEFINITIONS ========================= -->
<!-- Note that all must extend the base definition of genericDAO.-->
<bean id="userDAO" class="com.dingDang.mall.system.dao.impl.UserDAOImpl" parent="hibernateGenericDao"/>
<bean id="testDAO" class="com.dingDang.mall.system.dao.impl.TestDAOImpl" parent="ct_hibernateGenericDao"/>
</bean><!-- 注意不同的数据库对应不同的parent DAO -->
6、配置springManager文件spring-manager.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">
<beans default-lazy-init="true">
<!-- Transaction template for all Managers -->
<bean id="txProxyTemplate" abstract="true" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager" ref="transactionManager" />
<property name="transactionAttributes">
<props>
<prop key="set*">PROPAGATION_NOT_SUPPORTED,readOnly</prop>
<prop key="get*">PROPAGATION_SUPPORTS,readOnly</prop>
<prop key="is*">PROPAGATION_SUPPORTS,readOnly</prop>
<prop key="find*">PROPAGATION_SUPPORTS,readOnly</prop>
<prop key="search*">PROPAGATION_SUPPORTS,readOnly</prop>
<prop key="load*">PROPAGATION_SUPPORTS,readOnly</prop>
<prop key="save*">PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED</prop>
<prop key="update*">PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED</prop>
<prop key="create*">PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED</prop>
<prop key="add*">PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED</prop>
<prop key="remove*">PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED</prop>
<prop key="delete*">PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED</prop>
<prop key="do*">PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED</prop>
<prop key="*">PROPAGATION_SUPPORTS</prop>
</props>
</property>
</bean>
<bean id="ct_TxProxyTemplate" abstract="true" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager" ref="ct_TransactionManager" />
<property name="transactionAttributes">
<props>
<prop key="set*">PROPAGATION_NOT_SUPPORTED,readOnly</prop>
<prop key="get*">PROPAGATION_SUPPORTS,readOnly</prop>
<prop key="is*">PROPAGATION_SUPPORTS,readOnly</prop>
<prop key="find*">PROPAGATION_SUPPORTS,readOnly</prop>
<prop key="search*">PROPAGATION_SUPPORTS,readOnly</prop>
<prop key="load*">PROPAGATION_SUPPORTS,readOnly</prop>
<prop key="save*">PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED</prop>
<prop key="update*">PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED</prop>
<prop key="create*">PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED</prop>
<prop key="add*">PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED</prop>
<prop key="remove*">PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED</prop>
<prop key="delete*">PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED</prop>
<prop key="do*">PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED</prop>
<prop key="*">PROPAGATION_SUPPORTS</prop>
</props>
</property>
</bean>
</bean><!-- 不同数据库的manager对应不同的 managerbase -->
发表评论
相关推荐
简单实现图书的修改和删除功能，可以自己添加其他功能 数据库为mysql 表在压缩包里有，可以自己附加，库名为test 具体说明详见里面的 说明.txt
现在的结构是，Struts负责显示层，Hibernate负责持久层，Spring负责中间的业务层，另外，由于Spring使用的依赖注射以及AOP(面向方面编程)，所以它的这种内部模式非常优秀，以至于Spring自己也实现了一个使用依赖注射...
博文链接：https://sydxide2006.iteye.com/blog/127824
基于Hibernate+Spring+Spring MVC+Bootstrap的管理系统实现，内含有可直接运行的源代码以及数据库文件。由于项目中jar包过大，所以将源代码放在了百度网盘中，请根据文件中的链接以及提取码，下载源码。
java\SFS\spring\hibernate\mysql
spring+springMVC+mybatis+struts2+jdbc+hibernate 全面集成 此框架本人花费2天时间完成 工作中请勿配置如此多元化框架 框架的意义是为了让代码风格统一 此框架是为了学习 作为参考 jdbc.properties为数据库链接参数...
HibernateSHibernateSpring数据库的事务HibernateSpring数据库的事务HibernateSpring数据库的事务pring数据库的事务
网上商城源代码（JSP + Struts+ hibernate + spring + mysql）附带链接网上银行代码 这是我今年年初做练习时做的一个网上商城项目，基本上的功能都有 主要实现用户网上购物。主要提供了用户注册、登录、个人信息...
本项目适用移动端和电脑端，在页面上点击链接切换即可 论坛主页：http://localhost:8080/bbs/ 管理页面主页：http://localhost:8080/bbs/admin/ 用户： cc2019/111111 tt2019/123456 javaee/123456(管理员)
5、spring：3.1.1 hibernate：4.1.6 Hibernate-JPA：2.0 6、若更换数据库后代码有误，无法调通，请先运行com.web.test代码调试数据库配置，运行测试，数据库调通再运行com.web.mvc下的controller。 7、附带的另一...
后台框架：Spring、SpringMVC、MyBatis UI界面：BootStrap、H-ui 、JSP 数据库：MySQL 运行环境： JDK 8 Eclipse Tomcat 7.0 MySQL 5.5 三、系统功能 系统分为前台订餐和后台管理： 1.前台订餐 用户注册...
（1）MySql 数据库是否是utf-8 格式(在安装时选择支持多语言)，数据是否正常。 （2）项目是否为utf-8格式(同时看看的源代码文件中，中文是否乱码)。 （3）JSP页面是否是utf-8 格式。 （4）在web.xml 是否配置了编码...
框架整合Spring MVC3.23+Spring3.23+Hibernate4.2.3+Activiti5.16.3，三层架构dao,service,controller，使用proxool连接池（已配置好监听器），默认链接mysql数据库。可根据项目开发需要，做适当修改，各项配置齐全...
今天在这里分享一个当初给学弟学妹做的毕业设计，系统功能完整，改改完全能用于毕业设计，数据库齐全，初始链接密码为root,配置数据库在applicationContext.xml里
程序测试环境： MyEclipse8.5编程软件 + Win7操作系统 + MySql5.0数据库 本系统使用Struts2.0 + Spring2.0 +Hibernate 3.2 （即:SSH）及以上版本架构整合模式开发 本系统作为学生学习SSH很有参考价值，实现了图书...
含文档，系统功能完整，数据库齐全，初始链接密码为root,配置数据库在applicationContext.xml里 后台管理员，可以自己添加设置，初始为：admin,admin localhost:8080/sypt
目前有角色权限管理功能。登陆页面改天完善。目前是个链接。里面的技术包括junit，生成api，ant。数据库是mysql。 功能说明：登陆系统时，不同的角色不同的权限