Spring+HIbernate 数据库实例

---

---

Spring+HIbernate 数据库实例

这个实例，只有如何使用 Hibernate 在Spring框架进行 MySQL 数据库的数据处理工作(插入，选择，更新和删除)，没有UI界面。

参考教材：http://www.yiibai.com/spring/maven-spring-hibernate-mysql-example.html

版本信息

Tomcat 8.0
JDK 1.8
Eclipse版本 Neon.1a Release (4.6.1)
Spring 4.3.4
HIbernate 4.3.11
数据库 MySQL5.7.12

项目结构

源码下载：http://pan.baidu.com/s/1nvdf0Id

实体类

Stock.java

package com.jxust.model;

import java.io.Serializable;
/**
 * Stock股票信息实体类
 * @author Peng
 * @Date2016年11月28日下午2:32:49
 */
public class Stock implements Serializable {

    private Long stockId;//id
    private String stockCode;//股票代码
    private String stockName;//股票名称

    //省略getter and getter
    @Override
    public String toString() {
        return "Stock [stockId=" + stockId + ", stockCode=" + stockCode + ", stockName=" + stockName + "]";
    }   
}

Stock.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class name="com.jxust.model.Stock" table="tb_stock">
        <id name="stockId" type="java.lang.Long">
            <column name="STOCK_ID" />
            <generator class="identity" />
        </id>
        <property name="stockCode" type="string">
            <column name="STOCK_CODE" length="10" not-null="true" unique="true" />
        </property>
        <property name="stockName" type="string">
            <column name="STOCK_NAME" length="20" not-null="true" unique="true" />
        </property>
    </class>
</hibernate-mapping>

Dao层

StockDao.java

package com.jxust.dao;

import com.jxust.model.Stock;
/**
 * 股票信息Dao层接口
 * @author Peng
 * @Date2016年11月28日下午2:35:50
 */
public interface StockDao {

    void save(Stock stock);
    void update(Stock stock);
    void delete(Stock stock);
    Stock findByStockCode(String stockCode);
}

StockDaoImpl.java

package com.jxust.dao.impl;

import java.util.List;

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

import com.jxust.dao.StockDao;
import com.jxust.model.Stock;
/**
 * 股票Dao层实现类
 * @author Peng
 * @Date2016年11月28日下午2:36:19
 */
public class StockDaoImpl extends HibernateDaoSupport implements StockDao{

    /**
     * 保存方法
     */
    public void save(Stock stock){
        getHibernateTemplate().save(stock);
    }
    /**
     * 更新方法
     */
    public void update(Stock stock){
        getHibernateTemplate().update(stock);
    }
    /**
     * 删除方法
     */
    public void delete(Stock stock){
        getHibernateTemplate().delete(stock);
    }
    /**
     * 根据股票代码方法，查询股票信息
     * stockName 和 stockCode 都设置了UNIQUE 约束，可以标识每行 数据
     */
    public Stock findByStockCode(String stockCode){
        // from 跟 实体类名
        List list = getHibernateTemplate().find(
                      "from Stock where stockCode=?",stockCode
                );
        return (Stock)list.get(0);
    }
}

业务层

StockService.java

package com.jxust.service;

import com.jxust.model.Stock;
/**
 * 股票业务层接口
 * @author Peng
 * @Date2016年11月28日下午2:36:50
 */
public interface StockService {

    void save(Stock stock);
    void update(Stock stock);
    void delete(Stock stock);
    Stock findByStockCode(String stockCode);
}

StockServiceImpl.java

package com.jxust.service.impl;

import org.springframework.transaction.annotation.Transactional;

import com.jxust.dao.StockDao;
import com.jxust.model.Stock;
import com.jxust.service.StockService;
/**
 * 股票业务层实现类
 * @author Peng
 * @Date2016年11月28日下午2:37:07
 */
@Transactional//配置事务
public class StockServiceImpl implements StockService {

