|
|||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--oracle.jsp.dbutil.DBBean
A very simple bean that provides access to the database and execute queries (only, not DML or DDL).
Bean Properties that can be set and retrieved :
Constructor Summary | |
DBBean()
Default Constructor |
Method Summary | |
void |
close()
Close the database connection and any opened cursors. |
void |
connect()
Establish a database connection with the given user name, password and URL. |
java.lang.String |
getPassword()
Get the password for this data access bean. |
java.lang.String |
getResultAsHTMLTable(java.lang.String sql)
Execute the Sql and return the result as a HTM Table. |
java.lang.String |
getResultAsXMLString(java.lang.String sql)
Execute the Sql and return the result as a XML String |
java.lang.String |
getURL()
Get the URL of the datasource to which connections are made. |
java.lang.String |
getUser()
Get the user name for this data access bean. |
void |
outOfScope(JspScopeEvent ae)
Invoked when a JSP scope that this object is attached to is ending. |
void |
setPassword(java.lang.String password)
Set the password with which connections have to be obtained. |
void |
setURL(java.lang.String url)
Set the URL of the datasource to which connection have to be obtained. |
void |
setUser(java.lang.String user)
Set the user name with which connections have to be obtained. |
Methods inherited from class java.lang.Object |
clone,
equals,
finalize,
getClass,
hashCode,
notify,
notifyAll,
toString,
wait,
wait,
wait |
Constructor Detail |
public DBBean()
Method Detail |
public void setUser(java.lang.String user)
user
- Username to be set.public java.lang.String getUser()
public void setPassword(java.lang.String password)
password
- Passoword to be set.public java.lang.String getPassword()
public void setURL(java.lang.String url)
url
- URL to be set.public java.lang.String getURL()
public void connect() throws java.sql.SQLException
public void close() throws java.sql.SQLException
public java.lang.String getResultAsXMLString(java.lang.String sql) throws java.sql.SQLException
sql
- Sql String to be executedpublic java.lang.String getResultAsHTMLTable(java.lang.String sql) throws java.sql.SQLException
sql
- Sql String to be executedpublic void outOfScope(JspScopeEvent ae)
|
|||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |