get Table Details Statement - Java java.sql

Java examples for java.sql:Table

  1. HOME
  2. Java
  3. java.sql
  4. Table

Description

get Table Details Statement

Demo Code

/*//from  w  w  w.j  a va  2s . c om
 * Copyright (c) 2003, Orientation in Objects GmbH, www.oio.de
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without modification,
 * are permitted provided that the following conditions are met:
 * 
 * - Redistributions of source code must retain the above copyright notice, this
 *   list of conditions and the following disclaimer.
 * - Redistributions in binary form must reproduce the above copyright notice,
 *   this list of conditions and the following disclaimer in the documentation 
 *   and/or other materials provided with the distribution.
 * - Neither the name of Orienation in Objects GmbH nor the names of its 
 *   contributors may be used to endorse or promote products derived from this 
 *   software without specific prior written permission.
 * 
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" 
 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE 
 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE 
 * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR
 * ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES 
 * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS
 * OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY 
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
 * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, 
 * EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 * 
 * ${file_name} Created on ${date} by ${user}
 *  
 * ${todo}
 * 
 */
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Types;
import java.util.ArrayList;
import java.util.Collection;
import org.apache.log4j.Logger;

public class Main{
    public static void main(String[] argv) throws Exception{
        String tableName = "java2s.com";
        String id = "java2s.com";
        System.out.println(getTableDetailsStatement(tableName,id));
    }
    private static String getTableDetailsStatement(String tableName,
            String id) {

        StringBuffer queryString = new StringBuffer();
        queryString.append("select * from ");
        queryString.append(tableName);
        queryString.append(" where ");
        queryString.append(getPrimaryKeyColumnName(tableName));
        queryString.append(" = ");

        int type = getColumnType(tableName,
                getPrimaryKeyColumnName(tableName));

        queryString.append(getSQLParameterSubstring(id, type));

        return queryString.toString();
    }
    public static String getPrimaryKeyColumnName(String tableName) {

        try {
            Connection connection = DBConnection.getInstance();

            DatabaseMetaData metaData = connection.getMetaData();
            ResultSet resultSet = metaData.getPrimaryKeys(null, null,
                    tableName);

            resultSet.next();

            return resultSet.getString("COLUMN_NAME");
        } catch (SQLException e) {
            throw new IllegalArgumentException("Wrong tablename : "
                    + tableName);
        }
    }
    /**
     * Method getColumnType.
     * @param tableName
     * @param string
     * @return String
     */
    public static int getColumnType(String tableName, String columnName) {
        try {
            Connection connection = DBConnection.getInstance();

            DatabaseMetaData metaData = connection.getMetaData();
            ResultSet resultSet = metaData.getColumns(null, null,
                    tableName, columnName);

            resultSet.next();

            return resultSet.getInt("DATA_TYPE");
        } catch (SQLException e) {
            throw new IllegalArgumentException(
                    "Wrong tablename or columnName: " + tableName + ", "
                            + columnName);
        }

    }
    public static String getSQLParameterSubstring(String value, int type) {

        if (isNumericType(type)) {
            return value;
        } else {
            return "'" + value + "'";
        }
    }
    public static boolean isNumericType(int type) {
        return Types.BIGINT == type || Types.DECIMAL == type
                || Types.INTEGER == type || Types.NUMERIC == type
                || Types.SMALLINT == type || Types.TINYINT == type;
    }
}

Related Tutorials