Springboot项目常用配置

Springboot项目常用配置

yml

server:
  port: 9090

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/db_crud?serverTimezone=GMT%2b8
    username: root
    password: password

mybatis:
  mapper-locations: classpath:mapper/*.xml
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

xml

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

    <select id="list" resultType="com.example.springboot.entity.Books">
        select *
        from sys_books;
    </select>

    <select id="selectPage" resultType="com.example.springboot.entity.User">
        select *
        from sys_books limit #{pageNum},#{pageSize};
    </select>

    <select id="selectTotal" resultType="java.lang.Integer">
        select count(*)
        from sys_books
    </select>


</mapper>

thymeleaf

#关闭thymeleaf模板缓存
spring:
  thymeleaf:
    cache: false
    prefix: classpath:/templates/ #指定模板位置
    suffix: .html #指定后缀名
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/ssmbuild?characterEncoding=UTF-8
    username: root
    password: password
  web:
    resources:
      static-locations: classpath:/static/,file:${photo.file.dir} #暴露哪些资源可以通过项目名访问

mybatis:
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: com.xuda.springboot.pojo
#Mybatis配置

#日志配置
logging:
  level:
    root: info
    com.xuda: debug

#指定文件上传的位置
photo:
  file:
    dir: D:\__easyProjects__\IntelliJ_IDEA\SpringBootStudy\photo