spring-boot整合mybatis-plus_springboot atm-CSDN博客

本文链接：https://blog.csdn.net/weixin_51799151/article/details/122239261

一、创建一张数据库表

CREATE TABLE `user`(
	`id` INT(10) AUTO_INCREMENT PRIMARY KEY,
	`name` VARCHAR(30) NOT NULL,
	`age` INT(10) NOT NULL,
	`email` VARCHAR(50) NOT NULL
);

# 添加数据
INSERT INTO USER(NAME,age,email) VALUES
('Jone',18,'test1@taobao,com'),
('Jack',19,'test2@taobao.com'),
('Tom',28,'test3@baidu.com'),
('Sandy',21,'test4@alibaba.com'),
('Mae',24,'mae814@aliyun.com');

在这里插入图片描述

二、创建实体类User

/**
 * @author Mae
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
@TableName("user")
/**
* user 为表名
*/
public class User {
    public User(String username, String password) {
        this.username = username;
        this.password = password;
    }

    public User(int id, String name, int age, String email) {
        this.id = id;
        this.name = name;
        this.age = age;
        this.email = email;
    }

    /**
     * TableFiled false 说明此字段在数据库中不存在
     */
    @TableField(exist = false)
    private String username;
    @TableField(exist = false)
    private String password;

    private int id;
    private String name;
    private int age;
    private String email;

}

三、添加依赖

 <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.3.4</version>
        </dependency>

四、在application.yml 文件中添加数据库相关配置

数据源使用的是德鲁伊

spring:
  datasource:
    druid:
      # 监控页的配置
      stat-view-servlet:
        enabled: true
        login-username: admin
        login-password: 123456
        reset-enable: false
      # 监控web应用
      web-stat-filter:
        enabled: true
      #  url-pattern:
      #  exclusions:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://localhost:3306/book?characterEncoding=utf-8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true
      username: root
      password: 123456
      # 监控防火墙
      # proxy-filters: stat,wall,slf4j

五、在spring-boot启动类中添加注解

扫描 mapper 文件夹

/**
 * @author Mae
 */
@SpringBootApplication
@MapperScan("com.atmae.springboot_demo2.mapper")
public class SpringbootDemo2Application {

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

}

六、编写Mapper接口（userMapper）

/**
 * @author Mae
 */
public interface UserMapper extends BaseMapper<User> {
}

七、编写service层

1、userService接口

/**
 * @author Mae
 */
public interface UserService extends IService<User> {
}

2、其实现类

注意：一定要添加Service注解

/**
 * @author Mae
 */
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper,User> implements UserService {

}

八、编写Controller

/**
 * @author Mae
 */
@Controller
public class TestController {
    @Resource
    private UserService userService;

    @GetMapping("/test")
    public String testQuery(Model model){
        List<User> users=userService.list();
        model.addAttribute("users0",users);
        return "test";
    }
}

九、简单的测试页面(使用themleaf模板引擎)

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>Test</title>
</head>
<body>
<table>
    <thead>
    <tr>
        <th>#</th>
        <th>id</th>
        <th>name</th>
        <th>age</th>
        <th>email</th>
    </tr>
    </thead>
    <tbody>
    <tr th:each="user,stat:${users0}">
        <td th:text="${stat.count}">Trident</td>
        <td th:text="${user.id}">Trident</td>
        <td th:text="${user.name}"></td>
        <td th:text="${user.age}"></td>
        <td th:text="${user.email}"></td>
    </tr>
    </tbody>
</table>
</body>
</html>