01: //=============================================================================
02: //=== Copyright (C) 2001-2007 Food and Agriculture Organization of the
03: //=== United Nations (FAO-UN), United Nations World Food Programme (WFP)
04: //=== and United Nations Environment Programme (UNEP)
05: //===
06: //=== This program is free software; you can redistribute it and/or modify
07: //=== it under the terms of the GNU General Public License as published by
08: //=== the Free Software Foundation; either version 2 of the License, or (at
09: //=== your option) any later version.
10: //===
11: //=== This program is distributed in the hope that it will be useful, but
12: //=== WITHOUT ANY WARRANTY; without even the implied warranty of
13: //=== MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
14: //=== General Public License for more details.
15: //===
16: //=== You should have received a copy of the GNU General Public License
17: //=== along with this program; if not, write to the Free Software
18: //=== Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA
19: //===
20: //=== Contact: Jeroen Ticheler - FAO - Viale delle Terme di Caracalla 2,
21: //=== Rome - Italy. email: geonetwork@osgeo.org
22: //==============================================================================
23:
24: package org.fao.geonet.lib;
25:
26: import java.sql.SQLException;
27: import java.util.Iterator;
28: import jeeves.resources.dbms.Dbms;
29: import org.jdom.Element;
30:
31: //=============================================================================
32:
33: public class DbLib {
34: //-----------------------------------------------------------------------------
35: //---
36: //--- API methods
37: //---
38: //-----------------------------------------------------------------------------
39:
40: public Element select(Dbms dbms, String table, String name)
41: throws SQLException {
42: return select(dbms, table, name, null);
43: }
44:
45: //-----------------------------------------------------------------------------
46:
47: public Element select(Dbms dbms, String table, String name,
48: String where) throws SQLException {
49: String query = "SELECT * FROM " + table;
50:
51: if (where != null)
52: query += " WHERE " + where;
53:
54: Element result = dbms.select(query);
55:
56: Iterator i = result.getChildren().iterator();
57:
58: while (i.hasNext()) {
59: Element record = (Element) i.next();
60: record.setName(name);
61: }
62:
63: return result.setName(table.toLowerCase());
64: }
65: }
66:
67: //=============================================================================
|