org.jboss.soa.esb.helpers.persist
Class SqlDbTable

java.lang.Object
  extended by org.jboss.soa.esb.helpers.persist.SqlDbTable

public abstract class SqlDbTable
extends java.lang.Object


Field Summary
protected  SqlField[] m_oaFields
           
protected  java.sql.PreparedStatement[] m_oaPS
           
protected  java.lang.String m_sSelectSql
           
protected  java.lang.String m_sTableName
           
 
Constructor Summary
SqlDbTable(JdbcCleanConn p_oC, java.lang.String p_sTblNm)
           
 
Method Summary
 SqlField[] getAllFields()
           
 JdbcCleanConn getConn()
           
 java.lang.String getDeleteStatement()
           
 java.lang.String getFldName(int p_i)
           
abstract  java.lang.Object getFromRS(java.sql.ResultSet p_oRS)
           
 java.lang.String getInsertStatement()
           
protected abstract  java.lang.String getSelectFields()
           
 java.lang.String getSelectStatement()
           
 java.lang.String getTableName()
           
 java.lang.String getUpdateStatement()
           
abstract  int setInsValues(java.sql.PreparedStatement p_PS, java.lang.Object bobj)
           
 void setInt(java.sql.PreparedStatement p_PS, int p_iFld, int p_iVal)
           
 void setLong(java.sql.PreparedStatement p_PS, int p_iFld, long p_lVal)
           
 void setObject(java.sql.PreparedStatement p_PS, int p_iFld, java.lang.Object p_sFldVal)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

m_sTableName

protected java.lang.String m_sTableName

m_oaFields

protected SqlField[] m_oaFields

m_oaPS

protected java.sql.PreparedStatement[] m_oaPS

m_sSelectSql

protected java.lang.String m_sSelectSql
Constructor Detail

SqlDbTable

public SqlDbTable(JdbcCleanConn p_oC,
                  java.lang.String p_sTblNm)
           throws java.lang.Exception
Throws:
java.lang.Exception
Method Detail

getConn

public JdbcCleanConn getConn()

getTableName

public final java.lang.String getTableName()

getAllFields

public final SqlField[] getAllFields()

setInsValues

public abstract int setInsValues(java.sql.PreparedStatement p_PS,
                                 java.lang.Object bobj)
                          throws java.lang.Exception
Throws:
java.lang.Exception

getFromRS

public abstract java.lang.Object getFromRS(java.sql.ResultSet p_oRS)
                                    throws java.lang.Exception
Throws:
java.lang.Exception

getSelectFields

protected abstract java.lang.String getSelectFields()

getFldName

public java.lang.String getFldName(int p_i)

getSelectStatement

public java.lang.String getSelectStatement()

getInsertStatement

public java.lang.String getInsertStatement()

getUpdateStatement

public java.lang.String getUpdateStatement()

getDeleteStatement

public java.lang.String getDeleteStatement()

setObject

public void setObject(java.sql.PreparedStatement p_PS,
                      int p_iFld,
                      java.lang.Object p_sFldVal)
               throws java.sql.SQLException
Throws:
java.sql.SQLException

setLong

public void setLong(java.sql.PreparedStatement p_PS,
                    int p_iFld,
                    long p_lVal)
             throws java.sql.SQLException
Throws:
java.sql.SQLException

setInt

public void setInt(java.sql.PreparedStatement p_PS,
                   int p_iFld,
                   int p_iVal)
            throws java.sql.SQLException
Throws:
java.sql.SQLException