home *** CD-ROM | disk | FTP | other *** search
/ Java Certification Exam Guide / McGrawwHill-JavaCertificationExamGuide.iso / pc / Web Links and Code / code / chap21 / JdbcExample.java < prev   
Encoding:
Java Source  |  1997-04-20  |  917 b   |  38 lines
  1. import java.net.URL;
  2. import java.sql.*;
  3. import sun.jdbc.odbc.*;
  4.  
  5. class JdbcExample {
  6.  
  7.    public static void main(String[] args) {
  8.  
  9.       if (args.length == 0) {
  10.          System.out.println("java JdbcExample <url>");
  11.          System.exit(1);
  12.       }      
  13.  
  14.       try {
  15.          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  16.          Connection con = DriverManager.getConnection(args[0]);
  17.  
  18.          Statement stmt = con.createStatement();
  19.          ResultSet rs = 
  20.             stmt.executeQuery("SELECT name, seat FROM Table1");
  21.  
  22.          while (rs.next()) {
  23.             String name = rs.getString("name");
  24.             int    seat = rs.getInt("seat");
  25.  
  26.             System.out.println(name + " " + seat);
  27.          }
  28.  
  29.          stmt.close();
  30.          con.close();
  31.  
  32.       } catch (Exception x) {
  33.          System.out.println(x.getMessage());
  34.          x.printStackTrace();
  35.       }
  36.    }
  37. }
  38.