com.jaxfront.core.util.sql
Class SQLProcessor

java.lang.Object
  com.jaxfront.core.util.sql.SQLProcessor

public class SQLProcessor
extends java.lang.Object

Constructor Summary

SQLProcessor(java.lang.String user, IDBInfo dbInfo, boolean doBatch)

Method Summary

void	addToWorklist(java.lang.Object workVal)
static void	closeStatement(java.sql.Statement aStatement)
java.sql.Statement	createBatchStmnt(java.sql.Connection con, java.lang.String sql)
void	doInsert(java.sql.Connection con, java.lang.Object[] sqlSTMNTValues)
void	doInsert(IConnectionManager conMan, java.lang.Object[] sqlSTMNTValues)
int[]	doUpdateInsert(java.sql.Connection con, java.lang.String sql)
int[]	doUpdateInsert(IConnectionManager conMan, java.lang.String sql)
int[]	doUpdateInsertForObjArray(java.sql.Connection con, java.lang.Object[] sqlSTMNTValues)
int[]	doUpdateInsertForObjArray(IConnectionManager conMan, java.lang.Object[] sqlSTMNTValues)
int[]	executeBatch(java.sql.Statement batchStmnt)
int	getBatchCount()
int	getBatchSize()
java.lang.String	getBatchStmntSQL()
IDBInfo	getDBInfo()
int	getOverallCount()
java.util.List	getStatementWorkList()
java.lang.String	getUser()
boolean	isDoBatch()
int[]	performBatch(java.sql.Connection con)
int[]	release(java.sql.Connection con)
int[]	release(IConnectionManager conMan)
void	setBatchSize(int size)
void	setBatchStmntSQL(java.lang.String stmnt)
void	setDoCommit(boolean doCommit)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLProcessor

public SQLProcessor(java.lang.String user,
                    IDBInfo dbInfo,
                    boolean doBatch)

Method Detail

addToWorklist

public void addToWorklist(java.lang.Object workVal)

closeStatement

public static void closeStatement(java.sql.Statement aStatement)

createBatchStmnt

public java.sql.Statement createBatchStmnt(java.sql.Connection con,
                                           java.lang.String sql)
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

doInsert

public void doInsert(java.sql.Connection con,
                     java.lang.Object[] sqlSTMNTValues)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

doInsert

public void doInsert(IConnectionManager conMan,
                     java.lang.Object[] sqlSTMNTValues)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

doUpdateInsert

public int[] doUpdateInsert(java.sql.Connection con,
                            java.lang.String sql)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

doUpdateInsert

public int[] doUpdateInsert(IConnectionManager conMan,
                            java.lang.String sql)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

doUpdateInsertForObjArray

public int[] doUpdateInsertForObjArray(java.sql.Connection con,
                                       java.lang.Object[] sqlSTMNTValues)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

doUpdateInsertForObjArray

public int[] doUpdateInsertForObjArray(IConnectionManager conMan,
                                       java.lang.Object[] sqlSTMNTValues)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

executeBatch

public int[] executeBatch(java.sql.Statement batchStmnt)
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getBatchCount

public int getBatchCount()

getBatchSize

public int getBatchSize()

getBatchStmntSQL

public java.lang.String getBatchStmntSQL()

getDBInfo

public IDBInfo getDBInfo()

getOverallCount

public int getOverallCount()

getStatementWorkList

public java.util.List getStatementWorkList()

getUser

public java.lang.String getUser()

isDoBatch

public boolean isDoBatch()

performBatch

public int[] performBatch(java.sql.Connection con)
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

release

public int[] release(java.sql.Connection con)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

release

public int[] release(IConnectionManager conMan)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

setBatchSize

public void setBatchSize(int size)

setBatchStmntSQL

public void setBatchStmntSQL(java.lang.String stmnt)

setDoCommit

public void setDoCommit(boolean doCommit)