第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