Spring3.1.2与Hibernate4.1.8整合
整合Spring3.1.2 与 Hibernate 4.1.8
首先准备整合jar:
Spring3.1.2:
org.springframework.aop-3.1.2.RELEASE.jar
org.springframework.asm-3.1.2.RELEASE.jar
org.springframework.aspects-3.1.2.RELEASE.jar
org.springframework.beans-3.1.2.RELEASE.jar
org.springframework.context.support-3.1.2.RELEASE.jar
org.springframework.context-3.1.2.RELEASE.jar
org.springframework.core-3.1.2.RELEASE.jar
org.springframework.expression-3.1.2.RELEASE.jar(使用表达式${})
org.springframework.jdbc-3.1.2.RELEASE.jar
org.springframework.orm-3.1.2.RELEASE.jar
org.springframework.transaction-3.1.2.RELEASE.jar
Hibernate4.1.8:
--------------required下面---------------
antlr-2.7.7.jar
dom4j-1.6.1.jar
hibernate-commons-annotations-4.0.1.Final.jar
hibernate-core-4.1.8.Final.jar
hibernate-jpa-2.0-api-1.0.1.Final.jar
javassist-3.15.0-GA.jar
jboss-logging-3.1.0.GA.jar
jboss-transaction-api_1.1_spec-1.0.0.Final.jar
----------------------------
-----proxool-------
proxool-0.9.1.jar
proxool-cglib.jar
其他依赖包
aopalliance-1.0.jar
aspectjrt-1.7.0.jar
aspectjweaver-1.7.0.jar
commons-logging-1.1.1.jar
--数据库
mysql-connector-java-5.1.21.jar
整合示例:
UserModel:
- UserModel:
- package cn.sh.model;
- public class UserModel {
- private int id;
- private String username;
- private String password;
- --------getter & setter------
- }
user.hbm.xml
- <?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE hibernate-mapping PUBLIC
- "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
- "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
- <hibernate-mapping>
- <class name="cn.sh.model.UserModel" table="user">
- <id name="id" column="id">
- <generator class="native" />
- </id>
- <property name="username" column="username" />
- <property name="password" column="password" />
- </class>
- </hibernate-mapping>
resources/jdbc.properties:
- proxool.maxConnCount=10
- proxool.minConnCount=5
- proxool.statistics=1m,15m,1h,1d
- proxool.simultaneousBuildThrottle=30
- proxool.trace=false
- jdbc.driverClassName=com.mysql.jdbc.Driver
- jdbc.url=jdbc:mysql://localhost:3306/ssh
- jdbc.username=root
- jdbc.password=admin
resources/applicationContext-common.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"
- xsi:schemaLocation="http://www.springframework.org/schema/beans
- http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
- http://www.springframework.org/schema/tx
- http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
- http://www.springframework.org/schema/aop
- http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">
- <!-- 引入配置文件 -->
- <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
- <property name="locations">
- <list>
- <value>classpath:jdbc.properties</value>
- </list>
- </property>
- </bean>
- <!-- 数据源 -->
- <bean id="dataSource" class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy">
- <property name="targetDataSource">
- <bean class="org.logicalcobwebs.proxool.ProxoolDataSource">
- <property name="driver" value="${jdbc.driverClassName}" />
- <property name="driverUrl" value="${jdbc.url}" />
- <property name="user" value="${jdbc.username}" />
- <property name="password" value="${jdbc.password}" />
- <property name="maximumConnectionCount" value="${proxool.maxConnCount}" />
- <property name="minimumConnectionCount" value="${proxool.minConnCount}" />
- <property name="statistics" value="${proxool.statistics}" />
- <property name="simultaneousBuildThrottle" value="${proxool.simultaneousBuildThrottle}" />
- <property name="trace" value="${proxool.trace}" />
- </bean>
- </property>
- </bean>
- <!-- -->
- <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
- <property name="dataSource" ref="dataSource" />
- <property name="mappingResources">
- <list>
- <value>cn/sh/model/user.hbm.xml</value>
- </list>
- </property>
- <property name="hibernateProperties">
- <value>
- hibernate.dialect=org.hibernate.dialect.HSQLDialect
- hibernate.show_sql=true
- </value>
- </property>
- </bean>
- <!-- 声明式事务 -->
- <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
- <property name="sessionFactory" ref="sessionFactory" />
- </bean>
- <aop:config>
- <aop:pointcut id="productServiceMethods" expression="execution(* cn.sh.service..*.*(..))" />
- <aop:advisor advice-ref="txAdvice" pointcut-ref="productServiceMethods" />
- </aop:config>
- <tx:advice id="txAdvice" transaction-manager="transactionManager">
- <tx:attributes>
- <tx:method name="increasePrice*" propagation="REQUIRED" />
- <tx:method name="someOtherBusinessMethod" propagation="REQUIRES_NEW" />
- <tx:method name="*" propagation="SUPPORTS" read-only="true" />
- </tx:attributes>
- </tx:advice>
- </beans>
整合测试:
- public class SpringHibernateTest {
- private SessionFactory sessionFactory;
- private ApplicationContext ctx;
- @Before
- public void setUp() {
- String[] configLocations = new String[] {"classpath:applicationContext-*.xml"};
- ctx = new ClassPathXmlApplicationContext(configLocations);
- sessionFactory = ctx.getBean("sessionFactory", SessionFactory.class);
- }
- @Test
- public void testSessionFactory(){
- System.out.println(sessionFactory);
- System.out.println(ctx.getBean("dataSource"));
- Session session = sessionFactory.openSession();
- UserModel model = new UserModel();
- model.setUsername("wangwu");
- model.setPassword("123456");
- session.save(model);
- }
- }