1 /* create table T1 with 10 fields.
2 * insert some records into it with null values
3 * delete records from T1 with where clause
12 AbsSqlConnection
*con
= createConnection();
13 rv
= con
->connect("root","manager");
16 AbsSqlStatement
*stmt
= createStatement();
17 stmt
->setConnection(con
);
22 if(strcmp(getenv("DSN"),"oracle")==0){
23 strcpy(statement
,"INSERT INTO t1 VALUES(?,?,?,?,?,?,?,?,?);");
25 else if(strcmp(getenv("DSN"),"db2")==0){
26 strcpy(statement
,"INSERT INTO t1 VALUES(?,?,?,?,?,?,?,?,?,?)");
28 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
[12]="23fe";
46 rv
= stmt
->prepare(statement
);
47 if(rv
!=OK
) { delete stmt
; delete con
; return 4; }
48 if(strcmp(getenv("DSN"),"psql")==0){
53 for(int i
=0;i
<10;i
++) {
54 rv
= con
->beginTrans();
57 stmt
->setIntParam(1,f1var
);
58 stmt
->setShortParam(2,f2var
);
59 stmt
->setStringParam(3,f3var
);
60 stmt
->setFloatParam(4,f4var
);
62 stmt
->setDateParam(6,f6var
);
63 if(strcmp(getenv("DSN"),"oracle")==0){
64 stmt
->setTimeStampParam(7,f8var
);
65 stmt
->setIntParam(8,f9var
);
66 stmt
->setLongLongParam(9,f10var
);
69 stmt
->setTimeStampParam(8,f8var
);
70 stmt
->setIntParam(9,f9var
);
71 stmt
->setLongLongParam(10,f10var
);
72 //stmt->setBinaryParam(11,f11var, 12);
74 rv
= stmt
->execute(rows
);
81 //*********************************************************
82 // Insert with value list records from the T1
83 if(strcmp(getenv("DSN"),"oracle")==0)
84 strcpy(statement
,"INSERT INTO t1(f1,f2,f3,f4,f5,f6,f8,f9,f10) VALUES(?,?,?,?,?,?,?,?,?);");
85 else if(strcmp(getenv("DSN"),"db2")==0)
86 strcpy(statement
,"INSERT INTO t1(f1,f2,f3,f4,f5,f6,f7,f8,f9,f10) VALUES(?,?,?,?,?,?,?,?,?,?)");
88 strcpy(statement
,"INSERT INTO t1(f1,f2,f3,f4,f5,f6,f7,f8,f9,f10) VALUES(?,?,?,?,?,?,?,?,?,?);");
90 rv
= stmt
->prepare(statement
);
91 if(rv
!=OK
) { delete stmt
; delete con
; return 4; }
92 if(strcmp(getenv("DSN"),"psql")==0){
96 for(int i
=0;i
<10;i
++) {
97 rv
= con
->beginTrans();
100 stmt
->setIntParam(1,f1var
);
101 stmt
->setShortParam(2,f2var
);
102 stmt
->setStringParam(3,f3var
);
103 stmt
->setFloatParam(4,f4var
);
105 stmt
->setDateParam(6,f6var
);
106 if(strcmp(getenv("DSN"),"oracle")==0){
107 stmt
->setTimeStampParam(7,f8var
);
108 stmt
->setIntParam(8,f9var
);
109 stmt
->setLongLongParam(9,f10var
);
112 stmt
->setTimeStampParam(8,f8var
);
113 stmt
->setIntParam(9,f9var
);
114 stmt
->setLongLongParam(10,f10var
);
116 rv
= stmt
->execute(rows
);
122 printf("Total rows inserted %d\n",count
);
125 //**********************************************************
127 strcpy(statement
,"SELECT * FROM t1;");
128 if(strcmp(getenv("DSN"),"db2")==0){
129 strcpy(statement
,"SELECT * FROM t1");
131 rv
= stmt
->prepare(statement
);
132 if(rv
!=OK
) { delete stmt
; delete con
; return 5; }
133 stmt
->bindField(1,&f1var
);
134 stmt
->bindField(2,&f2var
);
135 stmt
->bindField(3,f3var
);
136 stmt
->bindField(4,&f4var
);
137 stmt
->bindField(5,&f5var
);
138 stmt
->bindField(6,&f6var
);
139 if(strcmp(getenv("DSN"),"oracle")==0){
140 stmt
->bindField(7,&f8var
);
141 stmt
->bindField(8,&f9var
);
142 stmt
->bindField(9,&f10var
);
145 stmt
->bindField(7,&f7var
);
146 stmt
->bindField(8,&f8var
);
147 stmt
->bindField(9,&f9var
);
148 stmt
->bindField(10,&f10var
);
150 //stmt->bindField(11,f11var);
152 rv
= con
->beginTrans();
155 while(stmt
->fetch() !=NULL
) {
156 if(stmt
->isFldNull(1)) printf("F1=NULL | ");
157 else printf("F1=%d | ", f1var
);
158 if(stmt
->isFldNull(2)) printf("F2=NULL | ");
159 else printf("F2=%hd | ", f2var
);
160 if(stmt
->isFldNull(3)) printf("F3=NULL | ");
161 else printf("F3=%s | ", f3var
);
162 if(stmt
->isFldNull(4)) printf("F4=NULL | ");
163 else printf("F4=%f | ", f4var
);
164 if(stmt
->isFldNull(5)) printf("F5=NULL | ");
165 else printf("F5=%f | ", f5var
);
166 if(stmt
->isFldNull(6)) printf("F6=NULL | ");
167 else printf("F6=%02d-%02d-%02d | ",f6var
.year(), f6var
.month(), f6var
.dayOfMonth());
168 if(strcmp(getenv("DSN"),"oracle") != 0){
169 if(stmt
->isFldNull(7)) printf("F7=NULL | ");
170 else printf("F7=%02d:%02d:%02d | ", f7var
.hours(),f7var
.minutes(),f7var
.seconds());
172 if(stmt
->isFldNull(8)) printf("F8=NULL | ");
173 else printf("F8=%d-%d-%d %d:%d:%d | ", f8var
.year(),f8var
.month(),f8var
.dayOfMonth(),f8var
.hours(),f8var
.minutes(),f8var
.seconds());
174 if(stmt
->isFldNull(9)) printf("F9=NULL | ");
175 else printf("F9=%d | ", f9var
);
176 if(stmt
->isFldNull(10)) printf("F10=NULL | ");
177 else printf("F10=%lld | ", f10var
);
183 if(rv
!=OK
) { delete stmt
; delete con
; return 7; }
184 printf("Total row fetched=%d\n",count
);
185 stmt
->free(); delete stmt
; delete con
;