Changeset 8438 for trunk/gsdl3/src/java/org/greenstone/gsdl3

Timestamp:

2004-11-03T14:33:35+13:00 (20 years ago)

Author:

kjdon

Message:

added a new function to check whether a document is hierarchical or not - its hierarchical if there is a structure named Section

File:

• trunk/gsdl3/src/java/org/greenstone/gsdl3/util/SQLQuery.java (modified) (1 diff)

trunk/gsdl3/src/java/org/greenstone/gsdl3/util/SQLQuery.java

@@ -99 +99 @@
     }
 
+    // does the document have sections, or is it just a single page document?
+    public boolean isHierarchicalDocument(String oid) {
+    // first just check the OID - it may already have section info in it
+    if (!GS3OID.isDocTop(oid)) {
+        return true;
+    }
+
+    // now we need to check the database
+    String query = "select * "+ 
+        " from "+GSSQL.STRUCTURE_TABLE +
+        " where "+ GSSQL.DOCUMENT_ID +GSSQL.EQUALS_QUOTE + oid + GSSQL.QUOTE +
+        " and "+ GSSQL.STRUCTURE_ID +GSSQL.EQUALS_QUOTE + "Section" + GSSQL.QUOTE +
+        GSSQL.END;
+    
+    connection.execute(query);
+    ResultSet results = null;
+    try {
+        results = connection.getResultSet();
+        if (results.next()) {
+        return true;
+        } 
+    } catch (java.sql.SQLException e) {
+        return false;
+    }
+
+    return false;
+    }
+    
     // classifier metadata is not actually metadata
     public String getClassifierMetadata(String oid, String full_meta_name) {