dke.smwp.db
Class DB_XML_Document

java.lang.Object
  |
  +--dke.smwp.db.DB_XML_Document

public class DB_XML_Document
extends java.lang.Object

handling XML document which are stored in database.

no method for update necessary; updating Clob data works by getting the Reader handle via the read method to manipulate the Reader directly

Version:
1.0
Author:
Werner Enser

Field Summary
private static java.lang.String TABLENAME_SMWP_XML_DOCUMENT
          tablename for storing xml documents
private static java.lang.String TABLENAME_SMWP_XML_DOCUMENT_PARAMS
          tablename for storing metadata for xml documents
 
Constructor Summary
DB_XML_Document()
          default constructor
 
Method Summary
 void delete(java.sql.Connection con, java.lang.String file_systemID)
          deletes xml document saved in database designated by file_systemID
 boolean documentExists(java.sql.Connection con, java.lang.String file_systemID)
          checks if xml document designated by file_systemID exists in database
 java.lang.String[] getAllSystemid(java.sql.Connection con)
          gets the filenames (systemID's) of all saved xml documents
 java.io.Reader read(java.sql.Connection con, java.lang.String file_systemID)
          gets the reader handle for xml document saved in database, designated by file_systemID
 void save(java.sql.Connection con, java.lang.String pc_name, java.lang.String file_systemID, java.io.Reader file_content, java.util.Hashtable parameters)
          saves xml document and to database
 
Methods inherited from class java.lang.Object
, clone, equals, finalize, getClass, hashCode, notify, notifyAll, registerNatives, toString, wait, wait, wait
 

Field Detail

TABLENAME_SMWP_XML_DOCUMENT

private static final java.lang.String TABLENAME_SMWP_XML_DOCUMENT
tablename for storing xml documents

TABLENAME_SMWP_XML_DOCUMENT_PARAMS

private static final java.lang.String TABLENAME_SMWP_XML_DOCUMENT_PARAMS
tablename for storing metadata for xml documents
Constructor Detail

DB_XML_Document

public DB_XML_Document()
default constructor
Method Detail

delete

public void delete(java.sql.Connection con,
                   java.lang.String file_systemID)
            throws java.sql.SQLException
deletes xml document saved in database designated by file_systemID
Parameters:
con - Connection handle
file_systemID - complete filename (with folder path) for xml document
Throws:
java.sql.SQLException - deletion from database failed

documentExists

public boolean documentExists(java.sql.Connection con,
                              java.lang.String file_systemID)
                       throws java.sql.SQLException
checks if xml document designated by file_systemID exists in database
Parameters:
con - Connection handle
file_systemID - complete filename (with folderpath) for xml document whose existence is checked
Throws:
java.sql.SQLException - fetching data failed

getAllSystemid

public java.lang.String[] getAllSystemid(java.sql.Connection con)
                                  throws java.sql.SQLException
gets the filenames (systemID's) of all saved xml documents
Parameters:
con - Connection handle
Throws:
java.sql.SQLException - fetching data failed

read

public java.io.Reader read(java.sql.Connection con,
                           java.lang.String file_systemID)
                    throws java.sql.SQLException,
                           java.io.IOException
gets the reader handle for xml document saved in database, designated by file_systemID
Parameters:
con - Connection handle
file_systemID - complete filename (with folder path) for xml document whose existence is checked
Throws:
java.sql.SQLException - fetching data failed
java.io.IOException - getting Reader handle for xml document

save

public void save(java.sql.Connection con,
                 java.lang.String pc_name,
                 java.lang.String file_systemID,
                 java.io.Reader file_content,
                 java.util.Hashtable parameters)
          throws java.sql.SQLException,
                 java.io.IOException
saves xml document and to database
Parameters:
con - Connection hanlde
file_systemID - String containing folder and file information e.g. wineries/winery_styria.xml
file_content - file content
pc_name - name of page class the page belongs to
parameters - parameter names and values used by page class instance; using parameter names as key and parameter values as value
Throws:
java.sql.SQLException - failed to save data
java.io.IOException - failed to save Clob