1 /* create table T1 with two fields,
2 * insert 10 rows into the table ,
3 * fetch without prepare.
5 * Author : Jitendra Lenka
13 AbsSqlConnection
*con
= createConnection();
14 rv
= con
->connect("root","manager");
16 AbsSqlStatement
*stmt
= createStatement();
17 stmt
->setConnection(con
);
19 strcpy(statement
,"CREATE TABLE T1(F1 INT,F2 CHAR(20));");
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 created\n");
28 strcpy(statement
,"INSERT INTO T1 VALUES(?,?);");
30 char f2var
[24] = "lakshya";
31 rv
= stmt
->prepare(statement
);
32 if(rv
!=OK
) { delete stmt
; delete con
; return 3; }
34 for(int i
=0;i
<2;i
++) {
35 for(int j
=0;j
<5;j
++) {
37 rv
= con
->beginTrans();
39 stmt
->setIntParam(1,f1var
);
40 stmt
->setStringParam(2,f2var
);
41 rv
= stmt
->execute(rows
);
47 printf("%d rows inserted\n",count
);
50 //*******************************************
51 strcpy(statement
,"SELECT * FROM T1;");
52 stmt
->bindField(1,&f1var
);
53 stmt
->bindField(2,f2var
);
56 rv
= con
->beginTrans();
60 ret
= ((char*)stmt
->fetch());
62 printf("fetch failed without prepare\n");
63 strcpy(statement
,"DROP TABLE T1;");
64 rv
= stmt
->prepare(statement
);
65 rv
= stmt
->execute(rows
);
66 if(rv
==OK
){printf("Table dropped successfully\n");}
67 stmt
->free(); delete stmt
; delete con
; return 0;
69 printf("Test script failed\n");
71 delete stmt
; delete con
;