Java SQL ResultSet Read getResultSetFromQueryAgainstDefaultConnection( String sql)

Description

get Result Set From Query Against Default Connection

License

Open Source License

Declaration

public static ResultSet getResultSetFromQueryAgainstDefaultConnection(
            String sql) throws SQLException 

Method Source Code

//package com.java2s;
/*/*from  w  ww.jav  a 2s  . co m*/
 * (C) Copyright IBM Corp. 2011
 *
 * LICENSE: Eclipse Public License v1.0
 * http://www.eclipse.org/legal/epl-v10.html
 */

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Main {
    public static ResultSet getResultSetFromQueryAgainstDefaultConnection(
            String sql) throws SQLException {

        Connection c = getDefaultDerbyConnection();
        //      System.out.println(sql);
        ResultSet rs = c.createStatement().executeQuery(sql);
        return rs;
    }

    public static Connection getDefaultDerbyConnection()
            throws SQLException {
        return DriverManager.getConnection("jdbc:default:connection"); //, getGaianNodeUser(), getGaianNodePassword());
        //      return DriverManager.getConnection("jdbc:derby://localhost:6414/gaiandb", getGaianNodeUser(), getGaianNodePassword());
    }
}

Related

1. getResultSet(String sql)
2. getResultSetColnumNames(ResultSet rs)
3. getResultSetColumns(ResultSet rs)
4. getResultSetDateValue(ResultSet rs, String sColumnName)
5. GetResultSetFromQuery(String command)
6. getResultSetInstance(Connection conn, String sql)
7. getResultSetMetaData(ResultSet rs)
8. getResultSetRowString(ResultSet rs)
9. getResultSetStrings(ResultSet rs)