examples/sqlapi/manSQLAPIdelete.c

   1 //  delete rows where eid > 1005.
   2 #include<SqlFactory.h>
   3
   4 int main()
   5 {
   6     DbRetVal rv = OK;
   7     AbsSqlConnection *con = SqlFactory :: createConnection(CSql);
   8     rv = con->connect("root","manager");
   9     if(rv!=OK)return 1;
  10
  11     AbsSqlStatement *stmt = SqlFactory :: createStatement(CSql);
  12     stmt->setConnection(con);
  13     if(rv!=OK)return 2;
  14     char statement[200];
  15     int rows = 0;
  16
  17 //    deleteing tuples from EMP;
  18
  19     int eid = 1000;
  20     char ename[20]="lakshya";
  21     float salary = 2000;
  22
  23     strcpy(statement,"DELETE FROM EMP WHERE EID > 1005;");
  24     rv = stmt->prepare(statement);
  25     if(rv!=OK) { delete stmt; delete con; return 3; }
  26
  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");
  32     rv = con->commit();
  33     if(rv!=OK) { delete stmt; delete con; return 6; }
  34     stmt->free();
  35
  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; }
  40
  41     stmt->bindField(1,&eid);
  42     stmt->bindField(2,ename);
  43     stmt->bindField(3,&salary);
  44
  45         printf("EmpId | name\t| salary\n");
  46         printf("--------------------------\n");
  47
  48         int count=0;
  49     rv = con->beginTrans();
  50     if(rv!=OK)return 6;
  51     stmt->execute(rows);
  52     while(stmt->fetch() !=NULL)
  53         printf("%d  | %s\t| %6.2f\n", eid, ename, salary);
  54     rv = con->commit();
  55     if(rv!=OK) { delete stmt; delete con; return 7; }
  56     stmt->close();
  57     stmt->free();
  58
  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; }
  64     stmt->free();
  65     printf("Table dropped\n");
  66
  67     delete stmt;
  68     delete con;
  69     return 0;
  70 }