Working with a Result Set : JDBC ODBC « Database « Java Tutorial

1. Java Tutorial
2. Database
3. JDBC ODBC

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class ResultSetExample {
  public static void main(String args[]) {
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

      Connection con = DriverManager.getConnection("jdbc:odbc:Inventory", "", "");

      Statement stmt = con.createStatement();

      ResultSet rs = stmt.executeQuery("SELECT SupplierName,ProductName, Price "
          + "FROM ProductSuppliersView WHERE CategoryName LIKE '%BEVERAGES%' ");
      while (rs.next()) {
        String supplier = rs.getString("SupplierName");
        String product = rs.getString("ProductName");
        int price = rs.getInt("Price");

        System.out.println(supplier + " sells " + product + " for $" + price);
      }

      stmt.close();
      con.close();
    } catch (Exception e) {
      System.out.println(e);
    }
  }
}