oracle11g pro二编程指导方针在编写pc源文件你出来的代码记事本即可而后改后缀名为

·Pro*C/C++基2.1编程指导方Pro*C/C++的程序设计规范。一．SQLSQLCpc（；“/*………*/”二.使用常O（ox三.定义部CEXECSQLBEGINDECLARESECTIONEXECSQLENDDECLARESECTION宿主变量：宿主变量（hostvariable）就是在嵌入式SQL语句中主语言说明的程序变SQL。每一个宿主变量都可定义一个指示器变量，主要用于处理空值（NULL）指示器变量的说明基本同一般SQL变量一样，但必须定义成2字节的整型，如SHORT、INT。在SQL语句中时,其前也应加“”(冒号)，而且必须附在其相关联的宿主变量之后，在C1分隔C/C++中成对的单引号）作为单字符分隔号，双引号作为字符串的分隔号）例：EXECSQLCREATETABLE“TEMP”(COLA五.文件长六.函数原七.SQL语句长八.宿主变量SQL所在的应用程序就是宿主啦。2.1与普通的C/C++程序不同，Pro*C/C++程序需要数据库，对数据库进行查询，插入，更PCC/C++的头文件之外还要Pro*C/C++头文件，常用头文件如下：scaf（，pint（，gets）abot（，eit）srcpy（，stcmp（）Sqlda.h：SQLDAOracleSQL（SQL语句只有在运行阶段sqlglm（。个函数，SQL，SQLSQLslq_errorEXECSQLWHENEVERSQLERRORDOsql_error();EXECSQLWHENEVERNOTFOUNDEXECSQLCOMMITRELEASE;示例程序：PC源文件（开发人员写的（51#include<sqlca.h>SQLCAcharusername[20],password[20],server[20]; externsqlglm(char*,int*,int*); voidconnect();voidsql();voidsql_error();voidmain(){EXECSQLWHENEVERSQLERRORDOsql_error();EXECSQLWHENEVERNOTFOUNDDOsql_error();SQLEXECSQLCOMMITRELEASE;}voidconnect(){EXECSQLCONNECT:usernameIDENTIFIEDBY:password}voidsql_error(){charsize_tbuf_len,msg_len;if(msg_len>buf_len)msg_len=buf_len;}voidintcharcname[12],cdepartment[12],coutpucolum[12],ccylinder[12] INTO:cname,:cdepartment,:ctopspeed,:choursepower,:cger,:coutpucolum,:ccylinderFROMcarTableWHERECTOPSPEED=:speed; }/*ResultSetsInterface*/#ifndefSQL_CRSR#defineSQL_CRSRstruct{unsignedint void*ptr1;void*ptr2;unsignedintmagic;typedefstructsql_cursorsql_cursor;typedefstructsql_cursor#endif/*SQL_CRSR/*ThreadSafety*/typedefvoid*sql_context;typedefvoid*/*Objectsupport*/structsqltvn{unsignedchar*tvnvsn;unsignedshorttvnvsnl;unsignedchar*tvnnm;unsignedshorttvnnml;unsignedchar*tvnsnm;unsignedshorttypedefstructsqltvnstruct{unsignedintadtvsn;unsignedshortadtmode;unsignedshortadtnum;sqltvnadttvn[1];typedefstructsqladtsstaticstructsqladtssqladt={/*BindingtoPL/SQLRecords*/structsqss{unsignedinttdsvsn;unsignedshorttdsnum;unsignedchar*tdsval[1];typedefstructsqsssqss;staticstructsqsssqs={/*Filename&PackageName*/structsqlcxp{unsignedshortcharstaticconststructsqlcxpsqlfpn{staticunsignedintsqlctx staticstructsqlexd{unsignedint unsignedint unsignedint unsignedint unsignedshortselerr;unsignedshortsqlety;unsigned constshort*cud;unsignedchar*sqlest;constchar*stmt;sqladtssqss*sqvoid**sqphsv;unsignedint void**sqpind; unsignedint unsignedint unsignedshort*sqpadto;unsignedshort*sqptdso;unsignedint unsignedint unsignedint unsignedint unsignedint unsignedint unsignedint void*sqhstv[8];unsignedint void*sqindv[8]; unsignedint unsignedint unsignedshortsqadto[8];unsignedshort}sqlstm=/*SQLLIBPrototypesexternvoidsqlcxt(void**,unsignedintstructsqlexd*,conststructsqlcxp*);externvoidsqlcx2t(void**,unsignedint*,structsqlexd*,conststructsqlcxp*);externvoidsqlbuft(void**,char*);externvoidsqlgs2t(void**,charexternvoidsqlorat(void**,unsignedint*,void/*FormsInterfacestaticconstintIAPSUCC=0;staticconstintIAPFAIL=1403;staticconstintIAPFTL=535;externvoidsqliem(unsignedchar*,signedinttypedefstruct{unsignedshortlen;unsignedchararr[1];}VARCHAR;typedefstruct{unsignedshortlen;unsignedchararr[1];}/*cud(compilationunitdata)array*/staticconstshortsqlcud0[]=#include<sqlca.h>SQLCAcharusername[20],password[20],server[20]; externsqlglm(char*,int*,int*); voidconnect();voidsql();voidsql_error();voidmain(){/*EXECSQLWHENEVERSQLERRORDOsql_error();/*EXECSQLWHENEVERNOTFOUNDDOsql_error();SQL/*EXECSQLCOMMITRELEASE;{structsqlexdsqlstm;sqlstm.sqlvsn=12;sqlstm.arrsiz=0;sqlstm.sqladtp=&sqladt;sqlstm.sqsp=&sqs;sqlstm.iters=(unsignedint)1;sqlstm.offset=(unsignedint)5;sqlstm.cud=sqlcud0;sqlstm.sqlest=(unsignedcharsqlstm.sqlety=(unsignedshort)4352;sqlstm.occurs=(unsignedint)0;sqlcxt((void**)0,&sqlctx,&sqlstm,&sqlfpn);if(sqlca.sqlcode<0)sql_error();}}voidconnect(){/*EXECSQLCONNECT:usernameIDENTIFIEDBY:passwordUSING:server;{structsqlexdsqlstm;sqlstm.sqlvsn=12;sqlstm.arrsiz=4;sqlstm.sqladtp=&sqladt;sqlstm.sqsp=&sqsqlstm.iters=(unsignedint)10;sqlstm.offset=(unsignedint)20;sqlstm.cud=sqlcud0;sqlstm.sqlest=(unsignedchar*)&sqlca;sqlstm.sqlety=(unsignedshort)4352;sqlstm.occurs=(unsignedint)0;sqlstm.sqhstv[0]=( void*)username;sqlstm.sqhstl[0]=(unsignedint)20;sqlstm.sqhsts[0]=( int)20;sqlstm.sqindv[0]= voidsqlstm.sqinds[0]=( int)0;sqlstm.sqharm[0]=(unsignedint)0;sqlstm.sqadto[0]=(unsignedshort)0;sqlstm.sqtdso[0]=(unsignedshort)0;sqlstm.sqhstv[1]=( void*)password;sqlstm.sqhstl[1]=(unsignedint)20;sqlstm.sqhsts[1]=( int)20;sqlstm.sqindv[1]= voidsqlstm.sqinds[1]=( int)0;sqlstm.sqharm[1]=(unsignedintsqlstm.sqadto[1]=(unsignedshort)0;sqlstm.sqtdso[1]=(unsignedshort)0;sqlstm.sqhstv[2]=( void*)server;sqlstm.sqhstl[2]=(unsignedint)20;sqlstm.sqhsts[2]=( int)20;sqlstm.sqindv[2]= voidsqlstm.sqinds[2]=( int)0;sqlstm.sqharm[2]=(unsignedint)0;sqlstm.sqadto[2]=(unsignedshort)0;sqlstm.sqtdso[2]=(unsignedshort)0;sqlstm.sqphsv=sqlstm.sqhstv;sqlstm.sqphsl=sqlstm.sqhstl;sqlstm.sqphss=sqlstm.sqhsts;sqlstm.sqpind=sqlstm.sqindv;sqlstm.sqpins=sqlstm.sqinds;sqlstm.sqparm=sqlstm.sqharm;sqlstm.sqparc=sqlstm.sqharc;sqlstm.sqpadto=sqlstm.sqadto;sqlstm.sqptdso=sqlstm.sqtdso;sqlstm.sqlcmax=(unsignedint)100;sqlstm.sqlcmin=(unsignedint)2;sqlstm.sqlcincr=(unsignedint)1;sqlstm.sqlctimeout=(unsignedintowait=(unsignedint)0;sqlcxt((void**)0,&sqlctx,&sqlstm,&sqlfpn);if(sqlca.sqlcode<0)sql_error();}}voidsql_error(){charmsg[200];size_tbuf_len,msg_len;if(msg_len>buf_len)msg_len=buf_len;}voidintcharcname[12],cdepartment[12],coutpucolum[12],ccylinder[12] INTO:cname,:cdepartment,:ctopspeed,:choursepower,:cger,:coutpucolum,:ccylinderFROMcarTableWHERECTOPSPEED=:speed;*/{structsqlexdsqlstm;sqlstm.sqlvsn=12;sqlstm.arrsiz=8;sqlstm.sqladtp=&sqladt;sqlstm.sqsp=&sqsqlstm.stmt="select*into:b0,:b1,:b2,:b3,:b4,:b5,:b6fromcarTablewhe\reCTOPSPEED=:b7";sqlstm.iters=(unsignedint)1;sqlstm.offset=(unsignedint)51;sqlstm.selerr=(unsignedshort)1;sqlstm.cud=sqlcud0;sqlstm.sqlest=(unsignedchar*)&sqlca;sqlstm.sqlety=(unsignedshort)4352;sqlstm.occurs=(unsignedint)0;sqlstm.sqhstv[0]=( void*)cname;sqlstm.sqhstl[0]=(unsignedint)12;sqlstm.sqhsts[0]=( int)0;sqlstm.sqindv[0]= voidsqlstm.sqinds[0]=( int)0;sqlstm.sqharm[0]=(unsignedint)0;sqlstm.sqadto[0]=(unsignedshort)0;sqlstm.sqtdso[0]=(unsignedshort)0;sqlstm.sqhstv[1]=( void*)cdepartment;sqlstm.sqhstl[1]=(unsignedint)12;sqlstm.sqhsts[1]=( int)0;sqlstm.sqindv[1]= voidsqlstm.sqinds[1]=( int)0;sqlstm.sqharm[1]=(unsignedint)0;sqlstm.sqadto[1]=(unsignedshort)0;sqlstm.sqtdso[1]=(unsignedshort)0;sqlstm.sqhstv[2]=( void*)&ctopspeed;sqlstm.sqhstl[2]=(unsignedint)sizeof(int);sqlstm.sqhsts[2]=( int)0;sqlstm.sqindv[2]= voidsqlstm.sqinds[2]=( int)0;sqlstm.sqharm[2]=(unsignedintsqlstm.sqadto[2]=(unsignedshort)0;sqlstm.sqtdso[2]=(unsignedshort)0;sqlstm.sqhstv[3]=( void*)&choursepower;sqlstm.sqhstl[3]=(unsignedint)sizeof(int);sqlstm.sqhsts[3]=( int)0;sqlstm.sqindv[3]= voidsqlstm.sqinds[3]=( int)0;sqlstm.sqharm[3]=(unsignedint)0;sqlstm.sqadto[3]=(unsignedshort)0;sqlstm.sqtdso[3]=(unsignedshort)0;sqlstm.sqhstv[4]=( void*)&cger;sqlstm.sqhstl[4]=(unsignedint)sizeof(int);sqlstm.sqhsts[4]=( int)0;sqlstm.sqindv[4]= voidsqlstm.sqinds[4]=( int)0;sqlstm.sqharm[4]=(unsignedint)0;sqlstm.sqadto[4]=(unsignedshort)0;sqlstm.sqtdso[4]=(unsignedshort)0;sqlstm.sqhstv[5]=( void*)coutpucolum;sqlstm.sqhstl[5]=(unsignedint)12;sqlstm.sqhsts[5]=( int)0;sqlstm.sqindv[5]= voidsqlstm.sqinds[5]=( int)0;sqlstm.sqharm[5]=(unsignedint)0;sqlstm.sqadto[5]=(unsignedshort)0;sqlstm.sqtdso[5]=(unsignedshort)0;sqlstm.sqhstv[6]=( void*)ccylinder;sqlstm.sqhstl[6]=(unsignedint)12;sqlstm.sqhsts[6]=( int)0;sqlstm.sqindv[6]= voidsqlstm.sqinds[6]=( int)0;sqlstm.sqharm[6]=(un