| 1 24 package org.riotfamily.revolt.support; 25 26 import java.sql.Types ; 27 import java.util.HashMap ; 28 import java.util.Map ; 29 30 34 public class TypeMap { 35 36 public final static String BIT = "BIT"; 37 38 public final static String TINYINT = "TINYINT"; 39 40 public final static String SMALLINT = "SMALLINT"; 41 42 public final static String INTEGER = "INTEGER"; 43 44 public final static String BIGINT = "BIGINT"; 45 46 public final static String FLOAT = "FLOAT"; 47 48 public final static String REAL = "REAL"; 49 50 public final static String DOUBLE = "DOUBLE"; 51 52 public final static String NUMERIC = "NUMERIC"; 53 54 public final static String DECIMAL = "DECIMAL"; 55 56 public final static String CHAR = "CHAR"; 57 58 public final static String VARCHAR = "VARCHAR"; 59 60 public final static String LONGVARCHAR = "LONGVARCHAR"; 61 62 public final static String DATE = "DATE"; 63 64 public final static String TIME = "TIME"; 65 66 public final static String TIMESTAMP = "TIMESTAMP"; 67 68 public final static String BINARY = "BINARY"; 69 70 public final static String VARBINARY = "VARBINARY"; 71 72 public final static String LONGVARBINARY = "LONGVARBINARY"; 73 74 public final static String BLOB = "BLOB"; 75 76 public final static String CLOB = "CLOB"; 77 78 private static HashMap jdbcTypes = new HashMap (); 79 80 static { 81 jdbcTypes.put(BIT, new Integer (Types.BIT)); 82 jdbcTypes.put(TINYINT, new Integer (Types.TINYINT)); 83 jdbcTypes.put(SMALLINT, new Integer (Types.SMALLINT)); 84 jdbcTypes.put(INTEGER, new Integer (Types.INTEGER)); 85 jdbcTypes.put(BIGINT, new Integer (Types.BIGINT)); 86 jdbcTypes.put(FLOAT, new Integer (Types.FLOAT)); 87 jdbcTypes.put(REAL, new Integer (Types.REAL)); 88 jdbcTypes.put(DOUBLE, new Integer (Types.DOUBLE)); 89 jdbcTypes.put(NUMERIC, new Integer (Types.NUMERIC)); 90 jdbcTypes.put(DECIMAL, new Integer (Types.DECIMAL)); 91 jdbcTypes.put(CHAR, new Integer (Types.CHAR)); 92 jdbcTypes.put(VARCHAR, new Integer (Types.VARCHAR)); 93 jdbcTypes.put(LONGVARCHAR, new Integer (Types.LONGVARCHAR)); 94 jdbcTypes.put(DATE, new Integer (Types.DATE)); 95 jdbcTypes.put(TIME, new Integer (Types.TIME)); 96 jdbcTypes.put(TIMESTAMP, new Integer (Types.TIMESTAMP)); 97 jdbcTypes.put(BINARY, new Integer (Types.BINARY)); 98 jdbcTypes.put(VARBINARY, new Integer (Types.VARBINARY)); 99 jdbcTypes.put(LONGVARBINARY, new Integer (Types.LONGVARBINARY)); 100 jdbcTypes.put(BLOB, new Integer (Types.BLOB)); 101 jdbcTypes.put(CLOB, new Integer (Types.CLOB)); 102 } 103 104 public static int getJdbcType(String name) { 105 Integer i = (Integer ) jdbcTypes.get(name.toUpperCase()); 106 if (i != null) { 107 return i.intValue(); 108 } 109 return Types.NULL; 110 } 111 112 public static boolean isComplete(Map map) { 113 return map.keySet().containsAll(jdbcTypes.keySet()); 114 } 115 } 116 | Popular Tags |