JAVA SSM统一框架代码生成

Select Join SQL语句生成 mybatis Mapper代码
数据库类型?：	mysql
Select Join DML语句 ?：	select distinct count(o.id) as order_count,max(o.id) max_order_id,avg(o.pay_num) as avg_pay_num,o.order_no,u.name,u.code,d.contact_address,d.home_address,d.phone as dphone from ((t_user u left join t_address d on d.user_id=u.id) left join t_order as o on o.user_id=u.id) where o.order_no='abc001' and o.id >0 and o.user_id >1 and d.user_id=100 and u.id not in (1,2,3) and u.no between 10 and 100 and u.code like '%abc%' and u.create_time>'2022-01-04' and u.create_time<'2022-01-05' and o.user_id not in (select aa.id from t_user as aa where aa.id <=100) group by o.user_id having order_count>100 order by o.id desc limit 10,20; CREATE TABLE `t_city` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) DEFAULT NULL COMMENT '名称', `code` varchar(100) DEFAULT NULL COMMENT '编码', `parent_id` int(11) DEFAULT NULL COMMENT '父ID', `is_delete` tinyint(1) DEFAULT NULL COMMENT '是否删除 0否1是', `create_id` int(11) DEFAULT NULL COMMENT '创建人ID', `update_id` int(11) DEFAULT NULL COMMENT '修改人ID', `publish_time` datetime DEFAULT NULL COMMENT '发布时间', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`id`), KEY `idx_parent_id` (`parent_id`), UNIQUE KEY `idx_code` (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='城市表'; create table spider.t_brand ( id bigint auto_increment primary key, brand_id bigint null comment '品牌ID', brand_name varchar(64) null comment '品牌名称', brand_url varchar(128) null comment '品牌信息页面URL', create_time datetime default current_timestamp() null, update_time datetime default current_timestamp() null on update current_timestamp(), constraint t_car_brand_brand_id_uindex unique (brand_id) ) comment '品牌表'; CREATE TABLE "ORDER_OWLMP"."T_FIX_CODE" ("ID" NUMBER(14,0), "CODE_TYPE" NUMBER(11,0) NOT NULL ENABLE, "CODE" NUMBER(15,0) NOT NULL ENABLE, "CODE_NAME" VARCHAR2(100) NOT NULL ENABLE, "REMARK" VARCHAR2(4000) DEFAULT NULL, "CREATE_DATE" DATE, "CREATE_BY" NUMBER(14,0), "UPDATE_DATE" DATE, "UPDATE_BY" NUMBER(14,0), "PRIORITY" NUMBER(*,0) DEFAULT NULL, "EXTRA" BLOB, PRIMARY KEY ("ID") ) COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."ID" IS '主键【SEQ_T_FIX_CODE】' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."CODE_TYPE" IS '类型' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."CODE" IS '代码' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."CODE_NAME" IS '值' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."REMARK" IS '备注' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."CREATE_DATE" IS '创建时间' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."CREATE_BY" IS '创建人' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."UPDATE_DATE" IS '修改时间' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."UPDATE_BY" IS '修改人' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."PRIORITY" IS '优先级' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."EXTRA" IS '额外的字段' COMMENT ON TABLE "ORDER_OWLMP"."T_FIX_CODE" IS '数据字典配置表' CREATE TABLE public.t_address ( id integer NOT NULL DEFAULT nextval('t_address_id_seq'::regclass), name character varying(200) , code character varying(200) , is_delete smallint, create_time date, update_time date, CONSTRAINT t_address_pkey PRIMARY KEY (id) ) COMMENT ON TABLE public.t_address IS '地址表'; COMMENT ON COLUMN public.t_address.id IS '主键ID'; COMMENT ON COLUMN public.t_address.name IS '名称'; COMMENT ON COLUMN public.t_address.code IS '编码'; COMMENT ON COLUMN public.t_address.is_delete IS '是否删除 0否1是'; COMMENT ON COLUMN public.t_address.create_time IS '创建时间'; COMMENT ON COLUMN public.t_address.update_time IS '修改时间';
Select Join DDL语句 ?：	CREATE TABLE `t_user` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID', `name` varchar(100) DEFAULT NULL COMMENT '名称', `code` varchar(100) DEFAULT NULL COMMENT '编码', `no` int DEFAULT NULL COMMENT '序号', `is_delete` tinyint(1) DEFAULT NULL COMMENT '是否删除', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表'; CREATE TABLE `t_order` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID', `order_no` varchar(100) DEFAULT NULL COMMENT '订单编号', `order_code` varchar(100) DEFAULT NULL COMMENT '订单编码', `pay_num` int DEFAULT NULL COMMENT '支付金额', `user_id` int DEFAULT NULL COMMENT '用户ID', `is_delete` tinyint(1) DEFAULT NULL COMMENT '是否删除', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `idx_order_code` (`order_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单表'; CREATE TABLE `t_address` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID', `contact_address` varchar(100) DEFAULT NULL COMMENT '联系地址', `home_address` varchar(100) DEFAULT NULL COMMENT '家庭住址', `phone` varchar(200) DEFAULT NULL COMMENT '手机号', `user_id` int DEFAULT NULL COMMENT '用户ID', `is_delete` tinyint(1) DEFAULT NULL COMMENT '是否删除', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户地址表'; CREATE TABLE `t_city` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) DEFAULT NULL COMMENT '名称', `code` varchar(100) DEFAULT NULL COMMENT '编码', `parent_id` int(11) DEFAULT NULL COMMENT '父ID', `is_delete` tinyint(1) DEFAULT NULL COMMENT '是否删除 0否1是', `create_id` int(11) DEFAULT NULL COMMENT '创建人ID', `update_id` int(11) DEFAULT NULL COMMENT '修改人ID', `publish_time` datetime DEFAULT NULL COMMENT '发布时间', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`id`), KEY `idx_parent_id` (`parent_id`), UNIQUE KEY `idx_code` (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='城市表'; create table spider.t_brand ( id bigint auto_increment primary key, brand_id bigint null comment '品牌ID', brand_name varchar(64) null comment '品牌名称', brand_url varchar(128) null comment '品牌信息页面URL', create_time datetime default current_timestamp() null, update_time datetime default current_timestamp() null on update current_timestamp(), constraint t_car_brand_brand_id_uindex unique (brand_id) ) comment '品牌表'; CREATE TABLE "ORDER_OWLMP"."T_FIX_CODE" ("ID" NUMBER(14,0), "CODE_TYPE" NUMBER(11,0) NOT NULL ENABLE, "CODE" NUMBER(15,0) NOT NULL ENABLE, "CODE_NAME" VARCHAR2(100) NOT NULL ENABLE, "REMARK" VARCHAR2(4000) DEFAULT NULL, "CREATE_DATE" DATE, "CREATE_BY" NUMBER(14,0), "UPDATE_DATE" DATE, "UPDATE_BY" NUMBER(14,0), "PRIORITY" NUMBER(*,0) DEFAULT NULL, "EXTRA" BLOB, PRIMARY KEY ("ID") ) COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."ID" IS '主键【SEQ_T_FIX_CODE】' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."CODE_TYPE" IS '类型' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."CODE" IS '代码' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."CODE_NAME" IS '值' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."REMARK" IS '备注' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."CREATE_DATE" IS '创建时间' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."CREATE_BY" IS '创建人' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."UPDATE_DATE" IS '修改时间' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."UPDATE_BY" IS '修改人' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."PRIORITY" IS '优先级' COMMENT ON COLUMN "ORDER_OWLMP"."T_FIX_CODE"."EXTRA" IS '额外的字段' COMMENT ON TABLE "ORDER_OWLMP"."T_FIX_CODE" IS '数据字典配置表' CREATE TABLE public.t_address ( id integer NOT NULL DEFAULT nextval('t_address_id_seq'::regclass), name character varying(200) , code character varying(200) , is_delete smallint, create_time date, update_time date, CONSTRAINT t_address_pkey PRIMARY KEY (id) ) COMMENT ON TABLE public.t_address IS '地址表'; COMMENT ON COLUMN public.t_address.id IS '主键ID'; COMMENT ON COLUMN public.t_address.name IS '名称'; COMMENT ON COLUMN public.t_address.code IS '编码'; COMMENT ON COLUMN public.t_address.is_delete IS '是否删除 0否1是'; COMMENT ON COLUMN public.t_address.create_time IS '创建时间'; COMMENT ON COLUMN public.t_address.update_time IS '修改时间';

Mapper包类名：? ResultMap包类名：? Query包类名：?
项目类型 ?：	单体项目模块化项目	集成spring-data-redis?:	是否
api模块名： common模块名： service模块名： web模块名：
数据库连接池?：	dbcp dbcp2 c3p0 druid	mysql版本?：	小于5.6 5.6 5.7 8
生成物理删除方法?：	是否	默认生成like查询?:	是否
SQL语句后追加逻辑未删除值?:	追加不追加	逻辑删除value?:	否是
domain类后缀名?:	DO PO Entity	DTO类后缀名?:	DTO TO BO
生成spring cloud feign层代码?:	是否	spring cloud feign层返回值?:	DTO类 domain类
controller层URL后缀?:	无 do action jsp	是否预览源代码?:	预览源码及生成zip压缩包
mybatis数据层实现方式?:	纯Mapper接口 dao接口及其实现类	服务层后缀名?:	Service Manager
数据层insert\|update方法实现方式?:	继承BaseMapper sqlmap.xml文件中生成	前端页面类型?:	bootstrap4
dao包名：		dao实现类包名：
service层包名：		service实现层包名：
cache dao包名：		cache dao实现类包名：
domain包名?:		query包名?:
VO包名?:		DTO包名?:
spring cloud feign客户端包名：		spring cloud feign服务端包名：
管理后台controller包名?:		APP Controller包名?:
管理后台controller 类名前缀?:		管理后台controller URL前缀?:
spring boot application包名?:		spring boot config包名?:
exception包名：		常量包名：
自定义validator包名：		util包名：
逻辑删除字段名?:		状态字段名?:
表中父ID字段名?:
创建时间字段名?:
修改时间字段名?:
创建人ID字段名?:
修改人ID字段名?:
JAVA类版权信息?:	/* * Copyright 2011-2021 XXX信息科技有限公司 * * http://www.xxx.com * */