Java applet and Database connection

Question

I'm a building a web application in java. I have to create an applet for displaying some charts to the clients. The problem is that I don't want the applet to connect directly to the database for security reasons.

Which is the best way to get the data without connection to the database? I was thinking of creating a servlet which sends the ResultSet or a list of Strings to the applet with URLConnection. But I'm not sure this is the correct way!

Michael Aaron Safyan · Accepted Answer · 2011-07-04 08:56:47Z

3

Yes, providing a servlet that returns the results in JSON or XML format is the most sensible approach.

answered Jul 4, 2011 at 8:56

Michael Aaron Safyan

96k16 gold badges140 silver badges200 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Talha Ahmed Khan · Accepted Answer · 2011-07-04 09:02:22Z

1

There are many ways to do that. If Java Applet is the solution for you I think you should make a Apache Commons HTTPClient and request a Servlet running on your server. The servlet make the communication with the DB and return the data in either XML or JSON which is you can parse on the Applet.

There are other ways to do that as well. You can make Web-Services for that which serves the same purpose. If I would be on your place I will put my money on RESTFul Service. :)

answered Jul 4, 2011 at 9:02

Talha Ahmed Khan

15.6k10 gold badges46 silver badges49 bronze badges

Collectives™ on Stack Overflow

Java applet and Database connection

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related