Spring+Hibernate

SpringMVC与Hibernate整合


1.创建web项目

2.引入类库

antlr-2.7.6.jar

com.springsource.com.mchange.v2.c3p0-0.9.1.2.jar

com.springsource.javax.servlet.jsp.jstl-1.1.2.jar

com.springsource.javax.validation-1.0.0.GA.jar

com.springsource.net.sf.cglib-2.2.0.jar

com.springsource.org.aopalliance-1.0.0.jar

com.springsource.org.apache.commons.logging-1.1.1.jar

com.springsource.org.apache.taglibs.standard-1.1.2.jar

com.springsource.org.aspectj.tools-1.6.6.RELEASE.jar

com.springsource.org.aspectj.weaver-1.6.8.RELEASE.jar

commons-collections-3.1.jar

commons-fileupload-1.2.2.jar

commons-io-2.0.1.jar

dom4j-1.6.1.jar

hibernate-validator-4.1.0.Final.jar

hibernate3.jar

javassist-3.9.0.GA.jar

jta-1.1.jar

log4j.jar

mysql-connector-java-5.0.8-bin.jar

org.springframework.aop-3.1.0.RELEASE.jar

org.springframework.asm-3.1.0.RELEASE.jar

org.springframework.aspects-3.1.0.RELEASE.jar

org.springframework.beans-3.1.0.RELEASE.jar

org.springframework.context-3.1.0.RELEASE.jar

org.springframework.context.support-3.1.0.RELEASE.jar

org.springframework.core-3.1.0.RELEASE.jar

org.springframework.expression-3.1.0.RELEASE.jar

org.springframework.jdbc-3.1.0.RELEASE.jar

org.springframework.orm-3.1.0.RELEASE.jar

org.springframework.transaction-3.0.0.RELEASE.jar

org.springframework.transaction-3.1.0.RELEASE.jar

org.springframework.web-3.1.0.RELEASE.jar

org.springframework.web.servlet-3.1.0.RELEASE.jar

slf4j-api-1.5.8.jar

slf4j-log4j12.jar

com.springsource.javax.annotation-1.0.0.jar

com.springsource.javax.xml.bind-2.1.7.jar



3.配置web.xml文件

<?xml version="1.0" encoding="UTF-8"?>

	
	<!-- 通过上下文参数指定spring配置文件的位置 -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:beans.xml</param-value>
	</context-param>
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	
	<servlet>
		<servlet-name>action</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<!-- 通过初始化参数指定springmvc配置文件的位置 -->
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>classpath:springmvc.xml</param-value>
		</init-param>
	</servlet>
	<servlet-mapping>
		<servlet-name>action</servlet-name>
		<url-pattern>/</url-pattern>
	</servlet-mapping>
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
</web-app>

4 编写beans.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:mvc="http://www.springframework.org/schema/mvc"
	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-3.0.xsd 
						http://www.springframework.org/schema/mvc 
						http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd 
						http://www.springframework.org/schema/context 
						http://www.springframework.org/schema/context/spring-context-3.0.xsd 
						http://www.springframework.org/schema/aop 
						http://www.springframework.org/schema/aop/spring-aop-3.0.xsd 
						http://www.springframework.org/schema/tx 
						http://www.springframework.org/schema/tx/spring-tx-3.0.xsd ">

	<!-- 组件扫描 -->
	<context:component-scan base-package="cn.itcast.springmvc.dao,cn.itcast.springmvc.service,cn.itcast.springmvc.controller"/>
	
	<!-- 注解驱动 -->
	<mvc:annotation-driven/>
	
		<!-- 数据源 -->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="com.mysql.jdbc.Driver" />
		<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/itcast" />
		<property name="user" value="root" />
		<property name="password" value="root" />
		<property name="maxPoolSize" value="10" />
		<property name="minPoolSize" value="5" />
		<property name="initialPoolSize" value="5" />
	</bean>
	
	<!-- 本地会话工厂bean -->
	<bean id="sf" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource" ref="dataSource"/>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.Dialect">org.hibernate.dialect.MySQL5Dialect</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.hbm2ddl">update</prop>
			</props>
		</property>
		<property name="mappingDirectoryLocations">
			<value>classpath:cn/itcast/springmvc/domain</value>
		</property>
	</bean>

	<!-- 事物管理器 -->
	<bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory" ref="sf"/>
	</bean>
	
	<!-- 事物通知 -->
	<tx:advice id="txAdvice" transaction-manager="txManager">
		<tx:attributes>
			<tx:method name="save*" propagation="REQUIRED"/>
			<tx:method name="update*" propagation="REQUIRED"/>
			<tx:method name="delete*" propagation="REQUIRED"/>
			<tx:method name="find*" read-only="true"/>
			<tx:method name="*" propagation="REQUIRED"/>
		</tx:attributes>
	</tx:advice>
	
	<aop:config>
		<aop:advisor pointcut="execution(* *..*Service.*(..))" advice-ref="txAdvice"/>
	</aop:config>
