Oracle之游标

#define _CRT_SECURE_NO_WARNINGS
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include "sqlca.h"
#pragma comment(lib,"orasql11.lib")

//serverid 宿主变量
EXEC SQL	 BEGIN DECLARE SECTION;
	char * serverid = "scott/scott@orcl";
	int empno;//员工编号
	char ename[20];//员工名字
	int deptno;//部门编号
	int sal;//薪水
EXEC SQL END DECLARE SECTION;
void main()
{
	//嵌入式SQL必须以EXEC SQL开头
	EXEC SQL connect :serverid;
	//检测是否成功连接数据库
	if(sqlca.sqlcode != 0)
	{
		printf("sql connect error\n");
	}
	printf("connect success\n");

	//定义游标
	EXEC SQL DECLARE mycursor CURSOR FOR
	select empno,ename,deptno,sal from emp;
	//打开游标
	EXEC SQL OPEN mycursor;

	//提取数据
	EXEC SQL WHENEVER NOT FOUND DO BREAK;

	while(1)
	{
		EXEC SQL FETCH mycursor INTO :empno,:ename,:deptno,:sal;
		printf("%d\t%s\t%d\t%d\n",empno,ename,deptno,sal);
	}

	//关闭游标
	EXEC SQL CLOSE mycursor;
	
	//提交事务并断开连接
	EXEC SQL COMMIT RELEASE;

	system("pause");
}

运行结果：