cdac.medinfo.sdk.dcm30_04.services.print.dbhelper

Class Print_DBAgent

java.lang.Object

cdac.medinfo.sdk.dcm30_04.services.print.dbhelper.Print_DBAgent

public class Print_DBAgent
extends java.lang.Object

This class provides implementation of DataBase Connection and processing of queries on DataBase. Print_DBAgent is a singleton class. Print_DBAgent provides the support to create, update and retrieve information of a print SOP Instance

Method Summary

Methods

Modifier and Type	Method and Description
void	close() Close data base connection.
static Print_DBAgent	createInstance(java.lang.String strConnectionString, java.lang.String strDriverName) Creates instance of Print_DBAgent.
boolean	createSOPInstance(EnumSOPClassUIDs enumSOPClassUIDs, IDataSet objIDataSet, java.lang.String strSOPInstanceUID) Creates SOP Instance for provided SOPInstanceUID and DataElement attributes.
boolean	deletePrintJOB(EnumSOPClassUIDs enumSOPClassUIDs, java.lang.String strSOPInstanceUID, IDataSet objIDataSet) This function deletes the Print Job which is specified in the DataSet.
boolean	deleteSOPInstance(EnumSOPClassUIDs enumSOPClassUIDs, java.lang.String strSOPInstance) This function deletes the SOP Instance Provided.
java.lang.String[]	getAllSOPInstance(EnumSOPClassUIDs enumSOPClassUIDsToFind, EnumSOPClassUIDs enumSOPClassUIDs, java.lang.String strValue) This function gets all the SOP instance UID of EnumSOPClassUIDsToFind related to SOP Instance UID.
boolean	insertIntoRelationShipTable(java.lang.String strBasicFilmSessionSOPInstanceUID, java.lang.String strBasicFilmBoxSOPInstanceUID, java.lang.String strImageBoxSOPInstanceUID, java.lang.String strBasicAnnotationSOPInstanceUID, java.lang.String strPresentationLUTSOPInstanceUID, java.lang.String strImageOvelaySOPInstanceUID) This function inserts the values provided in the Relationship table.
boolean	isSOPInstanceExist(EnumSOPClassUIDs enumSOPClassUIDs, java.lang.String strSOPInstance) Checks whether provided SOP Instance is created ot not.
IDataSet	retrieveSOPInstance(EnumSOPClassUIDs enumSOPClassUIDs, ISingleCollection<ITag> objITagCollection, java.lang.String strSOPInstanceUID) This function retrieves all DataSets related to strSOPInstanceUID.
boolean	storeImageInstanceInfo(IDataSet objIDataSet, java.lang.String strSOPInstanceUID, java.lang.String strPath) Stores the Dataset information into database.
boolean	storeStoredPrintInstanceInfo(IDataSet objIDataSet, java.lang.String strSOPInstanceUID) Stores the Dataset information into database.
boolean	updatePrintJob(EnumSOPClassUIDs enumSOPClassUIDs, java.lang.String strSOPInstanceUID, IDataSet objIDataSet) This function updates the Priority of Print JOB.
boolean	updateRelationShipTable(EnumSOPClassUIDs enumSOPClassUIDs, EnumSOPClassUIDs enumSOPClassUIDOFColumName, java.lang.String strSOPInstance, java.lang.String strUpdateSOPInstanceUID) This function updates the Relationship Table.
boolean	updateSOPInstance(EnumSOPClassUIDs enumSOPClassUIDs, IDataSet objIDataSet, java.lang.String strSOPInstanceUID) Updates a SOP Instance

Methods inherited from class java.lang.Object

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

Method Detail

createInstance

public static Print_DBAgent createInstance(java.lang.String strConnectionString,
                           java.lang.String strDriverName)
                                    throws java.sql.SQLException,
                                           java.lang.ClassNotFoundException,
                                           java.lang.InstantiationException,
                                           java.lang.IllegalAccessException

Creates instance of Print_DBAgent.

Returns:

Print_DBAgent object of Print_DBAgent

Throws:

java.sql.SQLException - Signals if SQL Exception occurs.

java.lang.ClassNotFoundException - if ClassNotFoundException occurs

java.lang.InstantiationException - if InstantiationException occurs

java.lang.IllegalAccessException - if IllegalAccessException occurs

