|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectuk.ac.starlink.ttools.cone.ConeSelector
public abstract class ConeSelector
Abstract class for an object which can make a JDBC SELECT query corresponding to cone searches.
Constructor Summary | |
---|---|
protected |
ConeSelector(Connection connection,
String tableName,
String raCol,
String decCol,
AngleUnits units,
String cols,
String where)
Constructor. |
Method Summary | |
---|---|
static ConeSelector |
createSelector(Connection connection,
String tableName,
String raCol,
String decCol,
AngleUnits units,
String cols,
String where,
boolean usePrepared)
Returns a new selector object which just queries on RA and Dec values. |
static ConeSelector |
createTiledSelector(Connection connection,
String tableName,
String raCol,
String decCol,
AngleUnits units,
String cols,
String where,
String tileCol,
SkyTiling tiling,
boolean usePrepared)
Returns a new selector object which queries using RA, Dec and a spatial tiling value. |
abstract ResultSet |
executeQuery(double ra,
double dec,
double sr)
Returns an SQL ResultSet containing the records corresponding to a cone search with the given parameters. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
protected ConeSelector(Connection connection, String tableName, String raCol, String decCol, AngleUnits units, String cols, String where) throws SQLException
connection
- live connection to databasetableName
- name of a table in the database to searchraCol
- name of table column containing right ascensiondecCol
- name of table column containing declinationunits
- angular units used by ra and dec columnscols
- list of column names for the SELECT statementwhere
- additional WHERE clause constraints
SQLException
Method Detail |
---|
public abstract ResultSet executeQuery(double ra, double dec, double sr) throws SQLException
ra
- right ascension of cone centre in degreesdec
- declination of cone centre in degreessr
- search radius of cone in degrees
SQLException
public static ConeSelector createSelector(Connection connection, String tableName, String raCol, String decCol, AngleUnits units, String cols, String where, boolean usePrepared) throws SQLException
PreparedStatement
s or not - there may be (big)
performance implications.
connection
- live connection to databasetableName
- name of a table in the database to searchraCol
- name of table column containing right ascensiondecCol
- name of table column containing declinationunits
- angular units used by ra and dec columnscols
- list of column names for the SELECT statementwhere
- additional WHERE clause constraintsusePrepared
- true to use JDBC PreparedStatement
s,
false for normal Statement
s
SQLException
public static ConeSelector createTiledSelector(Connection connection, String tableName, String raCol, String decCol, AngleUnits units, String cols, String where, String tileCol, SkyTiling tiling, boolean usePrepared) throws SQLException
PreparedStatement
s or not - there may be (big)
performance implications.
connection
- live connection to databasetableName
- name of a table in the database to searchraCol
- name of table column containing right ascensiondecCol
- name of table column containing declinationunits
- angular units used by ra and dec columnscols
- list of column names for the SELECT statementwhere
- additional WHERE clause constraintstileCol
- column containing a sky tiling index valuetiling
- tiling scheme used by tileCol columnusePrepared
- true to use JDBC PreparedStatement
s,
false for normal Statement
s
SQLException
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |