<#if entity.columns?exists> <#list entity.columns as attr> <#if attr.dbFieldName == "id"> <#if entity.jformPkType?if_exists?html=='UUID'> <#elseif entity.jformPkType?if_exists?html=='NATIVE'> <#if dataType=='MYSQL'> <#elseif dataType=='ORACLE'> <#elseif dataType=='SQLSERVER'> <#elseif dataType=='POSTGRESQL'> <#elseif entity.jformPkType?if_exists?html=='SEQUENCE'> <#if dataType=='MYSQL'> <#elseif dataType=='ORACLE'> ${entity.jformPkSequence} <#elseif dataType=='SQLSERVER'> <#elseif dataType=='POSTGRESQL'> <#else> <#else> <#case "string"> type="java.lang.String" <#break> <#case "text"> <#-- update--begin--author:scott Date:20180227 for:针对oracle情况下text类型采用clob转换 --> <#if dataType=='ORACLE'> type="clob" <#else> type="text" <#-- update--end--author:scott Date:20180227 for:针对oracle情况下text类型采用clob转换 --> <#break> <#case "int"> type="java.lang.Integer" <#break> <#case "double"> <#if dataType=='MYSQL'> type="java.lang.Double" <#elseif dataType=='ORACLE'> type="java.math.BigDecimal" <#elseif dataType=='POSTGRESQL'> type="java.math.BigDecimal" <#elseif dataType=='SQLSERVER'> type="java.math.BigDecimal" <#break> <#case "date"> <#if dataType=='MYSQL'> type="java.util.Date" <#elseif dataType=='ORACLE'> type="java.sql.Timestamp" <#elseif dataType=='POSTGRESQL'> type="java.util.Date" <#elseif dataType=='SQLSERVER'> type="java.util.Date" <#break> <#case "bigdecimal"> <#if dataType=='MYSQL'> type="java.math.BigDecimal" <#elseif dataType=='ORACLE'> type="java.math.BigDecimal" <#elseif dataType=='POSTGRESQL'> type="java.math.BigDecimal" <#elseif dataType=='SQLSERVER'> type="java.math.BigDecimal" <#break> <#case "blob"> <#if dataType=='MYSQL'> type="blob" <#elseif dataType=='ORACLE'> type="blob" <#elseif dataType=='POSTGRESQL'> type="binary" <#elseif dataType=='SQLSERVER'> type="image" <#break> access="property"> sql-type="nvarchar(${attr.dbLength})" <#if dataType=='SQLSERVER' && attr.dbType?lower_case="text"> sql-type="ntext" <#if attr.dbType=='double'||attr.dbType=='BigDecimal'> precision="${attr.dbLength}" scale="${attr.dbPointLength}"<#else>length="${attr.dbLength}" <#if attr.dbDefaultVal?exists&&attr.dbDefaultVal!=''>default="${attr.dbDefaultVal}" not-null="<#if attr.dbIsNull == 1>false<#else>true" unique="false"> ${attr.dbFieldTxt}