need your feedback on running my querries server-side
843859Sep 4 2006 — edited Sep 6 2006Hello all.
I'm building a web applet that will administer a large database.
I've recently been informed that due to the nature of applets this will result in all SQL querries being run on the client-side, thus forcing me to allow outside access to my mysql database. I'm not too thrilled by that thought and was wondering if there's a way around it.
In my applet I have one class named dbOper.java that handles all the sql querries. Is it possible to store this part of the applet server-side and make the client applet interact with it?
Just to clarify in case I'm being too vague. Optimally I'd like the mysql connection string to connect to localhost. This would greatly increase security and would prevent a wise person from getting access to all my SQL methods and potentially doing whatever he wishes with my DB.
Thanks for any input you can give, I appreciate it very much.