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.
String sql = "SELECT * FROM CUSTOMERS";
// 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
System.our.println("Field One: " +
"Field Two: " +
"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