import com.sun.rowset.JdbcRowSetImpl;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import javax.sql.rowset.JdbcRowSet;

/*
/**
 *
 * @author Pete Cappello
 */
public class RowSetExample 
{
    static final String DATABASE_URL = "jdbc:derby://localhost:1527/Mandelbrot";
    static final String USERNAME = "nbuser";
    static final String PASSWORD = "nbuser";
    
    public RowSetExample() 
    {
        try 
        {
            // try-with-resources
            try ( JdbcRowSet rowSet = new JdbcRowSetImpl() ) 
            {
                rowSet.setUrl( DATABASE_URL );         
                rowSet.setUsername( USERNAME );           
                rowSet.setPassword( PASSWORD );            
                rowSet.setCommand( "SELECT * FROM APP.MODELS" ); 
                rowSet.execute();                       

                // process query results
                ResultSetMetaData metaData = rowSet.getMetaData();
                int numberOfColumns = metaData.getColumnCount();
                System.out.println( "Models Table of APP Database:\n" );

                // display rowset header
                for ( int columnNum = 1; columnNum <= numberOfColumns; columnNum++ )
                {
                   System.out.printf( "%-8s\t", metaData.getColumnName( columnNum ) );
                }
                System.out.println();

                // display rowset
                while ( rowSet.next() ) 
                {
                    // display row
                   for ( int columnNum = 1; columnNum <= numberOfColumns; columnNum++ )
                   {
                      System.out.printf( "%-8s\t", rowSet.getObject( columnNum ) );
                   }
                   System.out.println();
                }
            }
        } 
        catch ( SQLException sqlException ) 
        {
           sqlException.printStackTrace();
           System.exit( 1 );
        } 
   }
    
   public static void main( String args[] )
   {
      RowSetExample rowSetExample = new RowSetExample();
   }
}