cusack.hcg.database

Class TableRow

java.lang.Object

cusack.hcg.database.TableRow

All Implemented Interfaces:

java.io.Serializable

Direct Known Subclasses:

Achievement, GlobalScore, Graph, HighScore, Log, News, PostGameAchievement, Problem, ProblemFamily, Puzzle, SessionUser, Solution, Tutorial, User, UserAchievement, UserAlgorithm

public abstract class TableRow
extends java.lang.Object
implements java.io.Serializable

The Class TableRow. Note: This class has exceptions dealt with by printStackTrace instead of calling the logError method because this class is used on the server as well as client, and things get confusing when code can be called on either. CAC, March 2010.

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor and Description
TableRow() Instantiates a new table row.
TableRow(java.sql.ResultSet rs) Instantiates a new table row using a ResultSet.

Method Summary

Modifier and Type	Method and Description
java.lang.String	getCSVFields(boolean includeReadOnlyFields) Gets the fields of this object in CSV (comma separated value) format.
java.sql.PreparedStatement	insertStatement(java.sql.Connection connection) Insert statement.
java.sql.PreparedStatement	insertStatement(java.sql.Connection connection, java.lang.String tableName) Insert statement.
java.sql.PreparedStatement	selectStatement(java.sql.Connection connection) Select statement.
java.sql.PreparedStatement	selectStatement(java.sql.Connection connection, java.lang.String conditions) Select statement.
java.sql.PreparedStatement	updateStatement(java.sql.Connection connection) Update statement.
java.sql.PreparedStatement	updateStatement(java.sql.Connection connection, java.lang.String condition) Update statement.
java.sql.PreparedStatement	updateStatement(java.sql.Connection connection, java.lang.String tableName, java.lang.String condition) Update statement.

Methods inherited from class java.lang.Object

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

Constructor Detail

TableRow

public TableRow()

Instantiates a new table row.

TableRow

public TableRow(java.sql.ResultSet rs)

Instantiates a new table row using a ResultSet. This constructor finds visible fields in the object that are (That are what? CAC. January, 2010)

Parameters:

rs - the rs

Method Detail

getCSVFields

public java.lang.String getCSVFields(boolean includeReadOnlyFields)

Gets the fields of this object in CSV (comma separated value) format.

Parameters:

includeReadOnlyFields - TODO

Returns:

the CS fields

insertStatement

public java.sql.PreparedStatement insertStatement(java.sql.Connection connection)
                                           throws java.sql.SQLException

Insert statement.

Parameters:

connection - the connection

Returns:

the prepared statement

Throws:

java.sql.SQLException - the SQL exception

insertStatement

public java.sql.PreparedStatement insertStatement(java.sql.Connection connection,
                                                  java.lang.String tableName)
                                           throws java.sql.SQLException

Insert statement.

Parameters:

connection - the connection

tableName - the table name

Returns:

the prepared statement

Throws:

java.sql.SQLException - the SQL exception

selectStatement

public java.sql.PreparedStatement selectStatement(java.sql.Connection connection)
                                           throws java.sql.SQLException

Select statement.

Parameters:

connection - the connection

Returns:

the prepared statement

Throws:

java.sql.SQLException - the SQL exception

selectStatement

public java.sql.PreparedStatement selectStatement(java.sql.Connection connection,
                                                  java.lang.String conditions)
                                           throws java.sql.SQLException

Select statement.

Parameters:

connection - the connection

conditions - the conditions

Returns:

the prepared statement

Throws:

java.sql.SQLException - the SQL exception

updateStatement

public java.sql.PreparedStatement updateStatement(java.sql.Connection connection)
                                           throws java.sql.SQLException

Update statement.

Parameters:

connection - the connection

Returns:

the prepared statement

Throws:

java.sql.SQLException - the SQL exception

updateStatement

public java.sql.PreparedStatement updateStatement(java.sql.Connection connection,
                                                  java.lang.String condition)
                                           throws java.sql.SQLException

Update statement.

Parameters:

connection - the connection

condition - the condition

Returns:

the prepared statement

Throws:

java.sql.SQLException - the SQL exception

updateStatement

public java.sql.PreparedStatement updateStatement(java.sql.Connection connection,
                                                  java.lang.String tableName,
                                                  java.lang.String condition)
                                           throws java.sql.SQLException

Update statement.

Parameters:

connection - the connection

tableName - the table name

condition - the condition

Returns:

the prepared statement

Throws:

java.sql.SQLException - the SQL exception