Windows下ESQLC編程實(shí)例.doc

Windows下ESQL/C編程實(shí)例數(shù)據(jù)庫(kù):Sybase Adaptive Server Enterprise 12.5 (ASE12.5)開(kāi)發(fā)工具:vc6.0Sybase安裝目錄為E:sybase設(shè)置環(huán)境變量:include、libinclude=%include%;E:sybaseOCS-12_5includelib=%lib%;E:sybaseOCS-12_5lib（右鍵單擊“我的電腦”，選擇“屬性”菜單項(xiàng)，再選擇“高級(jí)”選項(xiàng)卡，點(diǎn)擊“環(huán)境變量”）數(shù)據(jù)庫(kù)實(shí)例名:WEIHB數(shù)據(jù)庫(kù)名:mydb表名:employeeCreate table employee(emp_id varchar(10) not null primary key,emp_name varchar(20) not null,emp_sex char(1),emp_birth date,emp_hobby varchar(100)數(shù)據(jù)庫(kù)中的數(shù)據(jù)如下：編寫(xiě)代碼，文件C:sybsimp.ec通過(guò)輸入的emp_id信息，查詢(xún)emp_name字段信息并顯示。#include#include#define SQL_SUCCESS 0#define DATA_NOT_FOUND 100EXEC SQL INCLUDE sqlca;int main(int argc, char *argv) EXEC SQL BEGIN DECLARE SECTION; char szServer20 + 1; char szUser20 + 1; char szPwd20 + 1; char szDb20 + 1; char szEmpId20 + 1; char szEmpName20 + 1; EXEC SQL END DECLARE SECTION; strcpy(szServer, WEIHB); strcpy(szUser, sa); strcpy(szPwd, ); strcpy(szDb, mydb); printf(Please enter employee id:); gets(szEmpId); EXEC SQL CONNECT :szUser IDENTIFIED BY :szPwd using :szServer; if(sqlca.sqlcode != SQL_SUCCESS) printf(An error occured!%s,%d,error id:%dt msg:%sn,_FILE_, _LINE_, sqlca.sqlcode,sqlca.sqlerrm.sqlerrmc); getch(); exit(1); EXEC SQL USE :szDb; EXEC SQL SELECT emp_name into :szEmpName FROM employee WHERE emp_id=:szEmpId; if(sqlca.sqlcode = DATA_NOT_FOUND) fprintf(stderr, data not foundn); EXEC SQL DISCONNECT CUREENT; getch(); exit(1); printf(emp_name:%sn, szEmpName); EXEC SQL DISCONNECT CURRENT; getch(); return 0;將E:sybaseOCS-12_5include目錄下的sybesql.c文件拷貝到C:下。打開(kāi)“命令提示符”并切換到C:預(yù)編譯操作，執(zhí)行:cpre sybsimp.ec生成可執(zhí)行文件:cl sybsimp.c sybesql.c /link libct.lib libcs.lib注：cl是vc6.0提供的C/C+編譯器，/link選項(xiàng)后的參數(shù)是傳遞給連接器link.exe的，此處