com.wm.app.tn.db
Class BDDocAttributeOperations

java.lang.Object
  com.wm.app.tn.db.BDDocAttributeOperations

public class BDDocAttributeOperations
extends java.lang.Object

Constructor Summary

BDDocAttributeOperations()

Method Summary

static void	getAttributeValues(java.sql.Connection conn, BizDocEnvelope doc)
static java.sql.ResultSet	getDocumentQueryResults(java.lang.String code, java.util.List<java.lang.Object> parameters) This API fetches the query results based on the provided code( query code mentioned in dbops.sql) and list of parameters passed for binding with the query.
static int	setAttributeValues(java.sql.Connection conn, BizDocEnvelope doc)
static int	updateAttributeValues(BizDocEnvelope doc)
static boolean	updateSystemAttributes(BizDocEnvelope doc)

Methods inherited from class java.lang.Object

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

Constructor Detail

BDDocAttributeOperations

public BDDocAttributeOperations()

Method Detail

getAttributeValues

public static void getAttributeValues(java.sql.Connection conn,
                                      BizDocEnvelope doc)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

setAttributeValues

public static int setAttributeValues(java.sql.Connection conn,
                                     BizDocEnvelope doc)
                              throws java.sql.SQLException,
                                     java.text.ParseException

Throws:

java.sql.SQLException

java.text.ParseException

updateAttributeValues

public static int updateAttributeValues(BizDocEnvelope doc)
                                 throws java.sql.SQLException,
                                        java.text.ParseException

Throws:

java.sql.SQLException

java.text.ParseException

updateSystemAttributes

public static boolean updateSystemAttributes(BizDocEnvelope doc)
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getDocumentQueryResults

public static java.sql.ResultSet getDocumentQueryResults(java.lang.String code,
                                                         java.util.List<java.lang.Object> parameters)
                                                  throws java.sql.SQLException,
                                                         com.wm.app.b2b.server.ServiceException

This API fetches the query results based on the provided code( query code mentioned in dbops.sql) and list of parameters passed for binding with the query. User must pass exactly same number of binding parameters as per query. This API optimizes the performance of query by reducing the open cursors, as it uses bind variables and same cursor used. API supports parameters of type String,Integer and Timestamp Returned ResultSet object has to be closed by the invoking API.

Parameters:

code -

parameters. -

Returns:

Throws:

java.sql.SQLException

com.wm.app.b2b.server.ServiceException