springMVC4.3+hibernate5.4+freemarker2.3.28框架搭建

我就是我 2022-02-25 17:51 292阅读 0赞

**目录**

创建maven项目

设置settings.xml

mysql

添加依赖

目录结构

web.xml

applicationContext.xml

dispatcher-servlet.xml

UserController

userList.ftl

addUser.ftl

editUser.ftl

界面展示

完整pom.xml

源代码下载：

附：HibernateSessionFactory.java

一对多配置

--------------------

## 创建maven项目 ##

### 设置settings.xml ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70][]

maven添加**archetypeCatalog = internal**，解决maven项目速度慢的问题

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 1][]

另外可以修改默认设置解决maven慢的问题

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 5][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 6][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 7][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 8][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 9][]

### mysql ###

jdbc:mysql://localhost:3306/test?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 10][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 11][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 12][]

### 添加依赖 ###

<dependency>
    	<groupId>c3p0</groupId>
    	<artifactId>c3p0</artifactId>
    	<version>0.9.1.2</version>
    </dependency>
    
    <dependency>
    	<groupId>org.freemarker</groupId>
    	<artifactId>freemarker</artifactId>
    	<version>2.3.28</version>
    </dependency>

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 13][]

## 目录结构 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 14][]

### web.xml ###

### applicationContext.xml ###

### dispatcher-servlet.xml ###

### UserController ###

/*
     * Copyright © 2019 bjfansr@cn.ibm.com Inc. All rights reserved
     * @package: com.ibm.moses.controller
     * @version V1.0
     */
    package com.ibm.moses.user.controller;
    
    import com.ibm.moses.user.model.UserEntity;
    import com.ibm.moses.user.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    /**
     * @author Moses *
     * @Date 2019/4/2
     */
    @Controller
    @RequestMapping("/user")
    public class UserController {
        @Autowired
        private UserService userService;
    
        @RequestMapping("/getUserList")
        public String getUserList(Model model) {
            model.addAttribute("userList", userService.getUserList());
            return "/user/userList";
        }
    
        @RequestMapping("/getUser")
        public String getUser(long id, Model model) {
            model.addAttribute("user", userService.getUser(id));
            return "/user/editUser";
        }
    
        @RequestMapping("/toAddUser")
        public String toAddUser() {
            return "/user/addUser";
        }
    
        @RequestMapping("/addUser")
        public String addUser(UserEntity User, Model model) {
            userService.addUser(User);
            model.addAttribute("userList", userService.getUserList());
            return "/user/userList";
        }
    
        @RequestMapping("/delUser")
        public String delUser(long id, Model model) {
            userService.delUser(id);
            model.addAttribute("userList", userService.getUserList());
            return "/user/userList";
        }
    
        @RequestMapping("/updateUser")
        public String updateUser(UserEntity user, Model model) {
            userService.updateUser(user);
            model.addAttribute("userList", userService.getUserList());
            return "/user/userList";
        }
    }

UserService

/*
     * Copyright © 2019 bjfansr@cn.ibm.com Inc. All rights reserved
     * @package: com.ibm.moses.user.dao
     * @version V1.0
     */
    package com.ibm.moses.user.service;
    
    import com.ibm.moses.user.model.UserEntity;
    
    import java.util.List;
    
    /**
     * @author Moses *
     * @Date 2019/4/3
     */
    public interface UserService {
        UserEntity getUser(long id);
    
        List<UserEntity> getUserList();
    
        void addUser(UserEntity userEntity);
    
        void delUser(long id);
    
        void updateUser(UserEntity userEntity);
    }

UserServiceImpl

/*
     * Copyright © 2019 bjfansr@cn.ibm.com Inc. All rights reserved
     * @package: com.ibm.moses.user.dao
     * @version V1.0
     */
    package com.ibm.moses.user.service.impl;
    
    import com.ibm.moses.user.dao.UserDao;
    import com.ibm.moses.user.model.UserEntity;
    import com.ibm.moses.user.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Repository;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Transactional;
    
    import java.util.List;
    
    /**
     * @author Moses *
     * @Date 2019/4/3
     */
    @Service
    public class UserServiceImpl implements UserService {
        @Autowired
        private UserDao userDao;
    
        @Override
        public UserEntity getUser(long id) {
            return userDao.getUser(id);
        }
    
        @Override
        public List<UserEntity> getUserList() {
            return userDao.getUserList();
        }
    
        @Override
        public void addUser(UserEntity userEntity) {
            userDao.addUser(userEntity);
        }
    
        @Override
        public void delUser(long id) {
            userDao.delUser(id);
        }
    
        @Override
        public void updateUser(UserEntity userEntity) {
            userDao.updateUser(userEntity);
        }
    }

UserDao

/*
     * Copyright © 2019 bjfansr@cn.ibm.com Inc. All rights reserved
     * @package: com.ibm.moses.user.dao
     * @version V1.0
     */
    package com.ibm.moses.user.dao;
    
    import com.ibm.moses.user.model.UserEntity;
    
    import java.util.List;
    
    /**
     * @author Moses *
     * @Date 2019/4/3
     */
    public interface UserDao {
        UserEntity getUser(long id);
    
        List<UserEntity> getUserList();
    
        void addUser(UserEntity userEntity);
    
        void delUser(long id);
    
        void updateUser(UserEntity userEntity);
    }

UserDaoImpl

/*
     * Copyright © 2019 bjfansr@cn.ibm.com Inc. All rights reserved
     * @package: com.ibm.moses.user.dao
     * @version V1.0
     */
    package com.ibm.moses.user.dao.impl;
    
    import com.ibm.moses.common.BaseDao;
    import com.ibm.moses.user.dao.UserDao;
    import com.ibm.moses.user.model.UserEntity;
    import org.hibernate.query.Query;
    import org.springframework.stereotype.Repository;
    
    import java.util.List;
    
    /**
     * @author Moses *
     * @Date 2019/4/3
     */
    @Repository
    public class UserDaoImpl extends BaseDao<UserEntity> implements UserDao {
        @Override
        public UserEntity getUser(long id) {
            String hql = "from UserEntity p where p.id = ?0";
            return queryHQLList(hql, id).get(0);
        }
    
        @Override
        public List<UserEntity> getUserList() {
            String hql = "from UserEntity";
            return queryHQLList(hql);
        }
    
        @Override
        public void addUser(UserEntity userEntity) {
            executeCUD(userEntity, "C");
        }
    
        @Override
        public void delUser(long id) {
            UserEntity userEntity = new UserEntity();
            userEntity.setId(id);
            executeCUD(userEntity, "D");
        }
    
        @Override
        public void updateUser(UserEntity userEntity) {
            executeCUD(userEntity, "U");
        }
    }

BaseDao

/*
     * Copyright © 2019 bjfansr@cn.ibm.com Inc. All rights reserved
     * @package: com.ibm.moses.common.dao
     * @version V1.0
     */
    package com.ibm.moses.common;
    
    import org.hibernate.Session;
    import org.hibernate.SessionFactory;
    import org.hibernate.Transaction;
    import org.hibernate.query.NativeQuery;
    import org.hibernate.query.Query;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Repository;
    
    import java.util.List;
    
    /**
     * @author Moses *
     * @Date 2019/4/4
     */
    @SuppressWarnings("unchecked")
    @Repository
    public class BaseDao<T> {
        @Autowired
        private SessionFactory sessionFactory;
    
        public Session getSession() {
            return sessionFactory.openSession();
        }
    
        public void executeCUD(T obj, String method) {
            Session session = null;
            Transaction transaction = null;
            try {
                session = getSession();
                transaction = session.getTransaction();
                transaction.begin();
                switch (method) {
                    case "C":
                        session.save(obj);
                        break;
                    case "U":
                        session.update(obj);
                        break;
                    case "D":
                        session.delete(obj);
                        break;
                    default:
                        break;
                }
                transaction.commit();
            } catch (Exception e) {
                if (transaction != null) {
                    transaction.rollback();
                }
                throw new RuntimeException(e.getMessage());
            } finally {
                if (session != null && session.isOpen()) {
                    session.close();
                }
            }
        }
    
        public List<T> queryHQLList(String hql, Object... params) {
            Query query = getSession().createQuery(hql);
            if (params != null && params.length > 0) {
                for (int i = 0; i < params.length; i++) {
                    query.setParameter(i, params[i]);
                }
            }
            return query.list();
        }
    
        public List<T> executeJDBCSqlQuery(String sql, Class clazz, List<String> params) {
            NativeQuery nativeQuery = getSession().createNativeQuery(sql, clazz);
            for (int i = 0; i < params.size(); i++) {
                nativeQuery.setParameter(i, params.get(i));
            }
            return nativeQuery.getResultList();
        }
    
    }

