1 /* create table T1 with two fields,
2 * insert 10 rows into the table ,
3 * fetch without prepare.
5 * Author : Jitendra Lenka
8 #include<AbsSqlStatement.h>
14 AbsSqlConnection
*con
= SqlFactory :: createConnection(CSql
);
15 rv
= con
->connect("root","manager");
18 AbsSqlStatement
*stmt
= SqlFactory :: createStatement(CSql
);
19 stmt
->setConnection(con
);
22 strcpy(statement
,"CREATE TABLE T1(F1 INT,F2 CHAR(20));");
25 rv
= stmt
->prepare(statement
);
33 rv
= stmt
->execute(rows
);
41 printf("Table created\n");
45 strcpy(statement
,"INSERT INTO T1 VALUES(?,?);");
48 char f2var
[24] = "lakshya";
51 rv
= stmt
->prepare(statement
);
67 rv
= con
->beginTrans();
71 stmt
->setIntParam(1,f1var
);
72 stmt
->setStringParam(2,f2var
);
74 rv
= stmt
->execute(rows
);
80 printf("%d rows inserted\n",count
);
84 //*******************************************
86 strcpy(statement
,"SELECT * FROM T1;");
87 /*rv = stmt->prepare(statement);
94 stmt
->bindField(1,&f1var
);
95 stmt
->bindField(2,f2var
);
99 rv
= con
->beginTrans();
107 ret
= ((char*)stmt
->fetch());
111 printf("fetch failed without prepare\n");
112 strcpy(statement
,"DROP TABLE T1;");
113 rv
= stmt
->prepare(statement
);
114 rv
= stmt
->execute(rows
);
115 if(rv
==OK
){printf("Table dropped successfully\n");}
121 printf("Test script failed\n");