cockji.sqc

嵌入式ODBC和SQL应用 开发环境,VC++6.0

#include <stdio.h>
#include <stdlib.h>


int main()
{
  EXEC SQL BEGIN DECLARE SECTION;
 	char sno[6];
	char sname[11];
	long int  status;
	char city[11];
        int indcity=-1;
 EXEC  SQL END DECLARE SECTION;
 printf("Sample Embedded SQL for C application\n");
	
printf("%d,%u,%x\n",indcity,indcity,indcity);
	//连接到数据库
    EXEC SQL CONNECT TO cockji  USER coco.coco;

    if (SQLCODE==0)
    {
        printf("Connection to SQL Server established\n");


    }
    else
    {
        // 连接DBMS错误
	printf("%d",SQLCODE);
        printf("ERROR: Connection to SQL Server failed\n");
        return (1);
    }
	EXEC SQL if exists (select name from sysobjects where name='provider'and type='U') 
		    drop table coco.provider;
	//建表
    	EXEC SQL CREATE TABLE provider (
		SNO char(5)   primary key,
		SNAME char(10)  not null,
		STATUS int,
		CITY  char(10)	null
		);
	if(SQLCODE==0)
	{
		printf("creation success!\n");

	}
	else return(1);
	//插入值 查错用whenever
 	EXEC SQL INSERT INTO provider values('S1','精益','20','天津')
	 	insert into provider values('S2','胜锡','10','北京')
	 	insert into provider values('S3','东方红','30','天津')
	 	insert into provider values('S4','丰泰盛','20','天津')
	 	insert into provider values('S5','通天','25',NULL)
		insert into provider values('S6','为民','30','上海');
	 	
     
	EXEC SQL DECLARE C1 CURSOR FOR
            SELECT SNAME,CITY
 	    FROM provider;
	EXEC SQL OPEN C1;
	EXEC SQL FETCH C1 INTO :sname,:city :indcity;
	printf("    ********************************************************\n");
	while(SQLCODE==0)
	{
	printf("%x\n",indcity);
	if(indcity==-1)
	 printf("                snmae:%s             city:null\n",sname); 
	else  printf("                snmae:%s             city:%s\n",sname,city); 
	EXEC SQL FETCH C1 INTO :sname,:city :indcity;
	}
	printf("    ********************************************************\n");
	EXEC SQL CLOSE C1;
	EXEC SQL DISCONNECT ALL;
	return(0);

}