springboot整合MP

配置文件

spring:
  datasource:
    #    驱动
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/wyt?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    password: root
    username: root

#控制台打印sql
mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

package com.wyt.demo.Config;

import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
public class MybatiasMpConfig {

    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }
}

package com.wyt.demo.Mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.wyt.demo.domain.User;

public interface UserMapper extends BaseMapper<User> {

}

package com.wyt.demo.domain;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import org.springframework.web.servlet.view.InternalResourceViewResolver;

@Data
@TableName(value = "users")
public class User {
    @TableId(value = "userid",type = IdType.AUTO)
    private Integer userid;
    private String username;
    private String usersex;

}