1 /* create table T1 , insert and update
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 1; }
23 rv
= stmt
->execute(rows
);
24 if(rv
!=OK
) { delete stmt
; delete con
; return 2; }
26 printf("Table T1 CREATED\n");
27 strcpy(statement
,"INSERT INTO T1 VALUES(1,1);");
28 rv
= stmt
->prepare(statement
);
29 if(rv
!=OK
) { delete stmt
; delete con
; return 3; }
30 rv
= con
->beginTrans();
31 if(rv
!=OK
) { delete stmt
; delete con
; return 4; }
32 rv
= stmt
->execute(rows
);
33 if(rv
!=OK
) { delete stmt
; delete con
; return 5; }
34 printf("1 Record inserted\n");
36 strcpy(statement
,"UPDATE T1 SET F2=100;");
37 rv
= stmt
->prepare(statement
);
38 if(rv
!=OK
) { delete stmt
; delete con
; return 6; }
39 rv
= stmt
->execute(rows
);
40 if(rv
!=OK
&& rows
!=1)return 7;
41 printf("1 Record updated\n");
46 strcpy(statement
,"SELECT F2 FROM T1 ;");
47 rv
= stmt
->prepare(statement
);
48 if(rv
!=OK
) { delete stmt
; delete con
; return 9; }
50 stmt
->bindField(1,&id
);
51 rv
= con
->beginTrans();
55 while(stmt
->fetch()!=NULL
) {
56 printf("F2= %d\n",id
);
62 printf("Total record fetched =%d ,Because transaction rollbacked\n",count
);
64 strcpy(statement
,"DROP TABLE T1;");
65 rv
= stmt
->prepare(statement
);
66 if(rv
!=OK
) { delete stmt
; delete con
; return 11; }
67 rv
= stmt
->execute(rows
);
68 if(rv
!=OK
) { delete stmt
; delete con
; return 12; }
69 printf("Table droped\n");
70 stmt
->free(); delete stmt
; delete con
;