前言
虽然mybatis已经有了代码生成,但是对于SpringBoot 项目来说生成的还是需要改动,而且也没得逻辑层,和控制层。但是这些东西是逃避不了,所以我就针对单表,做了一个代码生成器。
mybatis-dsc-generator
根据完善的数据库表结构,一键生成dao.java,mapper.xml,service.java,serviceImpl.java,controller.java,完成单表的增删改查、组合条件集合查询,组合条件分页查询。
源码地址
MAVEN地址
com.github.flying-cattle
mybatis-dsc-generator
1.0.0.RELEASE
数据表结构样式
CREATE TABLE `order` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`order_no` varchar(50) NOT NULL COMMENT '订单编号',
`uid` bigint(20) NOT NULL COMMENT '用户ID',
`source` varchar(50) NOT NULL COMMENT '来源',
`product_id` bigint(20) NOT NULL COMMENT '产品ID',
`product_name` varchar(100) NOT NULL COMMENT '产品名字',
`unit_price` int(10) unsigned NOT NULL COMMENT '单价',
`number` int(10) unsigned NOT NULL COMMENT '数量',
`selling_price` int(11) DEFAULT NULL COMMENT '卖价',
`state` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '0等待支付,1支付成功,2支付失败,3撤销',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '交易变化时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='订单信息';
要求必须有表注释,要求必须有主键为id,切为bigint,所有字段必须有注释(便于生成java注释)。
生成的实体类
生成的实体类
/**
* @filename:Order 2018年7月5日
* @project deal-center V1.0
* Copyright(c) 2018 BianP Co. Ltd.
* All right reserved.
*/
package com.xin.dealcenter.entity;
import java.io.Serializable;
import java.util.Date;
import org.springframework.format.annotation.DateTimeFormat;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.ToString;
import lombok.NoArgsConstructor;
import lombok.AllArgsConstructor;
/**
*
* @Description: 订单
* @Author: BianP
* @CreateDate: 2018年7月5日
* @Version: V1.0
*
*/
@Data
@ToString
@AllArgsConstructor
@NoArgsConstructor
public class Order implements Serializable {
private static final long serialVersionUID = 1531104207412L;
@ApiModelProperty(name = "id" , value = "ID")
private Long id;
@ApiModelProperty(name = "orderNo" , value = "订单编号")
private String orderNo;
@ApiModelProperty(name = "uid" , value = "用户ID")
private Long uid;
@ApiModelProperty(name = "source" , value = "来源")
private String source;
@ApiModelProperty(name = "productId" , value = "产品ID")
private Long productId;
@ApiModelProperty(name = "productName" , value = "产品名字")
private String productName;
@ApiModelProperty(name = "unitPrice" , value = "单价")
private Integer unitPrice;
@ApiModelProperty(name = "number" , value = "数量")
private Integer number;
@ApiModelProperty(name = "sellingPrice" , value = "卖价")
private Integer sellingPrice;
@ApiModelProperty(name = "state" , value = "0等待支付,1支付成功,2支付失败,3撤销")
private Integer state;
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
@JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
@ApiModelProperty(name = "createTime" , value =