### userList.ftl ###

<#assign ctx = request.contextPath />
    <!DOCTYPE html>
    <html>
    <head lang="zh">
        <base id="ctx" href="${ctx}">
        <title>用户信息</title>
        <script type="text/javascript" src="${ctx}/js/common/jquery-3.3.1.min.js"></script>
        <script type="text/javascript">
            function del(id) {
                $.get("${ctx}/user/delUser.form?id=" + id, function (data) {
                    if ("success" == data.result) {
                        alert("删除成功");
                        window.location.reload();
                    } else {
                        alert("删除失败");
                    }
                });
            }
        </script>
    </head>
    <body>
    <h3><a href="${ctx}/user/toAddUser.form">添加用户</a></h3>
    <table border="1">
        <tbody>
        <tr>
            <th>姓名</th>
            <th>邮箱</th>
            <th>年龄</th>
            <th>操作</th>
        </tr>
        </tbody>
         <#list userList as user>
          <tr>
              <td>${user.name }</td>
              <td>${user.email }</td>
              <td>${user.age }</td>
              <td>
                  <a href="${ctx}/user/getUser.form?id=${user.id }">编辑</a>
                  <a href="${ctx}/user/delUser.form?id=${user.id }">删除</a>
              </td>
          </tr>
         </#list>
    </table>
    </html>

### addUser.ftl ###

### editUser.ftl ###

<#assign ctx = request.contextPath />
    <!DOCTYPE html>
    <html>
    <head lang="zh">
        <base id="ctx" href="${ctx}">
        <title>用户信息</title>
        <script type="text/javascript" src="${ctx}/js/common/jquery-3.3.1.min.js"></script>
    </head>
    <body>
    <h1>编辑用户</h1>
    <form action="${ctx}/user/updateUser.form" name="userForm" method="post">
        <input type="hidden" name="id" value="${user.id}">
        姓名：<input type="text" name="name" value="${user.name}">
        姓名：<input type="text" name="email" value="${user.email}">
        姓名：<input type="text" name="age" value="${user.age}">
        <input type="submit" value="编辑" >
    </form>
    </body>
    </html>

## 界面展示 ##

