81,094
社区成员
发帖
与我相关
我的任务
分享
<?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" xmlns:jee="http://www.springframework.org/schema/jee" xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-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/jee
http://www.springframework.org/schema/jee/spring-jee-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd">
<context:component-scan base-package="com.mdao">
<context:exclude-filter type="regex" expression="com\.mdao\.framework\.persistence\.hibernate\.Hibernate.*Dao" />
</context:component-scan>
<aop:aspectj-autoproxy />
<tx:annotation-driven transaction-manager="jahwaTxManager" />
<bean id="dataSource" name="emapDataSource" class="com.mdao.framework.database.DbcpDataSource" destroy-method="close">
<property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver" />
<property name="url" value="jdbc:jtds:sqlserver://192.168.1.10:1433;DatabaseName=emap8" />
<property name="username" value="devadmin" />
<property name="password" value="d123abc" />
<property name="initialSize" value="10" />
<property name="testOnBorrow" value="true" />
<property name="testOnReturn" value="true" />
<property name="testWhileIdle" value="true" />
<property name="validationQuery" value="select 1" />
<property name="validationQueryTimeout" value="10" />
</bean>
<bean name="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="mappingLocations">
<list>
<value>classpath*:mapping/**/*.hbm.xml</value>
<value>classpath*:com/mdao/emap/**/*.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<value>
hibernate.dialect=${hibernate.dialect}
hibernate.show_sql=false
hibernate.format_sql=true
hibernate.cache.use_second_level_cache=false
hibernate.cache.provider_class=org.hibernate.cache.NoCacheProvider
hibernate.cache.use_structured_entries=true
</value>
</property>
</bean>
<bean id="jahwaDataSource" class="com.mdao.framework.database.DbcpDataSource" destroy-method="close">
<property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver" />
<property name="url" value="jdbc:jtds:sqlserver://192.168.1.10:1433;DatabaseName=jahwa" />
<property name="username" value="devadmin" />
<property name="password" value="d123abc" />
<property name="initialSize" value="10" />
<property name="testOnBorrow" value="true" />
<property name="testOnReturn" value="true" />
<property name="testWhileIdle" value="true" />
<property name="validationQuery" value="select 1" />
<property name="validationQueryTimeout" value="10" />
</bean>
<bean id="jahwaSessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="jahwaDataSource" />
<property name="mappingLocations">
<list>
<value>classpath*:mapping/**/*.hbm.xml</value>
<value>classpath*:com/mdao/emap/**/*.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<value>
hibernate.dialect=${hibernate.dialect}
hibernate.show_sql=false
hibernate.format_sql=true
hibernate.cache.use_second_level_cache=false
hibernate.cache.provider_class=org.hibernate.cache.NoCacheProvider
hibernate.cache.use_structured_entries=true
</value>
</property>
</bean>
<bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
<bean id="jahwaTxManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="jahwaSessionFactory" />
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- Cache -->
<bean id="ehcacheManager" class="org.springframework.cache.ehcache.EhCacheManagerFactoryBean">
<property name="configLocation" value="classpath:ehcache.xml" />
</bean>
</beans>
package com.mdao.emap.agent.jahwa.dao;
import java.sql.Timestamp;
import java.util.Collection;
import java.util.Collections;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import org.apache.commons.lang3.ArrayUtils;
import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.criterion.Criterion;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.hibernate.metadata.ClassMetadata;
import org.springframework.stereotype.Component;
import com.mdao.framework.persistence.PageSession;
@Component
@SuppressWarnings("unchecked")
public class JahwaHibernateDao {
@Resource
private SessionFactory jahwaSessionFactory;
public final int SQL_FLUSH_VALVE = 20;
public SessionFactory getSessionFactory() {
return this.jahwaSessionFactory;
}
public Session getSession() {
return getSessionFactory().getCurrentSession();
}
public Query createQuery(String hql) {
return getSession().createQuery(hql);
}
public SQLQuery createSQLQuery(String sql) {
return getSession().createSQLQuery(sql);
}
public <T> T get(Class<T> entityClass, long id) {
return (T) getSession().get(entityClass, Long.valueOf(id));
}
public <T> List<T> get(Class<T> entityClass, Collection<Long> ids) {
if (ids.isEmpty()) {
return Collections.emptyList();
}
return find(
entityClass,
new Criterion[] { Restrictions.in(getIdName(entityClass), ids) });
}
public <T> List<T> get(Class<T> entityClass, Long[] ids) {
if (ids.length == 0) {
return Collections.emptyList();
}
return find(
entityClass,
new Criterion[] { Restrictions.in(getIdName(entityClass), ids) });
}
public <T> List<T> get(Class<T> entityClass, long[] ids) {
if (ids.length == 0) {
return Collections.emptyList();
}
return find(entityClass, new Criterion[] { Restrictions.in(
getIdName(entityClass), ArrayUtils.toObject(ids)) });
}
public <T> void save(T entity) {
Session session = getSession();
session.saveOrUpdate(entity);
}
}
<bean id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="*" propagation="REQUIRED" rollback-for="java.lang.Exception" />
</tx:attributes>
</tx:advice>
<aop:config>
<aop:pointcut id="mycut" expression="execution(* com.ql.service.*.*(..))" />
<aop:advisor advice-ref="txAdvice" pointcut-ref="mycut" />
</aop:config>