</beans>

5.编写spring-mvc.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:mvc="http://www.springframework.org/schema/mvc"
	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-3.0.xsd 
						http://www.springframework.org/schema/mvc 
						http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd 
						http://www.springframework.org/schema/context 
						http://www.springframework.org/schema/context/spring-context-3.0.xsd 
						http://www.springframework.org/schema/aop 
						http://www.springframework.org/schema/aop/spring-aop-3.0.xsd 
						http://www.springframework.org/schema/tx 
						http://www.springframework.org/schema/tx/spring-tx-3.0.xsd ">
	<!-- 内部资源视图解析器 -->
	<bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/jsp/"/>
		<property name="suffix" value=".jsp"/>
	</bean>
</beans>




6.定义Person实体类

package cn.itcast.springmvc.domain;

public class Person {

private String id;
private String name;
private int age;
private String address;
public String getId() {
return id;
}
public void setId(String 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;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
}

7.定义Person实体类的映射文件Person.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="cn.itcast.springmvc.domain.Person" table="persons">
		<id name="id" column="id" type="string">
			<generator class="uuid" />
		</id>
		<property name="name" column="name" type="string" />
		<property name="age" column="age" type="integer" />
		<property name="address" column="address" type="string"/>
	</class>
</hibernate-mapping>

8.创建Persons表


create table Persons (id varchar(36) primary key,name varchar(36),age int,address varchar(100));

9.定义Dao的接口和实现类 ,并注入sessionFactory

Dao接口:
public interface PersonDao {
public void savePerson(Person p);
public void deletePerson(Person p);
public void updatePerson(Person p);
public List<Person> findAllPerson();
public Person findPersonById(String id);
}

Dao实现类:
@Repository("personDao")
public class PersonDaoImpl implements PersonDao{
@Resource(name="sf")
private SessionFactory sf;
public void deletePerson(Person p) {
sf.getCurrentSession().delete(p);
}
public List<Person> findAllPerson() {
return sf.getCurrentSession().createQuery("from Person").list();
}
public Person findPersonById(String id) {
return (Person)sf.getCurrentSession().get(Person.class, id);
}
public void savePerson(Person p) {
sf.getCurrentSession().save(p);
}
public void updatePerson(Person p) {
sf.getCurrentSession().update(p);
}
}

10.定义Service的接口和实现类,并注入dao

Service接口:
public interface PersonService {
public void savePerson(Person p);
public void deletePerson(Person p);
public void updatePerson(Person p);
public List<Person> findAllPerson();
public Person findPersonById(String id);
}

Service实现类:
@Service("personService")
public class PersonServiceImpl implements PersonService {
@Resource
private PersonDao personDao;
public void deletePerson(Person p) {
personDao.deletePerson(p);
}
public List<Person> findAllPerson() {
return personDao.findAllPerson();
}
public Person findPersonById(String id) {
return personDao.findPersonById(id);
}
public void savePerson(Person p) {
personDao.savePerson(p);
}
public void updatePerson(Person p) {
personDao.updatePerson(p);
}
}

11.定义Controller,并注入service

@Controller
@RequestMapping(value="/per")//根路径
public class PersonController {
@Resource
private PersonService personService;
@RequestMapping(value="/save",method=RequestMethod.POST)
public String savePerson(Person p){
personService.savePerson(p);
return "redirect:/per/findAll";
}
@RequestMapping(value="/findAll")
public String findAllPersons(Model model){
List<Person> persons = personService.findAllPerson();
model.addAttribute("persons", persons);
return "personList";
}
@RequestMapping(value="/addPersonUI")
public String addPersonUI(Model model){
return "addPerson";
}
@RequestMapping(value="/delete")
public String delete(String id){
Person p = new Person();
p.setId(id);
personService.deletePerson(p);
return "redirect:/per/findAll";
}
@RequestMapping(value="/editUI")
public String editUI(String id ,Model model){
Person p = personService.findPersonById(id);
model.addAttribute("p", p);
return "editPerson";
}
@RequestMapping(value="/update")
public String updatePerson(Person p){
personService.updatePerson(p);
return "redirect:/per/findAll";
}
}

12.创建jsp页面

1.在WEB-INF下创建jsp目录
2.在jsp目录中创建addPerson.jsp,内容如下:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http : // j ava.sun.com/jsp/jstl/core"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
  <head>
    <title>addPerson.jsp</title>
  </head>
  
