public CloseableTableModel createTableModel(ResultSet rs) throws SQLException 
{
    return createTableModel
            (rs, "Label".equals(JFreeReportBoot.getInstance().getGlobalConfig().getConfigProperty //$NON-NLS-1$
                (ResultSetTableModelFactory.COLUMN_NAME_MAPPING_KEY, "Label"))); //$NON-NLS-1$
}

Creates a table model by using the given ResultSet as the backend. If the ResultSet is scrollable (the type is not TYPE_FORWARD_ONLY), an instance of org.jfree.report.modules.misc.tablemodel.ScrollableResultSetTableModel is returned. This model uses the extended capabilities of scrollable resultsets to directly read data from the database without caching or the need of copying the complete ResultSet into the programs memory.

If the ResultSet lacks the scollable features, the data will be copied into a DefaultTableModel and the ResultSet gets closed.

 public CloseableTableModel createTableModel(ResultSet rs,
    boolean labelMapping) throws SQLException 
{
    // Allow for override, some jdbc drivers are buggy :(
    final String prop =
            JFreeReportBoot.getInstance().getGlobalConfig().getConfigProperty
                    (ResultSetTableModelFactory.RESULTSET_FACTORY_MODE, "auto"); //$NON-NLS-1$
    if ("simple".equalsIgnoreCase(prop)) //$NON-NLS-1$
    {
      return generateDefaultTableModel(rs, labelMapping);
    }
    int resultSetType = ResultSet.TYPE_FORWARD_ONLY;
    try
    {
      resultSetType = rs.getType();
    }
    catch (SQLException sqle)
    {
      ResultSetTableModelFactory.logger.info("ResultSet type could not be determined, assuming default table model."); //$NON-NLS-1$
    }
    if (resultSetType == ResultSet.TYPE_FORWARD_ONLY)
    {
      return generateDefaultTableModel(rs, labelMapping);
    }
    else
    {
      return new ScrollableResultSetTableModel(rs, labelMapping);
    }
}

Creates a table model by using the given ResultSet as the backend. If the ResultSet is scrollable (the type is not TYPE_FORWARD_ONLY), an instance of org.jfree.report.modules.misc.tablemodel.ScrollableResultSetTableModel is returned. This model uses the extended capabilities of scrollable resultsets to directly read data from the database without caching or the need of copying the complete ResultSet into the programs memory.

If the ResultSet lacks the scollable features, the data will be copied into a DefaultTableModel and the ResultSet gets closed.

 public CloseableTableModel generateDefaultTableModel(ResultSet rs) throws SQLException 
{
    return generateDefaultTableModel(rs,
        "Label".equals(JFreeReportBoot.getInstance().getGlobalConfig().getConfigProperty
            (ResultSetTableModelFactory.COLUMN_NAME_MAPPING_KEY, "Label"))); //$NON-NLS-1$ //$NON-NLS-2$
}

Generates a TableModel that gets its contents filled from a ResultSet. The column names of the ResultSet will form the column names of the table model.

