tmptest/jdbc/insertT1.java

   1 import java.sql.*;
   2
   3 public class insertT1
   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             boolean rc = stmt.execute( "INSERT INTO t1 (f1, f2) values (2,3)" );
  18             rc = stmt.execute( "INSERT INTO t1 (f1, f2) values (31,80)" );
  19             rc = stmt.execute( "INSERT INTO t1 (f1, f2) values (722,9)" );
  20             con.commit();
  21             stmt.close();
  22
  23             // Disconnect from CSQL
  24             con.close();
  25
  26         } catch(Exception e) {
  27             System.out.println("insertT1: " + e );
  28             e.getStackTrace();
  29         }
  30     }
  31 }