1 /* create table T1 with 10 fields.
2 * insert some records into it.
3 * select * from T1 with where clause;
10 AbsSqlConnection
*con
= createConnection();
11 rv
= con
->connect("root","manager");
14 AbsSqlStatement
*stmt
= createStatement();
15 stmt
->setConnection(con
);
17 if(strcmp(getenv("DSN"),"oracle")==0)
18 strcpy(statement
,"CREATE TABLE t1(f1 number(9),f2 number(4),f3 CHAR(30),f4 FLOAT,f5 FLOAT,f6 DATE,f8 TIMESTAMP,f9 number(9),f10 number(18));");
19 else if(strcmp(getenv("DSN"),"psql")==0)
20 strcpy(statement
,"CREATE TABLE t1(f1 INT,f2 SMALLINT,f3 CHAR(30),f4 FLOAT4,f5 FLOAT4,f6 DATE,f7 TIME,f8 TIMESTAMP,f9 INT,f10 BIGINT);");
21 else if(strcmp(getenv("DSN"),"sybase")==0)
22 strcpy(statement
,"CREATE TABLE t1(f1 INT,f2 SMALLINT,f3 CHAR(30),f4 REAL,f5 REAL,f6 DATE,f7 TIME,f8 DATETIME,f9 INT,f10 BIGINT);");
23 else if(strcmp(getenv("DSN"),"db2")==0)
24 strcpy(statement
,"CREATE TABLE t1(f1 INT,f2 SMALLINT,f3 CHAR(30),f4 REAL,f5 REAL,f6 DATE,f7 TIME,f8 TIMESTAMP,f9 INT,f10 BIGINT)");
26 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);");
28 rv
= stmt
->prepare(statement
);
36 rv
= stmt
->execute(rows
);
45 printf("Table created\n");
48 if(strcmp(getenv("DSN"),"oracle")==0){
49 strcpy(statement
,"INSERT INTO t1 VALUES(?,?,?,?,?,?,?,?,?);");
51 else if(strcmp(getenv("DSN"),"db2")==0){
52 strcpy(statement
,"INSERT INTO t1 VALUES(?,?,?,?,?,?,?,?,?,?)");
55 strcpy(statement
,"INSERT INTO t1 VALUES(?,?,?,?,?,?,?,?,?,?);");
60 char f3var
[35]="jitendra";
64 f6var
.set(2007,01,21);
70 f8var
.setDate(2007,01,21);
71 f8var
.setTime(12,29,30);
74 long long f10var
= 12000;
76 rv
= stmt
->prepare(statement
);
83 if(strcmp(getenv("DSN"),"psql")==0){
92 rv
= con
->beginTrans();
95 stmt
->setIntParam(1,f1var
);
96 stmt
->setShortParam(2,f2var
);
97 stmt
->setStringParam(3,f3var
);
98 stmt
->setFloatParam(4,f4var
);
99 stmt
->setFloatParam(5,f5var
);
100 stmt
->setDateParam(6,f6var
);
101 if(strcmp(getenv("DSN"),"oracle")==0){
102 stmt
->setTimeStampParam(7,f8var
);
103 stmt
->setIntParam(8,f9var
);
104 stmt
->setLongLongParam(9,f10var
);
106 stmt
->setTimeParam(7,f7var
);
107 stmt
->setTimeStampParam(8,f8var
);
108 stmt
->setIntParam(9,f9var
);
109 stmt
->setLongLongParam(10,f10var
);
111 rv
= stmt
->execute(rows
);
117 printf("Total rows inserted %d\n",count
);
122 //**********************************************************
125 if(strcmp(getenv("DSN"),"oracle")==0)
126 strcpy(statement
,"SELECT * FROM t1 WHERE F1=? AND F2=? AND F3=? AND F4=? AND F5=? AND F6=? AND F8=? AND F9=? AND F10=?;");
127 else if(strcmp(getenv("DSN"),"sybase")==0)
128 strcpy(statement
,"SELECT * FROM t1 WHERE f1=? AND f2=? AND f3=? AND f4=? AND f5=? AND f6=? AND f7=? AND f8=? AND f9=? AND f10=?;");
129 else if(strcmp(getenv("DSN"),"db2")==0)
130 strcpy(statement
,"SELECT * FROM t1 WHERE f1=? AND f2=? AND f3=? AND f4=? AND f5=? AND f6=? AND f7=? AND f8=? AND f9=? AND f10=?");
132 strcpy(statement
,"SELECT * FROM t1 WHERE F1=? AND F2=? AND F3=? AND F4=? AND F5=? AND F6=? AND F7=? AND F8=? AND F9=? AND F10=?;");
133 rv
= stmt
->prepare(statement
);
141 stmt
->bindField(1,&f1var
);
142 stmt
->bindField(2,&f2var
);
143 stmt
->bindField(3,f3var
);
144 stmt
->bindField(4,&f4var
);
145 stmt
->bindField(5,&f5var
);
146 stmt
->bindField(6,&f6var
);
147 if(strcmp(getenv("DSN"),"oracle")==0){
148 stmt
->bindField(7,&f8var
);
149 stmt
->bindField(8,&f9var
);
150 stmt
->bindField(9,&f10var
);
153 stmt
->bindField(7,&f7var
);
154 stmt
->bindField(8,&f8var
);
155 stmt
->bindField(9,&f9var
);
156 stmt
->bindField(10,&f10var
);
161 char f3var1
[35]="jitendra";
165 f6var1
.set(2007,01,21);
168 f7var1
.set(12,29,30);
171 f8var1
.setDate(2007,01,21);
172 f8var1
.setTime(12,29,30);
175 long long f10var1
=12000;
177 for(int i
=0;i
<10;i
++)
179 rv
= con
->beginTrans();
183 stmt
->setIntParam(1,f1var1
);
184 stmt
->setShortParam(2,f2var1
);
185 stmt
->setStringParam(3,f3var1
);
186 stmt
->setFloatParam(4,f4var1
);
187 stmt
->setFloatParam(5,f5var1
);
188 stmt
->setDateParam(6,f6var1
);
189 if(strcmp(getenv("DSN"),"oracle")==0){
190 stmt
->setTimeStampParam(7,f8var1
);
191 stmt
->setIntParam(8,f9var1
);
192 stmt
->setLongLongParam(9,f10var1
);
194 stmt
->setTimeParam(7,f7var1
);
195 stmt
->setTimeStampParam(8,f8var1
);
196 stmt
->setIntParam(9,f9var1
);
197 stmt
->setLongLongParam(10,f10var1
);
203 while(stmt
->fetch()!=NULL
)
205 if(strcmp(getenv("DSN"),"oracle")==0)
206 printf("F1=%d | F2=%hd | F3=%s | F4=%f | F5=%f | DATE=%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(),f8var
.year(),f8var
.month(),f8var
.dayOfMonth(),f8var
.hours(),f8var
.minutes(),f8var
.seconds(),f9var
,f10var
);
208 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
);
218 printf("%d Tuples fetched\n",count
);
219 strcpy(statement
,"DROP TABLE t1;");
220 if(strcmp(getenv("DSN"),"db2")==0){
221 strcpy(statement
,"DROP TABLE t1");
223 rv
= stmt
->prepare(statement
);
224 if(rv
!=OK
){delete stmt
; delete con
; return -1;}
226 rv
= stmt
->execute(rows
);
227 if(rv
!=OK
){delete stmt
;delete con
;return -1;}
230 printf("Table dropped\n");