com.raritantechnologies.federated.eRoom
Class ERoomPersistence

java.lang.Object
  com.raritantechnologies.federated.eRoom.ERoomPersistence

public class ERoomPersistence

extends java.lang.Object

Constructor Summary

ERoomPersistence()

ERoomPersistence(java.lang.String tableName)

Method Summary

void	closeConnection(java.sql.Connection conn)
void	closeStatement(java.sql.Connection conn, java.sql.PreparedStatement stmt)
void	createDocument(java.sql.Connection conn, ERoomDocument eroomDoc)
void	createDocument(java.sql.Connection conn, java.lang.String id, java.lang.String status, java.lang.String modDate, java.lang.String url, java.lang.String var)
java.util.ArrayList	getDocumentsByStatus(java.sql.Connection conn, java.lang.String status)
java.util.ArrayList	getDocumentsByStatus(java.sql.Connection conn, java.lang.String status, java.lang.String eRoomURL)
void	markDocumentDeleted(java.sql.Connection conn, java.lang.String id, java.lang.String status)
java.sql.Connection	openConnection()
void	removeDocumentById(java.sql.Connection conn, java.lang.String id)
void	resetAllDocuments(java.sql.Connection conn, java.lang.String status)
void	resetAllDocuments(java.sql.Connection conn, java.lang.String status, java.lang.String eRoomURL)
void	resetAllDocumentsExceptDelete(java.sql.Connection conn, java.lang.String status)
void	resetAllDocumentsExceptDelete(java.sql.Connection conn, java.lang.String status, java.lang.String eRoomURL)
ERoomDocument	retrieveDocument(java.sql.Connection conn, java.lang.String id)
void	runUpdate(java.sql.Connection conn, java.lang.String query)
void	runUpdate(java.sql.Connection conn, java.lang.String query, java.lang.String param)
void	runUpdate(java.sql.Connection conn, java.lang.String query, java.lang.String param1, java.lang.String param2)
void	updateDocument(java.sql.Connection conn, ERoomDocument eroomDoc)
void	updateDocumentStatus(java.sql.Connection conn, java.lang.String id, java.lang.String status) Updates the document status where id = document ID

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ERoomPersistence

public ERoomPersistence()

ERoomPersistence

public ERoomPersistence(java.lang.String tableName)

Method Detail

resetAllDocuments

public void resetAllDocuments(java.sql.Connection conn,
                              java.lang.String status)

resetAllDocumentsExceptDelete

public void resetAllDocumentsExceptDelete(java.sql.Connection conn,
                                          java.lang.String status)

resetAllDocuments

public void resetAllDocuments(java.sql.Connection conn,
                              java.lang.String status,
                              java.lang.String eRoomURL)

resetAllDocumentsExceptDelete

public void resetAllDocumentsExceptDelete(java.sql.Connection conn,
                                          java.lang.String status,
                                          java.lang.String eRoomURL)

createDocument

public void createDocument(java.sql.Connection conn,
                           java.lang.String id,
                           java.lang.String status,
                           java.lang.String modDate,
                           java.lang.String url,
                           java.lang.String var)
                    throws java.lang.Exception

Throws:

java.lang.Exception

createDocument

public void createDocument(java.sql.Connection conn,
                           ERoomDocument eroomDoc)
                    throws java.lang.Exception

Throws:

java.lang.Exception

updateDocument

public void updateDocument(java.sql.Connection conn,
                           ERoomDocument eroomDoc)
                    throws java.lang.Exception

Throws:

java.lang.Exception

getDocumentsByStatus

public java.util.ArrayList getDocumentsByStatus(java.sql.Connection conn,
                                                java.lang.String status)
                                         throws java.lang.Exception

Throws:

java.lang.Exception

getDocumentsByStatus

public java.util.ArrayList getDocumentsByStatus(java.sql.Connection conn,
                                                java.lang.String status,
                                                java.lang.String eRoomURL)
                                         throws java.lang.Exception

Throws:

java.lang.Exception

updateDocumentStatus

public void updateDocumentStatus(java.sql.Connection conn,
                                 java.lang.String id,
                                 java.lang.String status)
                          throws java.lang.Exception

Updates the document status where id = document ID

Throws:

java.lang.Exception

markDocumentDeleted

public void markDocumentDeleted(java.sql.Connection conn,
                                java.lang.String id,
                                java.lang.String status)
                         throws java.lang.Exception

Throws:

java.lang.Exception

removeDocumentById

public void removeDocumentById(java.sql.Connection conn,
                               java.lang.String id)
                        throws java.lang.Exception

Throws:

java.lang.Exception

retrieveDocument

public ERoomDocument retrieveDocument(java.sql.Connection conn,
                                      java.lang.String id)
                               throws java.lang.Exception

Throws:

java.lang.Exception

openConnection

public java.sql.Connection openConnection()

closeConnection

public void closeConnection(java.sql.Connection conn)

closeStatement

public void closeStatement(java.sql.Connection conn,
                           java.sql.PreparedStatement stmt)

runUpdate

public void runUpdate(java.sql.Connection conn,
                      java.lang.String query)

runUpdate

public void runUpdate(java.sql.Connection conn,
                      java.lang.String query,
                      java.lang.String param)

runUpdate

public void runUpdate(java.sql.Connection conn,
                      java.lang.String query,
                      java.lang.String param1,
                      java.lang.String param2)