eXtropia: the open web technology company
Technology | Support | Tutorials | Development | About Us | Users | Contact Us
 ::   Tutorials
 ::   Presentations
Perl & CGI tutorials
 ::   Intro to Perl/CGI and HTML Forms
 ::   Intro to Windows Perl
 ::   Intro to Perl 5
 ::   Intro to Perl
 ::   Intro to Perl Taint mode
 ::   Sherlock Holmes and the Case of the Broken CGI Script
 ::   Writing COM Components in Perl

Java tutorials
 ::   Intro to Java
 ::   Cross Browser Java

Misc technical tutorials
 ::   Intro to The Web Application Development Environment
 ::   Introduction to XML
 ::   Intro to Web Design
 ::   Intro to Web Security
 ::   Databases for Web Developers
 ::   UNIX for Web Developers
 ::   Intro to Adobe Photoshop
 ::   Web Programming 101
 ::   Introduction to Microsoft DNA

Misc non-technical tutorials
 ::   Misc Technopreneurship Docs
 ::   What is a Webmaster?
 ::   What is the open source business model?
 ::   Technical writing
 ::   Small and mid-sized businesses on the Web

Offsite tutorials
 ::   ISAPI Perl Primer
 ::   Serving up web server basics
 ::   Introduction to Java (Parts 1 and 2) in Slovak


Introduction to Databases for Web Developers
Using JDBC to Query a Database  
Once you have the statement handle, it is very easy to query the database. To do so, you use the statement handle to send standard SQL to the database and then parse through the results returned from the database. Take a look at the following example.

Connection jdbcConnection =
Statement sqlStatement = jdbcConnection.createStatement();

        // We have seen all of the above before.
        // No surprises so far.  in the next line, we
        // will simply create a string of SQL.


        // Next we will attempt to send the SQL command to
        // the database.  If it works, the database will
        // return to us a set of results that JDBC will
        // store in a ResultSet object.

  ResultSet results = sqlStatement.executeQuery(sql);

        // We simply go through the ResultSet object
        // one element at a time and print out the
        // fields.  In this example, we assume that
        // the result set will contain three fields

  while (results.next())
    System.our.println("Field One: " +
                       results.getString(1) +
                       "Field Two: " +
                       results.getString(2) +
                       "Field Three: " +

        // If there was a problem sending the SQL,
        // we will get this error.

catch (Exception e)
  System.out.println("Problem with Sending Query: " + e);

Note that if the field is an Integer, you should use the getInt() method in ResultSet instead of getString()

Previous | Next | Table of Contents