spring整合hibernate

一、使用内部hibernateTemplate实现增删改查
1、导入所需jar包

2、配置applicationContext.xml文件

<?xml version="1.0" eccodeing="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:context="http://www.springframework.org/schema/context"
	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.xsd 
		http://www.springframework.org/schema/context 
		http://www.springframework.org/schema/context/spring-context.xsd 
		http://www.springframework.org/schema/aop 
		http://www.springframework.org/schema/aop/spring-aop.xsd 
		http://www.springframework.org/schema/tx 
		http://www.springframework.org/schema/tx/spring-tx.xsd ">
	<!-- 配置读取propertise文件的工具流 -->
	<context:property-placeholder location=""/>
	<!-- 配置c3p0连接池 -->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="jdbcUrl" value="${jdbc.url}"/>
		<property name="driverClass" value="${jdbc.driver.class}"/>
		<property name="user" value="${jdbc.username}"/>
		<property name="password" value="${jdbc.password}"/>
	</bean>
	<!-- 配置hibernate的sessionFactory -->
	<bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
		<property name="dataSource" ref="dataSource"/>
		<!-- hibernateProperties属性：配置与hibernate相关的内容，如：显示sql语句和开启正向工程 -->
		<property name="hibernateProperties">
			<props>
				<!-- 显示当前执行的sql语句 -->
				<prop key="hibernate.show_sql">true</prop>
				<!-- 开启正向工程 -->
				<prop key="hibernate.hbm2ddl.auto">update</prop>
			</props>
		</property>
		
		<!-- 扫描实体所在的包 -->
		<property name="packageToScan">
			<list>
				<value>con.xu.pojo</value>
			</list>
		</property>
	</bean>
	<!-- 配置hibernate的事务管理器 -->
	<bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory"/>
	</bean>
	<!-- 配置开启注解事务处理 -->
	<tx:annotation-driven transaction-manager="transactionManager"/>
	<!-- 配置IOC的注解扫描 -->
	<context:component-scan base-package="com.xu"/>
</beans>

小知识点：
在正向工程配置中，hibernate.hbm2ddl.auto的属性值如下：
create:删除之前的表，重新建立新表
create-drop:sessionFactory已关闭，删除之前的表，重新建立新表
update:创建表结构，不能和其他数据库的表重名
validate:不创建表，只做添加
3、使用注解编写实体类

@Entity
@Table(name = "t_user")
public class Users implements Serializable {
	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)//自增设置
	@Column(name = "userid")
	private Integer userid;
	@Column(name = "userage")
	private Integer userage;
	@Column(name = "username")
	private String username;

	public Integer getUserid() {
		return userid;
	}
	public void setUserid(Integer userid) {
		this.userid = userid;
	}
	public Integer getUserage() {
		return userage;
	}
	public void setUserage(Integer userage) {
		this.userage = userage;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
}

4、编写实现类
本来需继承HibernateDaoSupport
public class UserDaoImpl extends HibernateDaoSupport implements UserDao；
改由HibernateTemplate配置

<bean id="hihbernateTemplate" class="org.springframework.orm.hibernate5.HibernateTemplate">
	<property name="sessionFactory" ref="sessionFactory"/>
</bean>

实现类为

@Repository
public class UserDaoImpl implements UserDao{
	@Autowired
	private HibernateTemplate hibernateTemplate;
	@Override
	public void insertUsers(Users users) {
		// TODO Auto-generated method stub
		this.hibernateTemplate.save(users);
	}
	@Override
	public void updateUsers(Users users) {
		// TODO Auto-generated method stub
		this.hibernateTemplate.update(users);
	}
	@Override
	public void deleteUsers(Users users) {
		// TODO Auto-generated method stub
		this.hibernateTemplate.delete(users);
	}
	@Override
	public Users selectUsersById(Integer userid) {
		// TODO Auto-generated method stub
		return this.hibernateTemplate.get(Users.class, userid);
	}
}

5、测试类

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class UserDaoImplTest {
	@Autowired
	private UserDao userDao;
	//添加该用户
	@Test
	@Transactional
	@Rollback(false)//关闭测试类的自动回滚
	public void testInsertUsers() {
		Users user=new Users();
		user.setUserage(20);
		user.setUsername("李四");
		userDao.insertUsers(user);
	}
	@Test
	@Transactional
	@Rollback(false)
	public void testUpdateUsers() {
		Users user=new Users();
		user.setUserid(1);
		user.setUserage(20);
		user.setUsername("李四");
		userDao.updateUsers(user);
	}
	@Test
	public void testSelectUsersById() {
		Users user=this.userDao.selectUsersById(1); 
		System.out.println(user.toString());
	}
}

二、使用HQL语句实现功能
dao实现类

@Override
public List<Users> selectUserByName(String Name) {
	// getCurrentSession:当前session必须要有事务边界(即查询也受事务控制)，且只能处理唯一的一个事务，当事提交或是回滚后session自动失效
	//openSession：每次都回打开一个新的session，每次使用多次，获得的是不同的session的对象，使用完毕需手动调用close方法关闭session
	Session session=this.hibernateTemplate.getSessionFactory().getCurrentSession();
	//sql:select * from t_users where username=
	Query query=session.createQuery("from Users where username=:abc");
	Query queryTemp=query.setString("abc", Name);
	return queryTemp.list();
}

测试代码

@Test
@Transactional//开启事务
public void testSelectUsersByName() {
	List<Users> list=this.userDao.selectUserByName("李四"); 
	for (Users users : list) {
		System.out.println(users.toString());
	}
}

三、使用SQL查询

@Override
public List<Users> selectUserByNameSQL(String Name) {
	Session session=this.hibernateTemplate.getSessionFactory().getCurrentSession();
	Query query=session.createSQLQuery("select * from t_users where username=?").addEntity(Users.class).setString(0,Name);//映射到User对象
	return query.list();
}

四、使用QBC查询:将sql语句也转换成一个对象
QBC：Query By Criteria

@Override
public List<Users> selectUserByNameQBC(String Name) {
	Session session=this.hibernateTemplate.getSessionFactory().getCurrentSession();
	//sql:select * from t_users where username='李四'
	Criteria c=session.createCriteria(Users.class);
	c.add(Restrictions.eq("username",Name));
	return c.list();
}