mysql ddl 无法同时支持 datetime，timestamp 2种数据类型，因为在做映射时被反映射成同一类，如下图

![输入图片说明](https://images.gitee.com/uploads/images/2022/0308/192810_27323ff0_9706883.png "屏幕截图.png")
![输入图片说明](https://images.gitee.com/uploads/images/2022/0308/192839_a3d3a3a9_9706883.png "屏幕截图.png")

![输入图片说明](https://images.gitee.com/uploads/images/2022/0308/193323_27291765_9706883.png "屏幕截图.png")

columnDefination  为：mysql  数据类型  datatime 会报 throw new DialectException("'" + columnDef + "' can not be map to a dialect type"); 哪怕 映射成 TIMESTAMP  也好

public static Type colDef2DialectType(String columnDefination) {
		String columnDef = StrUtils.substringBefore(columnDefination, "(");
		if (BIGINT.equalsIgnoreCase(columnDef))
			return Type.BIGINT;
		if (BINARY.equalsIgnoreCase(columnDef))
			return Type.BINARY;
		if (BIT.equalsIgnoreCase(columnDef))
			return Type.BIT;
		if (BLOB.equalsIgnoreCase(columnDef))
			return Type.BLOB;
		if (BOOLEAN.equalsIgnoreCase(columnDef))
			return Type.BOOLEAN;
		if (CHAR.equalsIgnoreCase(columnDef))
			return Type.CHAR;
		if (CLOB.equalsIgnoreCase(columnDef))
			return Type.CLOB;
		if (DATE.equalsIgnoreCase(columnDef))
			return Type.DATE;
		if (DECIMAL.equalsIgnoreCase(columnDef))
			return Type.DECIMAL;
		if (DOUBLE.equalsIgnoreCase(columnDef))
			return Type.DOUBLE;
		if (FLOAT.equalsIgnoreCase(columnDef))
			return Type.FLOAT;
		if (INTEGER.equalsIgnoreCase(columnDef))
			return Type.INTEGER;
		if (INT.equalsIgnoreCase(columnDef))
			return Type.INTEGER;
		if (JAVA_OBJECT.equalsIgnoreCase(columnDef))
			return Type.JAVA_OBJECT;
		if (LONGNVARCHAR.equalsIgnoreCase(columnDef))
			return Type.LONGNVARCHAR;
		if (LONGVARBINARY.equalsIgnoreCase(columnDef))
			return Type.LONGVARBINARY;
		if (LONGVARCHAR.equalsIgnoreCase(columnDef))
			return Type.LONGVARCHAR;
		if (NCHAR.equalsIgnoreCase(columnDef))
			return Type.NCHAR;
		if (NCLOB.equalsIgnoreCase(columnDef))
			return Type.NCLOB;
		if (NUMERIC.equalsIgnoreCase(columnDef))
			return Type.NUMERIC;
		if (NVARCHAR.equalsIgnoreCase(columnDef))
			return Type.NVARCHAR;
		if (UNKNOW.equalsIgnoreCase(columnDef))
			return Type.UNKNOW;
		if (REAL.equalsIgnoreCase(columnDef))
			return Type.REAL;
		if (SMALLINT.equalsIgnoreCase(columnDef))
			return Type.SMALLINT;
		if (TIME.equalsIgnoreCase(columnDef))
			return Type.TIME;
		if (TIMESTAMP.equalsIgnoreCase(columnDef))
			return Type.TIMESTAMP;
		if (TINYINT.equalsIgnoreCase(columnDef))
			return Type.TINYINT;
		if (VARBINARY.equalsIgnoreCase(columnDef))
			return Type.VARBINARY;
		if (VARCHAR.equalsIgnoreCase(columnDef))
			return Type.VARCHAR;
	      if ("TEXT".equalsIgnoreCase(columnDef))
	            return Type.VARCHAR;
		// @formatter:on
		throw new DialectException("'" + columnDef + "' can not be map to a dialect type");
	}

drinkjava2/jSqlBox

内容风险标识

评论 (4)

drinkjava2/jSqlBox .gitee-modal { width: 500px !important; }

内容风险标识