oracle.forms.fd
Class DB_JDBC
java.lang.Object
oracle.forms.fd.DB_JDBC
public class DB_JDBC
- extends java.lang.Object
A class that handle client <--> database communication
via the JDBC driver
- Author:
- Francois Degrelle
Field Summary |
protected oracle.sql.BLOB |
blob
|
protected boolean |
bLog
|
private static DB_JDBC |
instance
|
protected java.lang.String |
sConn
|
protected java.lang.String |
sPwd
|
protected java.lang.String |
sUser
|
Method Summary |
(package private) void |
err(java.lang.String sMessage)
|
(package private) void |
getBLOBtoFile(java.lang.String sTable,
java.lang.String sColumn,
java.lang.String sWhere,
java.lang.String sFileName)
|
(package private) java.util.Vector |
getData(java.lang.String sClause,
int iNbColumns)
|
(package private) java.awt.Image |
getImage(java.lang.String sTable,
java.lang.String sColumn,
java.lang.String sWhere)
|
(package private) java.awt.Image |
getImageFromINStream(java.io.InputStream instream,
int iLength)
|
static DB_JDBC |
getInstance()
|
(package private) int |
getSequence()
|
(package private) java.lang.String |
getTime(java.lang.String sDec,
java.lang.String sFormat)
|
(package private) void |
InsertUpdateData(java.lang.String s)
|
(package private) boolean |
isPasswordOK(java.lang.String sID,
java.lang.String sPass)
|
(package private) void |
log(java.lang.String sMessage)
|
protected int |
sendMessage(java.lang.String sFrom,
java.lang.String sTo,
java.lang.String sTxt)
|
protected int |
sendMessageList(java.lang.String sFrom,
java.lang.String sList,
java.lang.String sTxt)
|
(package private) void |
setConnectString(java.lang.String s1,
java.lang.String s2,
java.lang.String s3)
|
(package private) void |
setLog(boolean b)
|
protected void |
setPassword(java.lang.String sID,
java.lang.String sPass)
|
(package private) boolean |
testConnection()
|
(package private) void |
updateAttachment(java.lang.String sType,
java.lang.String sName,
java.lang.String sSize,
java.lang.String sFileName,
int iSize,
int iID)
|
(package private) void |
writeBLOBFromFile(java.lang.String sTable,
java.lang.String sColumn,
java.lang.String sWhere,
java.lang.String sFileName,
int iSize)
|
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
blob
protected oracle.sql.BLOB blob
bLog
protected boolean bLog
sConn
protected java.lang.String sConn
sUser
protected java.lang.String sUser
sPwd
protected java.lang.String sPwd
instance
private static DB_JDBC instance
DB_JDBC
public DB_JDBC()
getInstance
public static DB_JDBC getInstance()
setConnectString
void setConnectString(java.lang.String s1,
java.lang.String s2,
java.lang.String s3)
setLog
void setLog(boolean b)
testConnection
boolean testConnection()
getImage
java.awt.Image getImage(java.lang.String sTable,
java.lang.String sColumn,
java.lang.String sWhere)
getImageFromINStream
java.awt.Image getImageFromINStream(java.io.InputStream instream,
int iLength)
getBLOBtoFile
void getBLOBtoFile(java.lang.String sTable,
java.lang.String sColumn,
java.lang.String sWhere,
java.lang.String sFileName)
writeBLOBFromFile
void writeBLOBFromFile(java.lang.String sTable,
java.lang.String sColumn,
java.lang.String sWhere,
java.lang.String sFileName,
int iSize)
updateAttachment
void updateAttachment(java.lang.String sType,
java.lang.String sName,
java.lang.String sSize,
java.lang.String sFileName,
int iSize,
int iID)
InsertUpdateData
void InsertUpdateData(java.lang.String s)
getData
java.util.Vector getData(java.lang.String sClause,
int iNbColumns)
sendMessage
protected int sendMessage(java.lang.String sFrom,
java.lang.String sTo,
java.lang.String sTxt)
sendMessageList
protected int sendMessageList(java.lang.String sFrom,
java.lang.String sList,
java.lang.String sTxt)
setPassword
protected void setPassword(java.lang.String sID,
java.lang.String sPass)
getTime
java.lang.String getTime(java.lang.String sDec,
java.lang.String sFormat)
isPasswordOK
boolean isPasswordOK(java.lang.String sID,
java.lang.String sPass)
getSequence
int getSequence()
log
void log(java.lang.String sMessage)
err
void err(java.lang.String sMessage)