public class SQL
extends java.lang.Object
Modifier and Type | Class and Description |
---|---|
static class |
SQL.Order
Possible ordering
|
Constructor and Description |
---|
SQL() |
Modifier and Type | Method and Description |
---|---|
protected void |
bind(java.sql.PreparedStatement pstmt,
Constraint constraint,
Column field)
Bind a constraint
|
static java.lang.Object |
get(java.sql.ResultSet rs,
Column col)
Get the result for a column from a result set.
|
static java.sql.Date |
getDate(java.sql.ResultSet rs,
Column col)
Get a date field from a result set.
|
static double |
getDouble(java.sql.ResultSet rs,
Column col)
Get a double field from a result set
|
static float |
getFloat(java.sql.ResultSet rs,
Column col)
Get a float field from a result set
|
static int |
getInt(java.sql.ResultSet rs,
Column col)
Get an integer field from a result set
|
static int |
getInteger(java.sql.ResultSet rs,
Column col)
Get an integer field from a result set
|
static long |
getLong(java.sql.ResultSet rs,
Column col)
Get a long integer field from a result set
|
static short |
getShort(java.sql.ResultSet rs,
Column col)
Get a short integer field from a result set
|
static java.lang.String |
getString(java.sql.ResultSet rs,
Column col)
Get a String field from a result set
|
static java.sql.Timestamp |
getTimestamp(java.sql.ResultSet rs,
Column col)
Get a timestamp field from a result set.
|
protected void bind(java.sql.PreparedStatement pstmt, Constraint constraint, Column field) throws java.sql.SQLException
pstmt
- The statementconstraint
- The constraintfield
- The fieldjava.sql.SQLException
- Failed to bindpublic static int getInteger(java.sql.ResultSet rs, Column col) throws java.sql.SQLException
rs
- query resultcol
- columnjava.sql.SQLException
- retrieval failedpublic static java.lang.String getString(java.sql.ResultSet rs, Column col) throws java.sql.SQLException
rs
- query resultcol
- columnjava.sql.SQLException
- retrieval failedpublic static short getShort(java.sql.ResultSet rs, Column col) throws java.sql.SQLException
rs
- query resultcol
- columnjava.sql.SQLException
- retrieval failedpublic static int getInt(java.sql.ResultSet rs, Column col) throws java.sql.SQLException
rs
- query resultcol
- columnjava.sql.SQLException
- retrieval failedpublic static long getLong(java.sql.ResultSet rs, Column col) throws java.sql.SQLException
rs
- query resultcol
- columnjava.sql.SQLException
- retrieval failedpublic static float getFloat(java.sql.ResultSet rs, Column col) throws java.sql.SQLException
rs
- query resultcol
- columnjava.sql.SQLException
- retrieval failedpublic static double getDouble(java.sql.ResultSet rs, Column col) throws java.sql.SQLException
rs
- query resultcol
- columnjava.sql.SQLException
- retrieval failedpublic static java.sql.Date getDate(java.sql.ResultSet rs, Column col)
rs
- query resultcol
- columnpublic static java.sql.Timestamp getTimestamp(java.sql.ResultSet rs, Column col)
rs
- query resultcol
- columnpublic static java.lang.Object get(java.sql.ResultSet rs, Column col) throws java.sql.SQLException
rs
- The resultcol
- The columnjava.sql.SQLException
- Could not get a valueCopyright \ (C) Arizona Board of Regents on behalf of the \ Planetary Image Research Laboratory, Lunar and \ Planetary Laboratory at the University of Arizona