1 /* create table T1 ,Insert some records in it.
2 * Close the connection, Fetch should fail.
4 * Author : Jitendra Lenka
12 AbsSqlConnection
*con
= createConnection();
13 rv
= con
->connect("root","manager");
15 printf("Connection opened\n");
16 AbsSqlStatement
*stmt
= createStatement();
17 stmt
->setConnection(con
);
19 strcpy(statement
,"CREATE TABLE T1(F1 INT,F2 INT);");
21 rv
= stmt
->prepare(statement
);
22 if(rv
!=OK
) { delete stmt
; delete con
; return 2; }
23 rv
= stmt
->execute(rows
);
24 if(rv
!=OK
) { delete stmt
; delete con
; return 3; }
26 printf("Table T1 CREATED\n");
27 // insert into statement
28 strcpy(statement
,"INSERT INTO T1 VALUES(1,1);");
29 rv
= stmt
->prepare(statement
);
30 if(rv
!=OK
) { delete stmt
; delete con
; return 4; }
31 rv
= con
->beginTrans();
32 if(rv
!=OK
) { delete stmt
; delete con
; return 5; }
33 rv
= stmt
->execute(rows
); if(rv
!=OK
) return 6;
37 printf("One record inserted\n");
38 strcpy(statement
,"SELECT F2 FROM T1 ;");
39 rv
= stmt
->prepare(statement
);
40 if(rv
!=OK
) { delete stmt
; delete con
; return 10; }
42 stmt
->bindField(1,&id
);
43 rv
= con
->beginTrans();
47 stmt
->close(); stmt
->free();
48 rv
= con
->disconnect(); //close the connection
51 rettype
= (char*)stmt
->fetch();
52 if(rettype
==NULL
&& rv
== OK
) {
53 printf("After closing the connection,fetch failed\n");
54 con
->connect("root", "manager");
55 stmt
->setConnection(con
);
56 strcpy(statement
,"DROP TABLE T1;");
57 rv
= stmt
->prepare(statement
);
58 rv
= stmt
->execute(rows
);
59 if(rv
==OK
) { printf("Table Dropped successfully\n"); }
60 stmt
->free(); delete stmt
; delete con
;
61 printf("Test script passed\n");
64 printf("Test script Failed\n");
65 delete stmt
; delete con
;