Spring Data-Spring整合Hibernate

入门Spring Data-Spring整合Hibernate

环境：
window 10
JDK 1.8
Version: Mars.2 Release (4.5.2)
MySQL 5.7
Spring 4.2.0
Hibernate 5.0.7 Final 等
基本步骤：

1. 创建Spring配置文件applicationContext.xml
   2 .读取外部文件
   3 .配置数据库连接池C3P0，DRUID，DBCP
   4 .配置Hibernate SessionFactory对象
2. 配置Hibernate通用配置属性，开启包扫描将POJO对象进行orm映射，打印SQL语句和开启正向工程
   6 .配置事务管理
3. 开启事务注解管理
4. 开启SpringIOC的包扫描
5. 配置HibernateTemplate，该类需要传入一个SessionFactory对现象
   开始配置
6. 创建JavaProject项目，导入Junit4包方便单元测试
   
7. 创建lib文件夹保存JAR包
   
8. 配置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:context="http://www.springframework.org/schema/context"
	xmlns:jdbc="http://www.springframework.org/schema/jdbc" xmlns:p="http://www.springframework.org/schema/p"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.3.xsd
		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-4.3.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
<!--配置读取外部文件  -->
<context:property-placeholder location="classpath:jdbc.properties"/>
<!--配置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"/>
<!--HIbernatePreporties 配置显示SQL语句开启正向工程  -->
<property name="hibernateProperties">
<props>
<!-- 显示当前执行的SQL语句 -->
<prop key="hibernate.show_sql">true</prop>
<!--开启正向工程  -->
<prop key="hibernate.hbm2ddl.auto">update</prop>
</props>
</property>
<!--扫描实体所在的包 ,设置pojo和hbm文件的映射-->
<property name="packagesToScan">
<list>
<value>com.OVA.pojo</value>
</list>
</property>
</bean>
<!--配置HibernateTemplate  -->
<bean id="hibernateTemplate" class="org.springframework.orm.hibernate5.HibernateTemplate">
<property name="sessionFactory" ref="sessionFactory"/>
</bean>
<!--配置HIbernate事务管理器  -->
<bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory"/>
</bean>
<!--配置开启事务处理  -->
<tx:annotation-driven transaction-manager="transactionManager"/>
<!--配置SpringIOC 的注解扫描 -->
<context:component-scan base-package="com.OVA"/>
</beans>

4. 配置jdbc.properties外置文件

jdbc.url=jdbc:mysql:///springboot
jdbc.driver.class=com.mysql.jdbc.Driver
jdbc.username=root
jdbc.password=666888

5. 项目分包：截图上面已经上传
6. pojo创建对象实现序列化

package com.OVA.pojo;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
@SuppressWarnings("serial")
@Entity
@Table(name = "users")
public class Users implements Serializable {
	@Id
	@GeneratedValue(strategy=GenerationType.IDENTITY)//设置主键自增
	@Column(name="userid")
	private Integer userid;
	@Column(name="username")
	private String username;
	@Column(name="userage")
	private Integer userage;

	public Integer getUserid() {
		return userid;
	}

	public void setUserid(Integer userid) {
		this.userid = userid;
	}

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}

	public Integer getUserage() {
		return userage;
	}

	public void setUserage(Integer userage) {
		this.userage = userage;
	}

	@Override
	public int hashCode() {
		final int prime = 31;
		int result = 1;
		result = prime * result + ((userage == null) ? 0 : userage.hashCode());
		result = prime * result + ((userid == null) ? 0 : userid.hashCode());
		result = prime * result + ((username == null) ? 0 : username.hashCode());
		return result;
	}

	@Override
	public boolean equals(Object obj) {
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		Users other = (Users) obj;
		if (userage == null) {
			if (other.userage != null)
				return false;
		} else if (!userage.equals(other.userage))
			return false;
		if (userid == null) {
			if (other.userid != null)
				return false;
		} else if (!userid.equals(other.userid))
			return false;
		if (username == null) {
			if (other.username != null)
				return false;
		} else if (!username.equals(other.username))
			return false;
		return true;
	}

	@Override
	public String toString() {
		return "Users [userid=" + userid + ", username=" + username + ", userage=" + userage + "]";
	}

}

7. dao创建持久层接口
   package com.OVA.dao;

import java.util.List;

import com.OVA.pojo.Users;

