tmptest/jdbc/selectT1.java

   1 import java.sql.*;
   2
   3 public class selectT1
   4 {
   5     public static void main( String argv[] )
   6     {
   7         try
   8         {
   9             // Load JDBC driver
  10             Class.forName("csql.jdbc.JdbcSqlDriver");
  11
  12             // Connect to CSQL
  13             Connection con = DriverManager.getConnection("jdbc:csql", "root", "manager");
  14
  15             // Insert Tuples
  16             Statement stmt = con.createStatement();
  17             ResultSet rs = stmt.executeQuery( "SELECT * FROM t1" );
  18             while( rs.next() )
  19             {
  20                System.out.println( rs.getInt(1) + ", " + rs.getInt(2) );
  21             }
  22             rs.close();
  23             con.commit();
  24             stmt.close();
  25
  26             // Disconnect from CSQL
  27             con.close();
  28
  29         } catch(Exception e) {
  30             System.out.println("selectT1: " + e );
  31             e.getStackTrace();
  32         }
  33     }
  34 }