|
||||||||||
| 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.MyDBacc
public class MyDBacc
| Field Summary | |
|---|---|
java.lang.String |
ver
|
| Constructor Summary | |
|---|---|
MyDBacc(java.lang.String p_DBName,
java.lang.String p_Location,
java.lang.String p_User,
java.lang.String p_PW)
Opens a MySQL database and initializes the service. |
|
| 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)
Add a byte stream |
SQLRslt |
chkConn()
|
SQLRslt |
chkReconn()
|
SQLRslt |
close()
|
SQLRslt |
commit()
|
java.lang.String |
escapeStr2(java.lang.String p_Str)
Prepares a string for the DB. |
SQLRslt |
execNoData(java.lang.String p_Query)
For queries that do not add data or expect any result back. |
RsltTable |
execRead(java.lang.String p_Query,
java.lang.String[] p_ColNames)
forced to public by interface |
SQLRslt |
insert(QuerySet p_Qset)
|
boolean |
lastInsertDbl(ISQLRslt p_SQLRes)
|
void |
resetRslt()
Set back to OK, dumps all messages. |
SQLRslt |
rollBack()
|
SQLRslt |
startTrans()
Not required for MySQL |
java.lang.String |
unescapeStr(java.lang.String p_Str)
|
SQLRslt |
update(QuerySet p_Qset)
|
| Methods inherited from class com.qanavigation.DBacc.SQLRslt |
|---|
checkRslt, checkRslt, getLastErrorCode, 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.DBacc.ISQLRslt |
|---|
checkRslt, getLastErrorCode, setRsltByExcp |
| 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 ver
| Constructor Detail |
|---|
public MyDBacc(java.lang.String p_DBName,
java.lang.String p_Location,
java.lang.String p_User,
java.lang.String p_PW)
p_DBName - p_Location - IP address host:portp_User - may be "" (but not null);p_PW - may be "" (but not null);| 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)
addBLOB in interface IDBaccBasep_TblName - p_KeyCol - p_Key - p_ContentCol - p_Content -
public SQLRslt chkConn()
chkConn in interface IDBaccBasepublic SQLRslt chkReconn()
chkReconn in interface IDBaccBasepublic SQLRslt close()
close in interface IDBaccBasepublic SQLRslt commit()
commit in interface IDBaccBasepublic java.lang.String escapeStr2(java.lang.String p_Str)
escapeStr2 in interface IDBaccBasep_Str -
public SQLRslt execNoData(java.lang.String p_Query)
execNoData in interface IDBaccBasep_Query -
public RsltTable execRead(java.lang.String p_Query,
java.lang.String[] p_ColNames)
execRead in interface IDBaccBasepublic SQLRslt insert(QuerySet p_Qset)
insert in interface IDBaccBasep_Qset -
public boolean lastInsertDbl(ISQLRslt p_SQLRes)
lastInsertDbl in interface IDBaccBasep_SQLRes -
public void resetRslt()
Rslt
resetRslt in interface IRsltresetRslt in interface ISQLRsltresetRslt in class SQLRsltpublic SQLRslt rollBack()
rollBack in interface IDBaccBasepublic SQLRslt startTrans()
startTrans in interface IDBaccBasepublic java.lang.String unescapeStr(java.lang.String p_Str)
unescapeStr in interface IDBaccBasep_Str -
public SQLRslt update(QuerySet p_Qset)
update in interface IDBaccBasep_Qset -
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||