我们先来看下表结构:
实体类:
package com.elq.product.entity;
import com.alibaba.fastjson.annotation.JSONField;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;
import java.io.Serializable;
import java.util.Date;
@Data
@TableName("elq_logs")
public class LogsEntity implements Serializable {
//自动生成雪花ID
@TableId(value = "snow_id",type = IdType.ASSIGN_ID)
private String snowId;
//入参时间格式化,如果入参不是pattern="yyyy-MM-dd HH:mm:ss" 定义的类型会报错
@DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
//出参数格式化,pattern = "yyyy-MM-dd HH:mm:ss"
@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")//jackson注解
//@JSONField(format = "yyyy-MM-dd HH:mm:ss") //适用于Alibaba fastjson,可以直接在JSON.tostring时进行转义
private Date createTime;
private String data;
@DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
private Date updateTime;
}
控制器:
@RequestMapping("/inserts")
public String add(@RequestBody LogsEntity logsEntity){
String indexList = indexService.inserts(logsEntity);
return indexList;
}
service实现类:
@Override
public String inserts(LogsEntity logsEntity) {
Date createTime = logsEntity.getCreateTime();
int insert = this.baseMapper.insert(logsEntity);
return insert+"";
}
POSTman 测试:
存储结果: