stmttest3.java

b树实现源码,linux和unix下运行,速度快,极好用

//close() and then execute INSERT/QUERY/UPDATE statement. It should fail
import java.sql.*;
public class StmtTest3 
{
    public static void main(String[] args) 
    {
       try
       {
           Class.forName("csql.jdbc.JdbcSqlDriver");
           Connection con = DriverManager.getConnection("jdbc:csql", "root", "manager");
           Statement cStmt = con.createStatement();
           cStmt.execute("CREATE TABLE T1 (f1 integer, f2 char (20));");
           cStmt.execute("CREATE INDEX IDX ON T1 ( f1);");
           con.commit();
           con.close();

		   //after close the connection,execute "INSERT" statement,it should fail
		   try
		   {
               cStmt.execute("INSERT INTO T1 VALUES (1, 'FIRST');");
			   System.exit(1);
		   }
		   catch(Exception e)
		   {
		       System.out.println("insert exception---" + e.getMessage());
		   }

           //after close the connection,execute "QUERY" statement,it should fail
		   try
		   {
               cStmt.executeQuery("SELECT * from T1 where f1 = 1;");
			   System.exit(2);
		   }
		   catch(Exception e)
		   {
		       System.out.println("query exception---" + e.getMessage());
		   }

		   //after close the connection,execute "UPDATE" statement,it should fail
		   try
		   {
               cStmt.executeUpdate("UPDATE T1 SET f2 = 'CHANGED' WHERE f1 = 1;");
			   System.exit(3);
		   }
		   catch(Exception e)
		   {
		       System.out.println("update exception---" + e.getMessage()); 
		   }

           //cleanup 
           cStmt.execute("DROP TABLE T1 ;");
		   cStmt.close();
           con.close();
        }catch(Exception e) {
            System.out.println("Exception in Test: " + e.getMessage());
            e.printStackTrace();
			System.exit(4);
        }
    }
}