public class Table_Style
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
ABSTRACT1 |
static java.lang.String |
ABSTRACT2 |
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 |
FEATUREURL1 |
static java.lang.String |
LATLONXMAX1 |
static java.lang.String |
LATLONXMIN1 |
static java.lang.String |
LATLONYMAX1 |
static java.lang.String |
LATLONYMIN1 |
static java.lang.String |
LAYERID1 |
static java.lang.String |
LAYERID2 |
static int |
LEGENDHEIGHT1 |
static int |
LEGENDHEIGHT2 |
static java.lang.String |
LEGENDURL1 |
static java.lang.String |
LEGENDURL2 |
static int |
LEGENDWIDTH1 |
static int |
LEGENDWIDTH2 |
static java.lang.String |
LNAME1
main() for standalone testing
|
static java.lang.String |
LOGOFORMAT1 |
static int |
LOGOHEIGHT1 |
static java.lang.String |
LOGOURL1 |
static int |
LOGOWIDTH1 |
static java.lang.String |
LTITLE1 |
static MapType |
MAPTYPE1 |
static java.lang.String |
NAME1 |
static java.lang.String |
NAME2 |
static java.lang.String |
RASQLOP1 |
static java.lang.String |
RASQLOP2 |
static double |
RESOLUTION1 |
static java.lang.String |
SHEETURL1 |
static java.lang.String |
SHEETURL2 |
static java.lang.String |
SRS1 |
static java.lang.String |
STYLEID1 |
static java.lang.String |
STYLEID2 |
static java.lang.String |
TITLE1 |
static java.lang.String |
TITLE2 |
Constructor and Description |
---|
Table_Style()
constructor
|
Modifier and Type | Method and Description |
---|---|
void |
deleteTuple(CommanderConnection conn,
int styleId,
int layerId)
delete tuple given by its (unique) id
precondition:
JDBC connection opened
|
void |
deleteTuplesByLayerId(CommanderConnection conn,
int layerId)
delete tuple set given by its layer 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 |
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 |
getAbstract() |
int |
getLayerId() |
int |
getLegendHeight() |
java.lang.String |
getLegendURL() |
int |
getLegendWidth() |
java.lang.String |
getName() |
java.lang.String |
getRasqlOp() |
java.lang.String |
getSheetURL() |
int |
getStyleId()
getter methods for attributes.
|
java.lang.String |
getTitle() |
int |
insertTuple(CommanderConnection conn,
int layerId,
java.lang.String name,
java.lang.String title,
java.lang.String abstractText,
int legendWidth,
int legendHeight,
java.lang.String legendURL,
java.lang.String sheetURL,
java.lang.String rasqlOp)
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 styleId,
int layerId,
java.lang.String name,
java.lang.String title,
java.lang.String abstractText,
int legendWidth,
int legendHeight,
java.lang.String legendURL,
java.lang.String sheetURL,
java.lang.String rasqlOp)
update tuple from all parameters passed.
|
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 STYLEID1
public static final java.lang.String LAYERID1
public static final java.lang.String NAME1
public static final java.lang.String TITLE1
public static final java.lang.String ABSTRACT1
public static final int LEGENDWIDTH1
public static final int LEGENDHEIGHT1
public static final java.lang.String LEGENDURL1
public static final java.lang.String SHEETURL1
public static final java.lang.String RASQLOP1
public static final java.lang.String STYLEID2
public static final java.lang.String LAYERID2
public static final java.lang.String NAME2
public static final java.lang.String TITLE2
public static final java.lang.String ABSTRACT2
public static final int LEGENDWIDTH2
public static final int LEGENDHEIGHT2
public static final java.lang.String LEGENDURL2
public static final java.lang.String SHEETURL2
public static final java.lang.String RASQLOP2
public int insertTuple(CommanderConnection conn, int layerId, java.lang.String name, java.lang.String title, java.lang.String abstractText, int legendWidth, int legendHeight, java.lang.String legendURL, java.lang.String sheetURL, java.lang.String rasqlOp) throws java.sql.SQLException, ConnectionFailedException, InvalidInputException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
ConnectionFailedException
InvalidInputException
public void updateTuple(CommanderConnection conn, int styleId, int layerId, java.lang.String name, java.lang.String title, java.lang.String abstractText, int legendWidth, int legendHeight, java.lang.String legendURL, java.lang.String sheetURL, java.lang.String rasqlOp) throws java.sql.SQLException, ConnectionFailedException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
ConnectionFailedException
public void deleteTuple(CommanderConnection conn, int styleId, int layerId) throws java.sql.SQLException, ConnectionFailedException
conn
- JDBC connectionstyleId
- layerId
- java.sql.SQLException
ConnectionFailedException
public void deleteTuplesByLayerId(CommanderConnection conn, int layerId) throws java.sql.SQLException, ConnectionFailedException
conn
- JDBC connectionlayerId
- layer identifierjava.sql.SQLException
ConnectionFailedException
public void fetchAllTuples(CommanderConnection conn) 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 boolean isTupleValid()
public int getStyleId()
public int getLayerId()
public java.lang.String getName()
public java.lang.String getTitle()
public java.lang.String getAbstract()
public int getLegendWidth()
public int getLegendHeight()
public java.lang.String getLegendURL()
public java.lang.String getSheetURL()
public java.lang.String getRasqlOp()
public java.lang.String toString()
toString
in class java.lang.Object
public static void main(java.lang.String[] args)