spring整合hibernate

上次讲到了struts2与spring的整合，今天讲一下spring和hibernate的整合。
两者一般的分配角色是：hibernate负责和数据库打交道，主要实现的是dao层的业务逻辑。spring主要是工作在dao层上面的service层，调用dao层的业务功能完成service层的业务逻辑，同时对service层提供声明式事务。

spring整合hibernate步骤：

一：jar包，包括spring和hibernate的各自必须的jar包：

二：配置文件

hibernate配置文件：

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE hibernate-configuration PUBLIC        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"><hibernate-configuration>    <session-factory>    <!-- 配置连接数据库的基本属性，这一部分可以写在spring框架的applicationcontext.xml文件中 -->    <!-- 连接映射文件 ,同上，写在applicationcontext.xml文件中    其实在spring整合hibernate的时候，hibernate的配置文件完全可以不要，而把所有配置信息写到applicationcontext.xml文件中-->    <!-- 基本属性 -->    <property name="hibernate.show_sql">true</property>    <property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>    <property name="hibernate.format_sql">true</property>    <property name="hbm2ddl.auto">update</property>    </session-factory></hibernate-configuration>

spring配置文件：

<?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:tx="http://www.springframework.org/schema/tx"    xmlns:aop="http://www.springframework.org/schema/aop"    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-4.3.xsd        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-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:db.properties"/>    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">        <property name="user" value="${jdbc.user}"></property>        <property name="password" value="${jdbc.password}"></property>        <property name="driverClass" value="${jdbc.driverClass}"></property>        <property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>        <property name="initialPoolSize" value="${jdbc.initPoolSize}"></property>        <property name="maxPoolSize" value="${jdbc.maxPoolSize}"></property>    </bean>    <!-- 配置hibernate的sessionfactory -->    <bean id="sessionfactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">        <property name="dataSource" ref="dataSource"></property>        <property name="configLocation" value="classpath:hibernate.cfg.xml"></property>        <property name="mappingLocations" value="classpath:com/sh/en/*.hbm.xml"></property>    </bean>    <!-- 配置事务管理器 -->    <bean id="TransactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">        <property name="sessionFactory" ref="sessionfactory"></property>    </bean>    <!-- 配置事务属性 -->    <tx:advice id="txadvice" transaction-manager="TransactionManager">        <tx:attributes>            <tx:method name="get*" read-only="true"/>            <tx:method name="*"/>        </tx:attributes>    </tx:advice>    <!-- 配置事务切入点 -->    <aop:config>        <aop:pointcut expression="execution(* com.service.*.*(..))" id="pointcut"/>        <aop:advisor advice-ref="txadvice" pointcut-ref="pointcut"/>    </aop:config><!-- 配置dao层bean -->    <bean id="bookdao" class="com.dao.BookDaoImp">        <property name="sessionfactory" ref="sessionfactory"></property>    </bean><!-- 配置service层 --><bean id="bookservice" class="com.service.BookService">    <property name="bookdaoimp" ref="bookdao"></property></bean></beans>

下面看示例代码：

实体类：

