Spring中的HibernateDaoSupport

Spring为我们提供与JdbcDaoSupport像似功能的类，以方便Spring与Hibenrate的结合，那就是HibernateDaoSupport，但是在使用之前要注意，HibernateDaoSupport仅仅支持Hibernate3的框架，而Hibernate4是不支持的，因为Spring认为Hibernate4的API已经十分简洁，事务处理已经十分方便，所以使用Hibernate4的项目是不能使用HibernateDaoSupport的。

首先创建项目，为项目导入Spring3.1与Hibernate3.2的支持，

一、创建实体类：

package com.spr.model;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "user")
public class User {
	@Id
	@GeneratedValue(strategy=GenerationType.AUTO)
	private int id;
	private String username;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	
}

二、创建DAO层接口：

package com.spr.dao;

import java.util.List;

import com.spr.model.User;

public interface UserDao {
	//保存用户
	public void saveUser(User user);
	//删除用户
	public void deleteUser(int id);
	//修改用户
	public void updateUser(User user);
	//通过id查找用户
	public User findUserInfo(int id);
	//查找所有用户
	public List<User> findAllUser();
	//判断用户是否存在
	public boolean findUser(User user);
}

三、实现UserDao接口：

package com.spr.dao.impl;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.spr.dao.UserDao;
import com.spr.model.User;

public class UserDaoImpl extends HibernateDaoSupport implements UserDao{

	@Override
	public void saveUser(User user) {
		// TODO Auto-generated method stub
		this.getHibernateTemplate().save(user);
	}

	@Override
	public void deleteUser(int id) {
		// TODO Auto-generated method stub
		User user = this.getHibernateTemplate().load(User.class, id);
		this.getHibernateTemplate().delete(user);
	}

	@Override
	public void updateUser(User user) {
		// TODO Auto-generated method stub
		this.getHibernateTemplate().update("username", user);
		
	}

	@Override
	public User findUserInfo(int id) {
		// TODO Auto-generated method stub
		String sql = "from User as user where user.id=?";
		List<User> list = this.getHibernateTemplate().find(sql, id);
		return list.get(0);
	}

	@Override
	public List<User> findAllUser() {
		// TODO Auto-generated method stub
		String sql = "from User";
		List<User> list = this.getHibernateTemplate().find(sql);
		return list;
	}

	@Override
	public boolean findUser(User user) {
		// TODO Auto-generated method stub
		Object[] values = {user.getId(), user.getUsername()};
		String sql = "from User as user where id=? and username=?";
		List<User> list = this.getHibernateTemplate().find(sql, values);
		if(list.size() > 0){
			return true;
		}
		else{
			return false;
		}
	}

}

四、编写applicationContext.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:p="http://www.springframework.org/schema/p"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd">
	
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
		<property name="url" value="jdbc:mysql://localhost:3306/hibernate"/>
		<property name="username" value="root"/>
		<property name="password" value="7756"/>	
	</bean>
	
	<bean name="user" class="com.spr.model.User"></bean>
	<bean name="userDaoImpl" class="com.spr.dao.impl.UserDaoImpl">
		<property name="sessionFactory" ref="sessionFactory"/>
	</bean>
	

	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
		
		<property name="dataSource" ref="dataSource"/>
		<property name="annotatedClasses">
			<list>
				<value>com.spr.model.User</value>
			</list>
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.format_sql">true</prop>
				<prop key="hibernate.hbm2ddl.auto">update</prop>
			</props>
		</property>
	</bean>

</beans>

五、编写测试类：

package com.spr.test;

import java.util.List;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.spr.dao.UserDao;
import com.spr.model.User;

public class Test {
	public static void main(String[] args){
		
		ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
		
		User user = (User) context.getBean("user");
		user.setId(5);
		user.setUsername("yezi");
		
		UserDao userDao = (UserDao) context.getBean("userDaoImpl");
//		userDao.saveUser(user);
//		userDao.deleteUser(2);
//		userDao.updateUser(user);
//		System.out.println(userDao.findUserInfo(3).getUsername());
//		if(userDao.findUser(user)){
//			System.out.println("存在");
//		}
//		else{
//			System.out.println("不存在");
//		}
		List<User> list = userDao.findAllUser();
		for(User users : list){
			System.out.println("ID:"+users.getId()+"  NAME:"+users.getUsername());
		}
		
	}
}

源码下载：http://download.youkuaiyun.com/detail/yezis/7352565