01: /*
02: * <copyright>
03: *
04: * Copyright 1997-2004 BBNT Solutions, LLC
05: * under sponsorship of the Defense Advanced Research Projects
06: * Agency (DARPA).
07: *
08: * You can redistribute this software and/or modify it under the
09: * terms of the Cougaar Open Source License as published on the
10: * Cougaar Open Source Website (www.cougaar.org).
11: *
12: * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
13: * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
14: * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
15: * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
16: * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
17: * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
18: * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
19: * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
20: * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
21: * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
22: * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
23: *
24: * </copyright>
25: */
26:
27: package org.cougaar.mlm.plugin.ldm;
28:
29: import java.sql.ResultSet;
30: import java.sql.SQLException;
31: import java.sql.Statement;
32: import java.util.ArrayList;
33: import java.util.Collection;
34:
35: import org.cougaar.glm.ldm.GLMFactory;
36: import org.cougaar.glm.ldm.plan.GeolocLocation;
37: import org.cougaar.glm.ldm.plan.NewGeolocLocation;
38: import org.cougaar.planning.ldm.measure.Latitude;
39: import org.cougaar.planning.ldm.measure.Longitude;
40: import org.cougaar.util.DBProperties;
41:
42: /** Reads geoloc info from a database table. Assumes it's being invoked on
43: * behalf of SQLOplanPlugin. Updates SQLOplanPlugin's geoloc table.
44: */
45:
46: public class NewGeoLocQueryHandler extends NewQueryHandler {
47: private static final String QUERY_NAME = "GeoLocQuery";
48:
49: public NewGeoLocQueryHandler(DBProperties dbp, NewOplanPlugin plugin) {
50: super (dbp, plugin);
51: }
52:
53: protected Collection executeQueries(Statement statement)
54: throws SQLException {
55: String query = dbp.getQuery(QUERY_NAME, dbp);
56: ResultSet rs = statement.executeQuery(query);
57: Collection result = new ArrayList();
58: while (rs.next()) {
59: result.add(processRow(rs));
60: }
61: rs.close();
62: return result;
63: }
64:
65: /** Process a single row in a result set,
66: * doing whatever is required.
67: **/
68: public GeolocLocation processRow(ResultSet rs) throws SQLException {
69: NewGeolocLocation geoloc = GLMFactory.newGeolocLocation();
70: geoloc.setGeolocCode(getString(rs, 1));
71: geoloc.setName(getString(rs, 2));
72: geoloc.setInstallationTypeCode(getString(rs, 3));
73: geoloc.setIcaoCode(getString(rs, 4));
74: geoloc.setLatitude(Latitude.newLatitude(rs.getDouble(5)));
75: geoloc.setLongitude(Longitude.newLongitude(rs.getDouble(6)));
76: geoloc.setCountryStateCode(getString(rs, 7));
77: geoloc.setCountryStateName(getString(rs, 8));
78: return geoloc;
79: }
80: }
|