spring+springMvc+mybatis框架整合

浅浅的花香味﹌ 2022-04-24 04:00 203阅读 0赞

### 一、搭建web应用 ###

由于是web项目，所以首先要搭建一个基础的web应用，搭建过程可以参考：[IDEA中使用maven搭建web应用][IDEA_maven_web]。  
搭建完的项目结构如下图：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70]

### 二、添加maven依赖 ###

pom.xml添加所需maven依赖，整个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</groupId>
        <artifactId>spring-demo</artifactId>
        <version>1.0-SNAPSHOT</version>
        <packaging>war</packaging>
    
        <name>spring-demo 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>
            <spring.version>5.0.13.RELEASE</spring.version>
            <mybatis.version>3.4.6</mybatis.version>
            <mybatis.spring.version>2.0.0</mybatis.spring.version>
            <mysql.version>6.0.6</mysql.version>
            <druid.version>1.1.15</druid.version>
            <fastjson.version>1.2.56</fastjson.version>
            <jackson.version>2.9.7</jackson.version>
        </properties>
    
        <dependencies>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-core</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-aspects</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-web</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-web</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>${mybatis.spring.version}</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>${mysql.version}</version>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>${druid.version}</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-api</artifactId>
                <version>1.7.25</version>
            </dependency>
            <dependency>
                <groupId>ch.qos.logback</groupId>
                <artifactId>logback-core</artifactId>
                <version>1.2.3</version>
            </dependency>
            <dependency>
                <groupId>ch.qos.logback</groupId>
                <artifactId>logback-classic</artifactId>
                <version>1.2.3</version>
            </dependency>
            <dependency>
                <groupId>ch.qos.logback</groupId>
                <artifactId>logback-access</artifactId>
                <version>1.2.3</version>
            </dependency>
            <dependency>
                <groupId>org.logback-extensions</groupId>
                <artifactId>logback-ext-spring</artifactId>
                <version>0.1.5</version>
            </dependency>
    
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                <version>${fastjson.version}</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-core</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-databind</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>servlet-api</artifactId>
                <version>2.5</version>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>javax.servlet.jsp</groupId>
                <artifactId>jsp-api</artifactId>
                <version>2.1</version>
                <scope>provided</scope>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
                <scope>test</scope>
            </dependency>
        </dependencies>
    
        <build>
            <finalName>spring-demo</finalName>
            <pluginManagement>
                <plugins>
                    
                    <plugin>
                        <groupId>org.apache.tomcat.maven</groupId>
                        <artifactId>tomcat7-maven-plugin</artifactId>
                        <version>2.2</version>
                        <configuration>
                            <port>8080</port>
                            <path>/</path>
                            <uriEncoding>UTF-8</uriEncoding>
                        </configuration>
                    </plugin>
                    
                    <plugin>
                        <groupId>org.mybatis.generator</groupId>
                        <artifactId>mybatis-generator-maven-plugin</artifactId>
                        <version>1.3.2</version>
                        <configuration>
                            <configurationFile>../springdemo/src/main/resources/generator/generatorConfig.xml
                            </configurationFile>
                            <overwrite>true</overwrite>
                            <verbose>true</verbose>
                        </configuration>
                    </plugin>
                </plugins>
            </pluginManagement>
        </build>
    </project>