  <body>
  <h3>添加Person</h3>
  <hr>
  <form action="<%=path %>/per/save" method="post">
  <table border="1" width="500">
    <tr>
    <td>Name:</td>
    <td><input type="text" name="name"></td>
    </tr>
    <tr>
    <td>Age:</td>
    <td><input type="text" name="age"></td>
    </tr>
    <tr>
    <td>Address:</td>
    <td><input type="text" name="address"></td>
    </tr>
    <tr>
    <td><input type="reset" name="res" value="取 消"></td>
    <td><input type="submit" name="sub" value="提 交"></td>
    </tr>
    </table>
  </form>
  </body>
</html>

3.在jsp目录下创建editPerson.jsp,内容如下:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="h t t p: // java.sun.com/jsp/jstl/core"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
  <head>
    <title>editPerson.jsp</title>
  </head>
  
  <body>
  <h3>编辑Person</h3>
  <hr>
  <form action="<%=path %>/per/update" method="post">
  <table border="1" width="500">
    <tr>
    <td>Name:</td>
    <td><input type="text" name="name" value="${p.name }"></td>
    </tr>
    <tr>
    <td>Age:</td>
    <td><input type="text" name="age" value="${p.age }"></td>
    </tr>
    <tr>
    <td>Address:</td>
    <td><input type="text" name="address"  value="${p.address }"></td>
    </tr>
    <tr>
    <td><input type="reset" name="res" value="取 消"></td>
    <td><input type="submit" name="sub" value="提 交"></td>
    </tr>
    </table>
    <input type="hidden" name="id" value="${p.id }">
  </form>
  </body>
</html>

4.在jsp目录下创建personList.jsp,内容如下:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="h t t p: / / java.sun.com/jsp/jstl/core"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
  <head>
    <title>personList.jsp</title>
  </head>
  
  <body>
  <a href="<%=path %>/per/addPersonUI">添加person</a><br>
    <table border="1" width="500">
    <tr>
    <td>name</td>
    <td>age</td>
    <td>address</td>
    <td>删除</td>
    <td>编辑</td>
    </tr>
    <c:forEach items="${persons}" var="p">
    <tr>
    <td>${p.name }</td>
    <td>${p.age }</td>
    <td>${p.address }</td>
    <td><a href="<%=path %>/per/delete?id=${p.id }">删除</a></td>
    <td><a href="<%=path %>/per/editUI?id=${p.id }">编辑</a></td>
    </tr>
    </c:forEach>
    </table>
  </body>
</html>



评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值