Hint: To customize the names of the columns, use the SQL column aliasing (done with SELECT nativecolumnname AS "JavaColumnName" FROM ....

 public CloseableTableModel generateDefaultTableModel(ResultSet rs,
    boolean labelMapping) throws SQLException 
{
    final ResultSetMetaData rsmd = rs.getMetaData();
    final int colcount = rsmd.getColumnCount();
    final Object[] header = new Object[colcount];
    final Class[] colTypes = TypeMapper.mapTypes(rsmd);
    final DefaultTableMetaData metaData = new DefaultTableMetaData(colcount);
    for (int i = 0; i <  colcount; i++)
    {
      if (labelMapping)
      {
        final String name = rsmd.getColumnLabel(i + 1);
        header[i] = name;
      }
      else
      {
        final String name = rsmd.getColumnName(i + 1);
        header[i] = name;
      }
      ResultSetTableModelFactory.updateMetaData(rsmd, metaData, i);
    }
    final ArrayList rows = new ArrayList();
    while (rs.next())
    {
      final Object[] column = new Object[colcount];
      for (int i = 0; i <  colcount; i++)
      {
        final Object val = rs.getObject(i + 1);
        column[i] = val;
      }
      rows.add(column);
    }
    final Object[] tempRows = rows.toArray();
    final int tempRowCount = tempRows.length;
    final Object[][] rowMap = new Object[tempRowCount][];
    for (int i = 0; i <  tempRowCount; i++)
    {
      rowMap[i] = (Object[]) tempRows[i];
    }
    return new CloseableDefaultTableModel(rowMap, header, colTypes, metaData, rs);
}

Generates a TableModel that gets its contents filled from a ResultSet. The column names of the ResultSet will form the column names of the table model.

Hint: To customize the names of the columns, use the SQL column aliasing (done with SELECT nativecolumnname AS "JavaColumnName" FROM ....

 public static synchronized ResultSetTableModelFactory getInstance() 
{
    if (defaultInstance == null)
    {
      defaultInstance = new ResultSetTableModelFactory();
    }
    return defaultInstance;
}

Returns the singleton instance of the factory.

 public static  void updateMetaData(ResultSetMetaData rsmd,
    DefaultTableMetaData metaData,
    int column) 
{
    try
    {
      if (rsmd.isCurrency(column + 1))
      {
        metaData.setColumnAttribute
            (column, MetaAttributeNames.Numeric.NAMESPACE, MetaAttributeNames.Numeric.CURRENCY, Boolean.TRUE);
      }
      else
      {
        metaData.setColumnAttribute
            (column, MetaAttributeNames.Numeric.NAMESPACE, MetaAttributeNames.Numeric.CURRENCY, Boolean.FALSE);
      }
      if (rsmd.isSigned(column + 1))
      {
        metaData.setColumnAttribute
            (column, MetaAttributeNames.Numeric.NAMESPACE, MetaAttributeNames.Numeric.SIGNED, Boolean.TRUE);
      }
      else
      {
        metaData.setColumnAttribute
            (column, MetaAttributeNames.Numeric.NAMESPACE, MetaAttributeNames.Numeric.SIGNED, Boolean.FALSE);
      }
      final String tableName = rsmd.getTableName(column + 1);
      if (tableName != null)
      {
        metaData.setColumnAttribute
            (column, MetaAttributeNames.Database.NAMESPACE, MetaAttributeNames.Database.TABLE, tableName);
      }
      final String schemaName = rsmd.getSchemaName(column + 1);
      if (schemaName != null)
      {
        metaData.setColumnAttribute
            (column, MetaAttributeNames.Database.NAMESPACE, MetaAttributeNames.Database.SCHEMA, schemaName);
      }
      final String catalogName = rsmd.getCatalogName(column + 1);
      if (catalogName != null)
      {
        metaData.setColumnAttribute
            (column, MetaAttributeNames.Database.NAMESPACE, MetaAttributeNames.Database.CATALOG, catalogName);
      }
      final String label = rsmd.getColumnLabel(column + 1);
      if (label != null)
      {
        metaData.setColumnAttribute
            (column, MetaAttributeNames.Formatting.NAMESPACE, MetaAttributeNames.Formatting.LABEL, label);
      }
      final int displaySize = rsmd.getColumnDisplaySize(column + 1);
      metaData.setColumnAttribute (column, MetaAttributeNames.Formatting.NAMESPACE,
              MetaAttributeNames.Formatting.DISPLAY_SIZE, IntegerCache.getInteger(displaySize));
      final int precision = rsmd.getPrecision(column + 1);
      metaData.setColumnAttribute (column, MetaAttributeNames.Numeric.NAMESPACE,
              MetaAttributeNames.Numeric.PRECISION, IntegerCache.getInteger(precision));
      final int scale = rsmd.getScale(column +1);
      metaData.setColumnAttribute (column, MetaAttributeNames.Numeric.NAMESPACE,
              MetaAttributeNames.Numeric.SCALE, IntegerCache.getInteger(scale));
    }
    catch (SQLException sqle)
    {
      // It is non-fatal if the meta-data cannot be read from the result set. Drivers are
      // buggy all the time .. 
    }
}