com.qanavigation.DBacc
Class DBacc2

java.lang.Object
  extended by com.qanavigation.Basics.Rslt
      extended by com.qanavigation.DBacc.SQLRslt
          extended by com.qanavigation.DBacc.DBacc2
All Implemented Interfaces:
IRslt, ISQLRslt

public class DBacc2
extends SQLRslt

Implementation of an access to an SQL DB.

Native interface used.

DBAcc isA SQLRslt.


Field Summary
 java.lang.String m_LastQCmnd
          Last query commmand issued.
 
Constructor Summary
DBacc2(java.lang.String p_DBName, java.lang.String p_Location, java.lang.String p_User, java.lang.String p_PW)
           
 
Method Summary
 SQLRslt addBLOB(java.lang.String p_TblName, java.lang.String p_KeyCol, java.lang.String p_Key, java.lang.String p_ContentCol, byte[] p_Content)
          Insert data as a byte array to a (1) column of a table.
 SQLRslt chkConn()
           
 SQLRslt chkReconn()
          Checks connection and tries to reconnect, if lost.
 SQLRslt close()
           
 SQLRslt commit()
           
 SQLRslt decrCounter(java.lang.String p_TblName, java.lang.String p_keyColName, java.lang.String p_keyVal, java.lang.String p_countColName)
          Decrements a counter.
 SQLRslt delete(java.lang.String p_TableName, java.lang.String p_WhereStmt)
          Deletes a row.
 SQLRslt doCommit(boolean p_isOK)
          Commits, if isOK, else rolls back.
 java.lang.String escapeStr2(java.lang.String p_Input)
           
 SetList findAllByVal(java.lang.String p_TableName, java.lang.String p_ColName, java.lang.String p_WhereStmt)
           
 RsltTable freeSelect(java.lang.String p_HeadStmnt, java.lang.String[] p_ColNames, java.lang.String p_TailStmnt)
          Free form select.
 RsltString getIncrCounter(java.lang.String p_TblName, java.lang.String p_ColName)
           
 SetList getKeys(java.lang.String p_ColName, java.lang.String p_TailStmnt)
           
 RsltString getValByKey(java.lang.String p_tblName, java.lang.String p_valCol, java.lang.String p_keyCol, java.lang.String p_keyVal)
          Returns a single value identified by a single key.
 SQLRslt incrCounter(java.lang.String p_TblName, java.lang.String p_keyColName, java.lang.String p_keyVal, java.lang.String p_countColName)
          Increments a counter.
 SQLRslt insert(QuerySet p_Qset)
          Insert a row.
 SQLRslt insertUpdate(QuerySet p_Qset)
          Inserts a new row or updates, if key is duplicate.
 SQLRslt rollBack()
          Performs a roll back.
 RsltTable select(java.lang.String p_TableName, java.lang.String[] p_ColNames, java.lang.String p_Appx)
          Executes a standard select.
 SQLRslt startTrans()
          Starts a transaction.
 SQLRslt update(QuerySet p_Qset)
          Updates a row.
 
Methods inherited from class com.qanavigation.DBacc.SQLRslt
checkRslt, checkRslt, getLastErrorCode, resetRslt, setRsltByExcp
 
Methods inherited from class com.qanavigation.Basics.Rslt
addRsltAddFailInfo, addRsltAddFailInfoIf, addRsltAddInfo, addRsltAddInfo, addRsltFinalInfo, addRsltInitialInfo, checkRslt, checkRslt, checkRslt, checkRslt, getRslt, getRsltAddInfo, getRsltFinalInfo, getRsltFinalMsg, getRsltInitialInfo, getRsltInitialMsg, getRsltStatVal, getRsltStatValLbl, isInStat, isOK, isOK, notOK, notOK, setInError, setOK, setRsltByExcp, setRsltByExcp, setRsltByExcp, setRsltStat, setRsltStat, setRsltStat, setRsltStat, setSelfReflect
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface com.qanavigation.Basics.IRslt
addRsltAddFailInfo, addRsltAddInfo, addRsltAddInfo, addRsltFinalInfo, addRsltInitialInfo, checkRslt, checkRslt, getRslt, getRsltAddInfo, getRsltFinalInfo, getRsltFinalMsg, getRsltInitialInfo, getRsltInitialMsg, getRsltStatVal, getRsltStatValLbl, isInStat, isOK, isOK, notOK, notOK, setInError, setOK, setRsltByExcp, setRsltStat, setRsltStat, setRsltStat, setRsltStat
 

