Java Reference
In-Depth Information
ResultSetMetaData rsmd
#
rs.getMetaData();
String name
#
"";
String type
#
"";
String value
#
"";
DBValueRecord record
#
new
DBValueRecord();
if
(rs.next())
for
(
int
i
#
1; i <
#
rsmd.getColumnCount(); i
!!
) {
name
#
rsmd.getColumnName(i);
type
#
rsmd.getColumnTypeName(i);
if
(type.equals("COUNTER"))
value
#
""
!
rs.getLong(name);
else if
(type.equals("VARCHAR"))
value
#
rs.getString(name);
record.addElement(name, type, value);
}
return
record;
}
catch
(Exception e) {e.printStackTrace();}
return null
;
}
}
15.5.4
Test
The test cases should verify two fundamental requirements, namely correct-
ness and completeness of data retrieval from the GIS database and from the
thematic databases. The data linker behaves correctly when it allows an
association of a geographic entity with a selected record extracted from a
thematic database. The data linker should therefore allow the user to browse
the GIS database and all the available thematic databases.
The associations between geographic entities and data records are
recorded in an XML file. The test cases should verify that the data linker
saves the XML file correctly and that it allows the user to load a cartographic
map from a previously created XML file.
15.6
■
Prototype 3: The web browser
The third prototype implements of the web-based data browser. This section
analyses non-functional requirements of the distributed system and builds
the design of the data browser taking into account the available domain
models and the data model defined for the previous prototypes.
15.6.1
Analysis
As we have discussed so far, a GIS service allows the user to interact with a
cartographic map by selecting geographic entities with the mouse and
