example.pc

来自「pro c示例,visual c++6环境下编译通过」· PC 代码 · 共 36 行

#include <stdio.h>
EXEC SQL BEGIN DECLARE SECTION;
  char username[20];
  char password[20];
EXEC SQL END DECLARE SECTION;
EXEC SQL INCLUDE sqlca;

main()
{
 EXEC SQL BEGIN DECLARE SECTION;
   char student[20];
   char title[20];
   float score;
 EXEC SQL END DECLARE SECTION; 
 

 strcpy(username,"Tyears");

 strcpy(password,"sa");


 EXEC SQL CONNECT :username IDENTIFIED BY :password;
 printf(":\nConnected to ORACLE as user:%s\n",username);
 EXEC SQL SELECT title,score INTO :title,:score   FROM test  
 WHERE student='王喃';
 printf("\n%s",title);
 printf("\n%d",score);
 printf("\t");
 
 exit(0);
 
 
}