grs.pds
Class TimeQuery

java.lang.Object
  |
  +--grs.pds.TimeQuery

public abstract class TimeQuery

extends Object

Abstract Base class for time-range constrained SQL queries. Contains static method for determining appropriate schema.

Version:

$Revision: 1.1.1.1 $

Author:

$Author: guym $

Field Summary

static long	TIME_OF_LCH
static long	TIME_OF_MAP
static long	TIME_OF_MOI

Constructor Summary

TimeQuery(Connection conn)
Set the Connection.

TimeQuery(Connection conn, String type)
Set the Connection.

Method Summary

static String	getSchema(long sctime) We now have different schemas for each mission phase.
abstract int	query(long start, long stop) Subclasses will provide this method implementation.
int	query(String utc0, String utc1)

Methods inherited from class java.lang.Object

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

Field Detail

TIME_OF_LCH

public static final long TIME_OF_LCH

See Also:

Constant Field Values

TIME_OF_MOI

public static final long TIME_OF_MOI

See Also:

Constant Field Values

TIME_OF_MAP

public static final long TIME_OF_MAP

See Also:

Constant Field Values

Constructor Detail

TimeQuery

public TimeQuery(Connection conn)

Set the Connection.

Parameters:

conn - JDBC Connection to our Oracle database.

TimeQuery

public TimeQuery(Connection conn,
                 String type)

Set the Connection.

Parameters:

conn - JDBC Connection to our Oracle database.

Method Detail

getSchema

public static String getSchema(long sctime)

We now have different schemas for each mission phase. Given a time, this will tell you which schema to use.

Parameters:

sctime - Spacecraft clock ticks

Returns:

Name of schema.

query

public int query(String utc0,
                 String utc1)
          throws IOException,
                 SQLException,
                 SpiceException

IOException

SQLException

SpiceException

query

public abstract int query(long start,
                          long stop)
                   throws IOException,
                          SQLException

Subclasses will provide this method implementation. Should return the number of rows selected.

IOException

SQLException