#include<stdio.h>
#include<stdlib.h>
EXEC SQL BEGIN DECLARE SECTION;主变量说明开始
char HSno[9];char HSname[20];char HSex[2];int HSage;char Hdept[20];
EXEC SQL END DECLARE SECTION;主变量说明结束
long SQLCODE;
EXEC SQL INCLUDE sqlca；定义SQL通信区
int main()
{
printf("Please input the sno:");输入查找的学号 scanf("%s",HSno);
连接数据库(数据库名TEST，主机名localhost，端口号54321，用户名密码SYSTEM/krms)
EXEC SQL CANNECTTO TEST@localhost:54321AS CONN1
USER "SYSTEM" USING"manager"
EXEC SQL SELECT Sno,Sname,Ssex,Sage,Sdept
INTO:Hsno,:Hname,:Hsex,:Hage,:Hdept
FROM Student
WHERE Sno=:HSno;
if(sqlca.sqlcode==0)
{
printf("\n%-9s%-20s%-2s%-4s%-20%\n","Sno","Sname","Ssex","Sage","Sdept");
printf("%-9s%-20s%-2s%-4s%-20s\n",Hsno,Hname,Hsex,HSage,Hdept);
}
EXEC SQL DISCONNECT CONN1;
return 0;
}
