com.qanavigation.DBacc
Class MyDBacc

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

public class MyDBacc
extends SQLRslt
implements IDBaccBase


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

ver

public java.lang.String ver
Constructor Detail

MyDBacc

public 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. A URL is constructed, but the parameters are not escaped yet.

Parameters:
p_DBName -
p_Location - IP address host:port
p_User - may be "" (but not null);
p_PW - may be "" (but not null);
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)
Add a byte stream

Specified by:
addBLOB in interface IDBaccBase
Parameters:
p_TblName -
p_KeyCol -
p_Key -
p_ContentCol -
p_Content -
Returns:

chkConn

public SQLRslt chkConn()
Specified by:
chkConn in interface IDBaccBase

chkReconn

public SQLRslt chkReconn()
Specified by:
chkReconn in interface IDBaccBase
Returns:
Checks connection and tries to reconnect.

close

public SQLRslt close()
Specified by:
close in interface IDBaccBase
Returns:

commit

public SQLRslt commit()
Specified by:
commit in interface IDBaccBase
Returns:

escapeStr2

public java.lang.String escapeStr2(java.lang.String p_Str)
Prepares a string for the DB. Escapes """, "'", "\".

Specified by:
escapeStr2 in interface IDBaccBase
Parameters:
p_Str -
Returns:

execNoData

public SQLRslt execNoData(java.lang.String p_Query)
For queries that do not add data or expect any result back.

Specified by:
execNoData in interface IDBaccBase
Parameters:
p_Query -
Returns:

execRead

public RsltTable execRead(java.lang.String p_Query,
                          java.lang.String[] p_ColNames)
forced to public by interface

Specified by:
execRead in interface IDBaccBase

insert

public SQLRslt insert(QuerySet p_Qset)
Specified by:
insert in interface IDBaccBase
Parameters:
p_Qset -
Returns:

lastInsertDbl

public boolean lastInsertDbl(ISQLRslt p_SQLRes)
Specified by:
lastInsertDbl in interface IDBaccBase
Parameters:
p_SQLRes -
Returns:

resetRslt

public void resetRslt()
Description copied from class: Rslt
Set back to OK, dumps all messages.

Specified by:
resetRslt in interface IRslt
Specified by:
resetRslt in interface ISQLRslt
Overrides:
resetRslt in class SQLRslt

rollBack

public SQLRslt rollBack()
Specified by:
rollBack in interface IDBaccBase
Returns:

startTrans

public SQLRslt startTrans()
Not required for MySQL

Specified by:
startTrans in interface IDBaccBase
Returns:

unescapeStr

public java.lang.String unescapeStr(java.lang.String p_Str)
Specified by:
unescapeStr in interface IDBaccBase
Parameters:
p_Str -
Returns:

update

public SQLRslt update(QuerySet p_Qset)
Specified by:
update in interface IDBaccBase
Parameters:
p_Qset -
Returns:


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