Code Samples

These code examples and other materials are subject to Sun Microsystems, Inc. Legal Terms

Getting All Rows from a Database Table

This example retrieves all the rows from a table called ``mytable''. A row in ``mytable'' consists of a string, integer, and floating point number. 
 try {
   Statement stmt = connection.createStatement();
     
   // Get data using colunm names.
   ResultSet rs = stmt.executeQuery(
     "SELECT * FROM mytable");
   while (rs.next()) {
     String s = rs.getString("COL_A");
     int i = rs.getInt("COL_B");
     float f = rs.getFloat("COL_C");
     process(s, i, f);
   }
    
   // Get data using colunm numbers.
   rs = stmt.executeQuery(
     "SELECT * FROM mytable");
   while (rs.next()) {
     String s = rs.getString(1);
     int i = rs.getInt(2);
     float f = rs.getFloat(3);
     process(s, i, f);
   }
 } catch (SQLException e) {
 }

ExampletsTM  are Copyrighted 2000 by Addison-Wesley and Patrick Chan
and are provided as a courtesy for your educational, non-commercial use.

Order this book from Amazon

[ This page was updated: 11-Sep-2000 ]

For more information on Java technology
and other software from Sun Microsystems, call:
 (800) 786-7638
 Outside the U.S. and Canada, dial your country's AT&T Direct Access Number first.
 		Sun Microsystems, Inc.
Copyright © 1995-2000 Sun Microsystems, Inc.
All Rights Reserved. Terms of Use. Privacy Policy.