Java Utililty Methods SQL Type

int resultType = 10; 
switch (sqlType) {
case java.sql.Types.BIT: {
    resultType = 1;
case java.sql.Types.BIGINT: {
    resultType = 19;
    break;
...

int result = -1; 
switch (sqlType) {
case java.sql.Types.REAL:
case java.sql.Types.DOUBLE: {
    result = 10;
    break;
default:
...

String rtn = null;
if (o == null) {
    rtn = null;
} else {
    if (o instanceof String) {
        rtn = (String) o;
    } else if (o instanceof Number || o instanceof BigDecimal || o instanceof StringBuffer) {
        rtn = o.toString();
...

switch (colType) {
case Types.DECIMAL:
case Types.DOUBLE:
case Types.FLOAT:
    return "%f";
case Types.DATE:
case Types.TIME:
case Types.TIMESTAMP:
...

final List<String> tableTypes = new LinkedList<String>();
final ResultSet rs = dbmd.getTableTypes();
while (rs.next()) {
    tableTypes.add(rs.getString(1));
rs.close();
return tableTypes;

String dbms = getDbmsFromConnection(conn);
if (dbms.equals(ORACLE))
    return "NUMBER(1,0)";
if (dbms.equals(POSTGRESQL))
    return "SMALLINT";
return "TINYINT";

switch (csqltype) {
case 0:
    return Types.INTEGER;
case 1:
    return Types.BIGINT;
case 2:
    return Types.BIGINT;
case 3:
...

try {
    Class c = Types.class;
    Field[] fields = c.getDeclaredFields();
    for (int i = 0; i < fields.length; i++) {
        String name = fields[i].getName();
        int value = fields[i].getInt(null);
        if (value == type) {
            return name;
...

switch (dataType) {
case Types.BIGINT:
    return "BIGINT";
case Types.BINARY:
    return "BINARY";
case Types.BIT:
    return "BIT";
case Types.CHAR:
...

switch (typeNumber) {
case Types.SMALLINT:
    return "SMALLINT";
case Types.INTEGER:
    return "INTEGER";
case Types.BIGINT:
    return "BIGINT";
case Types.FLOAT:
...