Spring4+SpringMVC4+hibernate4整合

刺骨的言语ヽ痛彻心扉 2022-03-07 02:48 328阅读 0赞

源码下载:[https://github.com/rj2017211811/springmvc-hibernate][https_github.com_rj2017211811_springmvc-hibernate]  
1.项目的目录和jar包  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3JqMjAxNzIxMTgxMQ_size_16_color_FFFFFF_t_70]  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3JqMjAxNzIxMTgxMQ_size_16_color_FFFFFF_t_70 1][]  
![在这里插入图片描述][20190316013745772.png]  
2.web.xml文件

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
    
    <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>
    	
    	<init-param>
    		
    		<param-name>contextConfigLocation</param-name>
    		<param-value>classpath:spring-mvc.xml</param-value>
    		
    	</init-param>
    	<load-on-startup>1</load-on-startup>
    </servlet> 
    
    <servlet-mapping>
    	<servlet-name>action</servlet-name>
    	<url-pattern>/</url-pattern>
    
    </servlet-mapping>
    
      <display-name>springmvcdb</display-name>
      <welcome-file-list>
        <welcome-file>index.html</welcome-file>
        <welcome-file>index.htm</welcome-file>
        <welcome-file>index.jsp</welcome-file>
        <welcome-file>default.html</welcome-file>
        <welcome-file>default.htm</welcome-file>
        <welcome-file>default.jsp</welcome-file>
      </welcome-file-list>
    </web-app>

3.spring-mvc.xml文件:配置spring-mvc

4.beans.xml文件:配置hibernate

<?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:p="http://www.springframework.org/schema/p"
    	xmlns:tx="http://www.springframework.org/schema/tx"
    	xmlns:aop="http://www.springframework.org/schema/aop"
    	xmlns:jaxws="http://cxf.apache.org/jaxws"
    	xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
    		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
    		http://cxf.apache.org/jaxws http://cxf.apache.org/schemas/jaxws.xsd
    		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
    		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
       
    		<context:component-scan base-package="per.czt.springmvc.dao,per.czt.springmvc.service" />
    		
    		<context:annotation-config />
    		
    		
    	
    	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
    		<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
    		<property name="url" value="jdbc:mysql://localhost:3306/springmvcdb?useSSL=false&serverTimezone=UTC&characterEncoding=utf-8"></property>
    		<property name="username" value="root"></property>
    	 <property name="password" value="123456"></property> 
     </bean>
    
    	
    	<bean id="sessionFactory"
    		class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
    		<property name="dataSource"><ref bean="dataSource" /></property>
    		
    		<property name="namingStrategy">
    		<bean class="org.hibernate.cfg.ImprovedNamingStrategy"></bean>
    		</property>
    		<property name="hibernateProperties">
    			
    			<props>
    			
    	        <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop> 
    			<prop key="hibernate.show_sql">true</prop>
    			
    			
    			
    			</props>
    		</property>
    		
    		
    		<property name="mappingDirectoryLocations">
    			<list>
    				<value>classpath:per/czt/springmvc/domain</value>
    			</list>
    		</property>
    	</bean>
    	<bean id="personDao" class="per.czt.springmvc.dao.PersonDaoImpl">
    		<property name="sessionFactory" ref="sessionFactory" />
    	</bean>
    	
    	<bean id="transactionManager"
    		class="org.springframework.orm.hibernate4.HibernateTransactionManager">
    		<property name="sessionFactory" ref="sessionFactory" />
    	</bean>
    	
    	<tx:advice id="transactionAdvice" transaction-manager="transactionManager">
    		
    		<tx:attributes>
    		
    			<tx:method name="add*" />
    			<tx:method name="save*" />
    			<tx:method name="Save*" />
    			<tx:method name="update*" />
    			<tx:method name="modify*" />
    			<tx:method name="edit*" />
    			<tx:method name="delete*" />
    			<tx:method name="remove*" />
    			<tx:method name="change*" />
    			<tx:method name="repair" />
    			<tx:method name="deleteAndRepair" />
    			<tx:method name="login*" />
    			<tx:method name="get*" propagation="SUPPORTS" />
    			<tx:method name="find*" propagation="SUPPORTS" />
    			<tx:method name="load*" propagation="SUPPORTS" />
    			<tx:method name="search*" propagation="SUPPORTS" />
    			<tx:method name="datagrid*" propagation="SUPPORTS" />
    			<tx:method name="*" propagation="SUPPORTS" />
    			
    			<tx:method name="get*" propagation="REQUIRED" />
    			<tx:method name="update*" propagation="REQUIRED"/>
    			<tx:method name="up*" propagation="REQUIRED" />
    			<tx:method name="delete*" propagation="REQUIRED"/>
                <tx:method name="count*" propagation="REQUIRED" read-only="true" />
                <tx:method name="find*" propagation="REQUIRED" read-only="true" />
                <tx:method name="list*" propagation="REQUIRED" read-only="true" />
                <tx:method name="*" propagation="REQUIRED" />
    		</tx:attributes>
    	</tx:advice>
    	
    	<aop:config proxy-target-class="true">
    		<aop:pointcut id="transactionPointcut" expression="execution(* per.czt.springmvc.service.*.*(..))" />
    		<aop:advisor pointcut-ref="transactionPointcut"
    			advice-ref="transactionAdvice" />
    	</aop:config>
    
    	
    	<tx:annotation-driven transaction-manager="transactionManager"/>
    	
    </beans>

