spring(4)：hibernate与spring整合

本节主要讲述hibernate与spring整合：

1，首先在数据库中创建person表:

包括id,name,age三个字段

2，创建一个WEB工程，导入hibernate与spring相关的jar包:除此外还要导入数据库连接池与mysql驱动相关的包，如下图所示：

 

3：代码：

 

PersonBean.java

package lee;

public class PersonBean {
	private int id;
	private String name;
	private int age;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
}

 

PersonDAO

package com.test.dao;

import java.util.List;
import lee.PersonBean;

public interface PersonDAO {
	public void createPerson(PersonBean person);

	public PersonBean getPerson(int id);

	public List findPersonsByName(String name);

	public void deletePerson(int id);

	public void updatePerson(PersonBean person);
}

 

具体操作类

package com.test.dao.impl;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import lee.PersonBean;

import com.test.dao.PersonDAO;

public class PersonDaoImpl extends HibernateDaoSupport implements PersonDAO {

	public void createPerson(PersonBean person) {
		this.getHibernateTemplate().save(person);
	}

	//根据id删除person
	public void deletePerson(int id) {
		PersonBean person = (PersonBean) this.getHibernateTemplate().get(PersonBean.class, id);
		this.getHibernateTemplate().delete(person);
	}
	
	//获取所有名称类似name的Person
	public List findPersonsByName(String name) {
		List list = this.getHibernateTemplate().find("from PersonBean as p where p.name like ?","%"+name+"%");
		return list;
	}

	public PersonBean getPerson(int id) {
		return (PersonBean) this.getHibernateTemplate().get(PersonBean.class,id);
	}

	public void updatePerson(PersonBean person) {
		this.getHibernateTemplate().saveOrUpdate(person);
	}

}

 

PersonBean.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC    
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"  
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
	<class name="lee.PersonBean" table="person">
		<id name="id" column="id" type="int">
			<generator class="increment"></generator>
		</id>
		<property name="name" column="name" type="java.lang.String"></property>
		<property name="age" column="age" type="int"></property>
	</class>
</hibernate-mapping>

 

hibernate.cfg.xml，此配置文件中没有什么配置。

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

    <session-factory>
    </session-factory>

</hibernate-configuration>

 

applicationContext.xml spring配置文件，这个文件是重点

<?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:p="http://www.springframework.org/schema/p"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
	<!-- 配置连接池数据源，destroy-method="close"表示退出时，将所有连接释放 -->
	<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://localhost:3306/hibernate</value>
		</property>
		<property name="username">
			<value>root</value>
		</property>
		<property name="password">
			<value>123456</value>
		</property>
	</bean>		
	<!-- session 工厂 -->
	<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource">
			<ref local="dataSource"/>
		</property>
		<property name="mappingResources">
			<list>
				<value>PersonBean.hbm.xml</value>
			</list>
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">
					org.hibernate.dialect.MySQLDialect
				</prop>
				<prop key="hibernate.show_sql">
					true
				</prop>
			</props>
		</property>
	</bean>
	<!-- PersonDaoImpl继承的抽象类HibernateDaoSupport里有setSessionFactory方法 -->
	<bean id="personDao" class="com.test.dao.impl.PersonDaoImpl">
		<property name="sessionFactory">
			<ref local="sessionFactory"/>
		</property>
	</bean>
</beans>

 

测试类

package lee;

import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.core.io.ClassPathResource;
import com.test.dao.PersonDAO;

public class Test {
	public static void main(String[] args) {
		XmlBeanFactory factory = new XmlBeanFactory(new ClassPathResource("applicationContext.xml"));
		PersonDAO personDao = (PersonDAO) factory.getBean("personDao");
		PersonBean person = new PersonBean();
		person.setName("lisi");
		person.setAge(21);
		personDao.createPerson(person);
	}
}