public interface UserDao {
void insertUsers(Users users );
void updateUsres(Users users );
void deleteUsers(Users users );
Users selectUsersByID(Integer userid );
List selectUserByName(String username);
List selectUserByNameUseSQL(String username);
List selectUserByNameUseCriteria(String username);
}

8. impl实现持久层接口

package com.OVA.impl;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.Restrictions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate5.HibernateTemplate;
import org.springframework.stereotype.Repository;

import com.OVA.dao.UserDao;
import com.OVA.pojo.Users;

@Repository
public class UserDaoImpl implements UserDao {
	@Autowired
	private HibernateTemplate hibernateTemplate;

	@Override
	public void insertUsers(Users users) {
		// TODO Auto-generated method stub
		hibernateTemplate.save(users);
	}

	@Override
	public void updateUsres(Users users) {
		// TODO Auto-generated method stub
		hibernateTemplate.update(users);
	}

	@Override
	public void deleteUsers(Users users) {
		// TODO Auto-generated method stub
		hibernateTemplate.delete(users);
	}

	@Override
	public Users selectUsersByID(Integer userid) {
		// TODO Auto-generated method stub
		return hibernateTemplate.get(Users.class, userid);
	}

	// HQL的查询方式
	@Override
	public List<Users> selectUserByName(String username) {
		// getCurrentSession返回当前Session必须具有事务边界，且只能处理唯一的一个事务，事务提交后Session对象被回收
		// openSession每次都会打开一个新的Session对象,使用完毕需要手动的关闭
		Session session = hibernateTemplate.getSessionFactory().getCurrentSession();
		Query query = session.createQuery("from Users where username=:username").setString("username", username);
		return query.list();
	}

	// 普通SQL的查询方式
	@Override
	public List<Users> selectUserByNameUseSQL(String username) {
		Session session = hibernateTemplate.getSessionFactory().getCurrentSession();
		Query query = session.createSQLQuery("select* from users where username=?").addEntity(Users.class).setString(0,
				username);
		return query.list();
	}

	@Override
	public List<Users> selectUserByNameUseCriteria(String username) {
		Session session =hibernateTemplate.getSessionFactory().getCurrentSession();
		Criteria c=session.createCriteria(Users.class);
		c.add(Restrictions.eq("username", username));
		return null;
	}

}

9. 测试

package test;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.annotation.Rollback;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.transaction.annotation.Transactional;

import com.OVA.dao.UserDao;
import com.OVA.pojo.Users;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class TestDaoImpl {
	@Autowired
	private UserDao userdao;
	Users users = null;

	// 添加
	@Test
	@Transactional
	@Rollback(false)
	public void testInsert() {
		// TODO Auto-generated method stub
		users = new Users();
		users.setUsername("张宁");
		users.setUserage(11);
		userdao.insertUsers(users);
	}

	// 删除
	@Test
	@Transactional
	@Rollback(false)
	public void testDelete() {
		// TODO Auto-generated method stub
		users = new Users();
		users.setUserid(3);
		userdao.deleteUsers(users);

	}

	// 查找
	@Test
	@Transactional
	@Rollback(false)
	public void testSelect() {
		// TODO Auto-generated method stub
		users = new Users();
		users.setUserid(3);
		System.out.println(userdao.selectUsersByID(3));

	}

	// 更新
	@Test
	@Transactional
	@Rollback(false)
	public void testUpdate() {
		// TODO Auto-generated method stub
		users = new Users();
		users.setUserid(3);
		users.setUsername("张宁");
		users.setUserage(22);
		userdao.updateUsres(users);
	}

	// HQL姓名查
	@Test
	@Transactional
	@Rollback(false)
	public void testSelectByName() {
		System.out.println(userdao.selectUserByName("张三"));
	}

	// SQL姓名查
	@Test
	@Transactional
	@Rollback(false)
	public void testSelectByNameUseSQL() {
		for (Users users : userdao.selectUserByName("张三")) {
			System.out.println(users);
		}
	}
	// QBC By Query Criteria姓名查
		@Test
		@Transactional
		@Rollback(false)
		public void testSelectByNameUseQBC() {
			for (Users users : userdao.selectUserByName("张三")) {
				System.out.println(users);
			}
		}
}

方法名称几乎都是见名知义，就不多做赘述了，首次发文有什么不对之处，还请各位大佬指正，我也只是想将自己学过去的代码保存下来，方便以后学习使用。有什么问题可以留言咱们一块学习。