spring3.2.3与hibernate3.2.6集成

第一步：配置web.xml文件，添加对spring和spring mvc的支持

  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
   <servlet> 
        <servlet-name>dispatcher</servlet-name> 
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> 
        <init-param> 
        	<description>指定配置文件路径</description> 
        	<param-name>contextConfigLocation</param-name> 
        	<param-value>/WEB-INF/applicationContext.xml</param-value> 
        </init-param> 
        <load-on-startup>1</load-on-startup> 
    </servlet> 
    <servlet-mapping> 
        <servlet-name>dispatcher</servlet-name> 
        <url-pattern>*.do</url-pattern> <!-- 所有以*.do结尾的request都会被拦截 -->
    </servlet-mapping> 
   

第二步：在spring的配置文件中配置数据源和对hibernate的支持

<?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"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:mvc="http://www.springframework.org/schema/mvc"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation=" 
		http://www.springframework.org/schema/aop 
			classpath:/org/springframework/aop/config/spring-aop-3.2.xsd 
        http://www.springframework.org/schema/beans
        	classpath:/org/springframework/beans/factory/xml/spring-beans-3.0.xsd 
        http://www.springframework.org/schema/context 
        	classpath:/org/springframework/context/config/spring-context-3.0.xsd 
        http://www.springframework.org/schema/mvc 
        	classpath:/org/springframework/web/servlet/config/spring-mvc-3.2.xsd 
        http://www.springframework.org/schema/tx 
        	classpath:/org/springframework/transaction/config/spring-tx-3.0.xsd 
	">

	<!-- ===================================== 视图配置 ===================================== -->
	<bean id="viewResolver"
		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/pages/" />
		<property name="suffix" value=".jsp" />
	</bean>

	<!-- ===================================== 注解驱动的配置 ===================================== -->
	<!-- <mvc:annotation-driven /> -->

	<mvc:annotation-driven>
		<mvc:message-converters>
			<bean class="org.springframework.http.converter.StringHttpMessageConverter">
				<property name="supportedMediaTypes">
					<list>
						<value>text/plain;charset=UTF-8</value>
						<value>text/html;charset=UTF-8</value>
					</list>
				</property>
			</bean>
			<!-- <bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter"> 
				<property name="supportedMediaTypes"> <list> <value>application/json; charset=UTF-8</value> 
				<value>application/x-www-form-urlencoded; charset=UTF-8</value> </list> </property> 
				</bean> -->
		</mvc:message-converters>
	</mvc:annotation-driven>
	<context:component-scan base-package="com.login" />
	<!-- 读取资源文件 -->
	<bean
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="location" value="classpath:jdbc.properties" />
	</bean>
	<bean id="dataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName">
			<value>${jdbc.driverClassName}</value>
		</property>
		<property name="password">
			<value>${jdbc.password}</value>
		</property>
		<property name="username">
			<value>${jdbc.username}</value>
		</property>
		<property name="url">
			<value>${jdbc.url}</value>
		</property>
	</bean>
	<!-- <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" 
		destroy-method="close"> <property name="driverClass"> <value>${jdbc.driverClassName}</value> 
		</property> <property name="jdbcUrl"> <value>${jdbc.url}</value> </property> 
		<property name="user"> <value>${jdbc.username}</value> </property> <property 
		name="password"> <value>${jdbc.password}</value> </property> <property name="minPoolSize"> 
		<value>2</value> </property> <property name="maxPoolSize"> <value>5</value> 
		</property> <property name="maxIdleTime"> <value>20000</value> </property> 
		<property name="acquireIncrement"> <value>2</value> </property> <property 
		name="maxStatements"> <value>0</value> </property> <property name="initialPoolSize"> 
		<value>2</value> </property> <property name="idleConnectionTestPeriod"> <value>8000</value> 
		</property> <property name="acquireRetryAttempts"> <value>30</value> </property> 
		<property name="breakAfterAcquireFailure"> <value>true</value> </property> 
		<property name="testConnectionOnCheckout"> <value>false</value> </property> 
		</bean> -->


	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource">
			<ref local="dataSource" />
		</property>
		<property name="mappingDirectoryLocations">
			<list>
				<value>classpath:com/login/entities</value>
			</list>
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">
					org.hibernate.dialect.SQLServerDialect
				</prop>
				<prop key="hibernate.show_sql">true</prop>
			</props>
		</property>
	</bean>

	<bean id="transactionManager"
		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource" />
	</bean>

	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource">
			<ref local="dataSource"></ref>
		</property>
	</bean>
	

</beans>

主要支持注解

