Posted on 2008-09-10 10:31
Prayer 閱讀(136)
評論(0) 編輯 收藏 引用 所屬分類:
數(shù)據(jù)庫,SQL 、
C/C++
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <sqlca.h>
int main()
{
EXEC SQL INCLUDE SQLCA;
EXEC SQL BEGIN DECLARE SECTION;
char cd[13+1];
char nm[255+1];
EXEC SQL END DECLARE SECTION;
EXEC SQL CONNECT TO INFDB USER usr USING pwd;
EXEC SQL DECLARE SX CURSOR FOR
SELECT CD,NM FROM TBL;
EXEC SQL OPEN SX;
for(;;)
{
EXEC SQL FETCH SX INTO :cd,:nm;
if(sqlca.sqlcode!=0)
break;
printf("ID is %s,NAME is %s\n",cd,nm);
}
EXEC SQL CLOSE SX;
EXEC SQL DISCONNECT CURRENT;
return 0;
}