oracle.forms.fd
Class DB_JDBC

java.lang.Object
  extended by 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
           
 
Constructor Summary
DB_JDBC()
           
 
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
 

Field Detail

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

DB_JDBC

public DB_JDBC()
Method Detail

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)