spring+springMVC+Hibernate整合

最新推荐文章于 2024-04-17 04:21:28 发布

光影九曜

最新推荐文章于 2024-04-17 04:21:28 发布

阅读量251

点赞数

分类专栏：框架整合

本文链接：https://blog.csdn.net/qq_34101232/article/details/103443668

版权

框架整合专栏收录该内容

0 篇文章 0 订阅

订阅专栏

框架整合无非就是几个配置文件的问题, 这里的spring+springMVC+Hibernate整合有3个配置文件和一个数据库的properties:

spring的application.xml

springMVC的mvc.xml

项目的web.xml

数据库相关的信息db.properties

hibernate的配置文件已经写入到了application里面所以这里没有

亲测没问题, 以下是具体步骤:

1.新建maven项目.

2.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.jc</groupId>
  <artifactId>springMVC-demo1</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>springMVC-demo1 Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <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>
    <spring-version>5.1.9.RELEASE</spring-version>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.18.10</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aspects</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-expression</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>org.hibernate</groupId>
      <artifactId>hibernate-core</artifactId>
      <version>5.0.7.Final</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.48</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-orm</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>org.hibernate</groupId>
      <artifactId>hibernate-c3p0</artifactId>
      <version>5.0.7.Final</version>
    </dependency>
    <dependency>
      <groupId>javax.servlet.jsp.jstl</groupId>
      <artifactId>jstl-api</artifactId>
      <version>1.2</version>
    </dependency>
    <dependency>
      <groupId>taglibs</groupId>
      <artifactId>standard</artifactId>
      <version>1.1.1</version>
    </dependency>
  </dependencies>

  <build>
    <finalName>springMVC-demo1</finalName>
    <resources>
      <resource>
        <directory>src/main/java</directory>
        <excludes>
          <exclude>**/*.java</exclude>
        </excludes>
      </resource>
    </resources>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.1.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <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>

注意: 如果用的是IDEA开发工具, build标签里面的resource是必须的, 不然项目编译不会把xml等资源文件编译到项目中.

3.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>

  <!-- [spring配置的监听器] -->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:applicationContext.xml</param-value>
  </context-param>
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>

  <!-- [springMVC的核心servlet] -->
  <servlet>
    <servlet-name>dispatcherServlet</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:mvc.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>dispatcherServlet</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>

  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  
  
</web-app>

dispatcherServlet的url-pattern可以是/也可以是.do, 但是要注意, 如果是.do的话使用restful风格的url如果Controller的路径是hello/{id}那么会出现匹配不到的情况, 因为这个路径末尾没有.do, 就算把hello/{id}改为hello.do/{id}也是一样, 如果在末尾的参数后面加上.do也不正确, 没有测试但是可以肯定的是逻辑不对, 可以写成/{id}/hello.do, 这样就可以匹配了, 如果想使用hello/{id}那么url-pattern必须写 /

4.在源码根目录下创建mvc.xml, application.xml, db.properties三个文件.

5.配置mvc.xml.

<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:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="
   http://www.springframework.org/schema/beans
   http://www.springframework.org/schema/beans/spring-beans-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/mvc
   http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd">

    <!-- [如果没有用到视图解析器可以不用写, 视图解析器例如: ModelAndView] -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/jsp/" />
        <property name="suffix" value=".jsp" />
    </bean>

    <!-- [如果spring整合springMVC就必须用exclude将service层进行排除, 否则报错] -->
    <context:component-scan base-package="com.jc">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Service"/>
    </context:component-scan>

    <!-- [放行静态资源] -->
    <mvc:default-servlet-handler />

    <!-- [注解驱动] -->
    <mvc:annotation-driven />
</beans>

注意: base-package="com.jc", com.jc是自己的包, 大家复制后修改为自己的包路径就可以了, base-package是进行springMVC的注解扫描, 为什么要排除service包呢? 因为在spring的配置文件application.xml中也会有一样的扫描, 如果不排除会产生冲突而报错, 下面看到spring的配置就明白了.

5.配置application.xml.

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

<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/aop
           http://www.springframework.org/schema/aop/spring-aop-4.2.xsd
           http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-4.2.xsd
           http://www.springframework.org/schema/tx
           http://www.springframework.org/schema/tx/spring-tx-4.2.xsd ">

    <!-- [注解扫描器] -->
    <context:component-scan base-package="com.jc">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
    <context:annotation-config />

    <!-- [加载数据库配置文件] -->
    <context:property-placeholder location="classpath:db.properties" />
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${com.jc.driver}" />
        <property name="jdbcUrl" value="${com.jc.url}" />
        <property name="user" value="${com.jc.username}" />
        <property name="password" value="${com.jc.password}" />
    </bean>
    <!-- [配置数据源] -->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
                <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
                <prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
                <!-- [单独使用hibernate才需要] -->
                <!--<prop key="hibernate.current_session_context_class">${hibernate.current_session_context_class}</prop>-->
            </props>
        </property>
        <!-- [和数据库关联的实体类包注解扫描] -->
        <property name="packagesToScan">
            <list>
                <value>com.jc.bean</value>
            </list>
        </property>
    </bean>

    <!-- [事务管理] -->
    <bean id="txManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>

    <tx:advice id="txAdvice" transaction-manager="txManager">
        <tx:attributes>
            <tx:method name="select*" read-only="true" />
            <tx:method name="*"/>
        </tx:attributes>
    </tx:advice>

    <aop:config>
        <aop:pointcut id="pointcut" expression="execution(* com.jc.service.*.*(..))" />
        <aop:advisor advice-ref="txAdvice" pointcut-ref="pointcut" />
    </aop:config>

</beans>

可以看到上面的配置和mvc.xml文件的注解扫描是一样的, 那么为了spring的扫描器和springMVC的扫描器不产生冲突需要把对方的扫描包进行排除, 如果不排除会出现什么问题大家可以测试下, 我自己测试确实报错, xml中添加排除代码后解决问题.hibernate的配置文件已经整合到里面所以不用写hibernate的配置文件了,

<property name="packagesToScan">可以让hibernate扫描到bean目录下的实体类对象(实体类使用注解开发), 这样就可以不用每个实体类都写一个映射文件.hbm.xml了

事务管理推荐大家使用配置文件, 如果是注解的话需要每个数据库处理方法上添加@Transaction注解, 如果类多了也是一个麻烦事,

<aop:pointcut id="pointcut" expression="execution(* com.jc.service..(..))" />请使用service层, 因为可能一个service方法里面会有几次调用dao层的数据库操作, 在service层进行事务开启和提交可以保证一次的逻辑处理只有一个事务.

6.配置db.properties.


#[dataSource config]
com.jc.driver = com.mysql.jdbc.Driver
com.jc.url = jdbc:mysql:///ssh1811
com.jc.username = root
com.jc.password = gymxd

#[hibernate config]
hibernate.hbm2ddl.auto = update
hibernate.show_sql = true
hibernate.format_sql = true

好了, 配置文件都已经编写完毕, 下面就是测试了:

1.在WEB-INF下面创建jsp文件夹, 然后在jsp文件夹里面创建hello.jsp.

hello.jsp:

<%--
  Created by IntelliJ IDEA.
  User: 光影九曜
  Date: 2019/12/4
  Time: 14:17
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<html>
<head>
    <title>Title</title>
</head>
<body>
    <h1>${users.size()}</h1>
    <table width="80%">
        <thead>
            <tr>
                <td>id</td>
                <td>名称</td>
                <td>描述</td>
            </tr>
        </thead>
        <tbody>
            <c:forEach items="${users}" var="user">
                <tr>
                    <td>${user.id}</td>
                    <td>${user.name}</td>
                    <td>${user.description}</td>
                </tr>

            </c:forEach>
        </tbody>
    </table>
</body>
</html>

2.创建Controller层.

com.jc.controller.Hello

package com.jc.controller;

import com.jc.bean.User;
import com.jc.service.UserService;
import lombok.Setter;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.ModelAndView;

import java.util.List;

/**
 * @author 光影九曜
 * @description []
 * @date 2019/12/4 14:18
 * @since 1.0
 */
