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 容器中运行，也可以单独运行.
