1.首先实现一个接口.
============================================================
package com.cqtele.tnbos;import java.util.*;public interface IUserDao { public void insertUser(userInfo user); public List findUser(String sql);}
==============================================================
2. 实现这个接口.
这里使用 Spring的 AOP-driven HibernateTemplate 简化 Hibernate 会话的处理.
================================================================package com.cqtele.tnbos;import java.util.*;
import net.sf.hibernate.*;import net.sf.hibernate.cfg.*;import java.io.Serializable;import org.springframework.orm.hibernate.*;//.HibernateCallback;import org.springframework.orm.hibernate.support.HibernateDaoSupport;
public class userDAO extends HibernateDaoSupport implements IUserDao{ //public List name=null; //Session session; private List list=null; public void insertUser(userInfo user) { getHibernateTemplate().saveOrUpdate(user); } public List findUser(String sql) { return getHibernateTemplate().find(sql); }}
=================================================================
3.声明式管理事务.
bean.xml
==========================================================================
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING/DTD BEAN/EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName"> <value>com.mysql.jdbc.Driver</value> </property> <property name="url"> <value>jdbc:mysql://127.0.0.1:3306/opertselect?useUnicode=true&characterEncoding=GBK</value> </property> <property name="username"> <value>root</value> </property> <property name="password"> <value></value> </property> </bean> <bean id="sessionFactory" class="org.springframework.orm.hibernate.LocalSessionFactoryBean"> <property name="dataSource"> <ref local="dataSource" /> </property> <property name="mappingResources"> <list> <value>userInfo.hbm.xml</value> <!--value>Fruits.hbm.xml</value--> </list> </property> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect"> net.sf.hibernate.dialect.MySQLDialect </prop> <prop key="hibernate.show_sql">true</prop> </props> </property> </bean> <bean id="transactionManager" class="org.springframework.orm.hibernate.HibernateTransactionManager"> <property name="sessionFactory"> <ref local="sessionFactory" /> </property> </bean> <bean id="userDAO" class="com.cqtele.tnbos.userDAO"> <property name="sessionFactory"> <ref local="sessionFactory" /> </property> </bean> <bean id="DAOProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"> <property name="transactionManager"> <ref bean="transactionManager" /> </property> <property name="target"> <ref local="userDAO" /> </property> <property name="transactionAttributes"> <props> <prop key="insert*">PROPAGATION_REQUIRED</prop> <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop> </props> </property> </bean></beans>==============================================================================
4.使用.(这是关于一个购物车的例子.)==============================================================================
package com.cqtele.tnbos;
import java.util.*;import java.io.*;import org.springframework.beans.factory.BeanFactory;import org.springframework.beans.factory.xml.XmlBeanFactory;import org.aopalliance.aop.Advice;
public class login{ private List list=null; private String sql="from userInfo"; public List getAllMessageList() { try{ InputStream is = new FileInputStream("bean.xml"); XmlBeanFactory factory = new XmlBeanFactory(is); IUserDao user = (IUserDao)factory.getBean("DAOProxy"); list = user.findUser(sql); }catch(IOException ioe) { System.out.println("getAllMessageList Ocurr Error!! Message: "+ioe.getMessage()); } return list; }}
======================================================================
5.总结
======================================================================
Hibernate 是一种先进的 OR 映射工具，而 Spring 是一个 AOP 框架和 IOC 容器。这两种技术的综合使用，使得开发人员可以编写媲美数据库厂商的代码，它可以在 J2EE 容器中运行，也可以单独运行.