createSOPInstance

public boolean createSOPInstance(EnumSOPClassUIDs enumSOPClassUIDs,
                        IDataSet objIDataSet,
                        java.lang.String strSOPInstanceUID)
                          throws java.sql.SQLException,
                                 java.io.IOException

Creates SOP Instance for provided SOPInstanceUID and DataElement attributes.

Parameters:

objIDataSet - instance of Dataset

strSOPInstanceUID - value of SOPInstanceUID

Returns:

boolean - status as true or false

Throws:

java.sql.SQLException - if SQL oparation fails

java.io.IOException

insertIntoRelationShipTable

public boolean insertIntoRelationShipTable(java.lang.String strBasicFilmSessionSOPInstanceUID,
                                  java.lang.String strBasicFilmBoxSOPInstanceUID,
                                  java.lang.String strImageBoxSOPInstanceUID,
                                  java.lang.String strBasicAnnotationSOPInstanceUID,
                                  java.lang.String strPresentationLUTSOPInstanceUID,
                                  java.lang.String strImageOvelaySOPInstanceUID)
                                    throws java.sql.SQLException

This function inserts the values provided in the Relationship table.

Parameters:

strBasicFilmSessionSOPInstanceUID - String value of Basic Film Session SOP instance.

strBasicFilmBoxSOPInstanceUID - String value of Basic Film Box SOP instance UID.

strImageBoxSOPInstanceUID - String value of Image Box SOP instance UID.

strBasicAnnotationSOPInstanceUID - String value of Basic Annotation SOP instance.

strPresentationLUTSOPInstanceUID - String value of Presentation LUT SOP instance.

strImageOvelaySOPInstanceUID - String value of Image Overlay SOP instance.

Returns:

boolean true if the values are inserted properly into Relationship Table.

Throws:

java.sql.SQLException - Signals if SQL operation fails.

updateSOPInstance

public boolean updateSOPInstance(EnumSOPClassUIDs enumSOPClassUIDs,
                        IDataSet objIDataSet,
                        java.lang.String strSOPInstanceUID)
                          throws java.sql.SQLException,
                                 java.io.IOException

Updates a SOP Instance

Parameters:

objIDataSet - instance of Dataset

strSOPInstanceUID - value of SOPInstanceUID

Returns:

boolean - status as true or false

Throws:

java.sql.SQLException - if SQL oparation fails

java.io.IOException

updateRelationShipTable

public boolean updateRelationShipTable(EnumSOPClassUIDs enumSOPClassUIDs,
                              EnumSOPClassUIDs enumSOPClassUIDOFColumName,
                              java.lang.String strSOPInstance,
                              java.lang.String strUpdateSOPInstanceUID)
                                throws java.sql.SQLException

This function updates the Relationship Table.

Parameters:

enumSOPClassUIDs - EnumValue of SOP Class UID.

enumSOPClassUIDOFColumName - EnumValue of SOP class UID which is to be updated.

strSOPInstance - String value of SOP instance UID.

strUpdateSOPInstanceUID - The new value of SOP instance.

Returns:

boolean return true if the relation ship table is updated successfully. Otherwise false is returned.

Throws:

java.sql.SQLException - Signals if SQL Exception occurs.

close

public void close()
           throws java.sql.SQLException

Close data base connection.

Throws:

java.sql.SQLException

isSOPInstanceExist

public boolean isSOPInstanceExist(EnumSOPClassUIDs enumSOPClassUIDs,
                         java.lang.String strSOPInstance)
                           throws java.sql.SQLException

Checks whether provided SOP Instance is created ot not.

Parameters:

strSOPInstance - value of SOP Instance UID

Returns:

boolean shows status as success or failure

Throws:

java.sql.SQLException - if sql operation fails

deleteSOPInstance

public boolean deleteSOPInstance(EnumSOPClassUIDs enumSOPClassUIDs,
                        java.lang.String strSOPInstance)
                          throws java.sql.SQLException

This function deletes the SOP Instance Provided.

Parameters:

enumSOPClassUIDs - EnumValue of SOP Classs UID.

strSOPInstance - String value of SOP Instance that is to be deleted.

Returns:

boolean - true of the SOP Instance is deleted successfully else return false.

Throws:

java.sql.SQLException - Signals if the SQL Operation fails.

retrieveSOPInstance

