package com.hx.auto.common;
|
|
/**javaType和jdbcType对比
|
*
|
* @author chenjiahe
|
*
|
*/
|
public class JdbcType {
|
|
/**
|
* @param type 字段类型
|
* @param isBol 是否长字符串
|
* @return
|
*/
|
public static String jdbcTypeData(String type,boolean isBol) {
|
//字母转化为小字母
|
type = type.toLowerCase();
|
if(type.equals("java.lang.string")) {
|
if(!isBol) {
|
type = "VARCHAR";
|
}else {
|
type = "LONGVARCHAR";
|
}
|
}else if(type.equals("int")) {
|
type = "INTEGER";
|
}else if(type.equals("java.lang.integer")) {
|
type = "INTEGER";
|
}else if(type.equals("boolean")) {
|
type = "BOOLEAN";
|
}else if(type.equals("byte")) {
|
type = "TINYINT";
|
}else if(type.equals("short")) {
|
type = "SMALLINT";
|
}else if(type.equals("long")) {
|
type = "BIGINT";
|
}else if(type.equals("float")) {
|
type = "REAL";
|
}else if(type.equals("double")) {
|
type = "DOUBLE";
|
}else if(type.equals("java.lang.double")) {
|
type = "DOUBLE";
|
}else if(type.equals("java.util.date")) {
|
type = "TIMESTAMP";
|
}else if(type.equals("java.sql.date")) {
|
type = "TIMESTAMP";
|
}else if(type.equals("blob")) {
|
type = "BLOB";
|
}
|
return type;
|
}
|
}
|
