1 // delete rows where eid > 1005.
7 AbsSqlConnection
*con
= SqlFactory :: createConnection(CSql
);
8 rv
= con
->connect("root","manager");
11 AbsSqlStatement
*stmt
= SqlFactory :: createStatement(CSql
);
12 stmt
->setConnection(con
);
17 // deleteing tuples from EMP;
20 char ename
[20]="lakshya";
23 strcpy(statement
,"DELETE FROM EMP WHERE EID > 1005;");
24 rv
= stmt
->prepare(statement
);
25 if(rv
!=OK
) { delete stmt
; delete con
; return 3; }
27 rv
= con
->beginTrans();
28 if(rv
!=OK
) { delete stmt
; delete con
; return 4; }
29 rv
= stmt
->execute(rows
);
30 if(rv
!=OK
) { delete stmt
; delete con
; return 5; }
31 printf("Rows Deleted successfully\n");
33 if(rv
!=OK
) { delete stmt
; delete con
; return 6; }
36 // fetching the rows from EMP Table
37 strcpy(statement
,"SELECT * FROM EMP;");
38 rv
= stmt
->prepare(statement
);
39 if(rv
!=OK
) { delete stmt
; delete con
; return 7; }
41 stmt
->bindField(1,&eid
);
42 stmt
->bindField(2,ename
);
43 stmt
->bindField(3,&salary
);
45 printf("EmpId | name\t| salary\n");
46 printf("--------------------------\n");
49 rv
= con
->beginTrans();
52 while(stmt
->fetch() !=NULL
)
53 printf("%d | %s\t| %6.2f\n", eid
, ename
, salary
);
55 if(rv
!=OK
) { delete stmt
; delete con
; return 7; }
59 strcpy(statement
,"DROP TABLE EMP;");
60 rv
= stmt
->prepare(statement
);
61 if(rv
!=OK
) { delete stmt
; delete con
; return 9; }
62 rv
= stmt
->execute(rows
);
63 if(rv
!=OK
) { delete stmt
; delete con
; return 10; }
65 printf("Table dropped\n");