1 /* create table T1 with 2 fields.
2 * get Metadata by Describe <tblName>
14 AbsSqlConnection
*con
= createConnection();
15 rv
= con
->connect("root","manager");
17 AbsSqlStatement
*stmt
= createStatement();
18 stmt
->setConnection(con
);
20 strcpy(statement
,"CREATE TABLE T1(F1 INT,F2 INT);");
22 rv
= stmt
->prepare(statement
);
23 if(rv
!=OK
) { delete stmt
; delete con
; return 2; }
24 rv
= stmt
->execute(rows
);
25 if(rv
!=OK
) { delete stmt
; delete con
; return 3; }
27 printf("Table T1 created\n");
28 strcpy(statement
,"DESCRIBE T1;");
29 rv
= stmt
->prepare(statement
);
30 char colName
[IDENTIFIER_LENGTH
];
34 stmt
->bindField(4, colName
);
35 stmt
->bindField(5, &sqlType
);
36 stmt
->bindField(7, &length
);
37 stmt
->bindField(11, &isNull
);
39 rv
= stmt
->execute(rows
);
40 if (rv
!= OK
) { printError(rv
, "execute failed"); return rv
; }
41 while (stmt
->fetch(rv
) != NULL
) {
42 printf("cnt = %d\n", i
++);
46 strcpy(statement
,"DROP TABLE T1;");
47 rv
= stmt
->prepare(statement
);
48 if(rv
!=OK
) { delete stmt
; delete con
; return 8; }
49 rv
= stmt
->execute(rows
);
50 if(rv
!=OK
) { delete stmt
; delete con
; return 9; }
51 printf("Table dropped\n");
52 stmt
->free(); delete stmt
; delete con
;