Java SQL Table queryAllFromTable(String tableName)

Description

return a Statement with the result of a "SELECT *" query for a given table

License

Open Source License

Parameter

Parameter	Description
conn	Connection to the database
tableName	String containing the name of the table you want to get the results.

Exception

Parameter	Description
SQLException	an exception

Return

a ResultSet with the query result returned from the DB

Declaration

public static String queryAllFromTable(String tableName) throws SQLException 

Method Source Code

//package com.java2s;
/*  Copyright (C) 2003-2015 JabRef contributors.
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General public static License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version./*w w  w.  j a v  a  2  s  .  co  m*/
    
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General public static License for more details.
    
You should have received a copy of the GNU General public static License along
with this program; if not, write to the Free Software Foundation, Inc.,
51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
 */

import java.sql.SQLException;

public class Main {
    /**
     * return a Statement with the result of a "SELECT *" query for a given table
     *
     * @param conn      Connection to the database
     * @param tableName String containing the name of the table you want to get the results.
     * @return a ResultSet with the query result returned from the DB
     * @throws SQLException
     */
    public static String queryAllFromTable(String tableName) throws SQLException {
        return "SELECT * FROM " + tableName + ';';
    }
}

Related

1. isExistsDerbyTable(Connection derbyConnection, String schema, String table)
2. isFileImportable(File file, String prefix)
3. isTableEmpty(Connection con, String schemaName, String tableName)
4. normalizeTableName(String table, Connection con)
5. parse(Connection connection, String tableName, String type)
6. quoteSchemaTable(Connection conn, String schema, String table)
7. truncateTable(Connection conn)
8. truncateTable(Connection conn, String table_name)
9. truncateTable(Connection conn, String tablename)