OK. Thanks. It can connects to the database now.
Here is a minor problem. The results I obtained from
the query is a ResultSet, rs. I keyed in this code:
while (rs.next())
{
System.out.print(rs.getString("RoomID");
}
In the Tomcat server, it printed the results that I
wanted. How to incorporate that results into the html
code to show on the web page? I tried but it's give me
error that cannot convert ResultSet into String.
Thanks,
Amy Cheung
--- Kwok Peng Tuck <[EMAIL PROTECTED]> wrote:
> Any JDBC driver for mysql (that works for you) will
> do.
>
> Amy Cheung wrote:
>
> >so what kind of connection is best? using the
> >J/Connector or the OCBC one?
> >
> >--- Bill Barker <[EMAIL PROTECTED]> wrote:
> >
> >
> >>Assuming that you aren't using JDBCRealm, then it
> >>should be enough to put
> >>the jar file in $TOMCAT_HOME/lib/apps. If you are
> >>using JDBCRealm, then
> >>place it in $TOMCAT_HOME/lib/common.
> >>
> >>Setting the CLASSPATH is evil ;-).
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