### 三、配置web.xml ###

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>classpath:config/applicationContext.xml</param-value>
      </context-param>
      
      <context-param>
        <param-name>logbackConfigLocation</param-name>
        <param-value>classpath:config/logback.xml</param-value>
      </context-param>
    
      
      <filter>
        <filter-name>springEncodingFilter</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>springEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
      </filter-mapping>
    
      
      <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
      
      <listener>
        <listener-class>ch.qos.logback.ext.spring.web.LogbackConfigListener</listener-class>
      </listener>
    
      
      <servlet>
        <servlet-name>springMvcServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
          <param-name>contextConfigLocation</param-name>
          <param-value>classpath:config/spring-mvc.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
      </servlet>
      <servlet-mapping>
        <servlet-name>springMvcServlet</servlet-name>
        
        <url-pattern>/*</url-pattern>
      </servlet-mapping>
    
      
      <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
      </welcome-file-list>
      <error-page>
        <error-code>404</error-code>
        <location>/errorPages/404.jsp</location>
      </error-page>
    </web-app>

### 四、配置applicationContext.xml ###

在src/main/resources/config/下面新建文件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:aop="http://www.springframework.org/schema/aop"
           xmlns:tx="http://www.springframework.org/schema/tx"
           xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
                http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
                http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
                http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
    
        
        <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
            <property name="locations" value="classpath:config/jdbc.properties"/>
        </bean>
    
        
        <context:component-scan base-package="com.demo.ssm">
            <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
        </context:component-scan>
    
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
            
            <property name="driverClassName" value="${jdbc.driverClassName}"/>
            <property name="url" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
            
            <property name="initialSize" value="10"/>
            <property name="minIdle" value="10"/>
            <property name="maxActive" value="50"/>
            
            <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" />
            
            <property name="poolPreparedStatements" value="false" />
            <property name="maxPoolPreparedStatementPerConnectionSize" value="20" />
            
            <property name="filters" value="wall,stat" />
        </bean>
    
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource" />
            
            <property name="mapperLocations" value="classpath:mappers/*.xml"/>
        </bean>
    
      
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com.demo.ssm.mapper" />
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        </bean>
    
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            
            <property name="dataSource" ref="dataSource"/>
        </bean>
    
        
        <aop:config>
            
            <aop:pointcut expression="execution(* com.demo.ssm.service..*(..))" id="txpoint" />
            
            <aop:advisor advice-ref="txAdvice" pointcut-ref="txpoint" />
        </aop:config>
    
        
        <tx:advice id="txAdvice" transaction-manager="transactionManager">
            <tx:attributes>
                
                <tx:method name="*" />
                
                <tx:method name="get*" read-only="true" />
            </tx:attributes>
        </tx:advice>
    </beans>

### 五、配置jdbc.properties文件 ###

在src/main/resources/config/下面新建文件jdbc.properties,配置数据库连接属性，注意属性名和applicationContext.xml中dataSource整个bean下的value保持一致,如下：

jdbc.driverClassName=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/ssm?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC
    jdbc.username=root
    jdbc.password=123456

### 六、配置spring-mvc.xml ###

在src/main/resources/config/下面新建文件spring-mvc.xml配置springMvc相关配置，如下：

<?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:p="http://www.springframework.org/schema/p"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:mvc="http://www.springframework.org/schema/mvc"
           xsi:schemaLocation="
                http://www.springframework.org/schema/beans
                http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
                http://www.springframework.org/schema/context
                http://www.springframework.org/schema/context/spring-context-4.3.xsd
                http://www.springframework.org/schema/mvc
                http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd">
    
        
        <context:component-scan base-package="com.demo.ssm.controller" use-default-filters="false">
            <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
        </context:component-scan>
    
        
        <mvc:annotation-driven/>
    
        
        <mvc:resources mapping="/static/**" location="/WEB-INF/static/"/>
    
        
        <bean id="mappingJacksonHttpMessageConverter"
              class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
            <property name="supportedMediaTypes">
                <list>
                    <value>text/html;charset=UTF-8</value>
                </list>
            </property>
        </bean>
    
        
        <bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter">
            <property name="messageConverters">
                <list>
                    <ref bean="mappingJacksonHttpMessageConverter"/> 
                </list>
            </property>
        </bean>
    
        
        <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
            
            <property name="prefix" value="/WEB-INF/jsp/"/>
            <property name="suffix" value=".jsp"/>
        </bean>
    </beans>

### 七、配置logback.xml ###

在src/main/resources/config/下面新建文件logback.xml，主要配置控制台输出日志以及按日每天输出日志：

<?xml version="1.0" encoding="UTF-8"?>
    <configuration debug="false">
        
        <property name="LOG_HOME" value="F://logs" />
        
        <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
            <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
                
                <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n</pattern>
            </encoder>
        </appender>
        
        <appender name="FILE" class="ch.qos.logback.core.rolling.RollingFileAppender">
            <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
                
                <FileNamePattern>${LOG_HOME}/TestWeb.log.%d{yyyy-MM-dd}.log</FileNamePattern>
                
                <MaxHistory>30</MaxHistory>
            </rollingPolicy>
            <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
                
                <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n</pattern>
            </encoder>
            
            <triggeringPolicy class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy">
                <MaxFileSize>10MB</MaxFileSize>
            </triggeringPolicy>
        </appender>
    
        
        <root level="INFO">
            
            <appender-ref ref="STDOUT" />
            <appender-ref ref="FILE"/>
        </root>
    </configuration>

### 八、配置generatorConfig.xml ###

在src/main/resources/generator/下面创建文件generatorConfig.xml，配置mybatis逆向工程，配置内容如下：

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
            PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    <generatorConfiguration>
        
        <classPathEntry location="F:\mybatis-generator\mysql-connector-java-5.1.38.jar"/>
        <context id="mysqlTables" targetRuntime="MyBatis3">
            <commentGenerator>
                <property name="suppressDate" value="true"/>
                
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/ssm"
                            userId="root" password="123456">
            </jdbcConnection>
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
            
            <javaModelGenerator targetPackage="com.demo.ssm.entity" targetProject="src/main/java">
                <property name="enableSubPackages" value="true"/>
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="mappers" targetProject="src/main/resources">
                <property name="enableSubPackages" value="true"/>
            </sqlMapGenerator>
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.demo.ssm.mapper" targetProject="src/main/java">
                <property name="enableSubPackages" value="true"/>
            </javaClientGenerator>
            
            <table tableName="user" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
        </context>
    </generatorConfiguration>

其中`F:\mybatis-generator\mysql-connector-java-5.1.38.jar`需要在本地相应位置提前放好`mysql-connector-java-5.1.38.jar`这个jar文件。**逆向工程使用时候应该注意：如果没有目标文件名，则会创建，如果有则会覆盖，这点应该特别注意，后期Java Bean以及mapper.xml文件生成后，建议将对应的table删除。**

### 九、运行逆向工程生成代码 ###

**1.创建user表**

CREATE TABLE `user` (
      `id` bigint(19) NOT NULL AUTO_INCREMENT,
      `nick_name` varchar(20) NOT NULL,
      `real_name` varchar(20) NOT NULL,
      `user_type` varchar(2) NOT NULL,
      `encrypt_password` varchar(50) NOT NULL,
      `sex` varchar(2) NOT NULL,
      `mobile` varchar(11) DEFAULT NULL,
      `address` varchar(20) DEFAULT NULL,
      `user_status` varchar(2) DEFAULT NULL,
      `birthday` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表'

**2.运行逆向工程生成对应类**  
点击Edit Configuration，添加一个maven配置，Command Line填入：`mybatis-generator:generate -f pom.xml`，Working directory选择当前工程路径，如下图：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 1]  
然后点击ok，此时在右侧Maven管理界面该工程对应的Run Configuration中可看到刚才添加的配置项：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 2]  
双击mybatisGenerator配置项生成代码，如下图：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 3]

### 十、编写接口测试 ###

**1.编写UserService**  
在生成的UserMapper接口上面加上注解`@Repository("userDao")`，以便将其交给spring管理，如下：  
![在这里插入图片描述][20190419214033977.png]  
紧接着，创建com.demo.ssm.service包，编写UserService，提供两个方法，分别测试查询单个用户信息，以及新增用户，代码如下：

package com.demo.ssm.service;
    
    import com.demo.ssm.entity.User;
    import com.demo.ssm.mapper.UserMapper;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    @Service("userService")
    public class UserService{
    
        @Autowired
        private UserMapper userDao;
    
        public User getUserById(Long id){
            return userDao.selectByPrimaryKey(id);
        }
    
        public int addUser(User user){
            return userDao.insert(user);
        }   
    }

至此，service方法完成。  
**2.编写测试controller**  
创建包：com.demo.ssm.controller，编写UserController类，提供两个接口，查询单个用户以及新增用户，UserController类内容如下：

package com.demo.ssm.controller;
    
    import com.alibaba.fastjson.JSON;
    import com.demo.ssm.entity.User;
    import com.demo.ssm.service.UserService;
    import org.slf4j.Logger;
    import org.slf4j.LoggerFactory;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.*;
    
    
    @RestController
    @RequestMapping(value = "test")
    public class UserController {
        @Autowired
        private UserService userService;
        private static final Logger LOGGER = LoggerFactory.getLogger(UserService.class);
    
        @GetMapping(value = "/{id}", produces = "application/json; charset=utf-8")
        @ResponseBody
        public String getOneUser(@PathVariable("id") String id) {
            LOGGER.warn("function=getAllUser,id = {}", id);
            User user = userService.getUserById(Long.valueOf(id));
            LOGGER.warn("function=getAllUser,user = {}", JSON.toJSONString(user));
            return JSON.toJSONString(user);
        }
    
        @PostMapping(value = "/user")
        @ResponseBody
        public String addUser(@RequestBody() User user) {
            LOGGER.warn("function=addUser,user={}", JSON.toJSONString(user));
            int i = userService.addUser(user);
            if (1 == i) {
                return "success";
            } else {
                return "error";
            }
        }
    }

以上是两个rest风格的接口，一个get接口，访问url为/test/\{id\}，另外一个是post接口，访问url问/test/user并携带body体。

### 十一、测试 ###

使用postman分别测试两个接口:  
（1）新增用户接口  
调用url:POST [http://localhost:8080/test/user][http_localhost_8080_test_user]  
测试结果：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 4]  
（2）查询单个用户信息:  
调用接口查询以下刚才新增的用户,访问url:GET [http://localhost:8080/test/100][http_localhost_8080_test_100]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 5]  
接口正常返回。注：如果返回的中文为乱码，则在方法上面的RequestMapping/GetMapping中加入 `produces = "application/json; charset=utf-8"`即可解决，如下图：  
![在这里插入图片描述][2019041921524212.png]  
查看控制台日志打印：![在这里插入图片描述][20190419215849709.png]  
查看F:/logs/目录下日志记录：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 6]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 7]  
说明mybatis,logback配置ok  
（3）静态资源访问测试：  
在/WEB-INF/static/html/下面新建一个success.html文件，浏览器访问http://localhost:8080/static/html/success.html,界面访问成功:  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 8]  
至此，spring+springMvc+mybatis框架整合完成。

源码下载地址：[https://download.csdn.net/download/m0\_37674755/11129422][https_download.csdn.net_download_m0_37674755_11129422]

参考文章：  
1.[logback的使用和logback.xml详解][logback_logback.xml]；  
2.[SSM框架——Spring+SpringMVC+Mybatis的搭建教程][SSM_Spring_SpringMVC_Mybatis];  
3.[SSM框架——详细整合教程（Spring+SpringMVC+MyBatis）][SSM_Spring_SpringMVC_MyBatis].

[IDEA_maven_web]: https://blog.csdn.net/m0_37674755/article/details/80374256
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70]: /images/20220220/5d98348416b44a928862a0412f8459c4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 1]: /images/20220220/ad875206bc184f41870047f4700dd7e5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 2]: /images/20220220/730febfb695b4dda857ca0a5f25315cf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 3]: /images/20220220/e75f185449404e2d8c2d5652e221b203.png
[20190419214033977.png]: /images/20220220/75aab70c5cb24e369dd3fe20a58c932b.png
[http_localhost_8080_test_user]: http://localhost:8080/test/user
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 4]: /images/20220220/8818898c17f34690891fc38362189484.png
[http_localhost_8080_test_100]: http://localhost:8080/test/100
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 5]: /images/20220220/24a9c4b87310444f82fef83da7c53a76.png
[2019041921524212.png]: /images/20220220/c53d1b4d736247549937b03a30765eac.png
[20190419215849709.png]: /images/20220220/0fd806fffa17482cbe43ead40d6b83ea.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 6]: /images/20220220/588bf8be6d4a40da85c87f48efb5c92c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 7]: /images/20220220/af9c6714078149058dcdf5faa44a730b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3Njc0NzU1_size_16_color_FFFFFF_t_70 8]: /images/20220220/00bf526b4ec440dba26f1b1221d9718f.png
[https_download.csdn.net_download_m0_37674755_11129422]: https://download.csdn.net/download/m0_37674755/11129422
[logback_logback.xml]: https://www.cnblogs.com/warking/p/5710303.html
[SSM_Spring_SpringMVC_Mybatis]: https://www.cnblogs.com/aflyun/p/6421441.html
[SSM_Spring_SpringMVC_MyBatis]: https://www.cnblogs.com/zyw-205520/p/4771253.html