public class Table_ServiceLayer
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
ATTRIBUTIONTITLE1 |
static java.lang.String |
ATTRIBUTIONTITLE2 |
static java.lang.String |
ATTRIBUTIONURL1 |
static java.lang.String |
ATTRIBUTIONURL2 |
static java.lang.String |
AUTHORITY1 |
static java.lang.String |
AUTHORITY2 |
static java.lang.String |
BBOXXMAX1 |
static java.lang.String |
BBOXXMAX2 |
static java.lang.String |
BBOXXMIN1 |
static java.lang.String |
BBOXXMIN2 |
static java.lang.String |
BBOXYMAX1 |
static java.lang.String |
BBOXYMAX2 |
static java.lang.String |
BBOXYMIN1 |
static java.lang.String |
BBOXYMIN2 |
static java.lang.String |
FEATUREURL1 |
static java.lang.String |
FEATUREURL2 |
static java.lang.String |
LATLONXMAX1 |
static java.lang.String |
LATLONXMAX2 |
static java.lang.String |
LATLONXMIN1 |
static java.lang.String |
LATLONXMIN2 |
static java.lang.String |
LATLONYMAX1 |
static java.lang.String |
LATLONYMAX2 |
static java.lang.String |
LATLONYMIN1 |
static java.lang.String |
LATLONYMIN2 |
static java.lang.String |
LNAME1 |
static java.lang.String |
LNAME2 |
static java.lang.String |
LOGOFORMAT1 |
static java.lang.String |
LOGOFORMAT2 |
static int |
LOGOHEIGHT1 |
static int |
LOGOHEIGHT2 |
static java.lang.String |
LOGOURL1 |
static java.lang.String |
LOGOURL2 |
static int |
LOGOWIDTH1 |
static int |
LOGOWIDTH2 |
static java.lang.String |
LTITLE1 |
static java.lang.String |
LTITLE2 |
static MapType |
MAPTYPE1 |
static MapType |
MAPTYPE2 |
static double |
RESOLUTION1 |
static double |
RESOLUTION2 |
static int |
SEQ1 |
static int |
SEQ2 |
static java.lang.String |
SRS1 |
static java.lang.String |
SRS2 |
Constructor and Description |
---|
Table_ServiceLayer()
constructor
|
Modifier and Type | Method and Description |
---|---|
void |
close()
close current result set, discarding all items in result set and local tuple variables
precondition:
successful call to fetchTuple()
|
void |
deleteTuple(CommanderConnection conn,
int serviceId,
int layerId)
delete tuple given by its (service,layer) id
precondition:
JDBC connection opened
|
void |
deleteTuplesByLayerId(CommanderConnection conn,
int layerId)
delete tuple given by its layer id
precondition:
JDBC connection opened
|
void |
deleteTuplesByServiceId(CommanderConnection conn,
int serviceId)
delete tuple given by its service id
precondition:
JDBC connection opened
|
void |
fetchAllTuples(CommanderConnection conn)
fetch all tuples from table, store result locally as a JDBC ResultList
precondition:
JDBC connection opened
|
void |
fetchTupleById(CommanderConnection conn,
int serviceId,
int layerId)
fetch one tuple by its (service,layer) id, keep in local result set
precondition:
JDBC connection opened
|
void |
fetchTuplesByLayerId(CommanderConnection conn,
int lId)
fetch (singleton) service pertaining to a particular layer, store result locally as a JDBC ResultList
precondition:
JDBC connection opened
|
void |
fetchTuplesByServiceId(CommanderConnection conn,
int sId)
fetch all layers pertaining to a particular service, store result locally as a JDBC ResultList
precondition:
JDBC connection opened
|
int |
getLayerId() |
int |
getLayerSeq() |
int |
getServiceId()
getter methods for attributes.
|
void |
insertTuple(CommanderConnection conn,
int serviceId,
int layerId,
int layerSeq)
insert one tuple; instance's local attribute set is not modified.
|
boolean |
isTupleValid()
is current tuple valid, ie, has there been a fetch before?
precondition:
successful call of fetchTuple
|
static void |
main(java.lang.String[] args) |
int |
newSeqNo(CommanderConnection conn,
int serviceId)
find a layer seq number for appending at the end (ie, larger than any existing)
|
boolean |
next()
cursor over result set of previous fetchAllTuples()
if successful, the tuple variables are set with the current fetch values
|
java.lang.String |
toString()
Method toString
|
void |
updateTuple(CommanderConnection conn,
int serviceId,
int layerId,
int layerSeq)
update (service,layer) tuple with seq#
null strings will be set to ""
precondition:
JDBC connection opened
tuple with id exists
|
public static final java.lang.String LNAME1
public static final java.lang.String LTITLE1
public static final java.lang.String SRS1
public static final java.lang.String AUTHORITY1
public static final java.lang.String LATLONXMIN1
public static final java.lang.String LATLONXMAX1
public static final java.lang.String LATLONYMIN1
public static final java.lang.String LATLONYMAX1
public static final java.lang.String BBOXXMIN1
public static final java.lang.String BBOXXMAX1
public static final java.lang.String BBOXYMIN1
public static final java.lang.String BBOXYMAX1
public static final java.lang.String ATTRIBUTIONURL1
public static final java.lang.String ATTRIBUTIONTITLE1
public static final int LOGOWIDTH1
public static final int LOGOHEIGHT1
public static final java.lang.String LOGOFORMAT1
public static final java.lang.String LOGOURL1
public static final java.lang.String FEATUREURL1
public static final double RESOLUTION1
public static final MapType MAPTYPE1
public static final java.lang.String LNAME2
public static final java.lang.String LTITLE2
public static final java.lang.String SRS2
public static final java.lang.String AUTHORITY2
public static final java.lang.String LATLONXMIN2
public static final java.lang.String LATLONXMAX2
public static final java.lang.String LATLONYMIN2
public static final java.lang.String LATLONYMAX2
public static final java.lang.String BBOXXMIN2
public static final java.lang.String BBOXXMAX2
public static final java.lang.String BBOXYMIN2
public static final java.lang.String BBOXYMAX2
public static final java.lang.String ATTRIBUTIONURL2
public static final java.lang.String ATTRIBUTIONTITLE2
public static final int LOGOWIDTH2
public static final int LOGOHEIGHT2
public static final java.lang.String LOGOFORMAT2
public static final java.lang.String LOGOURL2
public static final java.lang.String FEATUREURL2
public static final double RESOLUTION2
public static final MapType MAPTYPE2
public static final int SEQ1
public static final int SEQ2
public void insertTuple(CommanderConnection conn, int serviceId, int layerId, int layerSeq) throws java.sql.SQLException, ConnectionFailedException, InvalidInputException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
ConnectionFailedException
InvalidInputException
public void updateTuple(CommanderConnection conn, int serviceId, int layerId, int layerSeq) throws java.sql.SQLException, ConnectionFailedException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
ConnectionFailedException
public void deleteTuple(CommanderConnection conn, int serviceId, int layerId) throws java.sql.SQLException, ConnectionFailedException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
ConnectionFailedException
public void deleteTuplesByServiceId(CommanderConnection conn, int serviceId) throws java.sql.SQLException, ConnectionFailedException
conn
- JDBC connectionserviceId
- java.sql.SQLException
ConnectionFailedException
public void deleteTuplesByLayerId(CommanderConnection conn, int layerId) throws java.sql.SQLException, ConnectionFailedException
conn
- JDBC connectionlayerId
- java.sql.SQLException
ConnectionFailedException
public void fetchTupleById(CommanderConnection conn, int serviceId, int layerId) throws java.sql.SQLException
conn
- JDBC connectionid
- service tuple idSQLException,
- InvalidInputExceptionjava.sql.SQLException
public void fetchAllTuples(CommanderConnection conn) throws java.sql.SQLException
conn
- JDBC connectionjava.sql.SQLException
public void fetchTuplesByServiceId(CommanderConnection conn, int sId) throws java.sql.SQLException
conn
- JDBC connectionjava.sql.SQLException
public void fetchTuplesByLayerId(CommanderConnection conn, int lId) throws java.sql.SQLException
conn
- JDBC connectionjava.sql.SQLException
public boolean next() throws java.sql.SQLException
java.sql.SQLException
public void close() throws java.sql.SQLException
java.sql.SQLException
public int newSeqNo(CommanderConnection conn, int serviceId) throws java.lang.Exception
java.lang.Exception
public boolean isTupleValid()
public int getServiceId()
public int getLayerId()
public int getLayerSeq()
public java.lang.String toString()
toString
in class java.lang.Object
public static void main(java.lang.String[] args)