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 alploc info from a database table. Assumes it's being invoked on
43: * behalf of SQLOplanPlugin. Updates SQLOplanPlugin's geoloc table with alplocs.
44: *
45: * BOZO - alplocs are not geolocs but there isn't any other commonly understood way
46: * to access them.
47: */
48:
49: public class NewAlpLocQueryHandler extends NewQueryHandler {
50: private static final String QUERY_NAME = "AlpLocQuery";
51:
52: public NewAlpLocQueryHandler(DBProperties dbp, NewOplanPlugin plugin) {
53: super (dbp, plugin);
54: }
55:
56: protected Collection executeQueries(Statement statement)
57: throws SQLException {
58: String query = dbp.getQuery(QUERY_NAME, dbp);
59: ResultSet rs = statement.executeQuery(query);
60: Collection result = new ArrayList();
61: while (rs.next()) {
62: result.add(processRow(rs));
63: }
64: rs.close();
65: return result;
66: }
67:
68: /** Process a single row in a result set,
69: * doing whatever is required.
70: **/
71: public GeolocLocation processRow(ResultSet rs) throws SQLException {
72: NewGeolocLocation geoloc = GLMFactory.newGeolocLocation();
73: String code = getString(rs, 1);
74: geoloc.setName(getString(rs, 2));
75: geoloc.setLatitude(Latitude.newLatitude(rs.getDouble(3)));
76: geoloc.setLongitude(Longitude.newLongitude(rs.getDouble(4)));
77: geoloc.setInstallationTypeCode("AlpLoc");
78: geoloc.setGeolocCode(code);
79: geoloc.setIcaoCode(code);
80: return geoloc;
81: }
82: }
|