Spring4 MVC Hibernate4集成

Dear 丶 2022-09-25 10:16 199阅读 0赞

## 一、    本文所用环境 ##

Spring4.0.3.RELEASE

Hibernate4.3.5.Final

Mysql

## 二、    工程目录 ##

![151535008437650.png][]

## 三、    Maven添加依赖 ##

用Maven创建项目，pom.xml如下：

![ContractedBlock.gif][]

## 四、    新建数据库表 ##

数据库采用Mysql，新建users表，我们演示操作此表

![复制代码][copycode.gif]

CREATE TABLE `users` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `age` int(11) DEFAULT NULL,
      `nice_name` varchar(32) DEFAULT NULL,
      `user_name` varchar(32) DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

![复制代码][copycode.gif]

创建Entity类Users.java见下

![复制代码][copycode.gif]

package com.lei.demo.entity;
    
    import javax.persistence.*;
    
    @Entity(name="users")
    public class Users {
        
        public Users(){
            super();
        }
        
        @Id
        @GeneratedValue(strategy=GenerationType.AUTO)
        @Column(name="id")
        private Integer id;
        
        @Column(name="user_name",length=32)
        private String user_name;
        
        @Column(name="age")
        private Integer age;
        
        @Column(name="nice_name",length=32)
        private String nice_name;
        
        public Integer getId() {
            return id;
        }
        public void setId(Integer id) {
            this.id = id;
        }
        public String getUser_name() {
            return user_name;
        }
        public void setUser_name(String user_name) {
            this.user_name = user_name;
        }
        public Integer getAge() {
            return age;
        }
        public void setAge(Integer age) {
            this.age = age;
        }
        public String getNice_name() {
            return nice_name;
        }
        public void setNice_name(String nice_name) {
            this.nice_name = nice_name;
        }
    }

![复制代码][copycode.gif]

## 五、    配置文件 ##

### 1.        首先看一下Web.xml ###

![复制代码][copycode.gif]

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
        xmlns="http://java.sun.com/xml/ns/javaee" 
        xmlns:web="http://java.sun.com/xml/ns/javaee" 
        xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
            http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" 
            id="WebApp_ID" version="3.0">
      <display-name>Archetype Created Web Application</display-name>
      <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:/spring-*.xml</param-value>
      </context-param>
      <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
      
      <servlet>
        <servlet-name>lei-dispatcher</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
          
          <param-name>contextConfigLocation</param-name>
          <param-value>classpath:/lei-dispatcher-servlet.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
      </servlet>
      
      <servlet-mapping>
        <servlet-name>lei-dispatcher</servlet-name>
        <url-pattern>/</url-pattern>
      </servlet-mapping>
    </web-app>

![复制代码][copycode.gif]

### 2.        lei-dispatcher-servlet.xml ###

![复制代码][copycode.gif]

### 3.        Spring-hibernate的整合 ###

spring-hibernate.xml文件

![复制代码][copycode.gif]

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:context="http://www.springframework.org/schema/context"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:tx="http://www.springframework.org/schema/tx"
        xmlns:aop="http://www.springframework.org/schema/aop"
        xsi:schemaLocation="
            http://www.springframework.org/schema/beans     
            http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context-4.0.xsd
            http://www.springframework.org/schema/aop
            http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
            http://www.springframework.org/schema/tx
            http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
            ">
    
        
        
        <context:property-placeholder location="classpath:persistence-mysql.properties" />
        
        <bean id="sessionFactory" 
            class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
            <property name="dataSource" ref="dataSource" />
            <property name="packagesToScan">
                <list>
                    
                    <value>com.lei.demo.entity</value>
                </list>
            </property>
            <property name="hibernateProperties">
                <props>
                    <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
                    <prop key="hibernate.dialect">${hibernate.dialect}</prop>
                    <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
                     
                </props>
            </property>
        </bean>
        
        
        
        
        <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
          <property name="driverClassName" value="${jdbc.driverClassName}" />
          <property name="url" value="${jdbc.url}" />
          <property name="username" value="${jdbc.user}" />
          <property name="password" value="${jdbc.pass}" />
       </bean>
       
        
        <bean id="transactionManager"
            class="org.springframework.orm.hibernate4.HibernateTransactionManager">
          <property name="sessionFactory" ref="sessionFactory" />
       </bean>
       
       
       <bean id="persistenceExceptionTranslationPostProcessor" 
           class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor" />
       
       
        <tx:advice id="txAdvice" transaction-manager="transactionManager">
            <tx:attributes>
                <tx:method name="add*" propagation="REQUIRED" />
                <tx:method name="get*" propagation="REQUIRED" />
                <tx:method name="*" read-only="true" />
            </tx:attributes>
        </tx:advice>
        
        <aop:config expose-proxy="true">
            
            <aop:pointcut id="txPointcut" expression="execution(* com.lei.demo.service..*.*(..))" />
            
            <aop:advisor pointcut-ref="txPointcut" advice-ref="txAdvice"/>
        </aop:config>
        
    </beans>

![复制代码][copycode.gif]

事务采用tx:advice和aop:config的xml配置方式实现。事务的其他实现方式见[***《Spring MVC事务配置》***][Spring MVC]

