Package org.postgresql.pljava.example

Class ResultSetTest

java.lang.Object

org.postgresql.pljava.example.ResultSetTest

public class ResultSetTest
extends Object

Provides a function that takes any SQL SELECT query as a string, executes it, and returns the ResultSet produced as a single string column, the first row being a header, then one per row of the ResultSet, semicolons delimiting the original columns.

Author:

Filip Hrbek

Constructor Summary

Constructors

Constructor	Description
ResultSetTest(String selectSQL)

Method Summary

Modifier and Type	Method	Description
void	close()
static Iterator<String>	executeSelect(String selectSQL)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ResultSetTest

public ResultSetTest(String selectSQL)
              throws SQLException

Throws:

SQLException

Method Detail

executeSelect

public static Iterator<String> executeSelect(String selectSQL)
                                      throws SQLException

Throws:

SQLException

close

public void close()