|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.javaWebGen.data.OracleDataManager
public class OracleDataManager
Handles talking to an oracle database. This has not been tested much because I do not have oracle installed. This should work! SOMEDAY It will use Oracle Sequence tables for the next value stuff.
Field Summary | |
---|---|
java.lang.String |
BIG_DECIMAL
|
java.lang.String |
DATE
|
java.lang.String |
INT
|
java.lang.String |
LONG
|
java.lang.String |
OBJECT
|
java.lang.String |
STRING
|
java.lang.String |
TIMESTAMP
|
Constructor Summary | |
---|---|
OracleDataManager()
|
Method Summary | |
---|---|
void |
close(java.sql.Connection con)
close this connection ignoring any errors |
void |
endTransaction(java.sql.Connection con)
end Db tranacton commiting any uncommited data |
java.lang.String |
formatDate(java.util.Date date)
get a String that the Oracle data will accept |
java.sql.Connection |
getConnection()
get db connection |
java.util.Date |
getDate(java.lang.String dateStr)
get a date object by parsing a string the databases native format useful for doing updates etc.. |
int |
getNextValue(java.sql.Connection con,
java.lang.String tablename)
get next value for the primary key |
int |
getNextValue(java.lang.String tablename)
get next value for the primary key |
Sequence |
getSequence()
|
java.lang.String |
getSqlText(java.lang.String text)
get a String that is escaped (handles ') Oracle likes '' not \' |
java.lang.String[] |
getTableList()
EXPERIMENTAL returns a list of tables |
void |
init()
|
void |
rollbackTransaction(java.sql.Connection con)
rollback uncommited data ignoring any errors |
void |
setReader(PropertiesReader propReader)
|
void |
setSequence(Sequence seq)
Use this sequence generator NOTE this should not be used by a calling class |
void |
startTransaction(java.sql.Connection con)
start Db tranacton |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public final java.lang.String BIG_DECIMAL
public final java.lang.String LONG
public final java.lang.String INT
public final java.lang.String STRING
public final java.lang.String OBJECT
public final java.lang.String DATE
public final java.lang.String TIMESTAMP
Constructor Detail |
---|
public OracleDataManager()
Method Detail |
---|
public void setReader(PropertiesReader propReader)
setReader
in interface DataManager
public Sequence getSequence()
getSequence
in interface DataManager
public void setSequence(Sequence seq)
DataManager
setSequence
in interface DataManager
seq
- sequence objectpublic void init()
init
in interface DataManager
public java.sql.Connection getConnection() throws java.sql.SQLException
DataManager
getConnection
in interface DataManager
java.sql.SQLException
public void close(java.sql.Connection con)
DataManager
close
in interface DataManager
con
- db connectionpublic int getNextValue(java.lang.String tablename) throws DBException
DataManager
getNextValue
in interface DataManager
tablename
- table name
DBException
public int getNextValue(java.sql.Connection con, java.lang.String tablename) throws java.sql.SQLException
DataManager
getNextValue
in interface DataManager
con
- db connectiontablename
- table name
java.sql.SQLException
public void startTransaction(java.sql.Connection con) throws java.sql.SQLException
DataManager
startTransaction
in interface DataManager
con
- db connection
java.sql.SQLException
public void endTransaction(java.sql.Connection con) throws java.sql.SQLException
DataManager
endTransaction
in interface DataManager
con
- db connection
java.sql.SQLException
public void rollbackTransaction(java.sql.Connection con)
DataManager
rollbackTransaction
in interface DataManager
con
- db connectionpublic java.lang.String formatDate(java.util.Date date)
formatDate
in interface DataManager
date
- to convert
public java.util.Date getDate(java.lang.String dateStr) throws java.text.ParseException
getDate
in interface DataManager
dateStr
- date text
java.text.ParseException
public java.lang.String getSqlText(java.lang.String text)
getSqlText
in interface DataManager
text
- input text
public java.lang.String[] getTableList() throws java.sql.SQLException
getTableList
in interface DataManager
java.sql.SQLException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |