spring+hibernate实例

1.配置文件

<?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.springframework.jdbc.datasource.DriverManagerDataSource">
  <property name="driverClassName">
   <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
  </property>
  <property name="url">
   <value>jdbc:microsoft:sqlserver://localhost:1433</value>
  </property>
  <property name="username">
   <value>sa</value>
  </property>
  <property name="password">
   <value>sa</value>
  </property>
 </bean>
 <!-- 定义sessionFactory -->
 <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
  <property name="dataSource">
   <ref local="dataSource"/>此处dataSource是上面定义的dataSource
  </property>
  <property name="mappingResources">
   <list>
    <value>bao/Register.hbm.xml</value>   Register表对应的配置文件
   </list>
  </property>
  <property name="hibernateProperties">
   <props>
    <prop key="hibernate.Dialect">org.hibernate.dialect.SQLServerDialect</prop>
    <!-- <prop key="hibernate.hbm2ddl.aut">update</prop> -->
   </props>
  </property>
 </bean>
 <bean id="regis" class="RegisterDAO"> 配置DAO对象的sessionFactory
  <property name="sessionFactory">
   <ref local="sessionFactory"/>
  </property>
 </bean>
</beans> 

2.RegisterDAO源代码

import bao.Register;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import java.util.List;

public class RegisterDAO extends HibernateDaoSupport implements IRegisterDAO {

 public boolean insertRegister(Register reg) {
  // TODO Auto-generated method stub
   this.getHibernateTemplate().save(reg);
   return true;
 }

 public boolean removeRegister(Register reg) {
  if (this.findRegister(reg.getId()) != null) {
   this.getHibernateTemplate().delete(reg);
   return true;
  }
  return false;
 }

 public boolean updateRegister(Register reg) {
  if (this.findRegister(reg.getId()) != null) {
   this.getHibernateTemplate().update(reg);
   return true;
  }
  return false;
 }

 public Register findRegister(Integer id) {
  Object o = this.getHibernateTemplate().get(Register.class, id);
  if (o != null)
   return (Register) o;
  return null;
 }
 
 public List getList(){
  return this.getHibernateTemplate().find("from Register");
 }
}

3.测试

import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.beans.BeansException;
import org.springframework.beans.factory.xml.XmlBeanFactory;
import java.io.FileInputStream;
import java.io.FileNotFoundException;

import org.springframework.core.io.InputStreamResource;

import bao.Register;
import java.util.*;

public class test {
 public static void main(String[] args){
  try {
   XmlBeanFactory factory = new XmlBeanFactory(new InputStreamResource(new FileInputStream("src/applicationContext.xml")));
   IRegisterDAO dao = (IRegisterDAO)factory.getBean("regis");
   Register re = new Register();
   //re.setId(4);
   //re.setId(new Integer(7));                
   re.setUsername("my");
   re.setPassword("123456");
   dao.insertRegister(re);
   //dao.removeRegister(re);
   //re = dao.findRegister(new Integer(6));
   //List myArray = dao.getList();
   //System.out.println("查找成功"+myArray.size());
   System.out.println("插入成功");
  } catch (BeansException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (FileNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }
}