springboot-demo

在src\main\java\目录下创建packageorg.mjtabu等目录，可使用Easy code插件自动生成

<?xml version="1.0" encoding="UTF-8"?>

    4.0.0
    
        org.springframework.boot
        spring-boot-starter-parent
        2.6.2
         
    

    org.mjtabu
    springboot-demo
    1.0-SNAPSHOT
    springboot-demo
    Demo project for Spring Boot

    
    
        1.8
        2.6.2
        2.2.0
        1.7.21
    

    
        
            org.springframework.boot
            spring-boot-starter-web
        
        
            org.springframework.data
            spring-data-commons
        
        
            org.springframework.boot
            spring-boot-autoconfigure
            ${springboot.version}
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
        
        
        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            ${mybatis.version}
        
        
        
            mysql
            mysql-connector-java
            runtime
        
        
        
            org.slf4j
            slf4j-api
            ${slf4j.version}
        
        
            org.slf4j
            slf4j-log4j12
            ${slf4j.version}
        
        
            org.projectlombok
            lombok
        
    

    
        
            
            
                org.springframework.boot
                spring-boot-maven-plugin
                ${springboot.version}
            
        
    

# 访问根路径
server.servlet.context-path=/springboot

# 应用名称
spring.application.name=springboot-demo

# 访问端口号
server.port=1234

# 编码格式
server.tomcat.uri-encoding=utf-8

# 数据库相关配置
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/information_schema?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2b8&nullCatalogMeansCurrent=true
spring.datasource.username=root
spring.datasource.password=123456

# session生命周期
server.servlet.session.timeout=30m

# mybatis Mapper路径配置
mybatis.mapper-locations=classpath:mapper/*.xml

# mybatis 实体路径配置
mybatis.type-aliases-package=org.mjtabu.entity

# 开启Mapper打印sql
logging.level.org.mjtabu.mapper=debug

<?xml version="1.0" encoding="UTF-8"?>

    
    logs
    
    
    
    
    
    
    

    
    
        
            ${log.colorPattern}
        
    

    
    
        
            ${log.path}/info/info.%d{yyyy-MM-dd}.log
            ${log.maxHistory}
        
        
            ${log.pattern}
        
        
            INFO
            ACCEPT
            DENY
        
    

    
    
        
            ${log.path}/error/error.%d{yyyy-MM-dd}.log
        
        
            ${log.pattern}
        
        
            ERROR
            ACCEPT
            DENY
        
    

    
    
        
    

    
    
        
        
    

package org.mjtabu.config;

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

/**
 * 启动配置类
 * ComponentScan：扫描路径，若不配置，则默认只扫描当前包
 * MapperScan：mapper扫描路径
 */
@SpringBootApplication()
@ComponentScan("org.mjtabu")
@MapperScan(value = "org.mjtabu.mapper")
public class SpringbootApplication {
    public static void main(String[] args) {
        SpringApplication.run(SpringbootApplication.class, args);
    }
}

package org.mjtabu.entity;

import java.util.Date;
import java.io.Serializable;

/**
 * (Tables)实体类
 *
 * @author makejava
 * @since 2021-12-30 14:32:29
 */
public class Tables implements Serializable {
    private static final long serialVersionUID = -49556619006096444L;
    
    private String tableCatalog;
    
    private String tableSchema;
    
    private String tableName;
    
    private String tableType;
    
    private String engine;
    
    private Long version;
    
    private String rowFormat;
    
    private Long tableRows;
    
    private Long avgRowLength;
    
    private Long dataLength;
    
    private Long maxDataLength;
    
    private Long indexLength;
    
    private Long dataFree;
    
    private Long autoIncrement;
    
    private Date createTime;
    
    private Date updateTime;
    
    private Date checkTime;
    
    private String tableCollation;
    
    private Long checksum;
    
    private String createOptions;
    
    private String tableComment;


    public String getTableCatalog() {
        return tableCatalog;
    }

    public void setTableCatalog(String tableCatalog) {
        this.tableCatalog = tableCatalog;
    }

    public String getTableSchema() {
        return tableSchema;
    }

    public void setTableSchema(String tableSchema) {
        this.tableSchema = tableSchema;
    }

    public String getTableName() {
        return tableName;
    }

    public void setTableName(String tableName) {
        this.tableName = tableName;
    }

    public String getTableType() {
        return tableType;
    }

    public void setTableType(String tableType) {
        this.tableType = tableType;
    }

    public String getEngine() {
        return engine;
    }

    public void setEngine(String engine) {
        this.engine = engine;
    }

    public Long getVersion() {
        return version;
    }

    public void setVersion(Long version) {
        this.version = version;
    }

