从零创建SpringBoot项目

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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <!--SpringBoot依赖-->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.3.4.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>

    <groupId>com.mybatis</groupId> <!--包名-->
    <artifactId>mybatis</artifactId> <!--项目名-->
    <version>0.0.1-SNAPSHOT</version>
    <name>mybatis</name> <!--项目昵称-->
    <description>Demo project for Spring Boot</description> <!--简介-->

    <properties>
        <java.version>8</java.version> <!--java版本-->
    </properties>

    <dependencies>
        <!--thymeleaf 组件-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <!--web 组件-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--mybatis依赖-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>
        <!--mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <!--lombok-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <!--test组件-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <!-- validation组件 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-validation</artifactId>
        </dependency>
        <!--spring data redis 依赖-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-redis</artifactId>
        </dependency>
        <!-- AMQP依赖 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-amqp</artifactId>
        </dependency>
    </dependencies>

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

</project>

按照pom.xml包名创建

• [src]
  • [main]
    • [java]
      • [com.mybatis]
        • [controller]
          • [IndexController.java]
        • [dao]
          • [IndexDao.java]
        • [pojo]
          • [Book.java]
        • [service]
          • [impl]
            • [IndexServiceImpl.java]
          • [IndexService.java]
        • [MybatisApplication.java]
    • [resource]
      • [mappers]
        • [IndexMapper.xml]
      • [application.yml]
• [pom.xml]

application.yml

1. 修改mappers文件目录
2. 修改Mybatis的实体目录

server:
  #应用端口
  port: 8080
spring:
  # 应用名称
  application:
    name: mybatis
  #MySql
  datasource:
    name: localhost_mysql #数据源名称
    driver-class-name: com.mysql.cj.jdbc.Driver #数据库驱动
    url: jdbc:mysql://localhost:3306/mybatis?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC #数据库连接地址
    username: root #用户名
    password: 123456 #密码

#MyBatis映射
mybatis:
  mapper-locations: classpath:mappers/*.xml #指定Mybatis的Mapper文件
  type-aliases-package: com.example.mybatis.pojo #指定Mybatis的实体目录

IndexController.java

package com.example.mybatis.controller;

import com.example.mybatis.pojo.Book;
import com.example.mybatis.service.IndexService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@CrossOrigin
@RestController
@RequestMapping("/index")
public class IndexController {

    @Autowired
    private IndexService indexService;

    //查询电子书
    @RequestMapping("/bookAll")
    public List<Book> bookAll(Book book) {
        return indexService.bookAll(book);
    }

}

IndexService.java

package com.example.mybatis.service;

import com.example.mybatis.pojo.Book;
import java.util.List;

public interface IndexService {
    List<Book> bookAll(Book book);
}

IndexServiceImpl.java

package com.example.mybatis.service.impl;

import com.example.mybatis.dao.IndexDao;
import com.example.mybatis.pojo.Book;
import com.example.mybatis.service.IndexService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;

@Service
public class IndexServiceImpl implements IndexService {

    @Autowired
    private IndexDao indexDao;

    public List<Book> bookAll(Book book) {
        return indexDao.bookAll(book);
    }

}

IndexDao.java

package com.example.mybatis.dao;

import com.example.mybatis.pojo.Book;
import org.springframework.stereotype.Repository;
import java.util.List;

@Repository
public interface IndexDao {
    List<Book> bookAll(Book book);
}

Book.java

package com.example.mybatis.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.util.Date;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Book {
    public Integer id;
    public String name;
}

MybatisApplication.java

package com.example.mybatis;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan(basePackages = "com.example.mybatis.dao")
public class MybatisApplication {
    public static void main(String[] args) {
        SpringApplication.run(MybatisApplication.class, args);
    }
}

IndexMapper.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.mybatis.dao.IndexDao">
    <!--查询电子书-->
    <select id="bookAll" parameterType="Book" resultType="Book">
        SELECT * FROM book
    </select>
</mapper>