conntest3.c

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

/*  close the connection and call prepare ,it should fail

 *  Author : Jitendra Lenka
 */
 
#include<AbsSqlStatement.h>
#include<SqlFactory.h>

int main()
{
  DbRetVal rv = OK;
  AbsSqlConnection *con = SqlFactory::createConnection(CSql);
  rv = con->connect("root","manager");
  if(rv !=OK)return 1;
  printf("Connection opened\n");

  AbsSqlStatement *stmt = SqlFactory::createStatement(CSql); 
  stmt->setConnection(con);
  char statement[200];
  strcpy(statement,"CREATE TABLE T1(F1 INT);");
  
  int  rows;
  rv = con->disconnect();
  if(rv!=OK)return 2;
  printf("Connection closed\n"); 
  
  
  rv = stmt->prepare(statement);
  if(rv==OK)
  {
     
     delete stmt;
     delete con;
     printf("Test script failed\n");
     return 3;
  }
  printf("Test script passed\n");
  delete stmt;
  delete con;
  return 0;
}