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
<------------------------------------------------>