public class Table_Layer
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
ATTRIBUTIONTITLE1 |
static java.lang.String |
ATTRIBUTIONTITLE2 |
static java.lang.String |
ATTRIBUTIONTITLE3 |
static java.lang.String |
ATTRIBUTIONURL1 |
static java.lang.String |
ATTRIBUTIONURL2 |
static java.lang.String |
ATTRIBUTIONURL3 |
static java.lang.String |
AUTHORITY1 |
static java.lang.String |
AUTHORITY2 |
static java.lang.String |
AUTHORITY3 |
static java.lang.String |
BBOXXMAX1 |
static java.lang.String |
BBOXXMAX2 |
static java.lang.String |
BBOXXMAX3 |
static java.lang.String |
BBOXXMIN1 |
static java.lang.String |
BBOXXMIN2 |
static java.lang.String |
BBOXXMIN3 |
static java.lang.String |
BBOXYMAX1 |
static java.lang.String |
BBOXYMAX2 |
static java.lang.String |
BBOXYMAX3 |
static java.lang.String |
BBOXYMIN1 |
static java.lang.String |
BBOXYMIN2 |
static java.lang.String |
BBOXYMIN3 |
static java.lang.String |
FEATUREURL1 |
static java.lang.String |
FEATUREURL2 |
static java.lang.String |
FEATUREURL3 |
static java.lang.String |
LATLONXMAX1 |
static java.lang.String |
LATLONXMAX2 |
static java.lang.String |
LATLONXMAX3 |
static java.lang.String |
LATLONXMIN1 |
static java.lang.String |
LATLONXMIN2 |
static java.lang.String |
LATLONXMIN3 |
static java.lang.String |
LATLONYMAX1 |
static java.lang.String |
LATLONYMAX2 |
static java.lang.String |
LATLONYMAX3 |
static java.lang.String |
LATLONYMIN1 |
static java.lang.String |
LATLONYMIN2 |
static java.lang.String |
LATLONYMIN3 |
static java.lang.String |
LOGOFORMAT1 |
static java.lang.String |
LOGOFORMAT2 |
static java.lang.String |
LOGOFORMAT3 |
static int |
LOGOHEIGHT1 |
static int |
LOGOHEIGHT2 |
static int |
LOGOHEIGHT3 |
static java.lang.String |
LOGOURL1 |
static java.lang.String |
LOGOURL2 |
static java.lang.String |
LOGOURL3 |
static int |
LOGOWIDTH1 |
static int |
LOGOWIDTH2 |
static int |
LOGOWIDTH3 |
static MapType |
MAPTYPE1 |
static MapType |
MAPTYPE2 |
static MapType |
MAPTYPE3 |
static java.lang.String |
NAME1
main() for standalone testing
|
static java.lang.String |
NAME2 |
static java.lang.String |
NAME3 |
static double |
RESOLUTION1 |
static double |
RESOLUTION2 |
static double |
RESOLUTION3 |
static java.lang.String |
SRS1 |
static java.lang.String |
SRS2 |
static java.lang.String |
SRS3 |
static java.lang.String |
TITLE1 |
static java.lang.String |
TITLE2 |
static java.lang.String |
TITLE3 |
Constructor and Description |
---|
Table_Layer()
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 id)
delete tuple given by its (unique) 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 id)
fetch one tuple by its (unique) id, keep in local result set
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
|
java.lang.String |
getAttributionTitle() |
java.lang.String |
getAttributionURL() |
java.lang.String |
getAuthority() |
java.lang.String |
getBBoxXmax() |
java.lang.String |
getBBoxXmin() |
java.lang.String |
getBBoxYmax() |
java.lang.String |
getBBoxYmin() |
java.lang.String |
getFeatureURL() |
java.lang.String |
getLatLonBoxXmax() |
java.lang.String |
getLatLonBoxXmin() |
java.lang.String |
getLatLonBoxYmax() |
java.lang.String |
getLatLonBoxYmin() |
int |
getLayerId()
getter methods for attributes.
|
java.lang.String |
getLogoFormat() |
int |
getLogoHeight() |
java.lang.String |
getLogoURL() |
int |
getLogoWidth() |
MapType |
getMapType() |
java.lang.String |
getName() |
double |
getResolution() |
java.lang.String |
getSrs() |
java.lang.String |
getTitle() |
int |
insertTuple(CommanderConnection conn,
java.lang.String name,
java.lang.String title,
java.lang.String srs,
java.lang.String authority,
java.lang.String latLonBoxXmin,
java.lang.String latLonBoxXmax,
java.lang.String latLonBoxYmin,
java.lang.String latLonBoxYmax,
java.lang.String bBoxXmin,
java.lang.String bBoxXmax,
java.lang.String bBoxYmin,
java.lang.String bBoxYmax,
java.lang.String attributionURL,
java.lang.String attributionTitle,
int logoWidth,
int logoHeight,
java.lang.String logoFormat,
java.lang.String logoURL,
java.lang.String featureURL,
double resolution,
MapType mapType)
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) |
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 layerId,
java.lang.String name,
java.lang.String title,
java.lang.String srs,
java.lang.String authority,
java.lang.String latLonBoxXmin,
java.lang.String latLonBoxXmax,
java.lang.String latLonBoxYmin,
java.lang.String latLonBoxYmax,
java.lang.String bBoxXmin,
java.lang.String bBoxXmax,
java.lang.String bBoxYmin,
java.lang.String bBoxYmax,
java.lang.String attributionURL,
java.lang.String attributionTitle,
int logoWidth,
int logoHeight,
java.lang.String logoFormat,
java.lang.String logoURL,
java.lang.String featureURL,
double resolution,
MapType mapType)
update tuple from all parameters passed.
|
public static final java.lang.String NAME1
public static final java.lang.String TITLE1
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 NAME2
public static final java.lang.String TITLE2
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 java.lang.String NAME3
public static final java.lang.String TITLE3
public static final java.lang.String SRS3
public static final java.lang.String AUTHORITY3
public static final java.lang.String LATLONXMIN3
public static final java.lang.String LATLONXMAX3
public static final java.lang.String LATLONYMIN3
public static final java.lang.String LATLONYMAX3
public static final java.lang.String BBOXXMIN3
public static final java.lang.String BBOXXMAX3
public static final java.lang.String BBOXYMIN3
public static final java.lang.String BBOXYMAX3
public static final java.lang.String ATTRIBUTIONURL3
public static final java.lang.String ATTRIBUTIONTITLE3
public static final int LOGOWIDTH3
public static final int LOGOHEIGHT3
public static final java.lang.String LOGOFORMAT3
public static final java.lang.String LOGOURL3
public static final java.lang.String FEATUREURL3
public static final double RESOLUTION3
public static final MapType MAPTYPE3
public int insertTuple(CommanderConnection conn, java.lang.String name, java.lang.String title, java.lang.String srs, java.lang.String authority, java.lang.String latLonBoxXmin, java.lang.String latLonBoxXmax, java.lang.String latLonBoxYmin, java.lang.String latLonBoxYmax, java.lang.String bBoxXmin, java.lang.String bBoxXmax, java.lang.String bBoxYmin, java.lang.String bBoxYmax, java.lang.String attributionURL, java.lang.String attributionTitle, int logoWidth, int logoHeight, java.lang.String logoFormat, java.lang.String logoURL, java.lang.String featureURL, double resolution, MapType mapType) throws java.sql.SQLException, ConnectionFailedException, InvalidInputException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
ConnectionFailedException
InvalidInputException
public void updateTuple(CommanderConnection conn, int layerId, java.lang.String name, java.lang.String title, java.lang.String srs, java.lang.String authority, java.lang.String latLonBoxXmin, java.lang.String latLonBoxXmax, java.lang.String latLonBoxYmin, java.lang.String latLonBoxYmax, java.lang.String bBoxXmin, java.lang.String bBoxXmax, java.lang.String bBoxYmin, java.lang.String bBoxYmax, java.lang.String attributionURL, java.lang.String attributionTitle, int logoWidth, int logoHeight, java.lang.String logoFormat, java.lang.String logoURL, java.lang.String featureURL, double resolution, MapType mapType) throws java.sql.SQLException, ConnectionFailedException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
ConnectionFailedException
public void deleteTuple(CommanderConnection conn, int id) throws java.sql.SQLException, ConnectionFailedException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
ConnectionFailedException
public void fetchTupleById(CommanderConnection conn, int id) throws java.sql.SQLException, InvalidInputException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
InvalidInputException
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 boolean next() throws java.sql.SQLException
java.sql.SQLException
public void close() throws java.sql.SQLException
java.sql.SQLException
public boolean isTupleValid()
public int getLayerId()
public java.lang.String getName()
public java.lang.String getTitle()
public java.lang.String getSrs()
public java.lang.String getAuthority()
public java.lang.String getLatLonBoxXmin()
public java.lang.String getLatLonBoxXmax()
public java.lang.String getLatLonBoxYmin()
public java.lang.String getLatLonBoxYmax()
public java.lang.String getBBoxXmin()
public java.lang.String getBBoxXmax()
public java.lang.String getBBoxYmin()
public java.lang.String getBBoxYmax()
public java.lang.String getAttributionURL()
public java.lang.String getAttributionTitle()
public int getLogoWidth()
public int getLogoHeight()
public java.lang.String getLogoFormat()
public java.lang.String getLogoURL()
public java.lang.String getFeatureURL()
public double getResolution()
public MapType getMapType()
public java.lang.String toString()
toString
in class java.lang.Object
public static void main(java.lang.String[] args)