selecttest5.c

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

/*   call execute without calling 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;

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

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

  int rows=0;
  /*rv = stmt->prepare(statement);
  if(rv!=OK)
  {
    delete stmt;
    delete con;
    return 1;
 }*/

 rv  = stmt->execute(rows);
 printf("hello\n"); 
 if(rv!=OK)
  {
    delete stmt;
    delete con;
    printf("Execute failed without call prepare\n");
    return 0;
 }
 stmt->free();
 printf("Test script failed\n");

   
   delete stmt;
   delete con;
   return 1;
 }