org.salespointframework.core.data.database
Class PersistenceManager.CachedResultSet

java.lang.Object
  org.salespointframework.core.data.database.PersistenceManager.CachedResultSet

Enclosing class:

PersistenceManager

static class PersistenceManager.CachedResultSet
extends java.lang.Object

this class cahches ResultSets in performance mode to decrease query count

Since:

4.0

Author:

Thomas Kissinger

Field Summary

(package private) java.util.Map<java.lang.String,java.lang.Integer>	cols column -> label mapping
(package private) int	cursor cursor pointing to current record
(package private) java.util.ArrayList<java.util.List<java.lang.Object>>	data datas
(package private) java.util.ArrayList<java.lang.String>	rCols columns

Constructor Summary

PersistenceManager.CachedResultSet(java.sql.ResultSet rs)
default constructor

Method Summary

int	getColumnCount() get number of columns
java.lang.String	getColumnName(int i) get column name by index
java.lang.Object	getObject(int i) get object by index
java.lang.Object	getObject(java.lang.String name) get object by label
java.lang.String	getString(int i) get value of column with index i
java.lang.String	getString(java.lang.String name) get string by label
boolean	next(java.lang.String col, java.lang.Object val) moves the cursor to the next record which matches

Methods inherited from class java.lang.Object

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

Field Detail

data

java.util.ArrayList<java.util.List<java.lang.Object>> data

datas

cols

java.util.Map<java.lang.String,java.lang.Integer> cols

column -> label mapping

rCols

java.util.ArrayList<java.lang.String> rCols

columns

cursor

int cursor

cursor pointing to current record

Constructor Detail

PersistenceManager.CachedResultSet

public PersistenceManager.CachedResultSet(java.sql.ResultSet rs)

default constructor

Parameters:

rs - resultset to cache

Method Detail

next

public boolean next(java.lang.String col,
                    java.lang.Object val)

moves the cursor to the next record which matches

Parameters:

col - column to match

val - value to match

Returns:

true if match was found

getString

public java.lang.String getString(int i)

get value of column with index i

Parameters:

i - index

Returns:

value

getString

public java.lang.String getString(java.lang.String name)
                           throws java.sql.SQLException

get string by label

Parameters:

name - label

Returns:

value

Throws:

java.sql.SQLException - if label not found

getObject

public java.lang.Object getObject(java.lang.String name)
                           throws java.sql.SQLException

get object by label

Parameters:

name - label

Returns:

value

Throws:

java.sql.SQLException - if label was not found

getObject

public java.lang.Object getObject(int i)

get object by index

Parameters:

i - index

Returns:

value

getColumnCount

public int getColumnCount()

get number of columns

Returns:

getColumnName

public java.lang.String getColumnName(int i)

get column name by index

Parameters:

i - index

Returns:

column label