Field Detail

m_LastQCmnd

public java.lang.String m_LastQCmnd
Last query commmand issued.

Constructor Detail

DBacc2

public DBacc2(java.lang.String p_DBName,
              java.lang.String p_Location,
              java.lang.String p_User,
              java.lang.String p_PW)
Parameters:
p_DBName -
p_Location -
p_User -
p_PW -
Method Detail

addBLOB

public SQLRslt addBLOB(java.lang.String p_TblName,
                       java.lang.String p_KeyCol,
                       java.lang.String p_Key,
                       java.lang.String p_ContentCol,
                       byte[] p_Content)
Insert data as a byte array to a (1) column of a table. The row is identified by 1 key column.

Parameters:
p_KeyCol -
p_Key -
p_Content -
Returns:

close

public SQLRslt close()
Returns:

chkConn

public SQLRslt chkConn()
Returns:
RsltStatVal.notFound if connection is lost.

chkReconn

public SQLRslt chkReconn()
Checks connection and tries to reconnect, if lost.

Returns:

commit

public SQLRslt commit()
Returns:

decrCounter

public SQLRslt decrCounter(java.lang.String p_TblName,
                           java.lang.String p_keyColName,
                           java.lang.String p_keyVal,
                           java.lang.String p_countColName)
Decrements a counter.

Parameters:
p_TblName -
p_ColName -
Returns:

delete

public SQLRslt delete(java.lang.String p_TableName,
                      java.lang.String p_WhereStmt)
Deletes a row.

Parameters:
p_TableName -
p_WhereStmt -

doCommit

public SQLRslt doCommit(boolean p_isOK)
Commits, if isOK, else rolls back.

Parameters:
p_isOK -

escapeStr2

public java.lang.String escapeStr2(java.lang.String p_Input)
Parameters:
p_Input -
Returns:
the escaped string

findAllByVal

public SetList findAllByVal(java.lang.String p_TableName,
                            java.lang.String p_ColName,
                            java.lang.String p_WhereStmt)
Parameters:
p_WhereStmt -
Returns:

freeSelect

public RsltTable freeSelect(java.lang.String p_HeadStmnt,
                            java.lang.String[] p_ColNames,
                            java.lang.String p_TailStmnt)
Free form select. Between p_HeadStmnt and p_TailStmnt the list of columns is inserted.

Parameters:
p_HeadStmnt -
p_ColNames -
p_TailStmnt -
Returns:

getIncrCounter

public RsltString getIncrCounter(java.lang.String p_TblName,
                                 java.lang.String p_ColName)
Parameters:
p_TblName -
p_ColName -
Returns:

getKeys

public SetList getKeys(java.lang.String p_ColName,
                       java.lang.String p_TailStmnt)
Parameters:
p_ColName -
p_TailStmnt -
Returns:

getValByKey

public RsltString getValByKey(java.lang.String p_tblName,
                              java.lang.String p_valCol,
                              java.lang.String p_keyCol,
                              java.lang.String p_keyVal)
Returns a single value identified by a single key.

Parameters:
p_tblName -
p_valCol -
p_keyCol -
p_keyVal -
Returns:

incrCounter

public SQLRslt incrCounter(java.lang.String p_TblName,
                           java.lang.String p_keyColName,
                           java.lang.String p_keyVal,
                           java.lang.String p_countColName)
Increments a counter.

Parameters:
p_TblName -
p_ColName -
Returns:

insert

public SQLRslt insert(QuerySet p_Qset)
Insert a row.

Parameters:
p_Qset -
Returns:

insertUpdate

public SQLRslt insertUpdate(QuerySet p_Qset)
Inserts a new row or updates, if key is duplicate.

Parameters:
p_Qset -
Returns:

rollBack

public SQLRslt rollBack()
Performs a roll back.

Returns:

select

public RsltTable select(java.lang.String p_TableName,
                        java.lang.String[] p_ColNames,
                        java.lang.String p_Appx)
Executes a standard select.

Parameters:
p_TableName -
p_ColNames -
p_Appx -
Returns:

startTrans

public SQLRslt startTrans()
Starts a transaction.

Returns:

update

public SQLRslt update(QuerySet p_Qset)
Updates a row. The 'WHERE' statement is automatically built from the key columns from the QuerySet.

Parameters:
p_Qset -
Returns:


Copyright © 2003 - 20011 Ronald D. Grindle. All Rights Reserved.