资源文件*persistence-mysql.properties*如下：

![复制代码][copycode.gif]

# jdbc.X
    jdbc.driverClassName=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://yourServerIP:3306/yourDatabase?createDatabaseIfNotExist=true
    jdbc.user=user
    jdbc.pass=password
    
    # hibernate.X
    hibernate.connection.driverClass=org.gjt.mm.mysql.Driver
    hibernate.connection.url=jdbc:mysql:// yourServerIP:3306/yourDatabase
    hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
    hibernate.connection.username=user
    hibernate.connection.password=password
    hibernate.show_sql=true
    hibernate.hbm2ddl.auto=create-drop

![复制代码][copycode.gif]

## 六、    DAO、Service ##

UsersDAO.java如下：

![复制代码][copycode.gif]

package com.lei.demo.dao;
    
    import java.util.List;
    
    import org.hibernate.Query;
    import org.hibernate.Session;
    import org.hibernate.SessionFactory;
    
    import com.lei.demo.entity.Users;
    
    public class UsersDAO {
        private SessionFactory sessionFactory;
    
        public void setSessionFactory(SessionFactory sessionFactory) {
            this.sessionFactory = sessionFactory;
        }
        public SessionFactory getSessionFactory() {
            return sessionFactory;
        }
    
        public List<Users> getAllUser(){
            String hsql="from users";
            Session session = sessionFactory.getCurrentSession();
            Query query = session.createQuery(hsql);
            
            return query.list();
        }
    }

![复制代码][copycode.gif]

UserService.java如下：

![复制代码][copycode.gif]

package com.lei.demo.service;
    
    import com.lei.demo.dao.*;
    
    public class UserService {
        private UsersDAO userDao;
        
        public int userCount(){
            return userDao.getAllUser().size();
        }
    
        public UsersDAO getUserDao() {
            return userDao;
        }
    
        public void setUserDao(UsersDAO userDao) {
            this.userDao = userDao;
        }
    
    }

![复制代码][copycode.gif]

## 七、    加载Bean配置文件 ##

这里主要是加载上边的dao、service

![复制代码][copycode.gif]

当然你也可以不采用xml配置bean，采用注释加载bean，见[***《Spring3系列7- 自动扫描组件或Bean》***][Spring3_7-_Bean]、[***《Spring 开启Annotation <context:annotation-config> 和 <context:component-scan>诠释及区别》***][Spring_Annotation _context_annotation-config_context_component-scan]

## 八、    JSP页面和Controller ##

WEB-INF/user/users.jsp如下：

![复制代码][copycode.gif]

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Insert title here</title>
    </head>
    <body>
        <h1>Message : ${message}</h1>
    </body>
    </html>

![复制代码][copycode.gif]

写Controller访问上边的jsp

![复制代码][copycode.gif]

package com.lei.demo.controller;
    
    import javax.annotation.Resource;
    
    import com.lei.demo.service.*;
    
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestMethod;
    import org.springframework.web.servlet.ModelAndView;
    
    @Controller
    @RequestMapping("/user")
    public class UserController {
        
        @Resource(name="userService")
        private UserService service;
        
        @RequestMapping(value="/manager",method=RequestMethod.GET)
        public ModelAndView hello2(){
            ModelAndView mv = new ModelAndView();
            mv.addObject("message", "HelloMVC");
            mv.setViewName("users");
            return mv;
        }
        
        @RequestMapping(value="/count",method=RequestMethod.GET)
        public ModelAndView count(){
            
            int c = service.userCount();
            
            ModelAndView mv = new ModelAndView();
            mv.addObject("message", c);
            mv.setViewName("users");
            return mv;
        }
    }

![复制代码][copycode.gif]

上边的controller定义了两个路径

http://localhost:8080/spring4-mvc-hibernate4/user/manager

http://localhost:8080/spring4-mvc-hibernate4/user/count

以上两个路径都调用WEB-INF/user/users.jsp

参考资料《Spring3系列13-Controller和@RequestMapping》

## 九、    运行结果 ##

![151551046408095.png][]

![151551123758456.png][]

源代码下载：

[ http://www.oschina.net/code/snippet\_1764868\_35775][http_www.oschina.net_code_snippet_1764868_35775]

[151535008437650.png]: /images/20220718/535fe79e43c040dbaf07fd2db73ee099.png
[ContractedBlock.gif]: /images/20220718/0174a4b9a59b4aae88b0e61664fe29bc.png
[copycode.gif]: /images/20220718/b5986f7cc61f4853a3889fd448c9dbbb.png
[Spring MVC]: http://www.cnblogs.com/leiOOlei/p/3725911.html
[Spring3_7-_Bean]: http://www.cnblogs.com/leiOOlei/p/3547589.html
[Spring_Annotation _context_annotation-config_context_component-scan]: http://www.cnblogs.com/leiOOlei/p/3713989.html
[151551046408095.png]: /images/20220718/002afdfab8a940af94e15dcba238490c.png
[151551123758456.png]: /images/20220718/247a252390b445ed869f4b747ce260c0.png
[http_www.oschina.net_code_snippet_1764868_35775]: http://www.oschina.net/code/snippet_1764868_35775