שימוש ב-JDBC להפעלת שאילתות על בסיס נתונים

Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);
Connection jdbcConnection = 
	  DriverManager.getConnection
            (jdbc:odbc:Access);
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.

try
{
   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: " + 
                  results.getString(3));
   }
}

   // If there was a problem sending the SQL, 
   // we will get this error.
catch (Exception e)
{
   System.out.println("Problem with Sending Query: " + e);
}