pr0c数据库链接文档.docVIP

Pro*C/C++数据库链接文档 编写程序 首先用记事本或Editplus编写下列程序，并以后缀名为pc的文件。 示例程序如下： #include stdio.h #include string.h #include stdlib.h #include sqlca.h EXEC SQL BEGIN DECLARE SECTION; VARCHAR username[20]; VARCHAR password[20]; VARCHAR dblinkname[20]; EXEC SQL END DECLARE SECTION; EXEC SQL INCLUDE sqlca; void sqlerror(); main() { EXEC SQL BEGIN DECLARE SECTION; int emp_number; VARCHAR emp_name[15]; float salary; float commission; EXEC SQL END DECLARE SECTION; int total_number; printf(\n输入用户名：); gets(username.arr); username.len=strlen(username.arr); printf(\n输入口令：); gets(password.arr); password.len=strlen(password.arr); printf(\n输入网络服务名：); gets(dblinkname.arr); dblinkname.len=strlen(dblinkname.arr); EXEC SQL WHENEVER SQLERROR DO sqlerror(); //错误处理 EXEC SQL CONNECT :username IDENTIFIED BY :password USING :dblinkname; printf(\nConnected to ORACLE as user:%s\n,username.arr); total_number=0; //查询次数 while(1) //循环体 { emp_number=0; printf(\nEnter employee number (0 to quit):); scanf(%d,emp_number); //输入序号 if(emp_number==0)break; //退出循环 EXEC SQL WHENEVER NOT FOUND GOTO notfound; EXEC SQL SELECT ENAME,SAL,COMM INTO :emp_name, :salary, :commission FROM EMP WHERE EMPNO=:emp_number; printf(\n\nEmployee\tSalary\tCommission\n); printf(-----------\t---------\t---------\n); emp_name.arr[emp_name.len]=\0; printf(%8s\t%6.2f\t%6.2f\n,emp_name.arr,salary,commission); total_number=total_number+1; //访问次数加1 continue; notfound: printf(\nNot a valid employee number-try again.\n); } printf(\n\nTotal number queried was:%d\n,total_number); printf(\nHave a good day.\n); EXEC SQL COMMIT WORK RELEASE; exit(0); } void sqlerror() { EXEC SQL WHENEVER SQLERROR CONTINUE; printf(\nORACLE error detected:\n); printf(\n%.70s\n,sqlca.sqlerrm.sqlerrmc); EXEC SQL ROLLBACK RELEASE; exit(1); }