|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectto.etc.dbutil.GenericDB
public class GenericDB
A generic database access class to hide differences between databases.
Field Summary | |
---|---|
static BaseDB |
dbtypeMYSQL
|
static BaseDB |
dbtypeORACLE
|
static BaseDB |
dbtypeORANXO
|
static BaseDB |
dbtypePOSTGRESQL
|
static BaseDB |
dbtypeUNKNOWN
|
Method Summary | |
---|---|
static java.lang.String |
getCheckString(BaseDB dbtype)
|
static BaseDB |
getDbType(java.sql.Connection dbc)
Tries to return a database type for the connection passed. |
static BaseDB |
getDbTypeByDriverName(java.lang.String dn)
|
static int |
getFullSequenceID(java.sql.Connection dbc,
java.lang.String tablename)
|
static java.io.Reader |
getLobReader(java.sql.Connection dbc,
java.sql.ResultSet rs,
int col)
Returns a Reader from the blob (clob) column specified. |
static java.io.Reader |
getLobReader(java.sql.Connection dbc,
java.sql.ResultSet rs,
java.lang.String col)
Returns a Reader from the blob (clob) column specified. |
static java.io.InputStream |
getLobStream(java.sql.Connection dbc,
java.sql.ResultSet rs,
int col)
Returns an InputStream from the blob (clob) column specified. |
static java.io.InputStream |
getLobStream(java.sql.Connection dbc,
java.sql.ResultSet rs,
java.lang.String col)
Returns an InputStream from the blob (clob) column specified. |
static int |
getSequenceID(java.sql.Connection dbc,
java.lang.String tablename)
Returns a sequence number that can be used to create a new PK for a record in the given table. |
static boolean |
saveBlob(java.sql.ResultSet rs,
int col,
java.io.File f)
Saves a BLOB from a resultset to a file using Oracle semantics. |
static boolean |
saveBlob(java.sql.ResultSet rs,
int col,
java.io.OutputStream os)
|
static boolean |
saveBlob(java.sql.ResultSet rs,
java.lang.String col,
java.io.File f)
|
static void |
setBlob(java.sql.Connection dbc,
java.lang.String table,
java.lang.String column,
java.lang.String[] pkfields,
java.lang.Object[] key,
java.io.File f)
|
static void |
setBlob(java.sql.Connection dbc,
java.lang.String table,
java.lang.String column,
java.lang.String[] pkfields,
java.lang.Object[] key,
java.io.InputStream is)
|
static void |
setBlob(java.sql.Connection dbc,
java.lang.String table,
java.lang.String column,
java.lang.String where,
byte[][] data)
Writes a blob to the requested record. |
static void |
setBlob(java.sql.Connection dbc,
java.lang.String table,
java.lang.String column,
java.lang.String where,
java.io.File f)
Writes a blob to the requested record. |
static void |
setBlob(java.sql.Connection dbc,
java.lang.String table,
java.lang.String column,
java.lang.String where,
java.io.InputStream is)
Writes a blob to the requested record. |
static void |
setBlob(java.sql.Connection dbc,
java.lang.String table,
java.lang.String column,
java.lang.String where,
java.lang.String str)
|
static void |
setClob(java.sql.Connection dbc,
java.lang.String table,
java.lang.String column,
java.lang.String where,
java.io.Reader r)
|
static void |
setClob(java.sql.Connection dbc,
java.lang.String table,
java.lang.String column,
java.lang.String where,
java.lang.String content)
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final BaseDB dbtypeUNKNOWN
public static final BaseDB dbtypeORACLE
public static final BaseDB dbtypeMYSQL
public static final BaseDB dbtypePOSTGRESQL
public static final BaseDB dbtypeORANXO
Method Detail |
---|
public static BaseDB getDbType(java.sql.Connection dbc)
dbc
- the connection to check
public static BaseDB getDbTypeByDriverName(java.lang.String dn)
public static int getSequenceID(java.sql.Connection dbc, java.lang.String tablename) throws java.sql.SQLException
dbc
- tablename
-
java.sql.SQLException
public static int getFullSequenceID(java.sql.Connection dbc, java.lang.String tablename) throws java.sql.SQLException
java.sql.SQLException
public static java.lang.String getCheckString(BaseDB dbtype)
public static void setBlob(java.sql.Connection dbc, java.lang.String table, java.lang.String column, java.lang.String where, java.io.File f) throws java.lang.Exception
java.lang.Exception
public static void setBlob(java.sql.Connection dbc, java.lang.String table, java.lang.String column, java.lang.String where, java.lang.String str) throws java.lang.Exception
java.lang.Exception
public static void setBlob(java.sql.Connection dbc, java.lang.String table, java.lang.String column, java.lang.String where, java.io.InputStream is) throws java.lang.Exception
java.lang.Exception
public static void setBlob(java.sql.Connection dbc, java.lang.String table, java.lang.String column, java.lang.String where, byte[][] data) throws java.lang.Exception
java.lang.Exception
public static void setBlob(java.sql.Connection dbc, java.lang.String table, java.lang.String column, java.lang.String[] pkfields, java.lang.Object[] key, java.io.InputStream is) throws java.sql.SQLException
java.sql.SQLException
public static void setBlob(java.sql.Connection dbc, java.lang.String table, java.lang.String column, java.lang.String[] pkfields, java.lang.Object[] key, java.io.File f) throws java.sql.SQLException
java.sql.SQLException
public static java.io.Reader getLobReader(java.sql.Connection dbc, java.sql.ResultSet rs, int col) throws java.lang.Exception
rs
- col
-
java.lang.Exception
public static java.io.Reader getLobReader(java.sql.Connection dbc, java.sql.ResultSet rs, java.lang.String col) throws java.lang.Exception
rs
- col
-
java.lang.Exception
public static java.io.InputStream getLobStream(java.sql.Connection dbc, java.sql.ResultSet rs, int col) throws java.lang.Exception
rs
- col
-
java.lang.Exception
public static java.io.InputStream getLobStream(java.sql.Connection dbc, java.sql.ResultSet rs, java.lang.String col) throws java.lang.Exception
rs
- col
-
java.lang.Exception
public static void setClob(java.sql.Connection dbc, java.lang.String table, java.lang.String column, java.lang.String where, java.io.Reader r) throws java.lang.Exception
java.lang.Exception
public static void setClob(java.sql.Connection dbc, java.lang.String table, java.lang.String column, java.lang.String where, java.lang.String content) throws java.lang.Exception
java.lang.Exception
public static boolean saveBlob(java.sql.ResultSet rs, int col, java.io.File f) throws java.lang.Exception
java.lang.Exception
public static boolean saveBlob(java.sql.ResultSet rs, java.lang.String col, java.io.File f) throws java.lang.Exception
java.lang.Exception
public static boolean saveBlob(java.sql.ResultSet rs, int col, java.io.OutputStream os) throws java.lang.Exception
java.lang.Exception
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |