Windows下ESQLC编程实例.doc

Windows下ESQL/C编程实例数据库:Sybase Adaptive Server Enterprise 12.5 (ASE12.5)开发工具:vc6.0Sybase安装目录为E:sybase设置环境变量:include、libinclude=%include%;E:sybaseOCS-12_5includelib=%lib%;E:sybaseOCS-12_5lib（右键单击“我的电脑”，选择“属性”菜单项，再选择“高级”选项卡，点击“环境变量”）数据库实例名:WEIHB数据库名: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)数据库中的数据如下：编写代码，文件C:sybsimp.ec通过输入的emp_id信息，查询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:下。打开“命令提示符”并切换到C:预编译操作，执行:cpre sybsimp.ec生成可执行文件:cl sybsimp.c sybesql.c /link libct.lib libcs.lib注：cl是vc6.0提供的C/C+编译器，/link选项后的参数是传递给连接器link.exe的，此处