第三步：创建jdbc.properties文件

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
jdbc.username=root
jdbc.password=253503125

 

 

第四步：创建IBaseDao

public interface IBaseDao {

	/**
	 * 保存
	 * @param entity --实体对象
	 * @throws HibernateException
	 */
	public void save(final Object entity) throws HibernateException;

	/**
	 * 更新
	 * @param entity --实体对象
	 * @throws HibernateException
	 */
	public void update(final Object entity) throws HibernateException;

	/**
	 * 保存或更新
	 * @param entity  --实体对象
	 * @throws HibernateException
	 */
	public void saveOrUpdate(final Object entity) throws HibernateException;

	/**
	 * 根据主键ID删除
	 * @param id          --主键ID
	 * @param entityClass --实体类
	 * @throws HibernateException
	 */
	public void delById(final Serializable id, final Class entityClass)
			throws HibernateException;

	/**
	 * 删除
	 * @param entity  --实体对象
	 * @throws HibernateException
	 */
	public void del(final Object entity) throws HibernateException;

	/**
	 * 根据主键ID查找
	 * @param id          --主键ID
	 * @param entityClass --实体类
	 * @return Object
	 * @throws HibernateException
	 */
	public Object findById(final Serializable id, final Class entityClass)
			throws HibernateException;
	
	/**
	 * 根据属性查找
	 * @param propertyName --属性名称
	 * @param value        --查询值
	 * @param EntityClass  --实体类
	 * @return Object
	 * @throws HibernateException
	 */
	public Object findByProperty(final String propertyName, final Object value, final Class EntityClass)
	        throws HibernateException;

	/**
	 * 查询列表
	 * @param entityClass --实体类
	 * @return List
	 * @throws HibernateException
	 */
	public List findList(final Class entityClass) throws HibernateException;

	/**
	 * 查询列表
	 * @param entityClass --实体类
	 * @param order       --排序(不设定排序则为null)
	 * @return List
	 * @throws HibernateException
	 */
	public List findList(final Class entityClass, final Order order)
			throws HibernateException;

	/**
	 * 查询列表
	 * @param entityClass --实体类
	 * @param order       --排序(不设定排序则为null)
	 * @param curPage     --查询页码
	 * @return List
	 * @throws HibernateException
	 */
	public List findList(final Class entityClass, final Order order,
			final int curPage) throws HibernateException;

	/**
	 * 查询列表(模糊查询)
	 * @param param    --查询实体对象(带查询参数)
	 * @param order    --排序(不设定排序则为null)
	 * @param curPage  --查询页码
	 * @return List
	 * @throws HibernateException
	 */
	public List findList(final Object param, final Order order,
			final int curPage) throws HibernateException;

	/**
	 * 根据HQL查询列表
	 * @param hqlStr --HQL
	 * @return List
	 * @throws HibernateException
	 */
	public List findListByHql(final String hqlStr) throws HibernateException;

	/**
	 * 根据HQL查询列表
	 * @param hqlStr --HQL
	 * @param args   --参数
	 * @return List
	 * @throws HibernateException
	 */
	public List findListByHql(final String hqlStr, final Object[] args)
			throws HibernateException;
	
	/**
	 * 根据HQL查询列表
	 * @param hqlStr  --HQL
	 * @param curPage --查询页码
	 * @return List
	 * @throws HibernateException
	 */
	public List findListByHql(final String hqlStr, final int curPage) throws HibernateException;
	
	/**
	 * 根据HQL查询唯一一条记录
	 * @param hqlStr --HQL
	 * @return Object
	 * @throws HibernateException
	 */
	public Object findUniqueByHql(final String hqlStr)
			throws HibernateException;

	/**
	 * 根据HQL查询唯一一条记录
	 * @param hqlStr --HQL
	 * @param args   --参数
	 * @return Object
	 * @throws HibernateException
	 */
	public Object findUniqueByHql(final String hqlStr, final Object[] args)
			throws HibernateException;

	/**
	 * 获取Hibernate的Session
	 * @return Session
	 */
	public Session getHibernateSession();

	public void flush();

	public void clear();

	/**
	 * 执行SQL,返回执行影响行数
	 * @param sqlStr --SQL
	 * @return int
	 * @throws DataAccessException
	 */
	public int executeSql(final String sqlStr) throws DataAccessException;

	/**
	 * 执行SQL,返回执行影响行数
	 * @param sqlStr --SQL
	 * @param args   --参数
	 * @return int
	 * @throws DataAccessException
	 */
	public int executeSql(final String sqlStr, final Object[] args)
			throws DataAccessException;

