Meaningless Drivel is fun!*
The moose likes JSP and the fly likes web based sql client Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "web based sql client" Watch "web based sql client" New topic
Author

web based sql client

D Tom
Greenhorn

Joined: Feb 03, 2012
Posts: 4
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

Joined: Jan 30, 2012
Posts: 4
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

Joined: Jan 10, 2002
Posts: 60822
    
  65

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.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60822
    
  65

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

    Joined: Jan 30, 2012
    Posts: 4
    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

    Joined: Jan 10, 2002
    Posts: 60822
        
      65

    Yes, I like Tomcat myself, but he doesn't "need" to use it as was implied.
    James Reeves
    Greenhorn

    Joined: Jan 30, 2012
    Posts: 4
    Yes I agree

    Sorry I should of worded that sentence better.
    Bear Bibeault
    Author and ninkuma
    Marshal

    Joined: Jan 10, 2002
    Posts: 60822
        
      65

    I see you're fairly new... welcome to the Ranch!
    Tim Moores
    Rancher

    Joined: Sep 21, 2011
    Posts: 2408
    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

    Joined: Feb 03, 2012
    Posts: 4
    Thank you all for your replies and the learning material links.
     
    I agree. Here's the link: http://aspose.com/file-tools
     
    subject: web based sql client
     
    Similar Threads
    Flex to database
    need a best architecture & desgin patterns for my application
    VS.NET 2003 Example App is somewhat architecturally similar to SCEA app
    Servlet Between Application and SQL Server
    connecting to online SQL DB