Spring与Hibernate整合

14 篇文章 0 订阅
7 篇文章 0 订阅

1、创建一个maven项目PomDependency,以pom方式打包。 在pom.xml中添加如下依赖:

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>com.guo</groupId>
	<artifactId>PomDependency</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>pom</packaging>
	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>

	<dependencies>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.12</version>
			<scope>test</scope>
		</dependency>

		<dependency><!--servelt -->
			<groupId>javax.servlet</groupId>
			<artifactId>javax.servlet-api</artifactId>
			<version>4.0.0-b07</version>
			<scope>provided</scope>
		</dependency>

		<dependency>
			<groupId>redis.clients</groupId>
			<artifactId>jedis</artifactId>
			<version>3.0.1</version>
		</dependency>

		<dependency>
			<groupId>mysql</groupId><!-- MySql -->
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.39</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-orm</artifactId>
			<version>4.3.21.RELEASE</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-test</artifactId>
			<version>4.3.21.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.aspectj</groupId>
			<artifactId>aspectjrt</artifactId>
			<version>1.9.2</version>
		</dependency>

		<dependency>
			<groupId>org.aspectj</groupId>
			<artifactId>aspectjweaver</artifactId>
			<version>1.9.2</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-core</artifactId>
			<version>4.3.7.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-beans</artifactId>
			<version>4.3.7.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>4.3.7.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.data</groupId>
			<artifactId>spring-data-jpa</artifactId>
			<version>1.8.0.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>com.fasterxml.jackson.datatype</groupId>
			<artifactId>jackson-datatype-hibernate5</artifactId>
			<version>2.9.9</version>
		</dependency>
		<!-- 2.Spring dao依赖 -->
		<!-- spring-jdbc包括了一些如jdbcTemplate的工具类 -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>4.3.7.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-tx</artifactId>
			<version>4.3.7.RELEASE</version>
		</dependency>
		<!-- 3.Spring web依赖 -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-web</artifactId>
			<version>4.3.7.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>4.3.7.RELEASE</version>
		</dependency>
		<!-- 4.Spring test依赖:方便做单元测试和集成测试 <dependency> <groupId>org.springframework</groupId> 
			<artifactId>spring-test</artifactId> <version>4.3.7.RELEASE</version> </dependency> -->


		<!-- Log4J -->
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
			<version>1.2.17</version>
		</dependency>

		<!--mybatis -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.4.1</version>
		</dependency>

		<dependency>
			<groupId>com.mchange</groupId>
			<artifactId>c3p0</artifactId>
			<version>0.9.2.1</version>
		</dependency>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.3.0</version>
		</dependency>


		<!-- JSTL -->
		<dependency>
			<groupId>jstl</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>
		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-databind</artifactId>
			<version>2.9.1</version>
		</dependency>

		<dependency>
			<groupId>com.github.pagehelper</groupId>
			<artifactId>pagehelper</artifactId>
			<version>5.0.0</version>
		</dependency>

		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>jsp-api</artifactId>
			<version>2.0</version>
			<scope>provided</scope>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-orm</artifactId>
			<version>5.0.8.RELEASE</version>
		</dependency>

		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>servlet-api</artifactId>
			<version>2.5</version>
			<scope>provided</scope>
		</dependency>

		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-core</artifactId>
			<version>5.0.7.Final</version>
		</dependency>

		<dependency>
			<groupId>org.javassist</groupId>
			<artifactId>javassist</artifactId>
			<version>3.20.0-GA</version>
		</dependency>

		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-nop</artifactId>
			<version>1.6.4</version>
		</dependency>

	</dependencies>
</project>

2、再新建一个Maven项目,以jar形式打包,继承PomDependency
在src/mian/resources下创建spring.xml

<?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:context="http://www.springframework.org/schema/context"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
	http://www.springframework.org/schema/beans/spring-beans.xsd
	http://www.springframework.org/schema/context
	http://www.springframework.org/schema/context/spring-context.xsd
	http://www.springframework.org/schema/aop
	http://www.springframework.org/schema/aop/spring-aop.xsd
	http://www.springframework.org/schema/tx 
	http://www.springframework.org/schema/tx/spring-tx.xsd">


	<context:property-placeholder location="classpath:db.properties" />

	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="${mysql.driver}" />
		<property name="jdbcUrl" value="${mysql.url}" />
		<property name="user" value="${mysql.username}" />
		<property name="password" value="${mysql.password}" />
	</bean>

	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.show_sql">true</prop><!-- 显示当前执行的sql语句 -->
				<prop key="hibernate.hbm2ddl.auto">update</prop><!-- 开启正向工程 -->
			</props>
		</property>
		<property name="packagesToScan"><!-- 扫描实体所在的包 -->
			<list>
				<value>com.guo.bean</value>
			</list>
		</property>
	</bean>

	<!-- 配置HiberanteTemplate对象 -->
	<bean id="template" class="org.springframework.orm.hibernate5.HibernateTemplate">
		<property name="sessionFactory" ref="sessionFactory" />
	</bean>
	<!-- 配置Hibernate的事务管理器 -->
	<bean id="transactionManager"
		class="org.springframework.orm.hibernate5.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory" />
	</bean>
	<tx:annotation-driven transaction-manager="transactionManager" />


	<!-- 注解装配 -->
	<context:component-scan
		base-package="com.guo.dao.impl,com.guo.service.impl,com.guo.action" />

