EXEC SQL BEGIN DECLARE SECTION;
varchar deptname[64];
varchar HSno[64];
varchar HSname[64];
varchar HSsex[64];
int HSage;
int NEWAGE;
EXEC SQL END DECLARE SECTION;
long SQLCODE;
EXEC SQL INCLUDE sqlca;
int main(void)
{
int count = 0;
char yn;
printf("Please choose the department name(CS/MA/IS):");
scanf("%s",&deptname);
EXEC SQL CONNECT TO TEXT@CHONG:54321 USER "SYSTEM"/"MANAGER";
EXEC SQL DECLARE SX CURSOR FOR
SELECT Sno,Sname,Ssex,Sage
FROM Student
WHERE SDept =:deptname;
EXEC SQL OPEN SX;
for(;;)
{
EXEC SQL FETCH SX INTO :HSno,:HSname,:HSsex,:HSage;
if(sqlca.sqlcode!=0)
break;
if(count++=0)
printf("\n%-10s%-20s%-10s%-10s%\n","Sno","Sname","Ssex","Sage");
printf("%-10s%-20s%-10s%-10d\n",HSno,HSname,HSsex,HSage);
printf("UPDATEAGE(y/n)?");
do
{
scanf("%c",&yn);
}while(yn!='N'&&yn!='n'&&yn!='Y'&&yn!='y'); if(yn == 'y'||yn == 'Y')
{
printf("INPUT NEW AGE:");
scanf("%d",&NEWAGE);
EXEC SQL UPDATE Student
SET Sage = :NEWAGE
WHERE CURRENT OF SX;
}
}
EXEC SQL CLOSE SX;
EXEC SQL COMMIT WORK;
EXEC SQL DISCONNECT TEST
}
varchar deptname[64];
varchar HSno[64];
varchar HSname[64];
varchar HSsex[64];
int HSage;
int NEWAGE;
EXEC SQL END DECLARE SECTION;
long SQLCODE;
EXEC SQL INCLUDE sqlca;
int main(void)
{
int count = 0;
char yn;
printf("Please choose the department name(CS/MA/IS):");
scanf("%s",&deptname);
EXEC SQL CONNECT TO TEXT@CHONG:54321 USER "SYSTEM"/"MANAGER";
EXEC SQL DECLARE SX CURSOR FOR
SELECT Sno,Sname,Ssex,Sage
FROM Student
WHERE SDept =:deptname;
EXEC SQL OPEN SX;
for(;;)
{
EXEC SQL FETCH SX INTO :HSno,:HSname,:HSsex,:HSage;
if(sqlca.sqlcode!=0)
break;
if(count++=0)
printf("\n%-10s%-20s%-10s%-10s%\n","Sno","Sname","Ssex","Sage");
printf("%-10s%-20s%-10s%-10d\n",HSno,HSname,HSsex,HSage);
printf("UPDATEAGE(y/n)?");
do
{
scanf("%c",&yn);
}while(yn!='N'&&yn!='n'&&yn!='Y'&&yn!='y'); if(yn == 'y'||yn == 'Y')
{
printf("INPUT NEW AGE:");
scanf("%d",&NEWAGE);
EXEC SQL UPDATE Student
SET Sage = :NEWAGE
WHERE CURRENT OF SX;
}
}
EXEC SQL CLOSE SX;
EXEC SQL COMMIT WORK;
EXEC SQL DISCONNECT TEST
}
解决方案 »
- 怎么处理按钮一直被按下。。。
- 改变窗体透明度的问题
- LoadBitmap加载图片失败
- 中国程序员有天堂吗?在哪里呢?
- QQ功能越来越多,好像已经超过ICQ和MSN,主导这一行了.
- 怎么在水平滚动条的左边加一个按钮?就是让滚动条“让出”一点地方给一个button?默认全占满了啊!
- 在托盘程序中,这个程序menu.AppendMenu(MF_STRING,WM_DESTROY,"关闭");用来添加一个菜单,单击这个菜单的目的是关闭程序。如果让单击这
- 关于分割窗口和文档
- 求助,有个C++程序编译通过,运行出错!
- MFC列表控件滚动条问题
- 【求助】怎么样在MDI中实现新建文档时能弹对话框,选择文档类型,然后新建,同时根据文档类型构造不同的ChildFrame Client?
- MFC中是否有函数从字符串资源ID获取资源描述符
什么数据库下的
应该是informix
ESQL/C语法