sping整合hibernate之二：dao层开发

<?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:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd"> <!-- 此对象用来读取数据库配置文件jdbc.properties
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location">
<value>/WEB-INF/jdbc.properties</value>
</property>
</bean> --> <!-- 配置数据源(这里是使用spring默认的数据源，后面会换成c3p0) -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/ssh"></property>
<property name="username" value="root"></property>
<property name="password" value="123456"></property>
</bean> <!-- 配置hibernate的会话工厂sessionFactory-->
<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property> <!-- 数据源采用上面的 -->
<property name="mappingResources"> <!-- 自动扫描model包下的实体类 -->
<list>
<value>/com/scitc/ssh/model/User.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="dialect">org.hibernate.dialect.MySQL5Dialect</prop>
<!-- <prop key="hibernate.current_session_context_class">thread</prop>-->
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
</props>
</property>
</bean> <!-- 配置hibernateTemplate 相当于jdbc -->
<bean id="hibernateTemplate" class="org.springframework.orm.hibernate4.HibernateTemplate">
<property name="sessionFactory" ref="sessionFactory"></property> <!-- 注入sessionFactory -->
</bean> <!-- spring事务管理 -->
<bean name="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
<property name="dataSource" ref="dataSource" />
<property name="sessionFactory" ref="sessionFactory" />
</bean> <!-- 开启spring的注解 -->
<context:annotation-config /> <!-- 可以不要这个，下面的扫描包可以自动开启注解 --> <!-- 自动扫描services层和dao层的注解 -->
<context:component-scan base-package="com.scitc.ssh.services" />
<context:component-scan base-package="com.scitc.ssh.services.impl" />
<context:component-scan base-package="com.scitc.ssh.dao" />
<context:component-scan base-package="com.scitc.ssh.dao.impl" /> <!-- 声明事务 -->
<aop:config>
<aop:pointcut id="txServices" expression="execution(* com.scitc.ssh.dao..*.*(..))"/>
<aop:advisor advice-ref="txAdvice" pointcut-ref="txServices"/>
</aop:config> <tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="add*" propagation="REQUIRED"/>
<tx:method name="insert*" propagation="REQUIRED"/>
<tx:method name="update*" propagation="REQUIRED"/>
<tx:method name="delete*" propagation="REQUIRED"/>
<tx:method name="create*" propagation="REQUIRED"/>
<tx:method name="find*" propagation="REQUIRED"/>
</tx:attributes>
</tx:advice> <!-- 注入dao层需要用hibernateTemplate的类 -->
<bean id="BaseDao" class="com.scitc.ssh.dao.BaseDao">
<!-- 为此类注入一个属性，这样在类中就可以获取到这个对象 -->
<!-- 功能:HibernateTemplate hibernateTemplate = new HibernateTemplate() -->
<property name="hibernateTemplate" ref="hibernateTemplate"></property>
</bean> </beans>

package com.scitc.ssh.dao; import java.util.List; import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.orm.hibernate4.HibernateTemplate; import com.scitc.ssh.model.User; //数据访问层通用类
public class BaseDao { //@Autowired可以自动获取spring创建的对象
@Autowired private HibernateTemplate hibernateTemplate; //这里的属性名一定要和配置中的属性名一致 //返回hibernateTemplate方法
public HibernateTemplate getHibernateTemplate(){
return this.hibernateTemplate;
} public void setHibernateTemplate(HibernateTemplate hibernateTemplate) {
this.hibernateTemplate = hibernateTemplate;
} //添加
public boolean add(Object entity){
this.hibernateTemplate.save(entity); //hibernateTemplate.save(entity)保存
return true;
} //删除
public boolean delete(Object entity){
this.hibernateTemplate.delete(entity);
return true;
} //查询全部
@SuppressWarnings("unchecked")
public List<Object> findAll(String queryString){
return (List<Object>) this.hibernateTemplate.find(queryString); } //修改
public boolean update(Object entity){
this.hibernateTemplate.update(entity);
return true; } // //按参数查询
// public List<Object> findAll(String queryString, Object[] args){
// List<Object> list = new ArrayList<Object>();
// this.hibernateTemplate.find(queryString);
// return list;
// } public static void main(String[] args) {
User user = new User();
user.setU_id(1);
user.setU_name("社会你海哥");
//启动spring
ApplicationContext applicationContexts = new ClassPathXmlApplicationContext("applicationContext.xml");
//获取Ioc容器中的对象
BaseDao baseDao = applicationContexts.getBean("BaseDao", BaseDao.class);
// baseDao.add(user);
baseDao.update(user);
// User user2 = (User) baseDao.findAll("from User").get(0);
// baseDao.delete(user);
// System.out.println(user2.getU_name()); } }