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

RuoYi

2020-12-29 77ef2f201cebbeaeb10747e03484ecbc84e8e8c3

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

 src/main/java/com/ruoyi/common/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" };


 src/main/java/com/ruoyi/project/tool/gen/util/GenUtils.java

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

        // 设置java字段名

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

        // 设置默认类型

        column.setJavaType(GenConstants.TYPE_STRING);



        if (arraysContains(GenConstants.COLUMNTYPE_STR, dataType))

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

        {

            column.setJavaType(GenConstants.TYPE_STRING);

            // 字符串长度超过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))