selecttest9.c

来自「b树实现源码,linux和unix下运行,速度快,极好用」· C语言 代码 · 共 59 行

/*   prepare,execute,prepare....,
 *   second prepare should pass.

 *   Author : Jitendra Lenka
 */

#include<AbsSqlStatement.h>
#include<SqlFactory.h>
//#include<Info.h>
int main()
{
  DbRetVal rv = OK;
  AbsSqlConnection *con = SqlFactory :: createConnection(CSqlAdapter);
  rv  = con->connect("root","manager");
  if(rv!=OK)return 1;

  AbsSqlStatement *stmt = SqlFactory :: createStatement(CSqlAdapter);
  stmt->setConnection(con);
  char statement[200];

  strcpy(statement,"CREATE TABLE T1(F1 INT,F2 CHAR(20));");

   int rows=0;
   rv = stmt->prepare(statement);
   if(rv!=OK)
   {
     delete stmt;
     delete con;
     return 1;
   }
   printf("Prepared the statement\n");
 
   rv  = stmt->execute(rows);
   if(rv!=OK)
   {
     delete stmt;
     delete con;
     return 2;
   }
   printf("Execute the statement\n");
 
  
  //again prepare

  strcpy(statement,"DROP TABLE T1;");
  rv = stmt->prepare(statement);
  if(rv!=OK)
  {
     printf("Test script failed\n");
     return 3;
  }
  printf("Test script passed\n");
  stmt->execute(rows);
  stmt->free();
  delete stmt;
  delete con;
  return 0;
}