Package weka.gui.sql

Class ResultSetHelper

java.lang.Object
weka.gui.sql.ResultSetHelper
public class ResultSetHelper extends Object
Represents an extended JTable, containing a table model based on a ResultSet and the corresponding query.
Version:
$Revision: 11247 $
Author:
FracPete (fracpete at waikato dot ac dot nz)

  • Constructor Summary

    Constructors
    Constructor
    Description
    ResultSetHelper(ResultSet rs)
    initializes the helper, with unlimited number of rows.
    ResultSetHelper(ResultSet rs, int max)
    initializes the helper, with the given maximum number of rows (less than 1 means unlimited).

  • Method Summary

    Modifier and Type
    Method
    Description
    Object[][]
    getCells()
    returns an 2-dimensional array with the content of the resultset, the first dimension is the row, the second the column (i.e., getCells()[y][x]).
    Class<?>[]
    getColumnClasses()
    returns the classes for the columns.
    int
    getColumnCount()
    returns the number of columns in the resultset.
    String[]
    getColumnNames()
    returns an array with the names of the columns in the resultset.
    int
    getMaxRows()
    the maximum number of rows to retrieve, less than 1 means unlimited.
    boolean[]
    getNumericColumns()
    returns an array that indicates whether a column is numeric or nor.
    ResultSet
    getResultSet()
    the underlying resultset.
    int
    getRowCount()
    returns the number of rows in the resultset.
    boolean
    hasMaxRows()
    whether a limit on the rows to retrieve was set.
    static boolean
    typeIsNumeric(int type)
    returns whether the SQL type is numeric (and therefore the justification should be right).
    static Class<?>
    typeToClass(int type)
    Returns the class associated with a SQL type.

    Methods inherited from class java.lang.Object

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

  • Constructor Details

    • ResultSetHelper

      public ResultSetHelper(ResultSet rs)
      initializes the helper, with unlimited number of rows.
      Parameters:
      rs - the resultset to work on

    • ResultSetHelper

      public ResultSetHelper(ResultSet rs, int max)
      initializes the helper, with the given maximum number of rows (less than 1 means unlimited).
      Parameters:
      rs - the resultset to work on
      max - the maximum number of rows to retrieve

  • Method Details

    • getResultSet

      public ResultSet getResultSet()
      the underlying resultset.
      Returns:
      the resultset

    • getColumnCount

      public int getColumnCount()
      returns the number of columns in the resultset.
      Returns:
      the number of columns

    • getRowCount

      public int getRowCount()
      returns the number of rows in the resultset. If -1 then the number of rows couldn't be determined, i.e., the cursors aren't scrollable.
      Returns:
      the number of rows, -1 if it wasn't possible to determine

    • getColumnNames

      public String[] getColumnNames()
      returns an array with the names of the columns in the resultset.
      Returns:
      the column names

    • getNumericColumns

      public boolean[] getNumericColumns()
      returns an array that indicates whether a column is numeric or nor.
      Returns:
      the numeric columns

    • getColumnClasses

      public Class<?>[] getColumnClasses()
      returns the classes for the columns.
      Returns:
      the column classes

    • hasMaxRows

      public boolean hasMaxRows()
      whether a limit on the rows to retrieve was set.
      Returns:
      true if there's a limit

    • getMaxRows

      public int getMaxRows()
      the maximum number of rows to retrieve, less than 1 means unlimited.
      Returns:
      the maximum number of rows

    • getCells

      public Object[][] getCells()
      returns an 2-dimensional array with the content of the resultset, the first dimension is the row, the second the column (i.e., getCells()[y][x]). Note: the data is not cached! It is always retrieved anew.
      Returns:
      the data

    • typeToClass

      public static Class<?> typeToClass(int type)
      Returns the class associated with a SQL type.
      Parameters:
      type - the SQL type
      Returns:
      the Java class corresponding with the type

    • typeIsNumeric

      public static boolean typeIsNumeric(int type)
      returns whether the SQL type is numeric (and therefore the justification should be right).
      Parameters:
      type - the SQL type
      Returns:
      whether the given type is numeric