@RestController
@Setter
public class Hello {

    @Autowired
    private UserService userService;

    @RequestMapping("/hello/{name}/{description}")
    public ModelAndView hello(@PathVariable String name, @PathVariable String description, ModelAndView mv) {
        //[由spring创建dao层对象]
        //[dao对象查询数据库返回user集合, 需要进行事务处理]
        List<User> users = userService.selectAll();
        //[将list集合添加到域中]
        //[前端渲染]
        mv.addObject("users", users);
        mv.setViewName("hello");
        return mv;
    }
}

上面的参数只是做演示, 让大家知道应该如何使用, 而在代码中并没有用到传来的两个参数

大家没有看到setter方法是因为我用了lombok进行的注解让其自动生成setter方法, 这样可以极大的提高开发效率和代码的整洁性, 特别是在bean实体类中, 如果有小伙伴不知道lombok的可以百度, 我也是前不久才知道有这个强大的jar, 这个我已经写在了pom.xml里面了, 大家直接copy里面的就会自动导入lombok包了, 后面的实体类我也会用到lombok注解

3.创建service层.

package com.jc.service;

import com.jc.bean.User;
import com.jc.dao.UserDao;
import lombok.Setter;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @author 光影九曜
 * @description []
 * @date 2019/12/6 17:25
 * @since 1.0
 */