    public String getRowFormat() {
        return rowFormat;
    }

    public void setRowFormat(String rowFormat) {
        this.rowFormat = rowFormat;
    }

    public Long getTableRows() {
        return tableRows;
    }

    public void setTableRows(Long tableRows) {
        this.tableRows = tableRows;
    }

    public Long getAvgRowLength() {
        return avgRowLength;
    }

    public void setAvgRowLength(Long avgRowLength) {
        this.avgRowLength = avgRowLength;
    }

    public Long getDataLength() {
        return dataLength;
    }

    public void setDataLength(Long dataLength) {
        this.dataLength = dataLength;
    }

    public Long getMaxDataLength() {
        return maxDataLength;
    }

    public void setMaxDataLength(Long maxDataLength) {
        this.maxDataLength = maxDataLength;
    }

    public Long getIndexLength() {
        return indexLength;
    }

    public void setIndexLength(Long indexLength) {
        this.indexLength = indexLength;
    }

    public Long getDataFree() {
        return dataFree;
    }

    public void setDataFree(Long dataFree) {
        this.dataFree = dataFree;
    }

    public Long getAutoIncrement() {
        return autoIncrement;
    }

    public void setAutoIncrement(Long autoIncrement) {
        this.autoIncrement = autoIncrement;
    }

    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    public Date getUpdateTime() {
        return updateTime;
    }

    public void setUpdateTime(Date updateTime) {
        this.updateTime = updateTime;
    }

    public Date getCheckTime() {
        return checkTime;
    }

    public void setCheckTime(Date checkTime) {
        this.checkTime = checkTime;
    }

    public String getTableCollation() {
        return tableCollation;
    }

    public void setTableCollation(String tableCollation) {
        this.tableCollation = tableCollation;
    }

    public Long getChecksum() {
        return checksum;
    }

    public void setChecksum(Long checksum) {
        this.checksum = checksum;
    }

    public String getCreateOptions() {
        return createOptions;
    }

    public void setCreateOptions(String createOptions) {
        this.createOptions = createOptions;
    }

    public String getTableComment() {
        return tableComment;
    }

    public void setTableComment(String tableComment) {
        this.tableComment = tableComment;
    }

}

package org.mjtabu.mapper;

import org.apache.ibatis.annotations.Param;
import org.mjtabu.entity.Tables;
import org.springframework.data.domain.Pageable;

import java.util.List;

/**
 * (Tables)表数据库访问层
 *
 * @author makejava
 * @since 2021-12-30 14:32:32
 */
public interface TablesMapper {

    /**
     * 通过数据库和数据库表查询单条数据
     *
     * @param tableSchema 数据库
     * @param tableName   数据库表
     * @return
     */
    Tables queryBySchemaAndTable(@Param("tableSchema") String tableSchema, @Param("tableName") String tableName);

    /**
     * 查询指定行数据
     *
     * @param tables   查询条件
     * @param pageable 分页对象
     * @return 对象列表
     */
    List queryAllByLimit(Tables tables, @Param("pageable") Pageable pageable);

    /**
     * 统计总行数
     *
     * @param tables 查询条件
     * @return 总行数
     */
    long count(Tables tables);

    /**
     * 新增数据
     *
     * @param tables 实例对象
     * @return 影响行数
     */
    int insert(Tables tables);

    /**
     * 批量新增数据（MyBatis原生foreach方法）
     *
     * @param entities List 实例对象列表
     * @return 影响行数
     */
    int insertBatch(@Param("entities") List entities);

    /**
     * 批量新增或按主键更新数据（MyBatis原生foreach方法）
     *
     * @param entities List 实例对象列表
     * @return 影响行数
     * @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常，请自行校验入参
     */
    int insertOrUpdateBatch(@Param("entities") List entities);

    /**
     * 修改数据
     *
     * @param tables 实例对象
     * @return 影响行数
     */
    int update(Tables tables);

    /**
     * 通过数据库和数据库表删除数据
     *
     * @param tableSchema 数据库
     * @param tableName   数据库表
     * @return 影响行数
     */
    int deleteBySchemaAndTable(@Param("tableSchema") String tableSchema, @Param("tableName") String tableName);

}

