【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-461.sql,希望本篇文章对您学习有所帮助。
/*定义SQL通信区*/
EXEC SQL INCLUDE sqlca;
/*说明主变量*/
EXEC SQL BEGIN DECLARE SECTION;
char teacher_name[50];
char teacher_course[50];
int teacher_sal;
EXEC SQL END DECLARE SECTION;
main()
{
/*建立与SQL Server数据库连接*/
EXEC SQL CONNECT TO db_sql USER sa;
if (
sqlca->sqlcode !=0)
{
printf("连接失败\n");
}
else
{
printf("连接成功! \n");
}
/*创建游标,读取表tb_teacher23中的每一行数据*/
EXEC SQL DECLARE Teacher_Cur CURSOR FOR
SELECT teacher_name,teacher_course,teacher_sal FROM tb_teacher23;
/*游标操作--打开游标*/
EXEC SQL OPEN Teacher_Cur;
for(;;)
{
/*游标操作--推进游标指针,将当前数据存储到主变量中*/
EXEC SQL FETCH NEXT Teacher_Cur INTO :teacher_name,:teacher_course,:teacher_sal;
/*利用SQLCA
通信区中的状态信息检测是否成功操作*/
if(sqlca->sqlcode==0)
/*输出
查询结果*/
printf("教师: %s\n 所授
课程: %s\n 工资: %d\n",
teacher_name,teacher_course,teacher_sal);
else
break;
}
/*游标操作--关闭游标*/
EXEC SQL CLOSE Teacher_Cur;
}