Spring+Spring MVC+Mybatis+Maven整合教程(图文详解附代码)

我不是女神ヾ 2022-05-17 00:37 159阅读 0赞

## 1.配置整合前所需准备的环境: ##

这是我搭建的时候用的环境，至于环境的搭建我就不带大家搭建了，百度上一大堆教程

1.1：jdk1.8
    1.2：idea2018.1.5
    1.3：Maven 3.5.2

## 2.查看idea中是否安装Maven插件: ##

2.1：File --> Settings --> Plugins
    2.2：如下图所示的步骤进行操作(注:安装完插件，idea会重新启动)
    3.

![70][]

## 3.idea创建Maven项目的步骤 ##

这里大家可以选择maven提供的模板文件，然后先写项目名称之后需要等待一下，因为idea需要下载对应的模板下来。大家要按照图上的选择哟。

![70 1][]

![01][]

![01][01 1]

![03][]

![05][]

![07][]

## 4.搭建目录结构 ##

下图就是我搭建Maven项目之后，添加对应的目录和文件  
![08][]

# 5 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.mqc.projectOne</groupId>
      <artifactId>projectOne</artifactId>
      <version>1.0-SNAPSHOT</version>
      <packaging>war</packaging>
    
      <name>projectOne Maven Webapp</name>
      
      <url>http://www.example.com</url>
    
      <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    
        
        <spring.version>4.2.5.RELEASE</spring.version>
    
        
        <mybatis.version>3.2.8</mybatis.version>
    
        
        <mysql-driver.version>5.1.29</mysql-driver.version>
    
        
        <slf4j.version>1.7.18</slf4j.version>
        <log4j.version>1.2.17</log4j.version>
      </properties>
    
      
      <repositories>
        <repository>
          <id>public</id>
          <name>aliyun nexus</name>
          <url>http://maven.aliyun.com/nexus/content/groups/public/</url>
          <releases>
            <enabled>true</enabled>
          </releases>
        </repository>
      </repositories>
    
      <dependencies>
        
        <dependency>
          <groupId>jstl</groupId>
          <artifactId>jstl</artifactId>
          <version>1.2</version>
        </dependency>
    
        <dependency>
          <groupId>javax</groupId>
          <artifactId>javaee-api</artifactId>
          <version>7.0</version>
        </dependency>
    
        
        <dependency>
          <groupId>junit</groupId>
          <artifactId>junit</artifactId>
          <version>4.11</version>
          
          <scope>test</scope>
        </dependency>
    
        
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-core</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-oxm</artifactId>
          <version>${spring.version}</version>
        </dependency>
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-tx</artifactId>
          <version>${spring.version}</version>
        </dependency>
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-jdbc</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-context</artifactId>
          <version>${spring.version}</version>
        </dependency>
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-context-support</artifactId>
          <version>${spring.version}</version>
        </dependency>
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-aop</artifactId>
          <version>${spring.version}</version>
        </dependency>
    
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-test</artifactId>
          <version>${spring.version}</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis</artifactId>
          <version>${mybatis.version}</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis-spring</artifactId>
          <version>1.3.0</version>
        </dependency>
    
        
        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>${mysql-driver.version}</version>
        </dependency>
        
        <dependency>
          <groupId>commons-dbcp</groupId>
          <artifactId>commons-dbcp</artifactId>
          <version>1.2.2</version>
        </dependency>
    
        
        <dependency>
          <groupId>com.alibaba</groupId>
          <artifactId>fastjson</artifactId>
          <version>1.1.41</version>
        </dependency>
    
        
        <dependency>
          <groupId>log4j</groupId>
          <artifactId>log4j</artifactId>
          <version>${log4j.version}</version>
        </dependency>
        <dependency>
          <groupId>org.slf4j</groupId>
          <artifactId>slf4j-api</artifactId>
          <version>${slf4j.version}</version>
        </dependency>
        <dependency>
          <groupId>org.slf4j</groupId>
          <artifactId>slf4j-log4j12</artifactId>
          <version>${slf4j.version}</version>
        </dependency>
    
        
        
        <dependency>
          <groupId>org.codehaus.jackson</groupId>
          <artifactId>jackson-mapper-asl</artifactId>
          <version>1.9.13</version>
        </dependency>
        
        <dependency>
          <groupId>com.fasterxml.jackson.core</groupId>
          <artifactId>jackson-core</artifactId>
          <version>2.8.0</version>
        </dependency>
        
        <dependency>
          <groupId>com.fasterxml.jackson.core</groupId>
          <artifactId>jackson-databind</artifactId>
          <version>2.8.0</version>
        </dependency>
    
        <dependency>
          <groupId>commons-fileupload</groupId>
          <artifactId>commons-fileupload</artifactId>
          <version>1.3.1</version>
        </dependency>
    
        <dependency>
          <groupId>commons-io</groupId>
          <artifactId>commons-io</artifactId>
          <version>2.4</version>
        </dependency>
    
        <dependency>
          <groupId>commons-codec</groupId>
          <artifactId>commons-codec</artifactId>
          <version>1.9</version>
        </dependency>
      </dependencies>
    </project>

# 6.jdbc.properties文件配置 #

jdbc.url=jdbc:mysql://127.0.0.1:3306/mqc?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8
    jdbc.username=root
    jdbc.password=
    
    jdbc.initialSize=5
    jdbc.maxActive=30

# 7.spring-context.xml文件内容 #

其中每一个配置的作用我已经注释好了，对于spring加载对应properties文件的内容可以在我的博客中查找对应的配置方式。对于JDNI的方式引入数据源我在实际生产环境中也没有用过，只是知道也有这么一个数据源方式。

<?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:aop="http://www.springframework.org/schema/aop"
           xmlns:util="http://www.springframework.org/schema/util" xmlns:tx="http://www.springframework.org/schema/tx"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
        
        <context:property-placeholder location="classpath:config/jdbc.properties"></context:property-placeholder>
    
        
        <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
            <property name="locations">
                <list>
                    <value>classpath:config/jdbc.properties</value>
                </list>
            </property>
        </bean>
    
        
        <context:component-scan base-package="com.joker"></context:component-scan>
    
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
        init-method="init" destroy-method="clone">
            <property name="url">
                <value>${jdbc.url}</value>
            </property>
            <property name="username">
                <value>${jdbc.username}</value>
            </property>
            <property name="password">
                <value>${jdbc.password}</value>
            </property>
            <property name="initialSize">
                <value>${jdbc.initialSize}</value>
            </property>
            <property name="maxActive">
                <value>${jdbc.maxActive}</value>
            </property>
            <property name="proxyFilters">
                <list>
                    <ref bean="stat-filter" />
                    <ref bean="wall-filter" />
                </list>
            </property>
        </bean>
        <bean id="stat-filter" class="com.alibaba.druid.filter.stat.StatFilter">
            <property name="slowSqlMillis" value="1000" />
            <property name="logSlowSql" value="true" />
            <property name="mergeSql" value="true" />
        </bean>
        <bean id="wall-filter" class="com.alibaba.druid.wall.WallFilter">
            <property name="dbType" value="mysql" />
            <property name="config" ref="wall-filter-config" />
        </bean>
        <bean id="wall-filter-config" class="com.alibaba.druid.wall.WallConfig">
            <property name="multiStatementAllow" value="true" />
        </bean>
    
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"></property>
            
            <property name="mapperLocations" value="classpath*:mapper/*.xml"></property>
        </bean>
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com.joker"></property>
        </bean>
    
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource">
                <ref bean="dataSource"></ref>
            </property>
        </bean>
        
        
        
        
        
        <tx:annotation-driven transaction-manager="transactionManager"/>
    
        
    
        
        <tx:advice id="txAdvice" transaction-manager="transactionManager">
            
            <tx:attributes>
                
                <tx:method name="insert*" propagation="REQUIRED" />
                <tx:method name="update*" propagation="REQUIRED" />
                <tx:method name="edit*" propagation="REQUIRED" />
                <tx:method name="save*" propagation="REQUIRED" />
                <tx:method name="add*" propagation="REQUIRED" />
                <tx:method name="new*" propagation="REQUIRED" />
                <tx:method name="set*" propagation="REQUIRED" />
                <tx:method name="remove*" propagation="REQUIRED" />
                <tx:method name="delete*" propagation="REQUIRED" />
                <tx:method name="change*" propagation="REQUIRED" />
                <tx:method name="check*" propagation="REQUIRED" />
                <tx:method name="get*" propagation="REQUIRED" read-only="true" />
                <tx:method name="find*" propagation="REQUIRED" read-only="true" />
                <tx:method name="load*" propagation="REQUIRED" read-only="true" />
                
                <tx:method name="*" propagation="REQUIRED" read-only="true" />
            </tx:attributes>
        </tx:advice>
        
        
        <aop:config>
            <aop:pointcut id="serviceOperation"
                          expression="execution(* com.joker.service.*.*(..))" />
            <aop:advisor advice-ref="txAdvice" pointcut-ref="serviceOperation" />
        </aop:config>
    </beans>