book类：public class Books {    private Integer BookId;    private String BookName;    private Integer BookBalance;    private Integer BookStore;    public Integer getBookBalance() {        return BookBalance;    }    public void setBookBalance(Integer bookBalance) {        BookBalance = bookBalance;    }

account类：

public class account {    private Integer accountId;    private String accountName;    private Integer accountBalance;    public Integer getaccountId() {        return accountId;    }    public void setaccountId(Integer accountId) {        accountId = accountId;    }    public String getaccountName() {        return accountName;    }    public void setCountName(String accountName) {        accountName = accountName;    }    public Integer getaccountBalance() {        return accountBalance;    }    public void setCountBalance(Integer accountBalance) {        accountBalance = accountBalance;    }}

映射文件：

book类：<?xml version="1.0"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN""http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><!-- Generated 2017-8-25 12:29:58 by Hibernate Tools 3.5.0.Final --><hibernate-mapping>    <class name="com.sh.en.Books" table="BOOKS">        <id name="BookId" type="java.lang.Integer">            <column name="BOOKID" />            <generator class="native" />        </id>        <property name="BookName" type="java.lang.String">            <column name="BOOKNAME" />        </property>        <property name="BookBalance" type="java.lang.Integer">            <column name="BOOKBALANCE"></column>        </property>        <property name="BookStore" type="java.lang.Integer">            <column name="BOOKSTORE" />        </property>    </class></hibernate-mapping>

account类：

<?xml version="1.0"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN""http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><!-- Generated 2017-8-25 12:29:58 by Hibernate Tools 3.5.0.Final --><hibernate-mapping>    <class name="com.sh.en.Count" table="COUNT">        <id name="CountId" type="java.lang.Integer">            <column name="COUNTID" />            <generator class="native" />        </id>        <property name="CountName" type="java.lang.String">            <column name="COUNTNAME" />        </property>        <property name="CountBalance" type="java.lang.Integer">            <column name="COUNTBALANCE" />        </property>    </class></hibernate-mapping>

dao层：无非就是数据库的增删改查

package com.dao;import org.hibernate.Query;import org.hibernate.Session;import org.hibernate.SessionFactory;import com.Exception.BookStoreException;import com.Exception.CountBalanceException;public class BookDaoImp implements BookDao{    private SessionFactory sessionfactory;    public SessionFactory getSessionfactory() {        return sessionfactory;    }    public void setSessionfactory(SessionFactory sessionfactory) {        this.sessionfactory = sessionfactory;    }    public Session GetSession()    {        return sessionfactory.getCurrentSession();    }    //查询书的单价    @Override    public int findbookpricebyname(String bookname) {        String hql="SELECT b.BookBalance from Books b where b.BookName=?";        Query query=GetSession().createQuery(hql).setString(0, bookname);        return (int) query.uniqueResult();    }    //查询用户余额    @Override    public int findcountbalancebyname(String username) {        String hql="select c.CountBalance from Count c where c.CountName=?";        Query query=GetSession().createQuery(hql).setString(0, username);        return (int) query.uniqueResult();    }    //更新书的库存    @Override    public void updatebookstore(String bookname) {        //检查异常        String hql="select b.BookStore from Books b where b.BookName=?";        int bookstore=(Integer) GetSession().createQuery(hql).setString(0, bookname).uniqueResult();        if(bookstore==0)        {            throw new BookStoreException("库存不足");        }        hql="update Books b set b.BookStore=b.BookStore-1 where b.BookName=?";        GetSession().createQuery(hql).setString(0, bookname).executeUpdate();    }    //更新用户余额    @Override    public void updateacountbalance(String username,int price) {        //检查异常        String hql="select c.CountBalance from Count c where c.CountName=?";        int countbalance=(int) GetSession().createQuery(hql).setString(0, username).uniqueResult();        if(countbalance<price)        {            throw new CountBalanceException("余额不足");        }        hql="update Count c set c.CountBalance= c.CountBalance-? where c.CountName=?";        GetSession().createQuery(hql).setInteger(0, price).setString(1, username).executeUpdate();    }}

service层：调用dao层的业务功能

import com.dao.BookDaoImp;public class BookService {    private BookDaoImp bookdaoimp;    public BookDaoImp getBookdaoimp() {        return bookdaoimp;    }    public void setBookdaoimp(BookDaoImp bookdaoimp) {        this.bookdaoimp = bookdaoimp;    }    public int  findbookbalancebyname(String name)    {        return bookdaoimp.findbookpricebyname(name);    }    public void Countbuybook(String countname,String bookname)    {        bookdaoimp.updatebookstore(bookname);        bookdaoimp.updateacountbalance(countname, bookdaoimp.findbookpricebyname(bookname));    }}

异常类：

public class BookStoreException extends RuntimeException{    private static final long serialVersionUID = 1L;    public BookStoreException(String message)    {        super(message);    }   }

public class CountBalanceException extends RuntimeException{    public CountBalanceException(String message)    {        super(message);    }}

三：编写测试

import static org.junit.Assert.*;import java.sql.SQLException;import javax.sql.DataSource;import org.junit.Test;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;import com.dao.BookDaoImp;import com.service.BookService;public class test {    private BookService bookservice;    private ApplicationContext ac;    {        ac=new ClassPathXmlApplicationContext("applicationcontext.xml");        bookservice=ac.getBean(BookService.class);    }    @Test    public void buybook()    {        bookservice.Countbuybook("Tom", "c++");    }    @Test    public void testbookdao()    {        System.out.println(bookservice.findbookbalancebyname("java"));    }    @Test    public void tests() throws SQLException {        DataSource datasource=(DataSource) ac.getBean(DataSource.class);        System.out.println(datasource.getConnection());    }}

上面只是简单的测试了一下，可以使用的

至此，spring和hibernate的整合完成，具体功能就根据项目需求了