I'm planning to develop a basic web-based SQL client application that can connect to a database server, send SQL statements from the browser to the database server and display the results from the database server in the browser.
I think there should be a 3 - tier architecture. Browser - Application Server - Database Server to accomplish this.
I have knowledge of core java and jdbc, but don't not much about server side programming.
I need guidance as to how to start on this project. What all java server technologies I need to learn at a minimum in order to achieve this?