test/jdbc/Threads/noIndexTest.java

   1 /*
   2  * To change this template, choose Tools | Templates
   3  * and open the template in the editor.
   4  */
   5
   6 import java.sql.*;
   7 /**
   8  *
   9  * @author bijaya
  10  */
  11
  12 public class  noIndexTest{
  13
  14     public static void main(String[] args) {
  15      try
  16        {
  17
  18
  19            int noOfThreads=5;
  20            int noOfRecords=1000;
  21            Class.forName("csql.jdbc.JdbcSqlDriver");
  22            Connection con = DriverManager.getConnection("jdbc:csql:", "root", "manager");
  23            Statement cStmt = con.createStatement();
  24            cStmt.execute("CREATE TABLE emp (f1 int, f2 char (20));");
  25            connect[] conth= new connect[10];
  26            System.out.println("Table Insert");
  27            for(int i=0;i<noOfThreads;i++)
  28            {
  29                conth[i] = new connect(i,0,noOfRecords);
  30            }
  31            for(int i=0;i<noOfThreads;i++)
  32            {
  33               conth[i].th.join();
  34            }
  35            System.out.println("Table Select");
  36
  37            for(int i=0;i<noOfThreads;i++)
  38            {
  39                conth[i] = new connect(i,1,noOfRecords);
  40            }
  41            for(int i=0;i<noOfThreads;i++)
  42            {
  43               conth[i].th.join();
  44            }
  45            System.out.println("Table Update");
  46            for(int i=0;i<noOfThreads;i++)
  47            {
  48                conth[i] = new connect(i,2,noOfRecords);
  49            }
  50            for(int i=0;i<noOfThreads;i++)
  51            {
  52               conth[i].th.join();
  53            }
  54            System.out.println("Table delete");
  55            for(int i=0;i<noOfThreads;i++)
  56            {
  57                conth[i] = new connect(i,3,noOfRecords);
  58            }
  59            for(int i=0;i<noOfThreads;i++)
  60            {
  61               conth[i].th.join();
  62            }
  63
  64            System.out.println("Drop Table ");
  65
  66            cStmt.execute("DROP TABLE emp ;");
  67            con.close();
  68         }catch(Exception e) {
  69             System.out.println("Exception in Test: "+e);
  70             e.printStackTrace();
  71         }
  72     }
  73  }
  74
  75