- 论坛徽章:
- 0
|
请教ODBC编程问题
我刚好做了个
看看我的部分原码:
#include <odbc/sql.h>;
#include <odbc/sqlext.h>;
#include <odbc/sqltypes.h>;
rc = SQLAllocEnv(&henv);
if (rc) printf("allocate envrionment handle fail !! \n"
rc = SQLAllocConnect(henv,&hdbc);
if (rc) printf("allocate connection handle fail !! \n"
rc = SQLConnect(hdbc,(UCHAR *)DSN,SQL_NTS,(UCHAR *)UID,SQL_NTS,(UCHAR *)PWD,SQL_NTS);
checkrc(RTN_OK, NULL, hdbc, NULL);
intervalLoop = 2;
sprintf(buf,"%s%s",sql,SimpleDateFormat);
strcpy((char *)str1,buf);
rc = SQLExecDirect(cmdp1,str1,SQL_NTS);
checkrc(RTN_OK,NULL,NULL,cmdp1);
rc = SQLBindCol(cmdp1, 1,SQL_C_SSHORT,&item1, sizeof(SWORD),&szbc1);
rc = SQLBindCol(cmdp1, 2,SQL_C_CHAR ,&item2, sizeof(SWORD),&szbc2);
rc = SQLBindCol(cmdp1, 3,SQL_C_CHAR ,&item3, sizeof(SWORD),&szbc3);
rc = SQLBindCol(cmdp1, 4,SQL_C_CHAR ,&item4, sizeof(SWORD),&szbc4);
rc = SQLBindCol(cmdp1, 5,SQL_C_CHAR ,&item5, sizeof(SWORD),&szbc5);
rc = SQLBindCol(cmdp1, 6,SQL_C_CHAR ,&item6, sizeof(SWORD),&szbc6);
rc = SQLBindCol(cmdp1, 7,SQL_C_CHAR ,&item7, sizeof(SWORD),&szbc7);
rc = SQLBindCol(cmdp1, 8,SQL_C_CHAR ,&item8, sizeof(SWORD),&szbc;
rc = SQLBindCol(cmdp1, 9,SQL_C_CHAR ,&item9, sizeof(SWORD),&szbc9);
rc = SQLBindCol(cmdp1, 10,SQL_C_CHAR ,&item10,sizeof(SWORD),&szbc10);
rc = SQLBindCol(cmdp1, 11,SQL_C_CHAR ,&item11,sizeof(SWORD),&szbc11);
while (rc = SQLFetch(cmdp1))
{
sprintf(SendSN ,"%d",item1);
sprintf(ItemId ,"%s",item2);
sprintf(SpNumber ,"%s",item3);
sprintf(UserNumber,"%s",item4);
sprintf(FeeNumber ,"%s",item5);
sprintf(FeeType ,"%s",item6);
sprintf(ReportFlag,"%s",item7);
sprintf(MsgCode ,"%s",item;
sprintf(Msg ,"%s",item9);
sprintf(MtFlag ,"%s",item10);
sprintf(ExtData ,"%s",item11);
sprintf(CommandId ,"%04s",SendSN);
sprintf(MsgId ,"%s%06s",SimpleDateFormat,SendSN);
}
rc = SQLFreeStmt(cmdp1, SQL_CLOSE);
checkrc(RTN_OK,NULL,NULL,cmdp1); |
|