tmptest/example.java

   1 import java.sql.*;
   2
   3 public class example
   4 {
   5     public static void main( String argv[] )
   6     {
   7         try
   8         {
   9          Class.forName("csql.jdbc.JdbcSqlDriver");
  10             // Connection handle
  11          Connection con = DriverManager.getConnection("jdbc:csql", "praba", "manager");
  12             // Statement handle
  13          PreparedStatement stmt = con.prepareStatement("UPDATE t1 set f2 = ? WHERE f1 = ?");
  14          for (int i =0 ; i< 10 ; i++) {
  15          stmt.setInt(1, i+200);
  16          stmt.setInt(2, i);
  17          stmt.executeUpdate();
  18          }
  19          stmt.close();
  20          con.commit();
  21          con.close();
  22          }catch(Exception e) {
  23            System.out.println("example: "+e);
  24             e.getStackTrace();
  25          }
  26     }
  27 }