#include <stdio.h>
#include <string.h>
#include <stdlib.h>EXEC SQL INCLUDE sqlca.h;/*数据库变量的定义*/
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR 参数1..参数n,sid[60];
EXEC SQL END DECLARE SECTION;/*主程序*/
void main( int argc, char **argv )
{
while( (ch=getopt(argc, argv, "1:2:3:4")) != EOF )
{
switch( ch ) {
case '1':
strncpy( 参数1.arr, optarg, strlen( (char *)sid.arr ));
break;
case 'n':
strncpy( 参数1.arr, optarg, strlen( (char *)sid.arr ));
break;
}
} sprintf( (char *)sid.arr, "%s/%s@%s", username, password, dbname );
sid.len = strlen( (char *)sid.arr ); EXEC SQL CONNECT :sid;
/*判断有没有连接数据库*/
EXEC SQL select field into 变量 from tablename where field=:参数n;
}
#include <string.h>
#include <stdlib.h>EXEC SQL INCLUDE sqlca.h;/*数据库变量的定义*/
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR 参数1..参数n,sid[60];
EXEC SQL END DECLARE SECTION;/*主程序*/
void main( int argc, char **argv )
{
while( (ch=getopt(argc, argv, "1:2:3:4")) != EOF )
{
switch( ch ) {
case '1':
strncpy( 参数1.arr, optarg, strlen( (char *)sid.arr ));
break;
case 'n':
strncpy( 参数1.arr, optarg, strlen( (char *)sid.arr ));
break;
}
} sprintf( (char *)sid.arr, "%s/%s@%s", username, password, dbname );
sid.len = strlen( (char *)sid.arr ); EXEC SQL CONNECT :sid;
/*判断有没有连接数据库*/
EXEC SQL select field into 变量 from tablename where field=:参数n;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货