2021-10-27

//config

package com.mszlu.union.config;

import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
@MapperScan(“com.mszlu.union.mapper”)
public class MybatisPlusPageConfig {

@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
    //分页插件
    MybatisPlusInterceptor mybatisPlusInterceptor=new MybatisPlusInterceptor();
    mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor());
    return mybatisPlusInterceptor;
}

}

//mapper

package com.mszlu.union.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.mszlu.union.pojo.User;
//BaseMapper<User>  会和user表进行关联
public interface UserMapper extends BaseMapper<User> {
}

//POJO

package com.mszlu.union.pojo;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

@Data
//@TableName("user")
//@TableName("tb_user") mybatis-plus.global-config.db-config.table-prefix=tb_
public class User {

    //字段

    private Long id;
//    @TableField("name") //数据库表的字段名称
    private String name;

//    private String userName; //默认会映射到user_name

    private Integer age;

    private String email;
}

//service

package com.mszlu.union.service;

import com.mszlu.union.mapper.UserMapper;
import com.mszlu.union.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserService {

    @Autowired
    private UserMapper userMapper;

//    public List<User> findAll(){
//        return
//    }
}

server.port=8888
spring.datasource.url=jdbc:mysql://localhost:3306/test02?useUnicode=true&characterEncoding=UTF-8&serverTimeZone=UTC
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#数据库 默认采用的数据源 HikariDataSource
spring.main.allow-circular-references=true
##数据库脚本初始化的配置


##mybatis-plus的配置
#mybatis-plus.global-config.db-config.table-prefix=tb_