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;
}