JSP reading Oracle Tables...

Posted on 2006-05-23
Last Modified: 2010-04-01
Can JSP read Oracle tables? I've seen stuff like this done in ASP.NET, but I'm completely unfamiliar with using JSP/Java to connect to an Oracle Database and read-in information and send Queries and use results from those in outputs. Is there a place I can grab some APIs for doing this or examples??

Question by:kak39
    LVL 3

    Accepted Solution

    A JSP page can (almost) do everything that a Java class can do, although it shouldn't.

    If you want to do this the quick'n'dirty way, there is a set of JSP Tag Libraries that allow you to connect to a database, define an SQL query and execute it, and then use the rows for processing in your jsp page. You can find that here: with documentation here: and the binaries necessary here:

    If you are looking for an alternative solution, I would suggest calling a servlet that does your processing for you (Using something of this nature: )

    Hope this helps
    LVL 7

    Assisted Solution

    Like ASP.NET, you need to use the objects that JAVA provides for data access.

    Driver DriverObj = (Driver)Class.forName("Insert Driver String").newInstance();
    Connection ConnectionObj = DriverManager.getConnection("ConnectionString", "UsernameString", "PasswordString");
    PreparedStatment StatementObj = ConnectionObj.prepareStatement("SELECT * FROM SOMETABLE");
    ResultSet ResultsObj = StatementObj.executeUpdate();

      // Fun Stuff

    That should help get you started.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
    Local Continuous Replication is a cost effective and quick way of backing up Exchange server data. The following article describes the steps required to configure Local Continuous Replication. Also, the article tells you how to restore from a backup…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This video discusses moving either the default database or any database to a new volume.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now