This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes connecting java applet with mysql using JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "connecting java applet with mysql using JDBC" Watch "connecting java applet with mysql using JDBC" New topic

connecting java applet with mysql using JDBC

Priya Raja

Joined: Jun 17, 2006
Posts: 21
I have created a table for a database using mysql. I have a java applet and this applet performs its task by getting the start and end position using text box from the user and the remaining other details for the applet to run is to be obtained from mysql table. Is it possible for applets to retrieve the values from the table and work based on that information? how to do it? kindly give me some suggestions and some useful links..I am a newbie in JDBC.

The TIME to be HAPPY is NOW<br />The PLACE to be HAPPY is HERE<br />And the WAY to be HAPPY is to MAKE OTHERS HAPPY
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32818

I think this question relates more to applet connections than JDBC so I'm moving it to our applets forum. If I am wrong, someone can move the thread back here to JDBC.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42959
An applet is Java code like any other code, so whatever you can do in a desktop application or a web app, you can do in an applet.

BUT, applets are only allowed to connect to the server where they are hosted. So if the database is not located on the same machine as the web server that hosts the applet itself, this won't work. Unless the applet is signed, about which you can find more information at HowCanAnAppletReadFilesOnTheLocalFileSystem
I agree. Here's the link:
subject: connecting java applet with mysql using JDBC
jQuery in Action, 3rd edition