    //注入Dao层
    private StockDao stockDao;

    public void setStockDao(StockDao stockDao) {
        this.stockDao = stockDao;
    }
    //增
    public void save(Stock stock){
        stockDao.save(stock);
    }
    //改
    public void update(Stock stock){
        stockDao.update(stock);
    }
    //删
    public void delete(Stock stock){
        stockDao.delete(stock);
    }
    //查
    public Stock findByStockCode(String stockCode){
        return stockDao.findByStockCode(stockCode);
    }
}

数据库连接配置

database.properties

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/db_sh?useSSL=false
jdbc.username=root
jdbc.password=root

Spring 配置文件

引入database.properties文件，配置sessionFactory和事务

Hibernate.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: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-2.5.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.xsd ">

    <!-- 引用外部数据库配置文件 -->
    <bean
        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location">
            <value>properties/database.properties</value>
        </property>
    </bean>

    <bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${jdbc.driverClassName}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
    </bean>

    <!-- Hibernate配置 sessionFactory -->
    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <property name="dataSource">
            <ref bean="dataSource" />
        </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>

        <property name="mappingResources">
            <list>
                <value>/hibernate/Stock.hbm.xml</value>
            </list>
        </property>
    </bean>
    <!-- 配置事务管理器 -->
    <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"></property>
    </bean>

    <!-- 开启事务注解 -->
    <tx:annotation-driven transaction-manager="transactionManager"  />
</beans>

BeanLocations.xml

<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">

    <!-- 引入分开写的数据库的spring配置文件，你也可以写在这一个文件中 -->
    <import resource="../database/Hibernate.xml"/>
    <!--<import resource="classpath:/database/Hibernate.xml"/> -->

   <bean id="stockServiceBean" class="com.jxust.service.impl.StockServiceImpl" >
        <property name="stockDao" ref="stockDaoBean" />
   </bean>

   <bean id="stockDaoBean" class="com.jxust.dao.impl.StockDaoImpl" >
        <property name="sessionFactory" ref="sessionFactory"></property>
   </bean>
</beans>

执行类

使用Junit4测试

TestHibernate.java

package com.jxust.test;

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

import com.jxust.model.Stock;
import com.jxust.service.StockService;
/**
 * 测试增删改查
 * @author Peng
 * @Date2016年11月28日下午6:44:10
 */
public class TestHibernate {
    @Test
    public void testInsert(){
        ApplicationContext appContext = new ClassPathXmlApplicationContext("config/BeanLocations.xml");

        StockService stockBo = (StockService) appContext.getBean("stockServiceBean");
        /** insert **/
        Stock stock = new Stock();
        stock.setStockCode("7635");
        stock.setStockName("HAIO-6");
        stockBo.save(stock);        
    }

    @Test
    public void testselect() {
        ApplicationContext appContext = new ClassPathXmlApplicationContext("config/BeanLocations.xml");
        StockService stockBo = (StockService) appContext.getBean("stockServiceBean");
        /** select **/
        Stock stock2 = stockBo.findByStockCode("9668");
        System.out.println(stock2);
    }
    @Test
    public void testupdate(){
        ApplicationContext appContext = new ClassPathXmlApplicationContext("config/BeanLocations.xml");
        StockService stockBo = (StockService) appContext.getBean("stockServiceBean");
        /** update **/
        Stock stock2 =stockBo.findByStockCode("7668");
        stock2.setStockName("HAIO-1");
        stockBo.update(stock2);
    }
    @Test
    public void testdelete(){
        ApplicationContext appContext = new ClassPathXmlApplicationContext("config/BeanLocations.xml");
        StockService stockBo = (StockService) appContext.getBean("stockServiceBean");
        /** delete **/
        Stock stock2 = stockBo.findByStockCode("7668");
        stock2.setStockName("HAIO-1");//不根据这条数据，这里设置和数据表中不同数据，也能删除
        stockBo.delete(stock2);
        /**
         * getHibernateTemplate().delete(stock);
         * 必须要传入带主键的Stock 对象
         * 根据 主键删除
         */
    }
}

下面是testselect()查询语句的结果：

Hibernate: 
    select
        stock0_.STOCK_ID as STOCK_ID1_0_,
        stock0_.STOCK_CODE as STOCK_CO2_0_,
        stock0_.STOCK_NAME as STOCK_NA3_0_ 
    from
        tb_stock stock0_ 
    where
        stock0_.STOCK_CODE=?
Stock [stockId=2, stockCode=9668, stockName=WAHaha]

笔记.txt

上面的配置文件中使用了事务注解的方式，下面记录了三种事务管理的配置方式，配置方式具体看：http://blog.csdn.net/peng_hong_fu/article/details/53379282

                            <!--利用tx标签配置事务。  -->
    <!-- 配置事务容器 -->
    <bean id="transactionManager"
        class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>
     <!-- 配置事务通知属性 -->  
    <tx:advice id="txAdvice" transaction-manager="transactionManager">  
        <!-- 定义事务传播属性 -->  
        <tx:attributes>  
            <tx:method name="insert*" propagation="REQUIRED" />  
            <tx:method name="update*" propagation="REQUIRED" />  
            <tx:method name="edit*" propagation="REQUIRED" />  
            <tx:method name="save*" propagation="REQUIRED" />  
            <tx:method name="add*" propagation="REQUIRED" />  
            <tx:method name="new*" propagation="REQUIRED" />  
            <tx:method name="set*" propagation="REQUIRED" />  
            <tx:method name="remove*" propagation="REQUIRED" />  
            <tx:method name="delete*" propagation="REQUIRED" />  
            <tx:method name="change*" propagation="REQUIRED" />  
            <tx:method name="get*" propagation="REQUIRED" read-only="true" />  
            <tx:method name="find*" propagation="REQUIRED" read-only="true" />  
            <tx:method name="load*" propagation="REQUIRED" read-only="true" />  
            <tx:method name="*" propagation="REQUIRED" read-only="true" />  
        </tx:attributes>  
    </tx:advice>  
    <!-- 定义事务入口 需要aspectjweaver-1.x.x.jar包-->
    <aop:config>
        <aop:pointcut id="allDaoMethod" expression="execution(* com.jxust.dao.*.*(..))" />
        <aop:advisor advice-ref="txAdvice" pointcut-ref="allDaoMethod" />
    </aop:config>
<------------------------------------------------>
    org.springframework.dao.InvalidDataAccessApiUsageException: Write operations are not allowed in read-only mode (FlushMode.MANUAL): Turn your Session into FlushMode.COMMIT/AUTO or remove 'readOnly' marker from transaction definition.
<------------------------------------------------>
    <!--利用代理配置事务。  -->
    <!-- 配置事务容器 -->
    <bean id="transactionManager"
        class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>
    <!-- 定义事务规则 -->
    <bean id="transactionProxy"
        class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"
        abstract="true">
        <property name="transactionManager" ref="transactionManager" />
        <property name="transactionAttributes">
            <props>
                <prop key="sav*">PROPAGATION_REQUIRED</prop>
                <prop key="update*">PROPAGATION_REQUIRED</prop>
                <prop key="delete*">PROPAGATION_REQUIRED</prop>
                <prop key="*">PROPAGATION_REQUIRED</prop>
            </props>
        </property>
    </bean>
    <!-- 定义事务入口 -->
    <bean id="userDaoProxy" parent="transactionProxy">
        <property name="target" ref="stockDaoBean"></property>
    </bean>
    <------------------------------------------------>
        <!-- 配置事务管理器 -->
    <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"></property>
    </bean>

    <!-- 开启事务注解 -->
    <tx:annotation-driven transaction-manager="transactionManager"  />

    @Transactional
    <------------------------------------------------>