<?xml version="1.0" encoding="UTF-8"?>



    
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
    

    
    
        select TABLE_CATALOG,
               TABLE_SCHEMA,
               TABLE_NAME,
               TABLE_TYPE,
               ENGINE,
               VERSION,
               ROW_FORMAT,
               TABLE_ROWS,
               AVG_ROW_LENGTH,
               DATA_LENGTH,
               MAX_DATA_LENGTH,
               INDEX_LENGTH,
               DATA_FREE,
               AUTO_INCREMENT,
               CREATE_TIME,
               UPDATE_TIME,
               CHECK_TIME,
               TABLE_COLLATION,
               CHECKSUM,
               CREATE_OPTIONS,
               TABLE_COMMENT
        from TABLES
        where TABLE_SCHEMA = #{tableSchema}
          and TABLE_NAME = #{tableName}
    

    
    
        select
        TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE, VERSION, ROW_FORMAT, TABLE_ROWS, AVG_ROW_LENGTH,
        DATA_LENGTH, MAX_DATA_LENGTH, INDEX_LENGTH, DATA_FREE, AUTO_INCREMENT, CREATE_TIME, UPDATE_TIME, CHECK_TIME,
        TABLE_COLLATION, CHECKSUM, CREATE_OPTIONS, TABLE_COMMENT
        from TABLES
        
            
                and TABLE_CATALOG = #{tableCatalog}
            
            
                and TABLE_SCHEMA = #{tableSchema}
            
            
                and TABLE_NAME = #{tableName}
            
            
                and TABLE_TYPE = #{tableType}
            
            
                and ENGINE = #{engine}
            
            
                and VERSION = #{version}
            
            
                and ROW_FORMAT = #{rowFormat}
            
            
                and TABLE_ROWS = #{tableRows}
            
            
                and AVG_ROW_LENGTH = #{avgRowLength}
            
            
                and DATA_LENGTH = #{dataLength}
            
            
                and MAX_DATA_LENGTH = #{maxDataLength}
            
            
                and INDEX_LENGTH = #{indexLength}
            
            
                and DATA_FREE = #{dataFree}
            
            
                and AUTO_INCREMENT = #{autoIncrement}
            
            
                and CREATE_TIME = #{createTime}
            
            
                and UPDATE_TIME = #{updateTime}
            
            
                and CHECK_TIME = #{checkTime}
            
            
                and TABLE_COLLATION = #{tableCollation}
            
            
                and CHECKSUM = #{checksum}
            
            
                and CREATE_OPTIONS = #{createOptions}
            
            
                and TABLE_COMMENT = #{tableComment}
            
        
        limit #{pageable.offset}, #{pageable.pageSize}
    

    
    
        select count(1)
        from TABLES
        
            
                and TABLE_CATALOG = #{tableCatalog}
            
            
                and TABLE_SCHEMA = #{tableSchema}
            
            
                and TABLE_NAME = #{tableName}
            
            
                and TABLE_TYPE = #{tableType}
            
            
                and ENGINE = #{engine}
            
            
                and VERSION = #{version}
            
            
                and ROW_FORMAT = #{rowFormat}
            
            
                and TABLE_ROWS = #{tableRows}
            
            
                and AVG_ROW_LENGTH = #{avgRowLength}
            
            
                and DATA_LENGTH = #{dataLength}
            
            
                and MAX_DATA_LENGTH = #{maxDataLength}
            
            
                and INDEX_LENGTH = #{indexLength}
            
            
                and DATA_FREE = #{dataFree}
            
            
                and AUTO_INCREMENT = #{autoIncrement}
            
            
                and CREATE_TIME = #{createTime}
            
            
                and UPDATE_TIME = #{updateTime}
            
            
                and CHECK_TIME = #{checkTime}
            
            
                and TABLE_COLLATION = #{tableCollation}
            
            
                and CHECKSUM = #{checksum}
            
            
                and CREATE_OPTIONS = #{createOptions}
            
            
                and TABLE_COMMENT = #{tableComment}
            
        
    

    
    
        insert into TABLES(TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE, VERSION, ROW_FORMAT, TABLE_ROWS,
                           AVG_ROW_LENGTH, DATA_LENGTH, MAX_DATA_LENGTH, INDEX_LENGTH, DATA_FREE, AUTO_INCREMENT,
                           CREATE_TIME, UPDATE_TIME, CHECK_TIME, TABLE_COLLATION, CHECKSUM, CREATE_OPTIONS,
                           TABLE_COMMENT)
        values (#{tableCatalog}, #{tableSchema}, #{tableName}, #{tableType}, #{engine}, #{version}, #{rowFormat},
                #{tableRows}, #{avgRowLength}, #{dataLength}, #{maxDataLength}, #{indexLength}, #{dataFree},
                #{autoIncrement}, #{createTime}, #{updateTime}, #{checkTime}, #{tableCollation}, #{checksum},
                #{createOptions}, #{tableComment})
    

    
        insert into TABLES(TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE, VERSION, ROW_FORMAT, TABLE_ROWS,
        AVG_ROW_LENGTH, DATA_LENGTH, MAX_DATA_LENGTH, INDEX_LENGTH, DATA_FREE, AUTO_INCREMENT, CREATE_TIME, UPDATE_TIME,
        CHECK_TIME, TABLE_COLLATION, CHECKSUM, CREATE_OPTIONS, TABLE_COMMENT)
        values
        
            (#{entity.tableCatalog}, #{entity.tableSchema}, #{entity.tableName}, #{entity.tableType}, #{entity.engine},
            #{entity.version}, #{entity.rowFormat}, #{entity.tableRows}, #{entity.avgRowLength}, #{entity.dataLength},
            #{entity.maxDataLength}, #{entity.indexLength}, #{entity.dataFree}, #{entity.autoIncrement},
            #{entity.createTime}, #{entity.updateTime}, #{entity.checkTime}, #{entity.tableCollation},
            #{entity.checksum}, #{entity.createOptions}, #{entity.tableComment})
        
    

    
        insert into TABLES(TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE, VERSION, ROW_FORMAT, TABLE_ROWS,
        AVG_ROW_LENGTH, DATA_LENGTH, MAX_DATA_LENGTH, INDEX_LENGTH, DATA_FREE, AUTO_INCREMENT, CREATE_TIME, UPDATE_TIME,
        CHECK_TIME, TABLE_COLLATION, CHECKSUM, CREATE_OPTIONS, TABLE_COMMENT)
        values
        
            (#{entity.tableCatalog}, #{entity.tableSchema}, #{entity.tableName}, #{entity.tableType}, #{entity.engine},
            #{entity.version}, #{entity.rowFormat}, #{entity.tableRows}, #{entity.avgRowLength}, #{entity.dataLength},
            #{entity.maxDataLength}, #{entity.indexLength}, #{entity.dataFree}, #{entity.autoIncrement},
            #{entity.createTime}, #{entity.updateTime}, #{entity.checkTime}, #{entity.tableCollation},
            #{entity.checksum}, #{entity.createOptions}, #{entity.tableComment})
        
        on duplicate key update
        TABLE_CATALOG = values(TABLE_CATALOG),
        TABLE_SCHEMA = values(TABLE_SCHEMA),
        TABLE_NAME = values(TABLE_NAME),
        TABLE_TYPE = values(TABLE_TYPE),
        ENGINE = values(ENGINE),
        VERSION = values(VERSION),
        ROW_FORMAT = values(ROW_FORMAT),
        TABLE_ROWS = values(TABLE_ROWS),
        AVG_ROW_LENGTH = values(AVG_ROW_LENGTH),
        DATA_LENGTH = values(DATA_LENGTH),
        MAX_DATA_LENGTH = values(MAX_DATA_LENGTH),
        INDEX_LENGTH = values(INDEX_LENGTH),
        DATA_FREE = values(DATA_FREE),
        AUTO_INCREMENT = values(AUTO_INCREMENT),
        CREATE_TIME = values(CREATE_TIME),
        UPDATE_TIME = values(UPDATE_TIME),
        CHECK_TIME = values(CHECK_TIME),
        TABLE_COLLATION = values(TABLE_COLLATION),
        CHECKSUM = values(CHECKSUM),
        CREATE_OPTIONS = values(CREATE_OPTIONS),
        TABLE_COMMENT = values(TABLE_COMMENT)
    

    
    
        update TABLES
        
            
                TABLE_CATALOG = #{tableCatalog},
            
            
                TABLE_SCHEMA = #{tableSchema},
            
            
                TABLE_NAME = #{tableName},
            
            
                TABLE_TYPE = #{tableType},
            
            
                ENGINE = #{engine},
            
            
                VERSION = #{version},
            
            
                ROW_FORMAT = #{rowFormat},
            
            
                TABLE_ROWS = #{tableRows},
            
            
                AVG_ROW_LENGTH = #{avgRowLength},
            
            
                DATA_LENGTH = #{dataLength},
            
            
                MAX_DATA_LENGTH = #{maxDataLength},
            
            
                INDEX_LENGTH = #{indexLength},
            
            
                DATA_FREE = #{dataFree},
            
            
                AUTO_INCREMENT = #{autoIncrement},
            
            
                CREATE_TIME = #{createTime},
            
            
                UPDATE_TIME = #{updateTime},
            
            
                CHECK_TIME = #{checkTime},
            
            
                TABLE_COLLATION = #{tableCollation},
            
            
                CHECKSUM = #{checksum},
            
            
                CREATE_OPTIONS = #{createOptions},
            
            
                TABLE_COMMENT = #{tableComment},
            
        
        where = #{}
    

    
    
        delete
        from TABLES
        where TABLE_SCHEMA = #{tableSchema}
          and TABLE_NAME = #{tableName}
    

package org.mjtabu.service;

import org.mjtabu.entity.Tables;
import org.mjtabu.mapper.TablesMapper;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageImpl;
import org.springframework.data.domain.PageRequest;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

/**
 * (Tables)表服务实现类
 *
 * @author makejava
 * @since 2021-12-30 14:32:33
 */
@Service("tablesService")
public class TablesService {
    @Resource
    private TablesMapper tablesMapper;

    /**
     * 通过数据库和数据库表查询单条数据
     *
     * @param tableSchema 数据库
     * @param tableName   数据库表
     * @return
     */
    public Tables queryBySchemaAndTable(String tableSchema, String tableName) {
        return tablesMapper.queryBySchemaAndTable(tableSchema, tableName);
    }

    /**
     * 分页查询
     *
     * @param tables      筛选条件
     * @param pageRequest 分页对象
     * @return 查询结果
     */
    public Page queryByPage(Tables tables, PageRequest pageRequest) {
        long total = tablesMapper.count(tables);
        return new PageImpl<>(tablesMapper.queryAllByLimit(tables, pageRequest), pageRequest, total);
    }

    /**
     * 新增数据
     *
     * @param tables 实例对象
     * @return 实例对象
     */
    public Tables insert(Tables tables) {
        tablesMapper.insert(tables);
        return tables;
    }

    /**
     * 修改数据
     *
     * @param tables 实例对象
     * @return 实例对象
     */
    public Tables update(Tables tables) {
        tablesMapper.update(tables);
        return tablesMapper.queryBySchemaAndTable(tables.getTableSchema(), tables.getTableName());
    }

    /**
     * 通过数据库和数据库表删除数据
     *
     * @param tableSchema 数据库
     * @param tableName   数据库表
     * @return 是否成功
     */
    public boolean deleteBySchemaAndTable(String tableSchema, String tableName) {
        return tablesMapper.deleteBySchemaAndTable(tableSchema, tableName) > 0;
    }
}

package org.mjtabu.controller;

import lombok.extern.slf4j.Slf4j;
import org.mjtabu.entity.Tables;
import org.mjtabu.service.TablesService;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

/**
 * (Tables)表控制层
 *
 * @author makejava
 * @since 2021-12-30 14:32:34
 */
@Slf4j
@RestController
@RequestMapping("tables")
public class TablesController {
    /**
     * 服务对象
     */
    @Resource
    private TablesService tablesService;

    /**
     * 分页查询
     *
     * @param tables      筛选条件
     * @param pageRequest 分页对象
     * @return 查询结果
     */
    @GetMapping
    public ResponseEntity> queryByPage(Tables tables, PageRequest pageRequest) {
        return ResponseEntity.ok(tablesService.queryByPage(tables, pageRequest));
    }

    /**
     * 通过数据库和数据库表查询单条数据
     *
     * @param tableSchema 数据库
     * @param tableName   数据库表
     * @return 单条数据
     */
    @GetMapping("/queryBySchemaAndTable/{tableSchema}/{tableName}")
    public ResponseEntity queryBySchemaAndTable(@PathVariable("tableSchema") String tableSchema, @PathVariable("tableName") String tableName) {
        log.info("tableSchema:"+tableSchema+"tableName:"+tableName);
        return ResponseEntity.ok(tablesService.queryBySchemaAndTable(tableSchema, tableName));
    }

    /**
     * 新增数据
     *
     * @param tables 实体
     * @return 新增结果
     */
    @PostMapping
    public ResponseEntity add(Tables tables) {
        return ResponseEntity.ok(tablesService.insert(tables));
    }

    /**
     * 编辑数据
     *
     * @param tables 实体
     * @return 编辑结果
     */
    @PutMapping
    public ResponseEntity edit(Tables tables) {
        return ResponseEntity.ok(tablesService.update(tables));
    }

    /**
     * 通过数据库和数据库表删除数据
     *
     * @param tableSchema 数据库
     * @param tableName   数据库表
     * @return 删除是否成功
     */
    @GetMapping("/deleteBySchemaAndTable/{tableSchema}/{tableName}")
    public ResponseEntity deleteBySchemaAndTable(@PathVariable("tableSchema") String tableSchema, @PathVariable("tableName") String tableName) {
        return ResponseEntity.ok(tablesService.deleteBySchemaAndTable(tableSchema, tableName));
    }

}

通过数据库和数据库表查询单条数据

http://{{ip_port}}/springboot/tables/queryBySchemaAndTable/information_schema/TABLES