SpringBoot整合Mybatis详细版

最新推荐文章于 2022-12-06 10:07:21 发布

kelly921011

最新推荐文章于 2022-12-06 10:07:21 发布

阅读量260

点赞数 1

分类专栏： java 文章标签： springboot+mybatis

本文链接：https://blog.csdn.net/kelly921011/article/details/95475411

版权

java 专栏收录该内容

49 篇文章 1 订阅

订阅专栏

springboot+mybatis学习笔记。源码：https://github.com/kelly921011/sbm

1.创建一个Spring Initializr项目

2. 创建项目结构和jdk的版本

3.当我点击NEXT时，却出现如图4所示的错误，这由于创建时因为Artifact的命名为大小写混合，将大写改为小写即可正常创建。

4.接下来我们修改上面的错误，然后进行下一步。选择需要依赖

5.修改项目名/保存路径

6.查看建好后的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>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.6.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.example</groupId>
    <artifactId>springbootmybatis</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>springbootmybatis</name>
    <description>Demo project for Spring Boot</description>

    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.0.1</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <!-- 这个包是用做健康度监控的。手动加的 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-actuator</artifactId>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

7.修改配置文件

本文不使用application.properties文件而使用更加简洁的application.yml文件。将resource文件夹下原有的application.properties文件删除，创建application.yml配置文件（备注：其实SpringBoot底层会把application.yml文件解析为application.properties），本文创建了两个yml文件（application.yml和application-dev.yml），分别来看一下内容
application.yml

spring:
  profiles:
    active: dev

application-dev.yml

server:
  port: 8080

spring:
  datasource:
    username: root
    password: 1234
    url: jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    driver-class-name: com.mysql.cj.jdbc.Driver

mybatis:
  mapper-locations: classpath:mapping/*Mapper.xml #注意：一定要对应mapper映射xml文件的所在路径
  type-aliases-package: com.example.springbootmybatis.entity # 注意：对应实体类的路径

#showSql 打印日志 定位到到接口文件目录，如果路径层次出错 不会打印日志
logging:
  level:
    com:
      example:
         demo:
            mapper : debug

两个文件的意思是：

在项目中配置多套环境的配置方法。
因为现在一个项目有好多环境，开发环境，测试环境，准生产环境，生产环境，每个环境的参数不同，所以我们就可以把每个环境的参数配置到yml文件中，这样在想用哪个环境的时候只需要在主配置文件中将用的配置文件写上就行如application.yml

笔记：在Spring Boot中多环境配置文件名需要满足application-{profile}.yml的格式，其中{profile}对应你的环境标识，比如：

application-dev.yml：开发环境
application-test.yml：测试环境
application-prod.yml：生产环境
至于哪个具体的配置文件会被加载，需要在application.yml文件中通过spring.profiles.active属性来设置，其值对应{profile}值。

还有配置文件中最好不要有中文注释，会报错。

8.创建包controller、entity、mapper、service。resources下创建mapping文件夹，用于写sql语句，也可以用注解的方式直接写在mapper文件里。

AdminController.java

package com.example.demo.controller;

import com.example.demo.entity.Admin;
import com.example.demo.service.AdminService;
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 java.util.List;

@RestController
@RequestMapping("/admin")
public class AdminController {
    @Autowired
    private AdminService adminService;
    @RequestMapping("List/{permissions}")
    public List<Admin> ListAdmin(@PathVariable String permissions){
        System.out.println(permissions);
        return adminService.findList(permissions);
    }
}

AdminService.java

package com.example.demo.service;

import com.example.demo.entity.Admin;
import com.example.demo.mapper.AdminMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class AdminService {
    @Autowired
    private AdminMapper adminMapper;

    public List<Admin> findList(String permissions){
        return adminMapper.findList(permissions);
    }
}

AdminMapper.java

package com.example.demo.mapper;

import com.example.demo.entity.Admin;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;
@Repository
public interface AdminMapper {
    /**
     * 查询客服列表
     * @param permissions
     * @return
     */
    public List<Admin> findList(@Param("permissions") String permissions);
}

AdminMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.demo.mapper.AdminMapper">

    <!-- 查询管理员列表 -->
    <select id="findList" parameterType="string"
            resultType="com.example.demo.entity.Admin">
        select admin_id,admin_name,admin_pwd,admin_permissions,admin_telephone,create_time,last_modify_time from admin
        <where>
            admin_permissions !='0'
            and storeId = 0
            <if test="permissions !='0'">
                and admin_permissions !=#{permissions}
            </if>
        </where>
        order by last_modify_time desc
    </select>


</mapper>

9.最终框架

10.完成以上，下面在启动类里加上注解用于给出需要扫描的mapper文件路径@MapperScan("com.example.demo.mapper")

package com.example.demo;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@MapperScan("com.example.demo.mapper")
@SpringBootApplication
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }

}

11.测试，我使用的Postman测试，当然也可以直接上路径：http://localhost:8080/admin/List/2 输入到浏览器中直接测试

测试成功！

附上控制打印的日志：

"C:\Program Files\Java\jdk1.8.0_191\bin\java.exe" -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-javaagent:D:\Program Files\IntelliJ IDEA 2019.1.3\lib\idea_rt.jar=58855:D:\Program Files\IntelliJ IDEA 2019.1.3\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_191\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_191\jre\lib\rt.jar;E:\java项目文件\sbm\target\classes;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\boot\spring-boot-starter-freemarker\2.1.6.RELEASE\spring-boot-starter-freemarker-2.1.6.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\boot\spring-boot-starter\2.1.6.RELEASE\spring-boot-starter-2.1.6.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\boot\spring-boot\2.1.6.RELEASE\spring-boot-2.1.6.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\boot\spring-boot-autoconfigure\2.1.6.RELEASE\spring-boot-autoconfigure-2.1.6.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\boot\spring-boot-starter-logging\2.1.6.RELEASE\spring-boot-starter-logging-2.1.6.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\apache\logging\log4j\log4j-to-slf4j\2.11.2\log4j-to-slf4j-2.11.2.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\apache\logging\log4j\log4j-api\2.11.2\log4j-api-2.11.2.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\slf4j\jul-to-slf4j\1.7.26\jul-to-slf4j-1.7.26.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\javax\annotation\javax.annotation-api\1.3.2\javax.annotation-api-1.3.2.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\yaml\snakeyaml\1.23\snakeyaml-1.23.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\freemarker\freemarker\2.3.28\freemarker-2.3.28.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\spring-context-support\5.1.8.RELEASE\spring-context-support-5.1.8.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\spring-beans\5.1.8.RELEASE\spring-beans-5.1.8.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\spring-context\5.1.8.RELEASE\spring-context-5.1.8.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\spring-aop\5.1.8.RELEASE\spring-aop-5.1.8.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\spring-expression\5.1.8.RELEASE\spring-expression-5.1.8.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\boot\spring-boot-starter-jdbc\2.1.6.RELEASE\spring-boot-starter-jdbc-2.1.6.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\com\zaxxer\HikariCP\3.2.0\HikariCP-3.2.0.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\slf4j\slf4j-api\1.7.26\slf4j-api-1.7.26.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\spring-jdbc\5.1.8.RELEASE\spring-jdbc-5.1.8.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\spring-tx\5.1.8.RELEASE\spring-tx-5.1.8.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\boot\spring-boot-starter-thymeleaf\2.1.6.RELEASE\spring-boot-starter-thymeleaf-2.1.6.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\thymeleaf\thymeleaf-spring5\3.0.11.RELEASE\thymeleaf-spring5-3.0.11.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\thymeleaf\thymeleaf\3.0.11.RELEASE\thymeleaf-3.0.11.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\attoparser\attoparser\2.0.5.RELEASE\attoparser-2.0.5.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\unbescape\unbescape\1.1.6.RELEASE\unbescape-1.1.6.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\thymeleaf\extras\thymeleaf-extras-java8time\3.0.4.RELEASE\thymeleaf-extras-java8time-3.0.4.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\boot\spring-boot-starter-webflux\2.1.6.RELEASE\spring-boot-starter-webflux-2.1.6.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\boot\spring-boot-starter-json\2.1.6.RELEASE\spring-boot-starter-json-2.1.6.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\com\fasterxml\jackson\core\jackson-databind\2.9.9\jackson-databind-2.9.9.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\com\fasterxml\jackson\core\jackson-annotations\2.9.0\jackson-annotations-2.9.0.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\com\fasterxml\jackson\core\jackson-core\2.9.9\jackson-core-2.9.9.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.9.9\jackson-datatype-jdk8-2.9.9.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.9.9\jackson-datatype-jsr310-2.9.9.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.9.9\jackson-module-parameter-names-2.9.9.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\boot\spring-boot-starter-reactor-netty\2.1.6.RELEASE\spring-boot-starter-reactor-netty-2.1.6.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\projectreactor\netty\reactor-netty\0.8.9.RELEASE\reactor-netty-0.8.9.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\netty\netty-codec-http\4.1.36.Final\netty-codec-http-4.1.36.Final.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\netty\netty-common\4.1.36.Final\netty-common-4.1.36.Final.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\netty\netty-buffer\4.1.36.Final\netty-buffer-4.1.36.Final.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\netty\netty-transport\4.1.36.Final\netty-transport-4.1.36.Final.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\netty\netty-resolver\4.1.36.Final\netty-resolver-4.1.36.Final.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\netty\netty-codec\4.1.36.Final\netty-codec-4.1.36.Final.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\netty\netty-codec-http2\4.1.36.Final\netty-codec-http2-4.1.36.Final.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\netty\netty-handler\4.1.36.Final\netty-handler-4.1.36.Final.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\netty\netty-handler-proxy\4.1.36.Final\netty-handler-proxy-4.1.36.Final.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\netty\netty-codec-socks\4.1.36.Final\netty-codec-socks-4.1.36.Final.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\netty\netty-transport-native-epoll\4.1.36.Final\netty-transport-native-epoll-4.1.36.Final-linux-x86_64.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\netty\netty-transport-native-unix-common\4.1.36.Final\netty-transport-native-unix-common-4.1.36.Final.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\glassfish\javax.el\3.0.0\javax.el-3.0.0.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\hibernate\validator\hibernate-validator\6.0.17.Final\hibernate-validator-6.0.17.Final.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\javax\validation\validation-api\2.0.1.Final\validation-api-2.0.1.Final.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\jboss\logging\jboss-logging\3.3.2.Final\jboss-logging-3.3.2.Final.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\com\fasterxml\classmate\1.4.0\classmate-1.4.0.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\spring-web\5.1.8.RELEASE\spring-web-5.1.8.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\spring-webflux\5.1.8.RELEASE\spring-webflux-5.1.8.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\synchronoss\cloud\nio-multipart-parser\1.1.0\nio-multipart-parser-1.1.0.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\synchronoss\cloud\nio-stream-storage\1.1.3\nio-stream-storage-1.1.3.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\mybatis\spring\boot\mybatis-spring-boot-starter\2.0.1\mybatis-spring-boot-starter-2.0.1.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\mybatis\spring\boot\mybatis-spring-boot-autoconfigure\2.0.1\mybatis-spring-boot-autoconfigure-2.0.1.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\mybatis\mybatis\3.5.1\mybatis-3.5.1.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\mybatis\mybatis-spring\2.0.1\mybatis-spring-2.0.1.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\mysql\mysql-connector-java\8.0.16\mysql-connector-java-8.0.16.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\spring-core\5.1.8.RELEASE\spring-core-5.1.8.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\spring-jcl\5.1.8.RELEASE\spring-jcl-5.1.8.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\projectreactor\reactor-core\3.2.10.RELEASE\reactor-core-3.2.10.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\reactivestreams\reactive-streams\1.0.2\reactive-streams-1.0.2.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\boot\spring-boot-starter-actuator\2.1.6.RELEASE\spring-boot-starter-actuator-2.1.6.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\boot\spring-boot-actuator-autoconfigure\2.1.6.RELEASE\spring-boot-actuator-autoconfigure-2.1.6.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\springframework\boot\spring-boot-actuator\2.1.6.RELEASE\spring-boot-actuator-2.1.6.RELEASE.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\io\micrometer\micrometer-core\1.1.5\micrometer-core-1.1.5.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\hdrhistogram\HdrHistogram\2.1.9\HdrHistogram-2.1.9.jar;D:\Program Files\apache-maven-3.5.3\maven-repository\org\latencyutils\LatencyUtils\2.0.3\LatencyUtils-2.0.3.jar" com.example.demo.DemoApplication

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::        (v2.1.6.RELEASE)