5.person对象和Person.hbm.xml文件(pojo对象与数据库中的表一一对应)  
Person.class

package per.czt.springmvc.domain;
    
    public class Person {
    	private Integer id;
    	private String name;
    	private Integer age;
    
    	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 Integer getAge() {
    		return age;
    	}
    	public void setAge(Integer age) {
    		this.age = age;
    	}
    	
    	
    }

Person.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
    
    <!DOCTYPE hibernate-mapping PUBLIC 
    	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
    <hibernate-mapping package="per.czt.springmvc.domain">
    	<class name="Person" lazy="true" table="person">
    		<id name="id" column="id" type="java.lang.Integer">
    			<generator class="identity"></generator>
    		</id>
    		<property name="name" type="java.lang.String">
    			<column name="name" />
    		</property>
    		<property name="age" type="java.lang.Integer">
    			<column name="age" />
    		</property>
    		
    	</class>
    
    </hibernate-mapping>

6.dao层：定义一个接口，然后实现接口，获取sessionFactory(在bean.xml配置bean)实现对数据库的操作  
PersonDao

package per.czt.springmvc.dao;
    
    import java.util.List;
    
    import per.czt.springmvc.domain.Person;
    
    public interface PersonDao {
    	public List<Person> listAll(String hql);
    	public Person getById(Integer id);
    	public void saveOrUpdate(Person p);
    	public void deleteById(Integer id);
    	
    }

PersonDaoImpl

package per.czt.springmvc.dao;
    
    import java.util.List;
    
    import javax.annotation.Resource;
    
    import org.hibernate.SessionFactory;
    import org.springframework.stereotype.Repository;
    import org.springframework.transaction.annotation.Transactional;
    
    import per.czt.springmvc.domain.Person;
    
    @Repository("personDao")
    
    public class PersonDaoImpl  implements PersonDao {
    	
    	
    	private SessionFactory sessionFactory;
    	public SessionFactory getSessionFactory() {
    		return sessionFactory;
    	}
    
    	public void setSessionFactory(SessionFactory sessionFactory) {
    		this.sessionFactory = sessionFactory;
    	}
    
    	@Override
    	public List<Person> listAll(String hql) {
    		System.out.println("sessionFactory:"+sessionFactory);
    		System.out.println("hql:"+hql);
    		System.out.println(" sessionFactory.getCurrentSession():"+ sessionFactory.getCurrentSession());
    		List<Person> personList=(List<Person>) sessionFactory.getCurrentSession().createQuery(hql).list();
    		System.out.println("personList:"+personList.size());
    		return personList;
    	}
    
    	@Override
    	public Person getById(Integer id) {
    		
    		return (Person)sessionFactory.getCurrentSession().get(Person.class, id);
    	}
    
    	@Override
    	public void saveOrUpdate(Person p) {
    		sessionFactory.getCurrentSession().saveOrUpdate(p);
    		
    	}
    
    	@Override
    	public void deleteById(Integer id) {
    		sessionFactory.getCurrentSession().delete(this.getById(id));
    		
    	}
    
    }