# 8. web.xml配置内容 #

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
             http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
             version="3.1"  metadata-complete="false">
      <display-name>Archetype Created Web Application</display-name>
      
      
      
      <context-param>
        <param-name>
          contextConfigLocation
        </param-name>
        <param-value>
          classpath:config/spring/spring-*.xml
        </param-value>
      </context-param>
      
      <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
      
      <listener>
        <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
      </listener>
    
      
      <servlet>
        <servlet-name>SpringMVC</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
          <param-name>contextConfigLocation</param-name>
          <param-value>classpath:config/spring/spring-context.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
      </servlet>
      <servlet-mapping>
        <servlet-name>SpringMVC</servlet-name>
        
        <url-pattern>/</url-pattern>
      </servlet-mapping>
    
      
      <filter>
        <filter-name>encodingFilter</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>
      </filter>
      <filter-mapping>
        <filter-name>encodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
      </filter-mapping>
    
      
      <welcome-file-list>
        <welcome-file>/index.jsp</welcome-file>
      </welcome-file-list>
    
      
      <session-config>
        <session-timeout>15</session-timeout>
      </session-config>
    
    </web-app>

# 9.项目部署环境配置 #

![70 2][]

![70 3][]

![70 4][]

[70]: /images/20220517/aa704d5e1aec40c8ae9e7a9ce8b2dbc6.png
[70 1]: /images/20220517/6a450bc7302f422fbb20a91751361bd2.png
[01]: http://p0f0e6zkg.bkt.clouddn.com/03.png?imageView2/0/q/75%7Cwatermark/2/text/5pmT5LmL5769/font/5qW35L2T/fontsize/480/fill/I0Y2MDYzNg==/dissolve/100/gravity/SouthEast/dx/10/dy/10%7Cimageslim
[01 1]: http://p0f0e6zkg.bkt.clouddn.com/05.png?imageView2/0/q/75%7Cwatermark/2/text/5pmT5LmL5769/font/5qW35L2T/fontsize/480/fill/I0Y2MDYzNg==/dissolve/100/gravity/SouthEast/dx/10/dy/10%7Cimageslim
[03]: http://p0f0e6zkg.bkt.clouddn.com/07.png?imageView2/0/q/75%7Cwatermark/2/text/5pmT5LmL5769/font/5qW35L2T/fontsize/480/fill/I0Y2MDYzNg==/dissolve/100/gravity/SouthEast/dx/10/dy/10%7Cimageslim
[05]: http://p0f0e6zkg.bkt.clouddn.com/08.png?imageView2/0/q/75%7Cwatermark/2/text/5pmT5LmL5769/font/5qW35L2T/fontsize/480/fill/I0Y2MDYzNg==/dissolve/100/gravity/SouthEast/dx/10/dy/10%7Cimageslim
[07]: http://p0f0e6zkg.bkt.clouddn.com/09.png?imageView2/0/q/75%7Cwatermark/2/text/5pmT5LmL5769/font/5qW35L2T/fontsize/480/fill/I0Y2MDYzNg==/dissolve/100/gravity/SouthEast/dx/10/dy/10%7Cimageslim
[08]: http://p0f0e6zkg.bkt.clouddn.com/10.png?imageView2/0/q/75%7Cwatermark/2/text/5pmT5LmL5769/font/5qW35L2T/fontsize/480/fill/I0Y2MDYzNg==/dissolve/100/gravity/SouthEast/dx/10/dy/10%7Cimageslim
[70 2]: /images/20220517/62e387759ce743e7a35b001643a3b3f0.png
[70 3]: /images/20220517/8931b3f5f4a84c2ba789dc6747b4b40b.png
[70 4]: /images/20220517/e6b9188fc2d6436aa1755ad29f11e911.png