[http://localhost:8080/moses-spring-hibernate/user/getUserList.form][http_localhost_8080_moses-spring-hibernate_user_getUserList.form]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 15][]

[http://localhost:8080/moses-spring-hibernate/user/toAddUser.form][http_localhost_8080_moses-spring-hibernate_user_toAddUser.form]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 16][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 17][]

[http://localhost:8080/moses-spring-hibernate/user/delUser.form?id=12][http_localhost_8080_moses-spring-hibernate_user_delUser.form_id_12]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 18][]

## 完整pom.xml ##

<?xml version="1.0" encoding="UTF-8"?>
    
    <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.ibm.moses</groupId>
        <artifactId>moses-spring-hibernate</artifactId>
        <version>1.0-SNAPSHOT</version>
        <packaging>war</packaging>
    
        <name>moses-spring-hibernate Maven Webapp</name>
        
        <url>http://www.example.com</url>
    
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <maven.compiler.source>1.8</maven.compiler.source>
            <maven.compiler.target>1.8</maven.compiler.target>
            <failOnMissingWebXml>false</failOnMissingWebXml>
            <spring.version>5.0.0.RELEASE</spring.version>
            <hibernate.version>5.2.11.Final</hibernate.version>
            <hibernate.validator>5.4.1.Final</hibernate.validator>
            <c3p0.version>0.9.5.4</c3p0.version>
            <jstl.version>1.2.1</jstl.version>
            <tld.version>1.1.2</tld.version>
            <servlets.version>3.1.0</servlets.version>
            <jsp.version>2.3.1</jsp.version>
            <hsqldb.version>1.8.0.10</hsqldb.version>
            <mysql.version>8.0.11</mysql.version>
        </properties>
        <dependencies>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.11</version>
                <scope>test</scope>
            </dependency>
            
            <dependency>
                <groupId>org.freemarker</groupId>
                <artifactId>freemarker</artifactId>
                <version>2.3.28</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context-support</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-orm</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.hibernate</groupId>
                <artifactId>hibernate-core</artifactId>
                <version>${hibernate.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.hibernate</groupId>
                <artifactId>hibernate-c3p0</artifactId>
                <version>${hibernate.version}</version>
            </dependency>
            
            <dependency>
                <groupId>com.mchange</groupId>
                <artifactId>c3p0</artifactId>
                <version>${c3p0.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.hibernate</groupId>
                <artifactId>hibernate-validator</artifactId>
                <version>${hibernate.validator}</version>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet.jsp.jstl</groupId>
                <artifactId>javax.servlet.jsp.jstl-api</artifactId>
                <version>${jstl.version}</version>
            </dependency>
            <dependency>
                <groupId>taglibs</groupId>
                <artifactId>standard</artifactId>
                <version>${tld.version}</version>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>javax.servlet-api</artifactId>
                <version>${servlets.version}</version>
                <scope>provided</scope>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet.jsp</groupId>
                <artifactId>javax.servlet.jsp-api</artifactId>
                <version>${jsp.version}</version>
                <scope>provided</scope>
            </dependency>
            
            <dependency>
                <groupId>hsqldb</groupId>
                <artifactId>hsqldb</artifactId>
                <version>${hsqldb.version}</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>${mysql.version}</version>
            </dependency>
        </dependencies>
        <build>
            <finalName>moses-spring-hibernate</finalName>
            <pluginManagement>
                <plugins>
                    <plugin>
                        <artifactId>maven-clean-plugin</artifactId>
                        <version>3.1.0</version>
                    </plugin>
                    
                    <plugin>
                        <artifactId>maven-resources-plugin</artifactId>
                        <version>3.0.2</version>
                    </plugin>
                    <plugin>
                        <artifactId>maven-compiler-plugin</artifactId>
                        <version>3.8.0</version>
                    </plugin>
                    <plugin>
                        <artifactId>maven-surefire-plugin</artifactId>
                        <version>2.22.1</version>
                    </plugin>
                    <plugin>
                        <artifactId>maven-war-plugin</artifactId>
                        <version>3.2.2</version>
                    </plugin>
                    <plugin>
                        <artifactId>maven-install-plugin</artifactId>
                        <version>2.5.2</version>
                    </plugin>
                    <plugin>
                        <artifactId>maven-deploy-plugin</artifactId>
                        <version>2.8.2</version>
                    </plugin>
                </plugins>
            </pluginManagement>
        </build>
    </project>

### 源代码下载： ###

[https://github.com/glory2018/moses-spring-hibernate.git][https_github.com_glory2018_moses-spring-hibernate.git]

### 附：HibernateSessionFactory.java ###

package com.ibm.moses.common;
    
    import org.hibernate.HibernateException;
    import org.hibernate.Session;
    import org.hibernate.cfg.Configuration;
    import org.hibernate.service.ServiceRegistry;
    import org.hibernate.boot.MetadataSources;
    import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
    
    /**
     * Configures and provides access to Hibernate sessions, tied to the
     * current thread of execution.  Follows the Thread Local Session
     * pattern, see {@link http://hibernate.org/42.html }.
     */
    public class HibernateSessionFactory {
    
        /** 
         * Location of hibernate.cfg.xml file.
         * Location should be on the classpath as Hibernate uses  
         * #resourceAsStream style lookup for its configuration file. 
         * The default classpath location of the hibernate config file is 
         * in the default package. Use #setConfigFile() to update 
         * the location of the configuration file for the current session.   
         */
    	private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
        private static org.hibernate.SessionFactory sessionFactory;
    	
        private static Configuration configuration = new Configuration();
        private static ServiceRegistry serviceRegistry; 
    
    	static {
        	try {
    			configuration.configure();
    			serviceRegistry = new StandardServiceRegistryBuilder().configure().build();
    			try {
    				sessionFactory = new MetadataSources(serviceRegistry).buildMetadata().buildSessionFactory();
    			} catch (Exception e) {
    				StandardServiceRegistryBuilder.destroy(serviceRegistry);
    				e.printStackTrace();
    			}
    		} catch (Exception e) {
    			System.err.println("%%%% Error Creating SessionFactory %%%%");
    			e.printStackTrace();
    		}
        }
        private HibernateSessionFactory() {
        }
    	
    	/**
         * Returns the ThreadLocal Session instance.  Lazy initialize
         * the <code>SessionFactory</code> if needed.
         *
         *  @return Session
         *  @throws HibernateException
         */
        public static Session getSession() throws HibernateException {
            Session session = (Session) threadLocal.get();
    
    		if (session == null || !session.isOpen()) {
    			if (sessionFactory == null) {
    				rebuildSessionFactory();
    			}
    			session = (sessionFactory != null) ? sessionFactory.openSession()
    					: null;
    			threadLocal.set(session);
    		}
    
            return session;
        }
    
    	/**
         *  Rebuild hibernate session factory
         *
         */
    	public static void rebuildSessionFactory() {
    		try {
    			configuration.configure();
    			serviceRegistry = new StandardServiceRegistryBuilder().configure().build();
    			try {
    				sessionFactory = new MetadataSources(serviceRegistry).buildMetadata().buildSessionFactory();
    			} catch (Exception e) {
    				StandardServiceRegistryBuilder.destroy(serviceRegistry);
    				e.printStackTrace();
    			}
    		} catch (Exception e) {
    			System.err.println("%%%% Error Creating SessionFactory %%%%");
    			e.printStackTrace();
    		}
    	}
    
    	/**
         *  Close the single hibernate session instance.
         *
         *  @throws HibernateException
         */
        public static void closeSession() throws HibernateException {
            Session session = (Session) threadLocal.get();
            threadLocal.set(null);
    
            if (session != null) {
                session.close();
            }
        }
    
    	/**
         *  return session factory
         *
         */
    	public static org.hibernate.SessionFactory getSessionFactory() {
    		return sessionFactory;
    	}
    	/**
         *  return hibernate configuration
         *
         */
    	public static Configuration getConfiguration() {
    		return configuration;
    	}
    
    }

## 一对多配置 ##

import javax.persistence.*;
    import java.sql.Timestamp;
    import java.util.List;
    import java.util.Objects;
    
    /**
     * @author Moses
     * @Date 2019/4/26
     */
    @Entity
    @Table(name = "TB_MS_BASIC", schema = "AIIB_MS", catalog = "")
    public class TbMsBasicEntity {
        private int msBasicId;
    
        private List<TbMsDetailEntity> detailEntityList;
    
    
        @Id
        @Column(name = "MS_BASIC_ID")
        @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "generator")
        @SequenceGenerator(name = "generator", sequenceName = "SEQ_MS_BASIC_ID")
        public int getMsBasicId() {
            return msBasicId;
        }
    
        public void setMsBasicId(int msBasicId) {
            this.msBasicId = msBasicId;
        }
    
          
    
        @OneToMany(mappedBy = "detailEntityList")
        public List<TbMsDetailEntity> getDetailEntityList() {
            return detailEntityList;
        }
    
        public void setDetailEntityList(List<TbMsDetailEntity> detailEntityList) {
            this.detailEntityList = detailEntityList;
        }
    }

import javax.persistence.*;
    import java.sql.Timestamp;
    import java.util.Objects;
    
    /**
     * @author Moses
     * @Date 2019/4/26
     */
    @Entity
    @Table(name = "TB_MS_DETAIL", schema = "AIIB_MS", catalog = "")
    public class TbMsDetailEntity {
        private int msDetailId;
        private Integer msBasicId;
    
        private TbMsBasicEntity detailEntityList;
    
        @Id
        @Column(name = "MS_DETAIL_ID")
        @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "generator")
        @SequenceGenerator(name = "generator", sequenceName = "SEQ_MS_DETAIL_ID")
        public int getMsDetailId() {
            return msDetailId;
        }
    
        public void setMsDetailId(int msDetailId) {
            this.msDetailId = msDetailId;
        }
    
        @Basic
        @Column(name = "MS_BASIC_ID", insertable = false, updatable = false)
        public Integer getMsBasicId() {
            return msBasicId;
        }
    
        public void setMsBasicId(Integer msBasicId) {
            this.msBasicId = msBasicId;
        }
    
    
    
        @ManyToOne
        @JoinColumn(name = "MS_BASIC_ID", referencedColumnName = "MS_BASIC_ID")
        public TbMsBasicEntity getDetailEntityList() {
            return detailEntityList;
        }
    
        public void setDetailEntityList(TbMsBasicEntity detailEntityList) {
            this.detailEntityList = detailEntityList;
        }
    }

## 事务 ##

### 1.更新实体 ###

private int executeCUD(T obj, String method) {
            int result = 0;
            Session session = null;
            Transaction transaction = null;
            try {
                session = getSession();
                transaction = session.getTransaction();
                transaction.begin();
                switch (method) {
                    case "C":
                        result = (int) session.save(obj);
                        break;
                    case "U":
                        session.merge(obj);
                        break;
                    case "D":
                        session.delete(obj);
                        break;
                    default:
                        break;
                }
                transaction.commit();
            } catch (Exception e) {
                if (transaction != null) {
                    transaction.rollback();
                }
                throw new RuntimeException(e.getMessage());
            } finally {
                if (session != null && session.isOpen()) {
                    session.close();
                }
            }
            return result;
        }

### 2.更新hql ###

public int executeUpdateHql(String hql, Object... params) {
            Session session = getSession();
            Transaction tx = session.beginTransaction();
            Query query = session.createQuery(hql);
            if (params != null && params.length > 0) {
                for (int i = 0; i < params.length; i++) {
                    query.setParameter(i, params[i]);
                }
            }
            int updatedEntities = query.executeUpdate();
            tx.commit();
            session.close();
            return updatedEntities;
        }

### 3.配置事务 ###

Spring的配置文件会跳过@Controller注解；而Springmvc的配置文件只会扫描@Controller。

Springmvc配置中的use-default-filters="false"是必须要有的！如果不写上，它的默认值是true，而这个default-filters会默认扫描@Service、@Repository等注解，这样就会和Spring的配置发生冲突！

dispatcher-servlet.xml

applicationContext.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: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.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
        
        <context:component-scan base-package="com.ibm.xxx">
            
            <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
        </context:component-scan>
        <context:property-placeholder location="classpath:jdbc.properties" ignore-unresolvable="true"/>
        
        <bean id="dataSource"
              class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="driverClass" value="${jdbc.driver}"/>
            <property name="jdbcUrl" value="${jdbc.url}"/>
            <property name="user" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
        </bean>
        
        <bean id="sessionFactory"
              class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"/>
            <property name="packagesToScan" value="com.ibm.xxx.model"/>
            <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>
                    <prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
                </props>
            </property>
        </bean>
        
        
        
        
        
        <bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
            <property name="sessionFactory" ref="sessionFactory"></property>
        </bean>
        
        <tx:advice id="txAdvice" transaction-manager="transactionManager">
            <tx:attributes>
                
                <tx:method name="insert*" rollback-for="java.lang.Exception" propagation="REQUIRED"/>
                <tx:method name="update*" rollback-for="java.lang.Exception" propagation="REQUIRED"/>
                <tx:method name="delete*" rollback-for="java.lang.Exception" propagation="REQUIRED"/>
                
                <tx:method name="get*" propagation="SUPPORTS" read-only="true"/>
                <tx:method name="find*" propagation="SUPPORTS" read-only="true"/>
                
                <tx:method name="*"/>
            </tx:attributes>
        </tx:advice>
        
        <aop:config>
            <aop:pointcut expression="execution(* com.ibm.xxx.*.service.*.*(..))" id="point-cut"/>
            <aop:advisor advice-ref="txAdvice" pointcut-ref="point-cut"/>
        </aop:config>
    </beans>

web.xml

<!DOCTYPE web-app PUBLIC
            "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
            "http://java.sun.com/dtd/web-app_2_3.dtd" >
    <web-app>
        <display-name>Archetype Created Web Application</display-name>
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>
                /WEB-INF/applicationContext.xml
                classpath*:applicationcontext-*.xml
            </param-value>
        </context-param>
        
        <filter>
            <filter-name>characterEncodingFilter</filter-name>
            <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
            <init-param>
                <param-name>encoding</param-name>
                <param-value>UTF-8</param-value>
            </init-param>
            <init-param>
                <param-name>forceEncoding</param-name>
                <param-value>true</param-value>
            </init-param>
        </filter>
        <filter-mapping>
            <filter-name>characterEncodingFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
        <servlet>
            <servlet-name>dispatcher</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
            <init-param>
                <param-name>contextConfigLocation</param-name>
                <param-value>/WEB-INF/dispatcher-servlet.xml</param-value>
            </init-param>
            <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>dispatcher</servlet-name>
            <url-pattern>/</url-pattern>
        </servlet-mapping>
    </web-app>

dao

private Session getSession() {
            return this.sessionFactory.getCurrentSession();
        }
    
        @Override
        public int addEntity(T t) {
            return (int) getSession().save(t);
        }
    
        @Override
        public void updateEntity(T t) {
            getSession().update(t);
        }
    
        @Override
        public void deleteEntity(T t) {
            getSession().delete(t);
        }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70]: /images/20220225/574f22df0b39416fa65e57f9360c718f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 1]: /images/20220225/8f0da9da133c47f19aede30b19d6599c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 2]: /images/20220225/e9d53e6532a94ab1b05a08c8efb53c25.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 3]: /images/20220225/9ac9e9b773754a31bfbdadad2491adbd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 4]: /images/20220225/1ff8743fa795423dbd8acbcc7283a14a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 5]: /images/20220225/21575801419545ff9a5989dee6ae9bae.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 6]: /images/20220225/849f2e7f2cba490e981c21cad14926c4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 7]: /images/20220225/8f87f3e9043f42eda3585d2dd9f0f3d3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 8]: /images/20220225/eb5c19ed15464c149446446d88e74251.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 9]: /images/20220225/040d4266fa6f4972b3b2e94868597c53.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 10]: /images/20220225/550132d2d982483fb46aa59ccd27d261.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 11]: /images/20220225/60ca9b26826b4f9581c6efb86773bba3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 12]: /images/20220225/481b472f7e0348c99225452a2044c265.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 13]: /images/20220225/f8e42c313c294b23b010bfd39558e420.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 14]: /images/20220225/12a95436d821481d980ab6eacd1603b5.png
[http_localhost_8080_moses-spring-hibernate_user_getUserList.form]: http://localhost:8080/moses-spring-hibernate/user/getUserList.form
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 15]: /images/20220225/454301a7f60a45109b03eda34b28e1a0.png
[http_localhost_8080_moses-spring-hibernate_user_toAddUser.form]: http://localhost:8080/moses-spring-hibernate/user/toAddUser.form
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 16]: /images/20220225/89b7d0a69e5545c8825a516312ec954d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 17]: /images/20220225/bab0b65728f74901a7c4b884c3cd78f7.png
[http_localhost_8080_moses-spring-hibernate_user_delUser.form_id_12]: http://localhost:8080/moses-spring-hibernate/user/delUser.form?id=12
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 18]: /images/20220225/55cc6d75772e407fb6407c69483d3ada.png
[https_github.com_glory2018_moses-spring-hibernate.git]: https://github.com/glory2018/moses-spring-hibernate.git