1 /* prepare,execute,free,prepare, second prepare should pass.
3 * Author : Jitendra Lenka
11 AbsSqlConnection
*con
= createConnection();
12 rv
= con
->connect("root","manager");
14 AbsSqlStatement
*stmt
= createStatement();
15 stmt
->setConnection(con
);
17 strcpy(statement
,"CREATE TABLE T1(F1 INT,F2 CHAR(20));");
19 rv
= stmt
->prepare(statement
);
20 if(rv
!=OK
) { delete stmt
; delete con
; return 1; }
21 printf("Prepare the Statement\n");
22 rv
= stmt
->execute(rows
);
23 if(rv
!=OK
) { delete stmt
; delete con
; return 2; }
24 printf("Execute the Statement\n");
26 printf("free all the resources\n");
28 strcpy(statement
,"DROP TABLE T1;");
29 rv
= stmt
->prepare(statement
);
31 printf("Test script failed\n");
32 delete stmt
; delete con
; return 3;
34 printf("Again prepare passed\n");
36 strcpy(statement
,"DROP TABLE T1;");
37 rv
= stmt
->prepare(statement
);
38 rv
= stmt
->execute(rows
);
39 if(rv
==OK
)printf("Table dropped successfully\n");
40 stmt
->free(); delete stmt
; delete con
;