public IDataSet retrieveSOPInstance(EnumSOPClassUIDs enumSOPClassUIDs,
                           ISingleCollection<ITag> objITagCollection,
                           java.lang.String strSOPInstanceUID)
                             throws java.sql.SQLException,
                                    java.io.IOException

This function retrieves all DataSets related to strSOPInstanceUID.

Parameters:

enumSOPClassUIDs -

objITagCollection - list of requested attributes

strSOPInstanceUID - String value of SOP instance UID to be retrieved.

Returns:

IDataSet retrieve data set.

Throws:

java.sql.SQLException - Signals if the SQL operation fails.

java.io.IOException - Signals if IO Operation fails

getAllSOPInstance

public java.lang.String[] getAllSOPInstance(EnumSOPClassUIDs enumSOPClassUIDsToFind,
                                   EnumSOPClassUIDs enumSOPClassUIDs,
                                   java.lang.String strValue)
                                     throws java.sql.SQLException

This function gets all the SOP instance UID of EnumSOPClassUIDsToFind related to SOP Instance UID.

Parameters:

enumSOPClassUIDsToFind - SOP instance UID of EnumSOPClassUIDsToFind related to SOP Instance UID.

enumSOPClassUIDs - Enum SOP Class UID of strValue.

strValue - String value of SOP Instance UID.

Returns:

String array containg SOP instance UID of EnumSOPClassUIDsToFind related to SOP Instance UID.

Throws:

java.sql.SQLException - Signals if SQL Operation Fails.

deletePrintJOB

public boolean deletePrintJOB(EnumSOPClassUIDs enumSOPClassUIDs,
                     java.lang.String strSOPInstanceUID,
                     IDataSet objIDataSet)
                       throws java.io.IOException,
                              java.sql.SQLException

This function deletes the Print Job which is specified in the DataSet.

Parameters:

enumSOPClassUIDs - Enum Value of SOP Class UID.

strSOPInstanceUID - String value of SOP Instance UID.

objIDataSet - Data Set containing Print Job ID.

Returns:

boolean true if the Print Job is sucessfully deleted from the DataBase.

Throws:

java.io.IOException - Signals if IO Operation fails.

java.sql.SQLException - Signals if SQL Operation fails.

updatePrintJob

public boolean updatePrintJob(EnumSOPClassUIDs enumSOPClassUIDs,
                     java.lang.String strSOPInstanceUID,
                     IDataSet objIDataSet)
                       throws java.io.IOException,
                              java.sql.SQLException

This function updates the Priority of Print JOB.

Parameters:

enumSOPClassUIDs - Enum value of SOP Class UID.

strSOPInstanceUID - String value of SOP Instance Provided.

objIDataSet - DataSet containg job id and Priority.

Returns:

boolean true of the Priority of Print Job is modified. Otherfise false is returned.

Throws:

java.io.IOException - Signals if the IO Operation fails.

java.sql.SQLException - Signals if the SQL Opeation fails.

storeStoredPrintInstanceInfo

public boolean storeStoredPrintInstanceInfo(IDataSet objIDataSet,
                                   java.lang.String strSOPInstanceUID)
                                     throws java.sql.SQLException,
                                            java.io.IOException

Stores the Dataset information into database.

Parameters:

objIDataSet - instance of Dataset

strSOPInstanceUID - value of SOP Instance UID

Returns:

boolean true if successfully inserted else false

Throws:

java.sql.SQLException - if opeartion failes

java.lang.ClassNotFoundException - if operation failes

java.lang.InstantiationException - if operation failes

java.lang.IllegalAccessException - if operation failes

java.io.IOException

storeImageInstanceInfo

public boolean storeImageInstanceInfo(IDataSet objIDataSet,
                             java.lang.String strSOPInstanceUID,
                             java.lang.String strPath)
                               throws java.sql.SQLException,
                                      java.io.IOException

Stores the Dataset information into database.

Parameters:

objIDataSet - instance of Dataset

strSOPInstanceUID - value of SOP Instance UID

Returns:

boolean true if successfully inserted else false

Throws:

java.sql.SQLException - if opeartion failes

java.lang.ClassNotFoundException - if operation failes

java.lang.InstantiationException - if operation failes

java.lang.IllegalAccessException - if operation failes

java.io.IOException