com.edgeti.VisibilityServer.UsersAndRoles

Class DbTable

java.lang.Object

com.edgeti.VisibilityServer.UsersAndRoles.DbTable

public class DbTable
extends java.lang.Object

Class that manages the conversion of a ResultSet to something more usable.

Author:

phil.feldman

Field Summary

Fields

Modifier and Type	Field and Description
private java.util.List<java.lang.String>	header The header.
private java.util.List<java.util.List<java.lang.String>>	table The table.

Constructor Summary

Constructors

Constructor and Description
DbTable() Instantiates a new db table.
DbTable(java.util.List<java.util.List<java.lang.String>> data) Create a table based on a List> of rows.
DbTable(java.sql.ResultSet rs) Create a table based on a ResultSet.

Method Summary

Methods

Modifier and Type	Method and Description
java.util.List<java.lang.Integer>	getColumnInt(java.lang.String headerName) Get the values of a column as a List given the column name.
java.util.List<java.lang.String>	getColumnNames() Get all the column names.
java.util.List<java.lang.String>	getColumnString(java.lang.String headerName) Get the values of a column as a List given the column name.
java.lang.String	getFirstValue(java.lang.String headerName) Gets the first value in a column indicated by the header.
java.util.List<java.lang.String>	getHeaders() Return the names of all the columns.
java.util.HashMap<java.lang.String,java.lang.Object>	getRowAsKeyVal(int row) Gets the row as Map of key/value pairs.
int	getSize() Return the number of rows in this table.
java.util.List<java.util.List<java.lang.String>>	getTable() Get all the rows.
static DbTable	makeErrorTable(java.lang.String headerMsg, java.lang.String rowMsg) Make a table that contains an error message.
protected void	parseResultSet(java.sql.ResultSet rs) Parse the ResultSet into the table structure.
java.lang.String	toString() Return the entire table as a String.

Methods inherited from class java.lang.Object

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

Field Detail

header

private java.util.List<java.lang.String> header

The header.

table

private java.util.List<java.util.List<java.lang.String>> table

The table.

Constructor Detail

DbTable

public DbTable()

Instantiates a new db table.

DbTable

public DbTable(java.sql.ResultSet rs)

Create a table based on a ResultSet. This will produce a List of column names and a List> of rows

Parameters:

rs - the ResultSet

DbTable

public DbTable(java.util.List<java.util.List<java.lang.String>> data)

Create a table based on a List> of rows.

Parameters:

data - the DbTable

Method Detail

getSize

public int getSize()

Return the number of rows in this table.

Returns:

size

getHeaders

public java.util.List<java.lang.String> getHeaders()

Return the names of all the columns.

Returns:

List of the headers

getTable

public java.util.List<java.util.List<java.lang.String>> getTable()

Get all the rows.

Returns:

the table as a List>

getColumnNames

public java.util.List<java.lang.String> getColumnNames()

Get all the column names.

Returns:

list containing the column names. This is opposed to getHeaders, that returns the meta-data about the table

parseResultSet

protected void parseResultSet(java.sql.ResultSet rs)
                       throws java.sql.SQLException

Parse the ResultSet into the table structure.

Parameters:

rs - the ResultSet

Throws:

java.sql.SQLException - the SQL exception

getColumnString

public java.util.List<java.lang.String> getColumnString(java.lang.String headerName)

Get the values of a column as a List given the column name.

Parameters:

headerName - the header name

Returns:

the column string

getColumnInt

public java.util.List<java.lang.Integer> getColumnInt(java.lang.String headerName)

Get the values of a column as a List given the column name.

Parameters:

headerName - the header name

Returns:

the column List

getFirstValue

public java.lang.String getFirstValue(java.lang.String headerName)

Gets the first value in a column indicated by the header.

Parameters:

headerName - the header name

Returns:

the first value as a String

getRowAsKeyVal

public java.util.HashMap<java.lang.String,java.lang.Object> getRowAsKeyVal(int row)

Gets the row as Map of key/value pairs.

Parameters:

row - the row (0 - size)

Returns:

the row as HashMap

toString

public java.lang.String toString()

Return the entire table as a String.

Overrides:

toString in class java.lang.Object

Returns:

the string

makeErrorTable

public static DbTable makeErrorTable(java.lang.String headerMsg,
                     java.lang.String rowMsg)

Make a table that contains an error message.

Parameters:

headerMsg - the header msg

rowMsg - the row msg

Returns:

the DbTable