课程资源数据库系统课件chfig5.pdfVIP

/*Example5.1.1withusernameandpasswordacceptedviatheprompt()

function.*/

#includestdio.h

#includeprompt.h

/*headerforORACLEdatatypes*/

execsqlincludesqlca;

charuser_prompt[]=Pleaseenterusernameandpassword:;

charcid_prompt[]=PleaseentercustomerID:;

intmain()

{

execsqlbegindeclaresection;

charcust_id[5];

charcust_name[14];

floatcust_discnt;

charuser_name[20],user_pwd[20];

execsqlenddeclaresection;

execsqlwheneversqlerrorgotoreport_error;

execsqlwhenevernotfoundgotonotfound;

if(prompt(user_prompt,2,user_name,19,user_pwd,19)0)

{

printf(Failedtogetusernameandpassword(separatedby

whitespace)\n);

exit(1);

}

/*ORACLEformat:connect*/

execsqlconnect:user_nameidentifiedby:user_pwd;

/*callpromptfunctioninprompt.ctoparse1inputstring,len

=4*/

while(prompt(cid_prompt,1,cust_id,4)=0)

{

execsqlselectcname,discnt

into:cust_name,:cust_discnt

fromcustomerswherecid=:cust_id;

execsqlcommitwork;

printf(CUSTOMERSNAMEIS%sANDDISCNTIS%5.1f\n,

cust_name,cust_discnt);

continue;

notfound:printf(Cantfindcustomer%s,continuing\n,cust_id);

}

execsqlcommitrelease;

return0;

report_error:

print_dberror();

execsqlrollbackrelease;

return1;

}

示例5.1.1通过提示（）接受用户名和函数。*/＃includestdio.h#include“strimp.h”

OracleDatatypes的标题*/

ExecSQL包括SQLCA;

charuser_prompt[]=“请输入用户名和：”;