Java SQL Type getTableTypes(DatabaseMetaData dbmd)

Description

get Table Types

License

Open Source License

Declaration

public static List<String> getTableTypes(DatabaseMetaData dbmd)
            throws SQLException 

Method Source Code

//package com.java2s;
/*//from  www  .ja v  a 2  s  .com
 * Copyright (C) 2011 Michael Griffel
 *
 * This program is free software: you can redistrib
 * it under the terms of the GNU General Public Lic
 * the Free Software Foundation, either version 3 o
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it
 * but WITHOUT ANY WARRANTY; without even the impli
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURP
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU Gener
 * along with this program.  If not, see <http://ww
 *
 * This distribution includes other third-party lib
 * These libraries and their corresponding licenses
 * from the GNU General Public License) are enumera
 *
 * PlantUML is a Open-Source tool in Java to draw U
 * The software is developed by Arnaud Roques at
 * http://plantuml.sourceforge.org.
 */

import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.sql.SQLException;

import java.util.LinkedList;
import java.util.List;

public class Main {
    public static List<String> getTableTypes(DatabaseMetaData dbmd)
            throws SQLException {
        final List<String> tableTypes = new LinkedList<String>();
        final ResultSet rs = dbmd.getTableTypes();
        while (rs.next()) {
            tableTypes.add(rs.getString(1));
        }
        rs.close();
        return tableTypes;
    }
}

Related

1. getSQLTypeName(Integer sqltypecode)
2. getSQLTypePrecision(int sqlType)
3. getSQLTypeRadix(int sqlType)
4. getSqlValue(Object o)
5. getStringFormat(int colType)
6. getTinyIntTypeString(Connection conn)
7. getType(int csqltype)
8. getTypeforValue(int type)
9. getTypeName(int dataType)