	/**
	 * 执行SQL查询,返回统计值
	 * @param sqlStr --SQL
	 * @return int
	 * @throws DataAccessException
	 */
	public int queryForInt(final String sqlStr) throws DataAccessException;

	/**
	 * 执行SQL查询,返回统计值
	 * @param sqlStr --SQL
	 * @param args   --参数
	 * @return int
	 * @throws DataAccessException
	 */
	public int queryForInt(final String sqlStr, final Object[] args)
			throws DataAccessException;

	/**
	 * 批量操作(插入、更新、删除)
	 * @param sqlStr     --SQL
	 * @param batchPstmt --BatchPreparedStatementSetter对象
	 * @return int
	 * @throws DataAccessException
	 */
	public int batchExecuteBySql(final String sqlStr,
			final BatchPreparedStatementSetter batchPstmt)
			throws DataAccessException;

	public JdbcTemplate getJdbcTemplate();

	public void setJdbcTemplate(JdbcTemplate jdbcTemplate);

	/**
	 * 设置每页显示的记录数
	 * @param pageSize
	 */
	public void setPageSize(int pageSize);
	
}

第五步：创建BaseDao实现IBaseDao

package com.login.dao.impl;
import java.io.Serializable;
import java.sql.SQLException;
import java.util.Collection;
import java.util.Iterator;
import java.util.List;

import javax.annotation.Resource;

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.criterion.MatchMode;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BatchPreparedStatementSetter;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.login.dao.IBaseDao;
import com.login.util.Tools;



public class BaseDao extends HibernateDaoSupport implements IBaseDao {
	
	/**
	 * 保存
	 * @param entity --实体对象
	 * @throws HibernateException
	 */
	public void save(final Object entity) throws HibernateException {
		getHibernateTemplate().save(entity);
	}
	
	/** 
	 * 更新
	 * @param entity --实体对象
	 * @throws HibernateException
	 */
	public void update(final Object entity) throws HibernateException {
		getHibernateTemplate().update(entity);
	}
	
	/**
	 * 保存或更新
	 * @param entity  --实体对象
	 * @throws HibernateException
	 */
	public void saveOrUpdate(final Object entity) throws HibernateException {
		getHibernateTemplate().saveOrUpdate(entity);
	}
	
	/**
	 * 根据主键ID删除
	 * @param id          --主键ID
	 * @param entityClass --实体类
	 * @throws HibernateException
	 */
	public void delById(final Serializable id, final Class entityClass) throws HibernateException {
		Object entity = null;
		if(id.getClass().getSimpleName().equals("Integer")) {
		    entity = findById(Integer.valueOf(id.toString()), entityClass);
		}else {
			entity = findById(id, entityClass);
		}
		if(entity != null)
			del(entity);
	}
	
	/**
	 * 删除
	 * @param entity  --实体对象
	 * @throws HibernateException
	 */
	public void del(final Object entity) throws HibernateException {
		getHibernateTemplate().delete(entity);
	}
	
	/**
	 * 根据主键ID查找
	 * @param id          --主键ID
	 * @param entityClass --实体类
	 * @return Object
	 * @throws HibernateException
	 */
	@SuppressWarnings("unchecked")
	public Object findById(final Serializable id, final Class entityClass) throws HibernateException {
		Object entity = null;
		if(id.getClass().getSimpleName().equals("Integer")) {
		    entity = getHibernateTemplate().get(entityClass, Integer.valueOf(id.toString()));
		}else {
			entity = getHibernateTemplate().get(entityClass, id);
		}
		return entity;
	}
	
	/**
	 * 根据属性查找
	 * @param propertyName --属性名称
	 * @param value        --查询值
	 * @param EntityClass  --实体类
	 * @return Object
	 * @throws HibernateException
	 */
	public Object findByProperty(final String propertyName, final Object value, final Class entityClass)
	        throws HibernateException {
		Object entity = null;
		List list = getHibernateTemplate().executeFind(
				new HibernateCallback() {
					public Object doInHibernate(Session session) throws HibernateException {
						List results = session.createCriteria(entityClass)
						.add(Restrictions.eq(propertyName, value))
						.list();
						return results;
					}
				}
		);
		if(!list.isEmpty() && list.size() > 0) 
		{
			entity = list.get(0);
		}
		return entity;
	}
	
	
	/**
	 * 查询列表
	 * @param entityClass --实体类
	 * @return List
	 * @throws HibernateException
	 */
	public List findList(final Class entityClass) throws HibernateException {
		List list = null;
		list = getHibernateTemplate().executeFind(
				new HibernateCallback() {
					public Object doInHibernate(Session session) throws HibernateException {
						List results = null;
						Criteria criteria = session.createCriteria(entityClass);
						results = criteria.list();
						return results;
					}
				}
		);
		return list;
	}
	
