展开全部
#include
exec sql include sqlca;
int main(){
exec sql begin declare section;
char userpasswd[30]="openlab/123456";
struct{
int id;
char name[30];
double salary;
}emp;
exec sql end declare section;
exec sql connect:userpasswd;
exec sql declare empcursor cursor for
select id,first_name,salary from
s_emp order by salary;
exec sql open empcursor;
exec sql whenever notfound do break;
for(;;){
exec sql fetch empcursor into :emp;
printf("%d:%s:%lf\n",emp.id,emp.name,
emp.salary);
}
exec sql close empcursor;
exec sql commit work release;
}
把数据62616964757a686964616fe78988e69d8331333332626138存到结构体里。