java 数据库映射_将数据库类型映射到具体的Java类

小编典典

解

答案比使用getMetaData方法要复杂得多，因为方法返回的整数类型getMetaData和完整的类名没有直接映射。该解决方案需要两段代码：

实现一种获取java.sql.Types常量整数值的方法。

创建一个将该值转换为类名的方法。

Java类型方法

以下方法检索元信息：

public String getJavaType( String schema, String object, String column )

throws Exception {

String fullName = schema + '.' + object + '.' + column;

DatabaseMetaData metaData = getConnection().getMetaData();

ResultSet columnMeta = metaData.getColumns( null, schema, object, column );

String javaType = null;

if( columnMeta.first() ) {

int dataType = columnMeta.getInt( "DATA_TYPE" );

javaType = SQLTypeMap.convert( dataType );

}

else {

throw new Exception( "Unknown database column " + fullName + '.' );

}

return javaType;

}

静态转换方法

常量整数值必须转换为类名。这可以通过以下方式完成：

import java.sql.Types;

/**

* Converts database types to Java class types.

*/

public class SQLTypeMap {

/**

* Translates a data type from an integer (java.sql.Types value) to a string

* that represents the corresponding class.

*

* @param type

* The java.sql.Types value to convert to its corresponding class.

* @return The class that corresponds to the given java.sql.Types

* value, or Object.class if the type has no known mapping.

*/

public static Class> toClass(int type) {

Class> result = Object.class;

switch (type) {

case Types.CHAR:

case Types.VARCHAR:

case Types.LONGVARCHAR:

result = String.class;

break;

case Types.NUMERIC:

case Types.DECIMAL:

result = java.math.BigDecimal.class;

break;

case Types.BIT:

result = Boolean.class;

break;

case Types.TINYINT:

result = Byte.class;

break;

case Types.SMALLINT:

result = Short.class;

break;

case Types.INTEGER:

result = Integer.class;

break;

case Types.BIGINT:

result = Long.class;

break;

case Types.REAL:

case Types.FLOAT:

result = Float.class;

break;

case Types.DOUBLE:

result = Double.class;

break;

case Types.BINARY:

case Types.VARBINARY:

case Types.LONGVARBINARY:

result = Byte[].class;

break;

case Types.DATE:

result = java.sql.Date.class;

break;

case Types.TIME:

result = java.sql.Time.class;

break;

case Types.TIMESTAMP:

result = java.sql.Timestamp.class;

break;

}

return result;

}

}

注意，不同的数据库在映射上可以有不同的变化。

2020-10-25