springBoot+mybaties后端多层架构的实现示例

第springBoot+mybaties后端多层架构的实现示例artifactIdmybatis-plus-boot-starter/artifactId

version${mybatis-plus.version}/version

/dependency

dependency

groupIdmysql/groupId

artifactIdmysql-connector-java/artifactId

version8.0.28/version

/dependency

dependency

groupIdjectlombok/groupId

artifactIdlombok/artifactId

version1.18.4/version

scopeprovided/scope

/dependency

dependency

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-starter-web/artifactId

/dependency

dependency

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-starter-test/artifactId

scopetest/scope

/dependency

dependency

groupIdjectlombok/groupId

artifactIdlombok/artifactId

versionRELEASE/version

scopecompile/scope

/dependency

/dependencies

build

plugins

plugin

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-maven-plugin/artifactId

/plugin

/plugins

/build

/project

建立相关目录

说明:

各层名称说明补充controller与前端交互的接口部分service层业务逻辑主要写的地方mapper层mapper接口，对应mybatis的sql.xmlmapper.xml层在resource中，mybaites自动将数据返回给mapper层dao与数据库1v1对应的类，驼峰-》对应数据库的下划线

resource中的目录

idea下载安装插件

lombok

mybaits-tool（任意工具都可以plugin里很多，主要用于xml与mapper跳转）

配置mybais-config.xml

xmlversion="1.0"encoding="UTF-8"

!DOCTYPEconfiguration

PUBLIC"-////DTDConfig3.0//EN"

"/dtd/mybatis-3-config.dtd"

configuration

settings

settingname="mapUnderscoreToCamelCase"value="true"/

/settings

environmentsdefault="development"

environmentid="development"

transactionManagertype="JDBC"/

dataSourcetype="POOLED"

propertyname="driver"value="com.mysql.cj.jdbc.Driver"/

propertyname="url"value="jdbc:mysql://localhost:3306/testcharacterEncoding=utf-8amp;autoReconnect=trueamp;allowMultiQueries=true"/

propertyname="username"value="root"/

propertyname="password"value="123456"/

/dataSource

/environment

/environments

mappers

mapperresource="mapper/EtfHotMapper.xml"/

mapperresource="mapper/EtfTeachMapper.xml"/

mapperresource="mapper/TestEditorMapper.xml"/

mapperresource="mapper/TestClientMapper.xml"/

/mappers

/configuration

dao层案例:

packagecom.example.etf.story.dao;

importcom.alibaba.fastjson.JSON;

importcom.fasterxml.jackson.annotation.JsonFormat;

importlombok.Data;

importjava.util.Date;

@Data

publicclassTestStory{

privateintstoryId;

privateStringinitInfo;

privateStringstoryName;

privateStringstoryType;

privateintstatus;

privateStringcreater;

privateStringauditor;

@JsonFormat(pattern="yyyy-MM-ddhh:mm:ss")

privateDateupdateTime;

@JsonFormat(pattern="yyyy-MM-ddhh:mm:ss")

privateDatecreateTime;

}

数据库建表案例

附送他的建表语句:

SETNAMESutf8mb4;

SETFOREIGN_KEY_CHECKS=0;

--

--Tablestructurefortest_story

--

DROPTABLEIFEXISTS`test_story`;

CREATETABLE`test_story`(

`story_id`int(0)NOTNULLAUTO_INCREMENTCOMMENT'第一层id',

`init_info`jsonNOTNULLCOMMENT'初始信息',

`story_name`varchar(255)CHARACTERSETutf8mb4COLLATEutf8mb4_binNULLDEFAULTNULLCOMMENT'名称',

`story_type`varchar(255)CHARACTERSETutf8mb4COLLATEutf8mb4_binNULLDEFAULTNULLCOMMENT'属于种类，学习，游戏',

`status`int(0)NULLDEFAULTNULLCOMMENT'状态,0未发布，1未审核，2不通过，3审核通过，4失效',

`creator`varchar(255)CHARACTERSETutf8mb4COLLATEutf8mb4_binNULLDEFAULTNULLCOMMENT'作者',

`auditor`varchar(255)CHARACTERSETutf8mb4COLLATEutf8mb4_binNULLDEFAULTNULLCOMMENT'审核人',

`update_time`timestamp(0)NULLDEFAULTNULLCOMMENT'更新时间',

`create_time`timestamp(0)NULLDEFAULTNULLCOMMENT'创建时间',

PRIMARYKEY(`story_id`)USINGBTREE

)ENGINE=InnoDBAUTO_INCREMENT=4CHARACTERSET=utf8mb4COLLATE=utf8mb4_binROW_FORMAT=Dynamic;

SETFOREIGN_KEY_CHECKS=1;

Paramr案例

（前端字段交互部分）

例:入口（查询条件)

packagecom.example.etf.story.paramer;

importcom.fasterxml.jackson.annotation.JsonFormat;

importlombok.Data;

importjava.util.ArrayList;

importjava.util.List;

@Data

publicclassStorySelectParam{

privateintpageNum=1;

privateintpageSize=8;

@JsonFormat(pattern="yyyy-MM-ddhh:mm:ss")

privateListStringupdateTime;

@Json