代码生成数据库文本类型生成表单文本域

RuoYi

2020-12-29 4cc0e2650c57cef6606e70c4c7c9198b98b7dc94

代码生成数据库文本类型生成表单文本域

 ruoyi-common/ruoyi-common-core/src/main/java/com/ruoyi/common/core/constant/GenConstants.java

@@ -29,8 +29,10 @@
    public static final String PARENT_MENU_NAME = "parentMenuName";



    /** 数据库字符串类型 */

    public static final String[] COLUMNTYPE_STR = { "char", "varchar", "nvarchar", "varchar2", "tinytext", "text",

            "mediumtext", "longtext" };

    public static final String[] COLUMNTYPE_STR = { "char", "varchar", "nvarchar", "varchar2" };



    /** 数据库文本类型 */

    public static final String[] COLUMNTYPE_TEXT = { "tinytext", "text", "mediumtext", "longtext" };



    /** 数据库时间类型 */

    public static final String[] COLUMNTYPE_TIME = { "datetime", "time", "date", "timestamp" };


 ruoyi-modules/ruoyi-gen/src/main/java/com/ruoyi/gen/util/GenUtils.java

@@ -40,13 +40,14 @@
        column.setCreateBy(table.getCreateBy());

        // 设置java字段名

        column.setJavaField(StringUtils.toCamelCase(columnName));



        if (arraysContains(GenConstants.COLUMNTYPE_STR, dataType))

        {

        // 设置默认类型

            column.setJavaType(GenConstants.TYPE_STRING);



        if (arraysContains(GenConstants.COLUMNTYPE_STR, dataType) || arraysContains(GenConstants.COLUMNTYPE_TEXT, dataType))

        {

            // 字符串长度超过500设置为文本域

            Integer columnLength = getColumnLength(column.getColumnType());

            String htmlType = columnLength >= 500 ? GenConstants.HTML_TEXTAREA : GenConstants.HTML_INPUT;

            String htmlType = columnLength >= 500 || arraysContains(GenConstants.COLUMNTYPE_TEXT, dataType) ? GenConstants.HTML_TEXTAREA : GenConstants.HTML_INPUT;

            column.setHtmlType(htmlType);

        }

        else if (arraysContains(GenConstants.COLUMNTYPE_TIME, dataType))