1 #include<AbsSqlStatement.h>
7 AbsSqlConnection
*con
= SqlFactory :: createConnection(CSqlGateway
);
8 rv
= con
->connect("root","manager");
11 AbsSqlStatement
*stmt
= SqlFactory :: createStatement(CSqlGateway
);
12 stmt
->setConnection(con
);
14 strcpy(statement
,"insert into t1 values(60,'GGG');");
17 rv
= stmt
->prepare(statement
);
18 if(rv
!=OK
) { delete stmt
; delete con
; return 1; }
20 rv
= stmt
->execute(rows
);
21 if(rv
!=OK
) { delete stmt
; delete con
; return 2; }
24 printf("csql down: insert into t1(cached table) success\n");
26 strcpy(statement
,"insert into t2 values(60,'GGG');");
28 rv
= stmt
->prepare(statement
);
29 if(rv
!=OK
) { delete stmt
; delete con
; return 3; }
30 rv
= stmt
->execute(rows
);
31 if(rv
!=OK
) { printf("csql down: insert into t2(not cached mysql table) failed\n"); delete stmt
; delete con
; return 4; }
32 printf("csql down: insert into t2(not cached mysql table) success\n");
35 strcpy(statement
,"insert into t3 values(60,'GGG');");
37 rv
= stmt
->prepare(statement
);
38 if(rv
!=OK
) { delete stmt
; delete con
; return 5; }
39 rv
= stmt
->execute(rows
);
40 if(rv
!=OK
) { printf("csql down: insert into t3(not cached csql table) failed\n"); stmt
->free(); delete stmt
; con
->disconnect();delete con
; return 6; }
41 printf("csql down: insert into t3(not cached csql table) success\n");