|
||||||||||
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 IDBaccBase
p_TblName
- p_KeyCol
- p_Key
- p_ContentCol
- p_Content
-
public SQLRslt chkConn()
chkConn
in interface IDBaccBase
public SQLRslt chkReconn()
chkReconn
in interface IDBaccBase
public SQLRslt close()
close
in interface IDBaccBase
public SQLRslt commit()
commit
in interface IDBaccBase
public java.lang.String escapeStr2(java.lang.String p_Str)
escapeStr2
in interface IDBaccBase
p_Str
-
public SQLRslt execNoData(java.lang.String p_Query)
execNoData
in interface IDBaccBase
p_Query
-
public RsltTable execRead(java.lang.String p_Query, java.lang.String[] p_ColNames)
execRead
in interface IDBaccBase
public SQLRslt insert(QuerySet p_Qset)
insert
in interface IDBaccBase
p_Qset
-
public boolean lastInsertDbl(ISQLRslt p_SQLRes)
lastInsertDbl
in interface IDBaccBase
p_SQLRes
-
public void resetRslt()
Rslt
resetRslt
in interface IRslt
resetRslt
in interface ISQLRslt
resetRslt
in class SQLRslt
public SQLRslt rollBack()
rollBack
in interface IDBaccBase
public SQLRslt startTrans()
startTrans
in interface IDBaccBase
public java.lang.String unescapeStr(java.lang.String p_Str)
unescapeStr
in interface IDBaccBase
p_Str
-
public SQLRslt update(QuerySet p_Qset)
update
in interface IDBaccBase
p_Qset
-
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |