我在前端写Java SpringBoot项目( 四 ) _SpringBoot

配置数据库基础信息

// packages/node-server-demo/src/module/index.tsimport{Module }from'@nestjs/common';
import{UserModule }from'./user';
import{LogModule }from'./log';
import{Log }from'@/entities/Log';
import{SequelizeModule }from'@nestjs/sequelize';
@Module({
imports:[
SequelizeModule.forRoot({
dialect:'mysql',
// 按数据库实际配置
host:'127.0.0.1',
// 按数据库实际配置
port:3306,
// 按数据库实际配置
username:'root',
// 按数据库实际配置
password:'hello',
// 按数据库实际配置
database:'world',
synchronize:true,
models:[Log],
autoLoadModels:true,
}),
LogModule,
UserModule,
],
})
exportclassAppModule{}

实体与数据库一一映射处理

import{getNow }from'@/common/date';import{
Model,
Table,
Column,
PrimaryKey,
DataType,
}from'sequelize-type';
@Table({tableName:'test_sys_req_log'})
exportclassLogextendsModel<Log>{
@PrimaryKey
@Column({
type:DataType.INTEGER,
autoIncrement:true,
field:'id',
})
id:number;
@Column({field:'content',type:DataType.TEXT})
content:string;
@Column({field:'l_level',type:DataType.INTEGER})
level:number;// 3严重，2危险，1轻微
@Column({field:'l_category'})
category:string;// 模块分类/来源分类
@Column({
field:'l_created_at',
type:DataType.NOW,
defaultValue:getNow,
})
createdAt:number;
@Column({
field:'l_updated_at',
type:DataType.NOW,
defaultValue:getNow,
})
updatedAt:number;
}

module 注册实体

//packages/node-server-demo/src/module/log.tsimport{Module }from'@nestjs/common';
import{SequelizeModule }from'@nestjs/sequelize';
import{Log }from'@/entities/Log';
importLogServices,{
CreateLogService,
UpdateLogService,
DeleteLogService,
ReadLogService,
}from'@/service/log';
import{
CreateLogController,
RemoveLogController,
UpdateLogController,
}from'@/controller/log';
@Module({
imports:[SequelizeModule.forFeature([Log])],
providers:[
LogServices,
CreateLogService,
UpdateLogService,
DeleteLogService,
ReadLogService,
],
controllers:[CreateLogController,RemoveLogController,UpdateLogController],
})
exportclassLogModule{}

service 操作数据库处理数据

import{Log }from'@/entities/Log';import{Injectable }from'@nestjs/common';
import{AddLogDto }from'@/dto/log';
import{InjectModel }from'@nestjs/sequelize';
import{ResponseStatus }from'@/types/BaseResponse';
import{getErrRes,getSucVoidRes }from'@/common/response';
@Injectable
exportclassCreateLogService{
constructor(
@InjectModel(Log)
privatelogModel:typeofLog,
){}
asynccreate(createLogDto:AddLogDto):Promise<ResponseStatus<null>>{
console.info('CreateLogService create > ',createLogDto);
const{level =1,content ='',category ='INFO'}=createLogDto ||{};
conststr =content.trim;
if(!str){
returngetErrRes(500,'日志内容为空');
}
constitem ={
level,
category,
// Tips: 为防止外部数据进行数据注入，我们可以对内容进行 encode 处理。
// content: encodeURIComponent(str),
content:str,
};
awaitthis.logModel.create(item);
returngetSucVoidRes;
}
}
一路操作猛如虎，回头一看嘿嘿嘿～终于，我们收到了来自外界的第一条数据！ hello world！