@Service
@Setter
public class UserService {

    @Autowired
    private UserDao userDao;


    public List<User> selectAll() {
        return userDao.selectAll();
    }
}

4.创建dao层.

package com.jc.dao;

import com.jc.bean.User;
import lombok.Setter;
import org.hibernate.Criteria;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author 光影九曜
 * @description [数据库操作]
 * @date 2019/12/6 15:17
 * @since 1.0
 */
@Repository
@Setter
public class UserDao {

    @Autowired
    private SessionFactory sessionFactory;

    public List<User> selectAll() {
        Criteria criteria = sessionFactory.getCurrentSession().createCriteria(User.class);
        return criteria.list();
    }
}

大家可能看到了三个注解@Controller, @Service, @Repository, 大家不要晕, 其实这三个注解都是一个东西, 只是用英文的语义代表不同的分层, 比如Controller层你用@Respository可以么, 答案是可以的, 一样会被扫描到, 但是为了规范还是每个层用该层的注解, 这样才不会被误导.

5.创建实体类对象.

package com.jc.bean;

import lombok.*;

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

/**
 * @author 光影九曜
 * @description []
 * @date 2019/12/6 9:46
 * @since 1.0
 */
@Getter
@Setter
@EqualsAndHashCode
@ToString
@NoArgsConstructor
@AllArgsConstructor
@Entity
@Table(name = "tz_user")
public class User {
    /** [主键ID] */
    @Id
    @Column(name = "userId")
    private Integer id;
    /** [名称] */
    @Column(name = "userName")
    private String name;
    /** [描述] */
    @Column(name = "userDescription")
    private String description;
}

上面用的是lombok注解+hibernate注解.如果变量名和数据库中的字段名是一样的可以不用写name = "xxx"这个注解属性.

6.数据库表.

下面是sql, 大家复制导入数据库即可.