</beans>

3、创建实体类、dao、service、action等接口与实现类

package com.guo.bean;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="person")  //表名
public class Person implements Serializable {

	private static final long serialVersionUID = 1L;

	@Id
	@GeneratedValue(strategy=GenerationType.IDENTITY)//主键自增长
    private Integer id;
	
	@Column(name="name")
    private String name;
	
	@Column(name="gender")
    private Character gender;
	
	@Column(name="age")
    private Integer age;
	
	@Column(name="province")
    private String province;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Character getGender() {
        return gender;
    }

    public void setGender(Character gender) {
        this.gender = gender;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getProvince() {
        return province;
    }

    public void setProvince(String province) {
        this.province = province;
    }

    @Override
    public String toString() {
        return "Person [id=" + id + ", name=" + name + ", gender=" + gender + ", age=" + age + ", province=" + province
                + "]";
    }

    public Person(Integer id, String name, Character gender, Integer age, String province) {
        this.id = id;
        this.name = name;
        this.gender = gender;
        this.age = age;
        this.province = province;
    }
    

    public Person(String name, Character gender, Integer age, String province) {
		this.name = name;
		this.gender = gender;
		this.age = age;
		this.province = province;
	}

	public Person() {
    }

	public Person(int id) {
		this.id = id;
	}
}
package com.guo.dao;

import java.util.List;

import com.guo.bean.Person;

public interface PersonDao {
     void add(Person p);
    Person getByID(Integer id);
    void update(Person p);
    void delete(Person p);
    List<Person> getAll();
    List<Person> getByName(String name);
}
package com.guo.dao.impl;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate5.HibernateTemplate;
import org.springframework.stereotype.Repository;

import com.guo.bean.Person;
import com.guo.dao.PersonDao;


@Repository
public class PersonDaoImpl implements PersonDao {
	
	@Autowired
	private HibernateTemplate template;
	
	public void setHibernateTemplate(HibernateTemplate template) {
		this.template = template;
	}
	
    @Override
    public void add(Person p) {
        template.save(p);
    }

	@Override
	public Person getByID(Integer id) {
		return template.get(Person.class, id);
	}

	@Override
	public void update(Person p) {
		template.update(p);
	}

	@Override
	public void delete(Person p) {
		template.delete(p);
	}

	@Override
	public List<Person> getAll() {
		Session session = template.getSessionFactory().getCurrentSession();
		try {
			Criteria c = session.createCriteria(Person.class);
	        return (List<Person>)c.list();
		} finally {
			//session.close();关闭会出现异常LogicalConnectionManagedImpl@654c1a54 is closed
		}
	}

    @Override
	public List<Person> getByName(String name) {
		Session session = template.getSessionFactory().getCurrentSession();
        try {
        	//方式一:
        	Query query = session.createQuery(" from Person where name = :abc");
        	Query queryTemp = query.setString("abc",name);
        	return queryTemp.list();
		} catch (Exception e) {
			//方式二:
			SQLQuery entity = session.createSQLQuery("select * person where name = ?").addEntity(Person.class);
        	entity.setString(0, name);
        	return entity.list();
		}finally {
			//session.close();关闭会出现异常LogicalConnectionManagedImpl@654c1a54 is closed
		}
	}

}
package com.guo.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.guo.bean.Person;
import com.guo.dao.PersonDao;
import com.guo.service.PersonService;

@Service
@Transactional//对于事务提交方式默认的是回滚

public class PersonServiceImpl implements PersonService {

	@Autowired
	private PersonDao personDao;

	public void setPersonDao(PersonDao personDao) {
		this.personDao = personDao;
	}

	@Override
	public void add(Person p) {
		if (p != null)
			personDao.add(p);
	}

	@Override
	public Person getByID(Integer id) {
		return personDao.getByID(id);
	}

	@Override
	public void update(Person p) {
		if (p != null)
			personDao.update(p);
	}

	@Override
	public void delete(Person p) {
		if (p != null)
			personDao.delete(p);
	}

	@Override
	public List<Person> getAll() {
		return personDao.getAll();
	}
    @Override
	public List<Person> getByName(String name) {
		return personDao.getByName(name);
	}

}

package com.guo.action;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;

import com.guo.bean.Person;
import com.guo.service.PersonService;


@Controller
@Scope(scopeName="prototype")//多例模式
public class PersonAction {
    @Autowired//自动装配
    private PersonService personService;

    public void setPersonService(PersonService personService) {
		this.personService = personService;
	}

    public void add(Person p) {
        personService.add(p);
    }
    
    Person getByID(Integer id){
    	return personService.getByID(id);
    }
    public void update(Person p){
    	personService.update(p);
    }
    public void delete(Person p){
    	personService.delete(p);
    }
    public List<Person> getAll(){
    	return personService.getAll();
    }

    public List<Person> getByName(String name) {
		return personService.getByName(name);
	}
    
}

4、测试:

        ApplicationContext context = new ClassPathXmlApplicationContext("spring.xml");
		PersonAction action = context.getBean(PersonAction.class);
		Person add = new Person("张三", '男', 20, "京");
		//插入
		action.add(add);
		//删除
		//Person delete = new Person(1);
		//action.delete(delete);

		//按主键查询
		System.out.println(action.getByID(2));
		//按姓名查询
		System.out.println(action.getByName("张三"));
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值