|
||||||||||
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 |