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: import java.util.Date;
35:
36: import org.cougaar.glm.ldm.oplan.Oplan;
37: import org.cougaar.util.DBProperties;
38:
39: /** Reads oplan info from a database table. Assumes it's being invoked on
40: * behalf of SQLOplanPlugin. Updates oplan maintained by SQLOplanPlugin.
41: */
42: public class NewOplanQueryHandler extends NewQueryHandler {
43: private static final String QUERY_NAME = "OplanInfoQuery";
44:
45: public NewOplanQueryHandler(DBProperties adbp, NewOplanPlugin plugin) {
46: super (adbp, plugin);
47: }
48:
49: public Collection executeQueries(Statement statement)
50: throws SQLException {
51: String query = dbp.getQuery(QUERY_NAME, dbp);
52: ResultSet rs = statement.executeQuery(query);
53: Collection result = new ArrayList(1);
54: while (rs.next()) {
55: result.add(processRow(rs));
56: }
57: rs.close();
58: if (result.isEmpty())
59: System.err.println("Returning empty collection of oplans");
60: return result;
61: }
62:
63: /** Process a single row in a result set,
64: * doing whatever is required.
65: **/
66: private Oplan processRow(ResultSet rs) throws SQLException {
67: try {
68: String opName = getString(rs, 1);
69: String priority = getString(rs, 2);
70: String oplanId = dbp
71: .getProperty(OplanReaderPlugin.OPLAN_ID_PARAMETER);
72: Date cDay = plugin.getCDay();
73: return new Oplan(null, // Filled in by caller
74: oplanId, opName, priority, cDay);
75: } catch (Exception usee) {
76: System.err
77: .println("Caught exception while executing a query: "
78: + usee);
79: usee.printStackTrace();
80: return new Oplan();
81: }
82: }
83: }
|