Springboot设置

1. Springboot依赖

    初始化自带spring-boot-starter和spring-boot-starter-test, 共计7个依赖

     <!--lombook依赖-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <!--SpringWeb依赖-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--MySQL依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!--MyBatis依赖-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.0</version>
        </dependency>
        <!--Druid依赖-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.22</version>
        </dependency>

 

2. yml设置

server:
  port: 8080

spring:
  datasource:
    username: root                                  #1.改数据库登陆名,密码,数据库名
    password: 123456
    url: jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource

mybatis:
  mapper-locations: classpath:xml/*.xml             #2.前面的xml替换成放xml文件夹
  type-aliases-package: com.feicheng.demo.entity    #3.实体类的文件夹位置,xml的resultType可以不用全类名
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    lazy-loading-enabled: true
    map-underscore-to-camel-case: true

 

3. 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.feicheng.demo.mapper.BookMapper">

<!--    Book searchByISBN(String isbn);-->
    <select id="searchByISBN" parameterType="String" resultType="Book">
        select * from book where isbn = #{isbn}
    </select>

</mapper>