public class Table_PyramidLevels
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
ATTRIBUTIONTITLE1 |
static java.lang.String |
ATTRIBUTIONURL1 |
static java.lang.String |
AUTHORITY1 |
static java.lang.String |
BBOXXMAX1 |
static java.lang.String |
BBOXXMIN1 |
static java.lang.String |
BBOXYMAX1 |
static java.lang.String |
BBOXYMIN1 |
static java.lang.String |
COLLNAME1 |
static java.lang.String |
COLLNAME2 |
static java.lang.String |
COLLNAME3 |
static java.lang.String |
FEATUREURL1 |
static java.lang.String |
LATLONXMAX1 |
static java.lang.String |
LATLONXMIN1 |
static java.lang.String |
LATLONYMAX1 |
static java.lang.String |
LATLONYMIN1 |
static int |
LEVELID1 |
static int |
LEVELID2 |
static int |
LEVELID3 |
static java.lang.String |
LOGOFORMAT1 |
static int |
LOGOHEIGHT1 |
static java.lang.String |
LOGOURL1 |
static int |
LOGOWIDTH1 |
static MapType |
MAPTYPE1 |
static java.lang.String |
NAME1
main() for standalone testing
|
static double |
RESOLUTION1 |
static double |
SCALEFACTOR1 |
static double |
SCALEFACTOR2 |
static double |
SCALEFACTOR3 |
static java.lang.String |
SRS1 |
static java.lang.String |
TITLE1 |
Constructor and Description |
---|
Table_PyramidLevels()
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 layerId,
int levelId)
delete tuple given by its (unique) id
precondition:
JDBC connection opened
|
void |
deleteTuplesByLayerId(CommanderConnection conn,
int layerId)
delete tuples given by their layer id
precondition:
JDBC connection opened
|
void |
deleteTuplesByLevelId(CommanderConnection conn,
int levelId)
delete tuples given by their level id
precondition:
JDBC connection opened
|
void |
fetchTupleById(CommanderConnection conn,
int lId)
fetch one tuple by its (unique) id (sorted by scale factor), keep in local result set
precondition:
JDBC connection opened
|
void |
fetchTuplesByLayerId(CommanderConnection conn,
int lId)
fetch all styles pertaining to a particular layer, store result locally as a JDBC ResultList
precondition:
JDBC connection opened
|
java.lang.String |
getCollectionName() |
int |
getLayerId() |
int |
getLevelId()
getter methods for attributes.
|
double |
getScaleFactor() |
int |
insertTuple(CommanderConnection conn,
int layerId,
java.lang.String collectionName,
double scaleFactor)
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 levelId,
int layerId,
java.lang.String collectionName,
double scaleFactor)
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 int LEVELID1
public static final java.lang.String COLLNAME1
public static final double SCALEFACTOR1
public static final int LEVELID2
public static final java.lang.String COLLNAME2
public static final double SCALEFACTOR2
public static final int LEVELID3
public static final java.lang.String COLLNAME3
public static final double SCALEFACTOR3
public int insertTuple(CommanderConnection conn, int layerId, java.lang.String collectionName, double scaleFactor) throws java.sql.SQLException, ConnectionFailedException, InvalidInputException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
ConnectionFailedException
InvalidInputException
public void updateTuple(CommanderConnection conn, int levelId, int layerId, java.lang.String collectionName, double scaleFactor) throws java.sql.SQLException, ConnectionFailedException, InvalidInputException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
ConnectionFailedException
InvalidInputException
public void deleteTuple(CommanderConnection conn, int layerId, int levelId) throws java.sql.SQLException, ConnectionFailedException
conn
- JDBC connectionlayerId
- levelId
- 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 deleteTuplesByLevelId(CommanderConnection conn, int levelId) throws java.sql.SQLException, ConnectionFailedException
conn
- JDBC connectionlevelId
- java.sql.SQLException
ConnectionFailedException
public void fetchTupleById(CommanderConnection conn, int lId) throws java.sql.SQLException
conn
- JDBC connectionid
- service tuple idjava.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 boolean isTupleValid()
public int getLevelId()
public int getLayerId()
public java.lang.String getCollectionName()
public double getScaleFactor()
public java.lang.String toString()
toString
in class java.lang.Object
public static void main(java.lang.String[] args)