1 /* create table T1 with 10 fields.
2 * insert some records into it.
3 * noOfParamFields() should return 10.
4 * getParamFldInfo() for all fields and print the field info.
7 * Author : Jitendra Lenka.
15 AbsSqlConnection
*con
= createConnection();
16 rv
= con
->connect("root","manager");
18 AbsSqlStatement
*stmt
= createStatement();
19 stmt
->setConnection(con
);
21 strcpy(statement
,"CREATE TABLE T1(F1 INT,F2 SMALLINT,F3 CHAR(30),F4 FLOAT,F5 FLOAT,F6 DATE,F7 TIME,F8 TIMESTAMP,F9 INT,F10 BIGINT, F11 BINARY(4));");
23 rv
= stmt
->prepare(statement
);
24 if(rv
!=OK
) { delete stmt
; delete con
; return 2; }
25 rv
= stmt
->execute(rows
);
26 if(rv
!=OK
) { delete stmt
; delete con
; return 3; }
28 printf("Table created\n");
30 strcpy(statement
,"INSERT INTO T1 VALUES(?,?,?,?,?,?,?,?,?,?,?);");
33 char f3var
[32]="jitendra";
37 f6var
.set(2007,01,21);
41 f8var
.setDate(2007,01,21);
42 f8var
.setTime(12,29,30);
44 long long f10var
= 12000;
45 char f11var
[8]="23fe";
46 rv
= stmt
->prepare(statement
);
47 if(rv
!=OK
) { delete stmt
; delete con
; return 4; }
48 //****************************************************************************
50 nop
= stmt
->noOfParamFields();
51 printf("noOfParamField Returns=%d\n",nop
);
53 FieldInfo
*field
= new FieldInfo();
58 char defaultValueBuf
[10];
61 for(int i
=1;i
<=11;i
++) {
62 printf("\n***********************************************\n");
63 printf("%d FIELD INFORMATION ::\n",i
);;
64 rv
= stmt
->getParamFldInfo(i
,field
);
65 if(rv
!=OK
) { delete stmt
; delete con
; return 1; }
66 printf("Field Name :%s\n", field
->fldName
);
67 printf("Data type of the field :%d\n",field
->type
);
68 printf("length of the field :%d\n",field
->length
);
69 printf("Offset :%d\n",field
->offset
);
70 printf("Default value :%s\n",field
->defaultValueBuf
);
71 printf("Null field :%d\n",field
->isNull
);
72 printf("Default value :%d\n",field
->isDefault
);
73 printf("***********************************************\n");
77 for(int i
=0;i
<10;i
++) {
78 rv
= con
->beginTrans();
81 stmt
->setIntParam(1,f1var
);
82 stmt
->setShortParam(2,f2var
);
83 stmt
->setStringParam(3,f3var
);
84 stmt
->setFloatParam(4,f4var
);
85 stmt
->setFloatParam(5,f5var
);
86 stmt
->setDateParam(6,f6var
);
87 stmt
->setTimeParam(7,f7var
);
88 stmt
->setTimeStampParam(8,f8var
);
89 stmt
->setIntParam(9,f9var
);
90 stmt
->setLongLongParam(10,f10var
);
91 stmt
->setBinaryParam(11,f11var
,8);
92 rv
= stmt
->execute(rows
);
98 printf("Total rows inserted %d\n",count
);
100 //**********************************************************
102 strcpy(statement
,"SELECT * FROM T1;");
103 rv
= stmt
->prepare(statement
);
104 if(rv
!=OK
) { delete stmt
; delete con
; return 5; }
105 stmt
->bindField(1,&f1var
);
106 stmt
->bindField(2,&f2var
);
107 stmt
->bindField(3,f3var
);
108 stmt
->bindField(4,&f4var
);
109 stmt
->bindField(5,&f5var
);
110 stmt
->bindField(6,&f6var
);
111 stmt
->bindField(7,&f7var
);
112 stmt
->bindField(8,&f8var
);
113 stmt
->bindField(9,&f9var
);
114 stmt
->bindField(10,&f10var
);
115 stmt
->bindField(11,f11var
);
117 rv
= con
->beginTrans();
120 while(stmt
->fetch() !=NULL
) {
121 printf("F1=%d | F2=%hd | F3=%s | F4=%f | F5=%f | DATE=%d-%d-%d | TIME=%d:%d:%d | TIMESTAMP=%d-%d-%d %d:%d:%d | F9=%d | F10=%lld \n",f1var
,f2var
,f3var
,f4var
,f5var
,f6var
.year(),f6var
.month(),f6var
.dayOfMonth(),f7var
.hours(),f7var
.minutes(),f7var
.seconds(),f8var
.year(),f8var
.month(),f8var
.dayOfMonth(),f8var
.hours(),f8var
.minutes(),f8var
.seconds(),f9var
,f10var
);
123 AllDataType::printVal(f11var
,typeBinary
,4);
129 if(rv
!=OK
) { delete stmt
; delete con
; return 7; }
130 printf("Total row fetched=%d\n",count
);
132 strcpy(statement
,"DROP TABLE T1;");
133 rv
= stmt
->prepare(statement
);
134 if(rv
!=OK
) { delete stmt
; delete con
; return 8; }
135 rv
= stmt
->execute(rows
);
136 if(rv
!=OK
) { delete stmt
; delete con
; return 9; }
137 printf("Table dropped\n");
139 delete stmt
; delete con
;