	/**
	 * 查询列表
	 * @param entityClass --实体类
	 * @param order       --排序(不设定排序则为null)
	 * @return List
	 * @throws HibernateException
	 */
	public List findList(
			final Class entityClass,
			final Order order
			) 
	throws HibernateException {
		List list = null;
		list = getHibernateTemplate().executeFind(
				new HibernateCallback() {
					public Object doInHibernate(Session session) throws HibernateException {
						List results = null;
						Criteria criteria = session.createCriteria(entityClass);
						if(order != null) {
							criteria.addOrder(order);
						}
						results = criteria.list();
						return results;
					}
				}
		);
		return list;
	}
	
	/**
	 * 分页查询列表
	 * @param entityClass --实体类
	 * @param order       --排序(不设定排序则为null)
	 * @param curPage     --查询页码
	 * @return List
	 * @throws HibernateException
	 */
	public List findList(
			final Class entityClass,
			final Order order,
			final int curPage
			) 
	throws HibernateException {
		List list = null;
		list = getHibernateTemplate().executeFind(
				new HibernateCallback() {
					public Object doInHibernate(Session session) throws HibernateException {
						List results = null;
						Criteria criteria = session.createCriteria(entityClass);
						if(order != null) {
							criteria.addOrder(order);
						}
						criteria.setMaxResults(pageSize);
						criteria.setFirstResult((curPage-1)*pageSize);
						results = criteria.list();
						return results;
					}
				}
		);
		return list;
	}
	
	/**
	 * 查询列表(模糊查询)
	 * @param param    --查询实体对象(带查询参数)
	 * @param order    --排序(不设定排序则为null)
	 * @param curPage  --查询页码
	 * @return List
	 * @throws HibernateException
	 */
	public List findList(
			final Object param,
			final Order order,
			final int curPage
			) 
	throws HibernateException {
		List list = null;
		list = getHibernateTemplate().executeFind(
				new HibernateCallback() {
					public Object doInHibernate(Session session) throws HibernateException {
						List results = null;
						Criteria criteria = session.createCriteria(param.getClass());
						Collection methodInfo = Tools.getMethodInfo(param);
						Iterator itr = methodInfo.iterator();
			        	while(itr.hasNext()) {
			        		Object[] fv = (Object[])itr.next();
			        		//System.out.println("字段名:" + fv[1].toString() + " -- 返回值:" + fv[2].toString() + " -- 返回类型:" + fv[0].toString());
			        		if(fv[2] != null && !fv[2].equals("")) {
			        			if(fv[0].toString().indexOf("String") > 0) {   //如果返回值类型为字符串类型
			        				criteria.add(Restrictions.like(fv[1].toString(), fv[2].toString(), MatchMode.ANYWHERE));
			        			}else {   //如果返回值类型为数字类型
			        				if(Integer.valueOf(fv[2].toString()) != 0) {
			        					criteria.add(Restrictions.eq(fv[1].toString(), fv[2]));
			        				}
			        			}
			        		}
			        	}
			        	if(order != null) {
			        		criteria.addOrder(order);
			        	}
						criteria.setMaxResults(pageSize);
						criteria.setFirstResult((curPage-1)*pageSize);
						results = criteria.list();
						return results;
					}
				}
		);
		return list;
	}
	
	/**
	 * 根据HQL查询列表
	 * @param hqlStr --HQL
	 * @return List
	 * @throws HibernateException
	 */
	public List findListByHql(
			final String hqlStr
			) 
	throws HibernateException {
		return getHibernateTemplate().find(hqlStr);
	}
	
	/**
	 * 根据HQL查询列表
	 * @param hqlStr --HQL
	 * @param args   --参数
	 * @return List
	 * @throws HibernateException
	 */
	public List findListByHql(
			final String hqlStr,
			final Object[] args
			) 
	throws HibernateException {
		return getHibernateTemplate().find(hqlStr, args);
	}
	
	/**
	 * 根据HQL查询列表
	 * @param hqlStr  --HQL
	 * @param curPage --查询页码
	 * @return List
	 * @throws HibernateException
	 */
	public List findListByHql(
			final String hqlStr,
			final int curPage
			)
	throws HibernateException {
		List list = null;		
		list = getHibernateTemplate().executeFind(
				new HibernateCallback() {
					public Object doInHibernate(Session session) throws HibernateException, SQLException {
						List results = null;
						Query query = session.createQuery(hqlStr);
						query.setMaxResults(pageSize);
						query.setFirstResult((curPage-1)*pageSize);
						results = query.list();
						return results;
					}
				}
        );
		return list;
	}
	
