Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

web based sql client

 
D Tom
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi experts,

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?

Thanks in advance.
D Tom



 
James Reeves
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would look at using JSP/Servlets if you wanted to do this application via Java. I would also look into Spring/Hibernate to use as an interface for the JDBC connections.

You would obviously need to use Tomcat to act as the server you need.

I would recommended reading the following book on the topic "Murach's Java Servlets and JSP: 2nd Edition (Murach: Training & Reference)"
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64981
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
James Reeves wrote:You would obviously need to use Tomcat to act as the server you need.

Tomcat is only one of many Java app containers that could be used.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64981
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As a novice to JSP and servlets, I recommend you read these articles:
  • The Secret Life of JSPs
  • The Front Man

  • The first will ensure that you understand what JSP is all about, and the latter discusses properly structuring web applications.
     
    James Reeves
    Greenhorn
    Posts: 4
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Bear Bibeault wrote:
    James Reeves wrote:You would obviously need to use Tomcat to act as the server you need.

    Tomcat is only one of many Java app containers that could be used.


    Yeah I agree, but I found that Tomcat was easier to use. But I suppose that is down to preference.
     
    Bear Bibeault
    Author and ninkuma
    Marshal
    Pie
    Posts: 64981
    86
    IntelliJ IDE Java jQuery Mac Mac OS X
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Yes, I like Tomcat myself, but he doesn't "need" to use it as was implied.
     
    James Reeves
    Greenhorn
    Posts: 4
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Yes I agree

    Sorry I should of worded that sentence better.
     
    Bear Bibeault
    Author and ninkuma
    Marshal
    Pie
    Posts: 64981
    86
    IntelliJ IDE Java jQuery Mac Mac OS X
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    I see you're fairly new... welcome to the Ranch!
     
    Tim Moores
    Bartender
    Posts: 2851
    46
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    James Reeves wrote:I would also look into Spring/Hibernate to use as an interface for the JDBC connections.

    Since the point is to create a SQL client that is probably not such a good idea. Straight JDBC would be a good way to transport SQL queries from the web browser to the DB.
     
    D Tom
    Greenhorn
    Posts: 9
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Thank you all for your replies and the learning material links.
     
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic