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
);
15 if(0==strcmp(getenv("DSN"),"db2"))
16 strcpy(statement
,"insert into t1 values(11, 33, 4234, 'mohan', 34.34, 345.543, '1999-02-23', '11:22:33', '1999-02-23 11:22:33');");
18 strcpy(statement
,"insert into t1 values(11, 33, 4234, 'mohan', 34.34, 345.543, '1999/02/23', '11:22:33', '1999/02/23 11:22:33');");
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; }
27 printf("csql down: insert into t1(cached table) success\n");
29 if(0==strcmp(getenv("DSN"),"db2"))
30 strcpy(statement
,"insert into t2 values(11, 33, 4234, 'mohan', 34.34, 345.543, '1999-02-23', '11:22:33', '1999-02-23 11:22:33');");
32 strcpy(statement
,"insert into t2 values(11, 33, 4234, 'mohan', 34.34, 345.543, '1999/02/23', '11:22:33', '1999/02/23 11:22:33');");
34 rv
= stmt
->prepare(statement
);
35 if(rv
!=OK
) { delete stmt
; delete con
; return 3; }
36 rv
= stmt
->execute(rows
);
37 if(rv
!=OK
) { printf("csql down: insert into t2(not cached mysql table) failed\n"); delete stmt
; delete con
; return 4; }
38 printf("csql down: insert into t2(not cached mysql table) success\n");
41 if(0==strcmp(getenv("DSN"),"db2"))
42 strcpy(statement
,"insert into t3 values(11, 33, 4234, 'mohan', 34.34, 345.543, '1999-02-23', '11:22:33', '1999-02-23 11:22:33');");
44 strcpy(statement
,"insert into t3 values(11, 33, 4234, 'mohan', 34.34, 345.543, '1999/02/23', '11:22:33', '1999/02/23 11:22:33');");
46 rv
= stmt
->prepare(statement
);
47 if(rv
!=OK
) { delete stmt
; delete con
; return 5; }
48 rv
= stmt
->execute(rows
);
49 if(rv
!=OK
) { printf("csql down: insert into t3(not cached csql table) failed\n"); delete stmt
; delete con
; return 6; }
50 printf("csql down: insert into t3(not cached csql table) success\n");