	/**
	 * 根据HQL查询唯一一条记录
	 * @param hqlStr --HQL
	 * @return Object
	 * @throws HibernateException
	 */
	public Object findUniqueByHql(
			final String hqlStr
			)
	throws HibernateException {
		Object entity = null;
		List list = null;
		list = getHibernateTemplate().find(hqlStr);
		if(!list.isEmpty() && list.size() > 0) {
			entity = list.get(0);
		}
		return entity;
	}

	/**
	 * 根据HQL查询唯一一条记录
	 * @param hqlStr --HQL
	 * @param args   --参数
	 * @return Object
	 * @throws HibernateException
	 */
	public Object findUniqueByHql(
			final String hqlStr, 
			final Object[] args
			) 
	throws HibernateException {
		Object entity = null;
		List list = null;
		list = getHibernateTemplate().find(hqlStr, args);
		if(!list.isEmpty() && list.size() > 0) {
			entity = list.get(0);
		}
		return entity;
	}
	
	/**
	 * 获取Hibernate的Session
	 * @return Session
	 */
	public Session getHibernateSession() {
		return this.getSession();
	}
	
	public void flush() {
		getHibernateTemplate().flush();
	}
	
	public void clear() {
		getHibernateTemplate().clear();
	}
	
	//JDBC*************************************************************************************
	
	/**
	 * 执行SQL,返回执行影响行数
	 * @param sqlStr --SQL
	 * @return int
	 * @throws DataAccessException
	 */
	public int executeSql(
			final String sqlStr
			) 
	throws DataAccessException {
		//println("执行SQL:" + sqlStr);
		int resultSum = jdbcTemplate.update(sqlStr);
		//println("影响行数:" + resultSum);
		return resultSum;
	}
	
	/**
	 * 执行SQL,返回执行影响行数
	 * @param sqlStr --SQL
	 * @param args   --参数
	 * @return int
	 * @throws DataAccessException
	 */
	public int executeSql(
			final String sqlStr, 
			final Object[] args
			) 
	throws DataAccessException {
		//println("执行SQL:" + sqlStr);
		int resultSum = jdbcTemplate.update(sqlStr, args);
		//println("影响行数:" + resultSum);
		return resultSum;
	}
	
	/**
	 * 执行SQL查询,返回统计值
	 * @param sqlStr --SQL
	 * @return int
	 * @throws DataAccessException
	 */
	public int queryForInt(
			final String sqlStr
			) 
	throws DataAccessException {
		//println("执行SQL:" + sqlStr);
		int iValue = jdbcTemplate.queryForInt(sqlStr);
		//println("统计值:" + iValue);
		return iValue;
	}
	
	/**
	 * 执行SQL查询,返回统计值
	 * @param sqlStr --SQL
	 * @param args   --参数
	 * @return int
	 * @throws DataAccessException
	 */
	public int queryForInt(
			final String sqlStr,
			final Object[] args
			)  
	throws DataAccessException {
		int iValue = jdbcTemplate.queryForInt(sqlStr, args);
		return iValue;
	}
	
	/**
	 * 批量操作(插入、更新、删除)
	 * @param sqlStr     --SQL
	 * @param batchPstmt --BatchPreparedStatementSetter对象
	 * @return int
	 * @throws DataAccessException
	 */
	public int batchExecuteBySql(
			final String sqlStr,
			final BatchPreparedStatementSetter batchPstmt
	        )
	throws DataAccessException {
		int[] sum = jdbcTemplate.batchUpdate(sqlStr, batchPstmt);
		return sum.length;
	}
	
	//JDBC 模版********************************************************************************************
	@Autowired
	private JdbcTemplate jdbcTemplate;

	public JdbcTemplate getJdbcTemplate() {
		return jdbcTemplate;
	}

	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}
	
	//查询需要分页的数据列表时用到*****************************************************************************************
	
	/**
	 * 查询列表时,默认每页显示的记录数
	 */
	private int pageSize = 10;
	
	/**
	 * 设置每页显示的记录数
	 * @param pageSize
	 */
	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}
	@Resource
	public void setSessionFactory0(SessionFactory sessionFactory){  
		System.out.println("---__---");
		super.setSessionFactory(sessionFactory);  
	} 
}

然后在书写自己需要的dao时，只需要集成BaseDao即可。当BaseDao中的方法无法满足时，可以通过获取session,然后按照jdbc的操作方法来完成。