|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectcom.qanavigation.Basics.Rslt
com.qanavigation.DBacc.SQLRslt
com.qanavigation.DBacc.DBacc2
public class DBacc2
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 |
|---|
public java.lang.String m_LastQCmnd
| Constructor Detail |
|---|
public DBacc2(java.lang.String p_DBName,
java.lang.String p_Location,
java.lang.String p_User,
java.lang.String p_PW)
p_DBName - p_Location - p_User - p_PW - | Method Detail |
|---|
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)
p_KeyCol - p_Key - p_Content -
public SQLRslt close()
public SQLRslt chkConn()
public SQLRslt chkReconn()
public SQLRslt commit()
public SQLRslt decrCounter(java.lang.String p_TblName,
java.lang.String p_keyColName,
java.lang.String p_keyVal,
java.lang.String p_countColName)
p_TblName - p_ColName -
public SQLRslt delete(java.lang.String p_TableName,
java.lang.String p_WhereStmt)
p_TableName - p_WhereStmt - public SQLRslt doCommit(boolean p_isOK)
p_isOK - public java.lang.String escapeStr2(java.lang.String p_Input)
p_Input -
public SetList findAllByVal(java.lang.String p_TableName,
java.lang.String p_ColName,
java.lang.String p_WhereStmt)
p_WhereStmt -
public RsltTable freeSelect(java.lang.String p_HeadStmnt,
java.lang.String[] p_ColNames,
java.lang.String p_TailStmnt)
p_HeadStmnt - p_ColNames - p_TailStmnt -
public RsltString getIncrCounter(java.lang.String p_TblName,
java.lang.String p_ColName)
p_TblName - p_ColName -
public SetList getKeys(java.lang.String p_ColName,
java.lang.String p_TailStmnt)
p_ColName - p_TailStmnt -
public RsltString getValByKey(java.lang.String p_tblName,
java.lang.String p_valCol,
java.lang.String p_keyCol,
java.lang.String p_keyVal)
p_tblName - p_valCol - p_keyCol - p_keyVal -
public SQLRslt incrCounter(java.lang.String p_TblName,
java.lang.String p_keyColName,
java.lang.String p_keyVal,
java.lang.String p_countColName)
p_TblName - p_ColName -
public SQLRslt insert(QuerySet p_Qset)
p_Qset -
public SQLRslt insertUpdate(QuerySet p_Qset)
p_Qset -
public SQLRslt rollBack()
public RsltTable select(java.lang.String p_TableName,
java.lang.String[] p_ColNames,
java.lang.String p_Appx)
p_TableName - p_ColNames - p_Appx -
public SQLRslt startTrans()
public SQLRslt update(QuerySet p_Qset)
p_Qset -
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||