7.servic层:对dao层的结果处理，这里也是接口调用  
PersonService

package per.czt.springmvc.service;
    
    import java.util.List;
    
    import per.czt.springmvc.domain.Person;
    
    public interface PersonService {
    	public List<Person> listAll(String hql);
    	public Person getById(Integer id);
    	public void saveOrUpdate(Person p);
    	public void deleteById(Integer id);
    }

PersonServiceImpl

package per.czt.springmvc.service;
    
    import java.util.List;
    
    import javax.annotation.Resource;
    
    import org.springframework.stereotype.Service;
    
    import per.czt.springmvc.dao.PersonDao;
    import per.czt.springmvc.dao.PersonDaoImpl;
    import per.czt.springmvc.domain.Person;
    
    @Service("personService")
    public class PersonServiceImpl implements PersonService {
    	
    	@Resource(name="personDao")
    	private PersonDao personDao;
    	
    	public PersonDao getPersonDao() {
    		return personDao;
    	}
    
    	public void setPersonDao(PersonDao personDao) {
    		this.personDao = personDao;
    	}
    
    	@Override
    	public List<Person> listAll(String hql) {
    		
    		System.out.println("personDao:"+personDao);
    		return personDao.listAll(hql);
    	}
    
    	@Override
    	public Person getById(Integer id) {
    		// TODO Auto-generated method stub
    		return personDao.getById(id);
    	}
    
    	@Override
    	public void saveOrUpdate(Person p) {
    		personDao.saveOrUpdate(p);
    
    	}
    
    	@Override
    	public void deleteById(Integer id) {
    		personDao.deleteById(id);
    
    	}
    
    }

8.controller层:调用service，并且将结果显示到view层，即jsp页面  
PersonController

package per.czt.springmvc.web.controller;
    
    import java.util.List;
    
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    import per.czt.springmvc.domain.Person;
    import per.czt.springmvc.service.PersonService;
    
    
    @Controller
    @RequestMapping("/person")
    public class PersonController {
    	
    	private PersonService personService;
    	
    	
         
    	@RequestMapping("/listAll")
    	public String listAll(Model model)
    	{
    		ApplicationContext ac=new ClassPathXmlApplicationContext("beans.xml");
    		personService=(PersonService) ac.getBean("personService");
    		System.out.println("personService1:"+personService);
    		System.out.println("personService:"+personService);
    		List<Person> personList=personService.listAll("from Person");
    		System.out.println("personList.size()"+personList);
    		model.addAttribute(personList);
    		return "person/personList";
    		
    	}
    
    }

9.view层:显示controller层返回的结果  
person.jsp(在WEB-INF/person下)

<%@ page language="java" contentType="text/html; charset=UTF-8"
    	pageEncoding="UTF-8"%>
    <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
    <!DOCTYPE html>
    <html>
    <head>
    <meta charset="UTF-8">
    <title>Insert title here</title>
    </head>
    <body>
    	<table>
    		<tbody>
    
    			<tr>
    				<th>id</th>
    				<th>name</th>
    				<th>age</th>
    			
    			</tr>
    			<c:forEach items="${personList }" var="person">
    				<tr>
    					<td>${person.id }</td>
    					<td>${person.name }</td>
    					<td>${person.age }</td>
    				
    				</tr>
    
    			</c:forEach>
    
    		</tbody>
    	</table>
    </body>
    </html>

index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <!DOCTYPE html>
    <html>
    <head>
    <meta charset="UTF-8">
    <title>Insert title here</title>
    </head>
    <body>
    	
    	<a href="${pageContext.request.contextPath }/person/listAll.action">显示列表</a>
    </body>
    </html>

10.在index.jsp点击显示列表，即可显示所有person了

[https_github.com_rj2017211811_springmvc-hibernate]: https://github.com/rj2017211811/springmvc-hibernate
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3JqMjAxNzIxMTgxMQ_size_16_color_FFFFFF_t_70]: /images/20220307/e7325438318c43578478465158bde00a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3JqMjAxNzIxMTgxMQ_size_16_color_FFFFFF_t_70 1]: /images/20220307/c89da92d57be458585b77215be7b9752.png
[20190316013745772.png]: /images/20220307/8599e0e1ee9841fe987ca39057bbc737.png