/*
Navicat MySQL Data Transfer

Source Server         : root
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : ssh1811

Target Server Type    : MYSQL
Target Server Version : 50553
File Encoding         : 65001

Date: 2019-12-08 13:31:31
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `tz_user`
-- ----------------------------
DROP TABLE IF EXISTS `tz_user`;
CREATE TABLE `tz_user` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(255) DEFAULT NULL,
  `userCode` varchar(255) DEFAULT NULL,
  `userPassword` varchar(255) DEFAULT NULL,
  `userSex` int(11) DEFAULT NULL,
  `userHeadImg` varchar(255) DEFAULT NULL,
  `userEmail` varchar(255) DEFAULT NULL,
  `userPhone` varchar(255) DEFAULT NULL,
  `userCreationTime` datetime DEFAULT NULL,
  `userBirthday` datetime DEFAULT NULL,
  `userQQ` varchar(255) DEFAULT NULL,
  `userState` int(11) DEFAULT NULL,
  `userDescription` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tz_user
-- ----------------------------
INSERT INTO `tz_user` VALUES ('1', '七影', 'qiying', '84ef32f5e2ae43269111342934a4533f', '1', '/upload/qiying.jpg', '2139278706@qq.com', '18888888888', '2019-01-07 15:12:58', '2019-01-10 00:00:00', '2139278706', '1', '很帅很瘦');
INSERT INTO `tz_user` VALUES ('2', '七七', 'qiqi', '0c5adbd178ec83685e17f7e9e5239780', '1', '/upload/寸照.jpg', '2139278706@qq.com', '13333333333', '2019-01-07 15:18:28', '2019-01-08 00:00:00', '2139278706', '1', '嘻嘻');
INSERT INTO `tz_user` VALUES ('3', '163', '163', '78ad080d77106e4494a58f02508942e7', '1', '/upload/火箭.jpg', '18775418074@163.com', '18775418074', '2019-01-07 15:24:56', '2019-01-07 00:00:00', '18775418074', '1', '11111');
INSERT INTO `tz_user` VALUES ('4', 'admin', 'admin', 'c7122a1349c22cb3c009da3613d242ab', '1', '/upload/加我微信.jpg', '18775418074@163.com', '18775418074', '2019-01-07 15:28:54', '2019-01-08 00:00:00', '2623123406', '1', '....');
INSERT INTO `tz_user` VALUES ('5', '张三', 'zhangsan', '6aed0784ab2ebabab73da2c52955eabf', '1', '/upload/abc1.jpg', '2139278706@qq.com', '10086', '2019-01-08 19:12:29', '2019-01-09 00:00:00', '2139278706', '1', '很帅');
INSERT INTO `tz_user` VALUES ('6', '3003', '3003', '8533c081673a38d894378edf00f19bdf', '1', '/upload/abc2.jpg', '3003197877@qq.com', '1330', '2019-01-08 19:19:08', '2019-01-10 00:00:00', '3003197877', '1', '123');
INSERT INTO `tz_user` VALUES ('7', '金克斯', 'jks', '7f9a6055fff214d247943ebad56823e9', '1', '/upload/jks.jpg', '3003197877@.com', '10086', '2019-01-08 19:55:48', '2019-01-10 00:00:00', '3003197877', '0', '感谢金克斯送的一枚导弹');
INSERT INTO `tz_user` VALUES ('8', '赏金', 'sj', '94cd1e09cca88461cb0cc8106f088bdf', '1', '/upload/sjin.jpg', '2139278706@qq.com', '1006', '2019-01-08 20:06:30', '2019-01-09 00:00:00', '2139278706', '0', '小');
INSERT INTO `tz_user` VALUES ('9', '小老鼠', ' xls', 'b1d7958aadefc7e529a536a564341df4', '1', '/upload/xiaolaoshu.jpg', '2139278706@qq.com', '10086', '2019-01-08 20:10:51', '2019-01-09 00:00:00', '2139278706', '0', 'xiaolaoshu');
INSERT INTO `tz_user` VALUES ('10', '豆豆', 'doudou', 'f3295a9fb8dda7df7a1518618ff8454d', '1', '/upload/豆豆.jpg', '2139278706@qq.com', '111', '2019-01-08 20:15:30', '2019-01-18 00:00:00', '2139278706', '0', 'hen');
INSERT INTO `tz_user` VALUES ('11', '讲道理', 'jiangdaoli', '27b82dce9fde228bf8ce2a07595d3363', '1', '/upload/admin.jpg', '2139278706@ qq.com', '1001', '2019-01-08 20:53:22', '2019-01-01 00:00:00', ' 2139278706', '0', '不讲道理');
INSERT INTO `tz_user` VALUES ('12', '深蓝', 'shenlan', 'e57494e99514dcb88579aa91206485e0', '1', '/upload/xiaolaoshu.jpg', '2139278706@qq.com', '100', '2019-01-08 20:54:20', '2019-01-01 00:00:00', ' 2139278706', '0', '不讲道理');
INSERT INTO `tz_user` VALUES ('13', '1806', '1808', '882b15daf0fbe9ba34101d22fcb11771', '1', '/upload/jks.jpg', '3003197877@qq.com', '3003197877', '2019-01-11 20:20:04', '2019-01-01 00:00:00', '3003197877', '0', 'sdfsa');
INSERT INTO `tz_user` VALUES ('14', 'tom', 'tom', 'eeb6a828dd2b9664e1bac9f99208aa08', '1', '/upload/admin.jpg', '3003197877@qq.com', '3003197877', '2019-01-19 22:03:11', '2019-01-19 00:00:00', '3003197877', '0', '3003197877');
INSERT INTO `tz_user` VALUES ('15', '小恒', 'xiaoheng', '123456', null, null, '1', '1', null, null, null, '1', null);
INSERT INTO `tz_user` VALUES ('16', 'zhangsan', 'zhangsan', '123456', null, null, '1', '1', null, null, null, '1', null);

好了, 大家可以启动项目然后在url后面加上/hello/123/张三即可访问数据库中的数据了, 因为hello.java里面的路径带了后面的两个参数所以必须写, 否则404

到此spring+springMVC+Hibernate整合完毕, 有问题可以留言或者QQ: 150032099

补充: 如果Hibernate不想使用c3p0连接池而想使用druid连接池可以将application配置文件做如下修改, 然后将pom.xml里面的c3p0的依赖改为druid的依赖

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

<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/aop
           http://www.springframework.org/schema/aop/spring-aop-4.2.xsd
           http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-4.2.xsd
           http://www.springframework.org/schema/tx
           http://www.springframework.org/schema/tx/spring-tx-4.2.xsd ">

    <!-- [注解扫描器] -->
    <context:component-scan base-package="com.jc">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
    <context:annotation-config />

    <!-- [加载数据库配置文件] -->
    <context:property-placeholder location="classpath:db.properties" />
    <!-- [c3p0连接池配置] -->
    <!--<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${com.jc.driver}" />
        <property name="jdbcUrl" value="${com.jc.url}" />
        <property name="user" value="${com.jc.username}" />
        <property name="password" value="${com.jc.password}" />
    </bean>-->
    <!-- [druid连接池配置, 可以只配置基本信息而不用配置初始化大小等] -->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <!-- [使用connectProperties来配置也是可以的] -->
        <!--<property name="connectProperties">
            <props>
                <prop key="druid.driverClassName">${com.jc.driver}</prop>
                <prop key="druid.url">${com.jc.url}</prop>
                <prop key="druid.username">${com.jc.username}</prop>
                <prop key="druid.password">${com.jc.password}</prop>
            </props>
        </property>-->
        <property name="driverClassName" value="${com.jc.driver}" />
        <property name="url" value="${com.jc.url}" />
        <property name="username" value="${com.jc.username}" />
        <property name="password" value="${com.jc.password}" />
        <!-- 配置初始化大小、最小、最大 -->
        <property name="initialSize" value="5" />
        <property name="minIdle" value="5" />
        <property name="maxActive" value="99" />

        <!-- 配置获取连接等待超时的时间 -->
        <property name="maxWait" value="60000" />

        <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
        <property name="timeBetweenEvictionRunsMillis" value="60000" />

        <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
        <property name="minEvictableIdleTimeMillis" value="300000" />

        <property name="validationQuery" value="SELECT 'x'" />
        <property name="testWhileIdle" value="true" />
        <property name="testOnBorrow" value="false" />
        <property name="testOnReturn" value="false" />

        <!-- 打开PSCache，并且指定每个连接上PSCache的大小 -->
        <property name="poolPreparedStatements" value="true" />
        <property name="maxPoolPreparedStatementPerConnectionSize" value="20" />
    </bean>
    <!-- [配置数据源] -->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
                <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
                <prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
                <!-- [单独使用hibernate才需要] -->
                <!--<prop key="hibernate.current_session_context_class">${hibernate.current_session_context_class}</prop>-->
            </props>
        </property>
        <!-- [和数据库关联的实体类包注解扫描] -->
        <property name="packagesToScan">
            <list>
                <value>com.jc.bean</value>
            </list>
        </property>
    </bean>

    <!-- [事务管理] -->
    <bean id="txManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>

    <tx:advice id="txAdvice" transaction-manager="txManager">
        <tx:attributes>
            <tx:method name="select*" read-only="true" />
            <tx:method name="*"/>
        </tx:attributes>
    </tx:advice>

    <aop:config>
        <aop:pointcut id="pointcut" expression="execution(* com.jc.service.*.*(..))" />
        <aop:advisor advice-ref="txAdvice" pointcut-ref="pointcut" />
    </aop:config>

</beans>

光影九曜

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
spring+springMVC+Hibernate整合

框架整合无非就是几个配置文件的问题, 这里的spring+springMVC+Hibernate整合有3个配置文件和一个数据库的properties:spring的application.xmlspringMVC的mvc.xml项目的web.xml数据库相关的信息db.propertieshibernate的配置文件已经写入到了application里面所以这里没有亲...
复制链接

扫一扫