![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e291. Getting the Name of a JDBC TypeThis example implements a convenient method for converting ajava.sql.Types integer value into a printable name. This method
is useful for debugging. The method uses reflection to get all the
field names from java.sql.Types. It then retrieves their values
and creates a map of values to names.
// This method returns the name of a JDBC type. // Returns null if jdbcType is not recognized. public static String getJdbcTypeName(int jdbcType) { // Use reflection to populate a map of int values to names if (map == null) { map = new HashMap(); // Get all field in java.sql.Types Field[] fields = java.sql.Types.class.getFields(); for (int i=0; i<fields.length; i++) { try { // Get field name String name = fields[i].getName(); // Get field value Integer value = (Integer)fields[i].get(null); // Add to map map.put(value, name); } catch (IllegalAccessException e) { } } } // Return the JDBC type name return (String)map.get(new Integer(jdbcType)); } static Map map;
e285. Listing the String Functions Supported by a Database e286. Listing the Numeric Functions Supported by a Database e287. Listing the System Functions Supported by a Database e288. Listing the Time and Date Functions Supported by a Database e289. Getting the Maximum Table Name Length in a Database e290. Listing Available SQL Types Used by a Database © 2002 Addison-Wesley. |