tmptest/jdbc/createT1.java

   1 import java.sql.*;
   2
   3 public class createT1
   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             // Create Table
  16             Statement stmt = con.createStatement();
  17             boolean rc = stmt.execute( "CREATE TABLE t1 (f1 int, f2 int)" );
  18             con.commit();
  19             stmt.close();
  20
  21             // Disconnect from CSQL
  22             con.close();
  23
  24                 } catch(Exception e) {
  25             System.out.println("createT1: " + e );
  26             e.getStackTrace();
  27                 }
  28     }
  29 }
  30
  31
  32