2019-07-12 11:34:20.557  INFO 16272 --- [           main] com.example.demo.DemoApplication         : Starting DemoApplication on PC201606261756 with PID 16272 (started by Administrator in E:\java项目文件\sbm)
2019-07-12 11:34:20.560  INFO 16272 --- [           main] com.example.demo.DemoApplication         : The following profiles are active: dev
2019-07-12 11:34:21.594  INFO 16272 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$61d3af52] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-07-12 11:34:22.015  WARN 16272 --- [           main] ion$DefaultTemplateResolverConfiguration : Cannot find template location: classpath:/templates/ (please add some templates or check your Thymeleaf configuration)
2019-07-12 11:34:22.348  INFO 16272 --- [           main] o.s.b.a.e.web.EndpointLinksResolver      : Exposing 2 endpoint(s) beneath base path '/actuator'
2019-07-12 11:34:22.625  WARN 16272 --- [           main] o.s.b.a.f.FreeMarkerAutoConfiguration    : Cannot find template location(s): [classpath:/templates/] (please add some templates, check your FreeMarker configuration, or set spring.freemarker.checkTemplateLocation=false)
2019-07-12 11:34:22.923  INFO 16272 --- [           main] o.s.b.web.embedded.netty.NettyWebServer  : Netty started on port(s): 8080
2019-07-12 11:34:22.928  INFO 16272 --- [           main] com.example.demo.DemoApplication         : Started DemoApplication in 2.765 seconds (JVM running for 3.401)
2019-07-12 11:34:23.101  INFO 16272 --- [1)-192.168.1.17] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2019-07-12 11:34:23.221  INFO 16272 --- [1)-192.168.1.17] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2
2019-07-12 11:34:27.146 DEBUG 16272 --- [ctor-http-nio-3] c.e.demo.mapper.AdminMapper.findList     : ==>  Preparing: select admin_id,admin_name,admin_pwd,admin_permissions,admin_telephone,create_time,last_modify_time from admin WHERE admin_permissions !='0' and storeId = 0 and admin_permissions !=? order by last_modify_time desc 
2019-07-12 11:34:27.162 DEBUG 16272 --- [ctor-http-nio-3] c.e.demo.mapper.AdminMapper.findList     : ==> Parameters: 2(String)
2019-07-12 11:34:27.177 DEBUG 16272 --- [ctor-http-nio-3] c.e.demo.mapper.AdminMapper.findList     : <==      Total: 3

kelly921011

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SpringBoot整合Mybatis详细版

springboot+mybatis学习笔记。源码：https://github.com/kelly921011/sbm1.创建一个Spring Initializr项目2. 创建项目结构和jdk的版本3.当我点击NEXT时，却出现如图4所示的错误，这由于创建时因为Artifact的命名为大小写混合，将大写改为小写即可正常创建。4.接下来我们修改上面的错误，然后进...
复制链接

扫一扫