CREATE TABLE "RKSJ_POPULATION_INFO" ( "ID" VARCHAR2(32 BYTE) NOT NULL , "BSRK" NUMBER(11) COMENT '用户名', "LRRK" NUMBER(11) , "LRRKZB" NUMBER(3,1) , "LRRKTB" CHAR(1 BYTE) , "LCRK" NUMBER(11) , "LCRKZB" NUMBER(3,1) , "LCRKTB" CHAR(1 BYTE) ); COMMENT ON COLUMN "RKSJ_POPULATION_INFO"."ID" IS '主表唯一标示'; COMMENT ON COLUMN "RKSJ_POPULATION_INFO"."BSRK" IS '本市人口'; COMMENT ON COLUMN "RKSJ_POPULATION_INFO"."LRRK" IS '流入人口'; COMMENT ON COLUMN "RKSJ_POPULATION_INFO"."LRRKZB" IS '流入人口占比'; COMMENT ON COLUMN "RKSJ_POPULATION_INFO"."LRRKTB" IS '流入人口同比增长还是下降（0:下降 1:增长）'; COMMENT ON COLUMN "RKSJ_POPULATION_INFO"."LCRK" IS '流出人口'; COMMENT ON COLUMN "RKSJ_POPULATION_INFO"."LCRKZB" IS '流出人口占比'; COMMENT ON COLUMN "RKSJ_POPULATION_INFO"."LCRKTB" IS '流出人口同比增长还是下降（0:下降 1:增长）';

看了下源码，发现只是单纯的对ddl做了字符串的解析，既然是这种实现方式的话，其实完全可以用纯正则来处理了，而且甚至还可以用 js+html+一些js模板引擎 来实现一个纯静态页面的版本。贡献一下我的正则吧，供作者参考。

    //匹配整个ddl，将ddl分为表名，列sql部分，表注释
    private static final Pattern DDL_PATTERN = Pattern.compile("\\s*create\\s+table\\s+(?<tableName>\\S+)[^\\(]*\\((?<columnsSQL>[\\s\\S]+)\\)[^\\)]+?(comment\\s*(=|on\\s+table)\\s*'(?<tableComment>.*?)'\\s*;?)?$", Pattern.CASE_INSENSITIVE);
    //匹配列sql部分，分别解析每一列的列名 类型 和列注释
    private static final Pattern COL_PATTERN = Pattern.compile("\\s*(?<fieldName>\\S+)\\s+(?<fieldType>\\w+)\\s*(?:\\([\\s\\d,]+\\))?((?!comment).)*(comment\\s*'(?<fieldComment>.*?)')?\\s*(,|$)", Pattern.CASE_INSENSITIVE);

    public static void parse(String sql){
        Matcher matcher = DDL_PATTERN.matcher(sql);
        if (matcher.find()){
            String tableName = matcher.group("tableName");
            String tableComment = matcher.group("tableComment");
            System.out.println(tableName + "\t\t" + tableComment);
            System.out.println("==========");
            String columnsSQL = matcher.group("columnsSQL");
            if (columnsSQL != null && columnsSQL.length() > 0){
                Matcher colMatcher = COL_PATTERN.matcher(columnsSQL);
                while (colMatcher.find()){
                    String fieldName = colMatcher.group("fieldName");
                    String fieldType = colMatcher.group("fieldType");
                    String fieldComment = colMatcher.group("fieldComment");
                    if (!"key".equalsIgnoreCase(fieldType)){
                        System.out.println(fieldName + "\t\t" + fieldType + "\t\t" + fieldComment);
                    }
                }
            }
        }
    }

    public static void main(String[] args){
        System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>");
        parse("CREATE TABLE `userinfo` (\n" +
                "  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',\n" +
                "  `username` varchar(255) NOT NULL COMMENT '用户名',\n" +
                "  `addtime` datetime NOT NULL COMMENT '创建时间',\n" +
                "  PRIMARY KEY (`user_id`)\n" +
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户信息'");
        System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>");
        parse("CREATE TABLE `USER` (\n" +
                "`ID` varchar(32) PRIMARY KEY COMMENT '主键',\n" +
                "`password` varchar(32) NOT NULL COMMENT '密码',\n" +
                "`username` varchar(32) NOT NULL COMMENT '用户'\n" +
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8;");
        System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>");
        parse("CREATE TABLE `tb_amount` (\n" +
                "`ID` int(10) NOT NULL AUTO_INCREMENT,\n" +
                "`PRODUCT_CODE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '产品代码',\n" +
                "`GENDER` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别(male,female)',\n" +
                "`MIN_INSURED_AGE` int(3) NULL DEFAULT NULL COMMENT '最小投保年龄',\n" +
                "`MAX_INSURED_AGE` int(3) NULL DEFAULT NULL COMMENT '最大投保年龄',\n" +
                "`AMOUNT` double(10, 2) NULL DEFAULT NULL COMMENT '基本保额',\n" +
                "`PREMIUM_RATE` double(10, 2) NULL DEFAULT NULL COMMENT '基本保费',\n" +
                "`YEAR_NUM` int(3) NULL DEFAULT NULL COMMENT '缴费年限',\n" +
                "`PREMIUM_TYPE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '费率类型',\n" +
                "`INSURANCE_PERIOD` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '保险期间(30年，60年)',\n" +
                "`INSURANCE_PERIOD_TYPE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '保险期间类型(如定期年0,定期岁1,终身2,以后终身对应值：200)',\n" +
                "`PAY_MODE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '交费方式',\n" +
                "PRIMARY KEY (`ID`) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;");
    }

输出内容：

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
`userinfo`		用户信息
==========
`user_id`		int		用户ID
`username`		varchar		用户名
`addtime`		datetime		创建时间
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
`USER`		null
==========
`ID`		varchar		主键
`password`		varchar		密码
`username`		varchar		用户
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
`tb_amount`		null
==========
`ID`		int		null
`PRODUCT_CODE`		varchar		产品代码
`GENDER`		varchar		性别(male,female)
`MIN_INSURED_AGE`		int		最小投保年龄
`MAX_INSURED_AGE`		int		最大投保年龄
`AMOUNT`		double		基本保额
`PREMIUM_RATE`		double		基本保费
`YEAR_NUM`		int		缴费年限
`PREMIUM_TYPE`		varchar		费率类型
`INSURANCE_PERIOD`		varchar		保险期间(30年，60年)
`INSURANCE_PERIOD_TYPE`		varchar		保险期间类型(如定期年0,定期岁1,终身2,以后终身对应值：200)
`PAY_MODE`		varchar		交费方式

CREATE TABLE 'lab_model_evaluation' ( 'id' int(11) NOT NULL AUTO_INCREMENT, 'advertiser' varchar(50) DEFAULT NULL, 'model' varchar(50) DEFAULT NULL, 'model_type' varchar(50) DEFAULT NULL, 'removed' tinyint(1) DEFAULT NULL, 'creation' datetime DEFAULT NULL, 'last_modified' datetime DEFAULT NULL, 'version' int(11) DEFAULT NULL, 'index_sign' tinyint(1) NOT NULL DEFAULT 0, 'index_name' varchar(20) DEFAULT NULL, 'index_value' float DEFAULT NULL, 'index_placeholder1' varchar(20) DEFAULT NULL, 'figure_sign' tinyint(1) NOT NULL DEFAULT 0, 'figure_name' varchar(20) DEFAULT NULL, 'figure_series' varchar(20) DEFAULT NULL, 'figure_type' varchar(20) DEFAULT NULL, 'figure_is_x_float' tinyint(1) DEFAULT NULL, 'figure_x' varchar(20) DEFAULT NULL, 'figure_y' float DEFAULT NULL, 'figure_xname' varchar(20) DEFAULT NULL, 'figure_yname' varchar(20) DEFAULT NULL, 'figure_placeholder1' varchar(20) DEFAULT NULL, 'figure_placeholder2' varchar(20) DEFAULT NULL, 'feature_sign' tinyint(1) NOT NULL DEFAULT 0, 'feature_name' varchar(100) DEFAULT NULL, 'feature_is_positive' tinyint(1) DEFAULT NULL, 'feature_importance' float DEFAULT NULL, 'feature_shap' float DEFAULT NULL, 'feature_shuffle' float DEFAULT NULL, 'feature_lost' float DEFAULT NULL, 'feature_bs' float DEFAULT NULL, 'feature_placeholder1' varchar(20) DEFAULT NULL, 'feature_placeholder2' varchar(20) DEFAULT NULL, PRIMARY KEY ('id') ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

1.正则表达式的点号前面应该加上两个反斜杠，否则会认为是任意字符。 该BUG导致我的.ID和.ROAD_ID的备注发生覆盖

Matcher columnCommentMatcher = Pattern.compile("\\."+columnName+" is `").matcher(tableSql); // "\{(.*?)\}"

2.处理字段类型的时候，不严谨 columnLine.contains(" int") 类似这种的，可在前后适当加一些空格之类的加以区分，否则当我的字段包含这些字符的时候，产生类型判断问题。

3.建议对number类型增加int，long，BigDecimal的区分判断 以下是我自己加的：

else if (columnLine.contains("decimal")||columnLine.contains("number")) {
                    	//如果startKh大于等于0，则表示有设置取值范围
                    	int startKh=columnLine.indexOf("(");
                    	if(startKh>=0){
                    		int endKh=columnLine.indexOf(")",startKh);
                    		String[] fanwei=columnLine.substring(startKh+1,endKh).split("，");
                    		if("0".equals(fanwei[1])){
                    			//如果没有小数位数
                    			int length=Integer.valueOf(fanwei[0]);
                    			if(length<=9){
                    				fieldClass = Integer.class.getSimpleName();
                    			}else{
                    				fieldClass = Long.class.getSimpleName();
                    			}
                    		}else{
                    			//有小数位数一律使用BigDecimal
                    			fieldClass = BigDecimal.class.getSimpleName();
                    		}
                    	}else{
                    		fieldClass = BigDecimal.class.getSimpleName();
                    	}
                    }

1.mybatis-plus的代码为何Controller直接调用了Mapper?

那Service的代码 作用是什么?

2.Service 接口,为何没有实现类

3.我在Controller类中引入Service类 private final OmsOrderLogisticsService omsOrderLogisticsService;

启动时报错 Parameter 0 of constructor in com.macro.mall.controller.OmsOrderLogisticsController required a bean of type 'com.macro.mall.service.OmsOrderLogisticsService' that could not be found.

bejson 提交ddl会被宝塔网站防火墙拦截

{"tableSql":"CREATE TABLE growth_device (\n  id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',\n  device_id varchar(128) NOT NULL COMMENT '设备id',\n  identifier varchar(255) NOT NULL DEFAULT '' COMMENT '设备标识 oaid/idfa/idfv',\n  attribution_data varchar(4095) NOT NULL DEFAULT '' COMMENT '归因数据体',\n  app_version varchar(32) NOT NULL DEFAULT '' COMMENT 'app版本',\n  os varchar(32) NOT NULL DEFAULT '' COMMENT '手机系统 ios android',\n  created_at bigint(20) unsigned zerofill NOT NULL COMMENT '创建时间',\n  PRIMARY KEY (id);","options":{"dataType":"sql","authorName":"zhengkai.blog.csdn.net","packageName":"com.software.system","returnUtilSuccess":"ReturnT.success","returnUtilFailure":"ReturnT.error","isPackageType":true,"isSwagger":false,"isAutoImport":false,"isWithPackage":false,"isComment":true,"isLombok":true,"ignorePrefix":"sys_","tinyintTransType":"int","nameCaseType":"CamelCase","timeTransType":"Date"}}

这个语句生成的mybatis 缺少id 貌似是解析的时候都不会有id这个字段，所以所有的模板都不会有id字段

create table stu
(
    id      int auto_increment
        primary key,
    name    varchar(255) null,
    stu_num varchar(222) null,
    sex     varchar(255) null,
    id_num  varchar(33)  null,
    email   varchar(33)  null
);

生成的部分代码

<resultMap id="BaseResultMap" type="cn.edu.zucc.entity.Stu" >
    <result column="name" property="name" />
    <result column="stu_num" property="stuNum" />
    <result column="sex" property="sex" />
    <result column="id_num" property="idNum" />
    <result column="email" property="email" />
</resultMap>

<sql id="Base_Column_List">
            name,
            stu_num,
            sex,
            id_num,
            email
</sql>

https://blog.csdn.net/beidaol/article/details/85061472 Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String 是由于 'create_time' datetime NOT NULL COMMENT '创建时间', 在mybatis mapper中进行了 create_time = #{createTime} 这样的判断。希望只对字符串进行为空判断，避免错误。

<if "null != amount and '' != amount"> #{amount}, 这个amount如果是Ingeger或者decimal类型 非空表达（'' != amount）不合适吧, 另外： <if "null != createTime and '' != createTime">#{createTime}, 把空字符串跟date类型对比会报错的