Spring+Hibernate双数据源测试Mysql集群读写分离(转自http://blog.csdn.net/hzw2312/article/details/9083519)
来源:互联网 发布:用友nc系统java插件 编辑:程序博客网 时间:2024/06/06 01:37
进行测试!环境就是SH框架、当然这只是一个简单的测试!
准备环境就是Spring框架跟Hibernate框架的整合!
然后在Spring配置文件中配置两个数据源、这里我采用的是从c3po数据源配置:
注:配置文件中的url里面要加"&"符号的话得这样写"&"
- <span style="font-size:14px;"><?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"
- xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
- <!-- 读 -->
- <!--<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< -->
- <!-- 定义数据源Bean,使用C3P0数据源实现 -->
- <bean id="dataSourceR" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
- <!-- 指定连接数据库的驱动 -->
- <property name="driverClass" value="com.mysql.jdbc.Driver"/>
- <!-- 指定连接数据库的URL -->
- <property name="jdbcUrl" value="jdbc:mysql:loadbalance://10.11.0.75,172.16.0.202:3306/DB_TEST7?roundRobinLoadBalance=true&characterEncoding=UTF-8"/>
- <!-- 指定连接数据库的用户名 -->
- <property name="user" value="TESTUSER"/>
- <!-- 指定连接数据库的密码 -->
- <property name="password" value="TESTPWD"/>
- <!-- 指定连接数据库连接池的最大连接数 -->
- <property name="maxPoolSize" value="20"/>
- <!-- 指定连接数据库连接池的最小连接数 -->
- <property name="minPoolSize" value="1"/>
- <!-- 指定连接数据库连接池的初始化连接数 -->
- <property name="initialPoolSize" value="1"/>
- <!-- 指定连接数据库连接池的连接的最大空闲时间 -->
- <property name="maxIdleTime" value="20"/>
- </bean>
- <!--定义了Hibernate的SessionFactory -->
- <bean id="sessionFactoryR" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
- <property name="dataSource" ref="dataSourceR"/>
- <property name="mappingResources">
- <list>
- </list>
- </property>
- <property name="hibernateProperties">
- <props>
- <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
- <prop key="show_sql">true</prop>
- <prop key="hibernate.hbm2ddl.auto">update</prop>
- <prop key="hibernate.jdbc.batch_size">20</prop>
- </props>
- </property>
- </bean>
- <bean id="transactionManagerR" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
- <property name="sessionFactory" ref="sessionFactoryR"/>
- </bean>
- <bean id="transactionInterceptorR" class="org.springframework.transaction.interceptor.TransactionInterceptor">
- <!-- 事务拦截器bean需要依赖注入一个事务管理器 -->
- <property name="transactionManager" ref="transactionManagerR"/>
- <property name="transactionAttributes">
- <!-- 下面定义事务传播属性-->
- <props>
- <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
- <prop key="find*">PROPAGATION_REQUIRED,readOnly</prop>
- </props>
- </property>
- </bean>
- <bean id="daoR" class="com.boxun.test.dao.impl.daoR" >
- <property name="sessionFactory">
- <ref bean="sessionFactoryR" />
- </property>
- </bean>
- <!-- 写 -->
- <bean id="dataSourceW" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
- <!-- 指定连接数据库的驱动 -->
- <property name="driverClass" value="com.mysql.jdbc.Driver"/>
- <!-- 指定连接数据库的URL -->
- <property name="jdbcUrl" value="jdbc:mysql:loadbalance://10.11.2.126:3306/DB_TEST7?roundRobinLoadBalance=true&characterEncoding=UTF-8"/>
- <!-- 指定连接数据库的用户名 -->
- <property name="user" value="TESTUSER"/>
- <!-- 指定连接数据库的密码 -->
- <property name="password" value="TESTPWD"/>
- <!-- 指定连接数据库连接池的最大连接数 -->
- <property name="maxPoolSize" value="20"/>
- <!-- 指定连接数据库连接池的最小连接数 -->
- <property name="minPoolSize" value="1"/>
- <!-- 指定连接数据库连接池的初始化连接数 -->
- <property name="initialPoolSize" value="1"/>
- <!-- 指定连接数据库连接池的连接的最大空闲时间 -->
- <property name="maxIdleTime" value="20"/>
- </bean>
- <!--定义了Hibernate的SessionFactory -->
- <bean id="sessionFactoryW" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
- <property name="dataSource" ref="dataSourceW"/>
- <property name="mappingResources">
- <list>
- </list>
- </property>
- <property name="hibernateProperties">
- <props>
- <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
- <prop key="show_sql">true</prop>
- <prop key="hibernate.hbm2ddl.auto">update</prop>
- <prop key="hibernate.jdbc.batch_size">20</prop>
- </props>
- </property>
- </bean>
- <bean id="transactionManagerW" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
- <property name="sessionFactory" ref="sessionFactoryW"/>
- </bean>
- <bean id="transactionInterceptorW" class="org.springframework.transaction.interceptor.TransactionInterceptor">
- <!-- 事务拦截器bean需要依赖注入一个事务管理器 -->
- <property name="transactionManager" ref="transactionManagerW"/>
- <property name="transactionAttributes">
- <!-- 下面定义事务传播属性-->
- <props>
- <prop key="*">PROPAGATION_REQUIRED</prop>
- </props>
- </property>
- </bean>
- <bean id="daoW" class="com.boxun.test.dao.impl.daoW" >
- <property name="sessionFactory">
- <ref bean="sessionFactoryW" />
- </property>
- </bean>
- </beans></span>
- <span style="font-size:14px;">public class daoR extends HibernateDaoSupport implements IdaoR{
- private Query query = null;
- public List find(String sql){
- query = super.getSession().createSQLQuery(sql);
- return query.list();
- }
- }
- </span>
写的Dao:
- <span style="font-size:14px;">public class daoW extends HibernateDaoSupport implements IdaoW{
- private Query query = null;
- public void save(String sql){
- Transaction t = super.getSession().beginTransaction();
- query = super.getSession().createSQLQuery(sql);
- query.executeUpdate();
- t.commit();
- }
- }</span>
测试main方法:
- <span style="font-size:14px;">public class Test {
- public static void main(String[] args) {
- ApplicationContext context=new FileSystemXmlApplicationContext("/WebRoot/WEB-INF/classes/applicationContext.xml");
- IdaoR daor =(IdaoR) context.getBean("daoR");
- IdaoW daow =(IdaoW) context.getBean("daoW");
- daow.save("insert into city(sname) values('Spring双数据源')");
- List list = daor.find("select * from city where sname = 'Spring双数据源'");
- for (int i = 0; i < list.size(); i++) {
- Object[] obj = (Object[])list.get(i);
- System.out.println(obj[0]+" --- "+obj[1]);
- }
- }
- } </span>
输出:
- <span style="font-size:14px;">log4j:WARN No appenders could be found for logger (org.springframework.context.support.FileSystemXmlApplicationContext).
- log4j:WARN Please initialize the log4j system properly.
- 5 --- Spring双数据源</span>
测试成功!!!
0 0
- Spring+Hibernate双数据源测试Mysql集群读写分离(转自http://blog.csdn.net/hzw2312/article/details/9083519)
- Spring+Hibernate双数据源测试Mysql集群读写分离
- Spring+Hibernate双数据源测试Mysql集群读写分离
- Spring+mongodb集群集成(吐血教程) 转自:http://blog.csdn.net/qq_16497617/article/details/52817335
- Spring+Hibernate进行双数据源测试Mysql集群读写分离
- 如何用c#读写配置文件(转自:http://blog.csdn.net/lanman/article/details/5287717)
- 转自 http://blog.csdn.net/coollofty/article/details/8058859
- 转自http://blog.csdn.net/rookieding/article/details/7639898
- 转自http://blog.csdn.net/mazhaojuan/article/details/7660657
- 转自: http://blog.csdn.net/ahuier/article/details/8982516
- 转自: http://blog.csdn.net/xiaxiaorui2003/article/details/3838631
- 转自 http://blog.csdn.net/gnehcuoz/article/details/52686824
- 转自 http://blog.csdn.net/g_brightboy/article/details/14229139
- Hibernate对象三种状态详细分析(转自http://blog.csdn.net/redarmy_chen/article/details/7069482)
- Android开源工具项目集合转自http://blog.csdn.net/qq_16131393/article/details/51465538
- C# 选择文件对话框(转自:http://blog.csdn.net/longest9/article/details/1567929)
- VS2008提示jquery(转自:http://blog.csdn.net/wanglong7505/article/details/6307126)
- 140个Google面试问题(转自http://blog.csdn.net/bopgroup/article/details/6514423)
- echo 输出中文
- VBScript 中的 "+" 和 "&" 连接字符串的区别
- 关于32位机大文件写测试
- FFMpeg介绍
- IAR 的精确延时程序
- Spring+Hibernate双数据源测试Mysql集群读写分离(转自http://blog.csdn.net/hzw2312/article/details/9083519)
- 哟西 今天第一天
- SharePoint 2010/2013 使用Javascript 动态添加Ribbon 按钮
- 【算法之道】之字符串逆序输出
- 关于WinFrom 中 label背景透明的那点事
- 聚集索引和非聚集索引(整理)
- TestNG + Eclipse
- tomcat配置https
- 不错的JQuery屏幕居中提示信息封装,使用方便,可集成到项目