Re: Can a ResultSet be passed back to a main program

On 2011-10-10, Linus Flustillbe <admin@nacs.dyndns-office.com> wrote:


I have been succesful.... here is my code

This is the class that does the connection

package mainClasses;
import java.sql.*;
public class TableConnect {

    public Statement getStatement() {
        return statement;
    }

    public void setStatement(Statement statement) {
        this.statement = statement;
    }

    private Statement statement;

    public TableConnect() throws ClassNotFoundException,
SQLException
    {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        Statement tstate;

        String url = "jdbc:oracle:thin:@xxxxxxx1:1521:xxxxxxx";
        Connection conn =
            DriverManager.getConnection(url,"xxxxxxx",
"xxxxxxx");
        
        tstate = conn.createStatement();
        setStatement(tstate);
    }

    public ResultSet GetResultSet(Statement stmt, String tableName)
throws SQLException {
        String query = "select * from " + tableName ;
        return stmt.executeQuery(query);
    }
}

====================

And here is my testing code

package testing;

import java.sql.*;

import mainClasses.*;
public class ConnectionTest {
    public static void main(String[] args) throws
ClassNotFoundException, SQLException
    {
     Class.forName("oracle.jdbc.driver.OracleDriver");
     String tableName="LU_MEDIA_USAGE";
          TableConnect myConnection = new TableConnect();
          Statement stmt = myConnection.getStatement();
          ResultSet rset = myConnection.GetResultSet(stmt, tableName);
          while (rset.next()) {
     System.out.println (rset.getString(1));
     }
   stmt.close();
     }
}

When I run ConnectionTest, I get the following output

CL
COM
CS
DRA
HIS
HOR
NF
OPS
REC
ROM
SF
THR
TR

These are just 3 character codes that I am using as "enum" types
for my application. Suggestions for improvement are welcome.
Like I would have preferred to do one method call and have the stmt
be internal to that i.e. without needing a variable in the main program
called stmt that gets set from a method call then then passed to a
another method. Maybe if I sleep on it, the answer will come to me.

 

--
********************************************************************************
* Usenet Impovement Project http://nacs.dyndns-office.com/usenet
*********************************************************************************