c语言编程基础之数据库操作

查询：
vi opsql.ec

EXEC SQL include sqlca.h;

#include <stdio.h>
#include <string.h>

int main(int argc,char **argv) 
{
  EXEC SQL BEGIN DECLARE SECTION;
    char name[50];
    char dbname[20];
  EXEC SQL END DECLARE SECTION;
  strcpy(dbname,"hostdb");

  EXEC SQL CONNECT TO :dbname;
  if(sqlca.sqlcode)
  {
    printf("opeb db error,code=%d\n",sqlca.sqlcode);
    return -1;
  }
  EXEC SQL DECLARE cur1 CURSOR FOR
  SELECT khxm FROM accoinfo;
  EXEC SQL OPEN cur1;
  if(sqlca.sqlcode)
  {
    printf("open cur1 error,code=%d\n",sqlca.sqlcode);
    return -1;
  }

  while(1) 
  {
    memset(name,0x00,sizeof(name));
    EXEC SQL FETCH cur1 INTO :name;
    if(sqlca.sqlcode==100)break;
    else if(sqlca.sqlcode){
        printf("open cur1 error,code=%d\n",sqlca.sqlcode);
        return -1;
    }
    printf("name is [%s]\n",name);
  }
  EXEC SQL CLOSE cur1;
  EXEC SQL DISCONNECT CURRENT;
  return 0; 
}

esql -o opsql opsql.ec
./opsql

新增
vi insql.ec

EXEC SQL include sqlca.h;

#include <stdio.h>
#include <string.h>

int main(int argc,char **argv) 
{
  EXEC SQL BEGIN DECLARE SECTION;
    char khzh[20];
    char name[50];
    char sfzh[18];
    int  zhye;
    char dbname[20];
  EXEC SQL END DECLARE SECTION;
  strcpy(dbname,"hostdb");

  EXEC SQL CONNECT TO :dbname;
  if(sqlca.sqlcode)
  {
    printf("opeb db error,code=%d\n",sqlca.sqlcode);
    return -1;
  }
  
  strcpy(khzh,"001");
  strcpy(name,"mcfeng");
  strcpy(sfzh,"1811");
  zhye=1000000;
  
  EXEC SQL INSERT INTO accoinfo VALUES(:khzh,:name,:sfzh,:zhye);
  
  if(sqlca.sqlcode)
  {
    printf("open cur1 error,code=%d\n",sqlca.sqlcode);
    return -1;
  }

  EXEC SQL DISCONNECT CURRENT;
  return 0; 
}

修改

EXEC SQL include sqlca.h;

#include <stdio.h>
#include <string.h>

int main(int argc,char **argv) 
{
  EXEC SQL BEGIN DECLARE SECTION;
    char khzh[20];
    char name[50];
    char sfzh[18];
    int  zhye;
    char dbname[20];
  EXEC SQL END DECLARE SECTION;
  strcpy(dbname,"hostdb");

  EXEC SQL CONNECT TO :dbname;
  if(sqlca.sqlcode)
  {
    printf("opeb db error,code=%d\n",sqlca.sqlcode);
    return -1;
  }
  
  strcpy(khzh,"001");
  strcpy(name,"mcfeng");
  strcpy(sfzh,"1811");
  zhye=1000000;
  
  EXEC SQL UPDATE accoinfo SET zhye=zhye+:zhye WHERE khzh=:khzh;
  
  if(sqlca.sqlcode)
  {
    printf("open cur1 error,code=%d\n",sqlca.sqlcode);
    return -1;
  }

  EXEC SQL DISCONNECT CURRENT;
  return 0; 
}

删除

EXEC SQL include sqlca.h;

#include <stdio.h>
#include <string.h>

int main(int argc,char **argv) 
{
  EXEC SQL BEGIN DECLARE SECTION;
    char khzh[20];
    char name[50];
    char sfzh[18];
    int  zhye;
    char dbname[20];
  EXEC SQL END DECLARE SECTION;
  strcpy(dbname,"hostdb");

  EXEC SQL CONNECT TO :dbname;
  if(sqlca.sqlcode)
  {
    printf("opeb db error,code=%d\n",sqlca.sqlcode);
    return -1;
  }
  
  strcpy(khzh,"001");
  strcpy(name,"mcfeng");
  strcpy(sfzh,"1811");
  zhye=1000000;
  
  EXEC SQL DELETE FROM accoinfo WHERE khzh=:khzh;
  
  if(sqlca.sqlcode)
  {
    printf("open cur1 error,code=%d\n",sqlca.sqlcode);
    return -1;
  }
  printf("ok\n");
  EXEC SQL DISCONNECT CURRENT;
  return 0; 
}