Hi this is my connection to the database from inside my JApplet.


Class.forName("oracle.jdbc.driver.OracleDriver");
        con = DriverManager.getConnection
("jdbc:oracle:thin:@seagull.magardi.com:1521:jilldb", "user", "pass");
        stmt = con.createStatement();
        rs = stmt.executeQuery("SELECT email_address FROM cfg_app_users WHERE
first_name = 'Troy'");


Thanks

Troy


-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
dushyanth harinath
Sent: Saturday, September 02, 2000 12:34 AM
To: [EMAIL PROTECTED]
Subject: Re: JApplet DB connection


Hi.
It would be better if u tell us what driver u r using
and the url that u r giving to connect to the database
from the JApplet.
bye
dushyanth
--- Troy Rowe <[EMAIL PROTECTED]> wrote: > Sorry for
the NON servlet question.
>
> I was wondering if anyone out there connects to a
> database through a
> JApplet.
>
> I have a japplet sending parameters to a servlet and
> the servlet based on
> the parameters then sends emails.  What I want is
> for the applet to connect
> to a database and retreive email addresses from a
> user table and then
> display them in a JList.
>
> Everything works fine for a hardcoded email address,
> but when I try to use a
> connection to the database, no email is sent.  Even
> when I just try to
> retrieve the email address from the db and print it
> out somewhere.
>
> SOooo from all of that I hope you gathered that
> obvisoulsy there is no
> connection taking place.  However I have used this
> connection many times in
> my servlets.
>
> CAN ANYONE HELP?
>
> Thanks in advance.
>
> PS.  Sorry to those who consider this inapporiate
> for this userlist.  : )
>
>
> ~~~~~~~~~~~~~~~
> Troy Rowe
> GUI Developer
> www.magardi.com
> ~~~~~~~~~~~~~~~
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED]
> and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives:
>
http://archives.java.sun.com/archives/servlet-interest.html
> Resources:
>
http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help:
http://www.lsoft.com/manuals/user/user.html


=====
H.Dushyanth
Web Programmer
Archean Infotech Limited
http://www.archeanit.com
Where Technology Meets Business

____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.in address at http://mail.yahoo.co.in

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

Reply via email to