C语言连接数据库代码.doc

附一源码 CWinApp theApp; using namespace std; CHmbAdoDBRs RfRst; CString sSql; CString seq, body, eng, tm, tl, icol, ecol, alc, bhmcdate; int i; BOOL DbOpen(); BOOL CkseqtmpSelect(); BOOL CkseqtmpUpdate(); int PrintStatus(); int SockInit(); CHmbAdoDB Sqldb; int _tmain(int argc, TCHAR* argv[], TCHAR* envp[]) { int cnt = 0; int nRetCode = 0; int page = 1; int prt_ret; CString strDate, strTime; // initialize MFC and print and error on failure if (!AfxWinInit(::GetModuleHandle(NULL), NULL, ::GetCommandLine(), 0)) { // TODO: change error code to suit your needs cerr _T(Fatal Error: MFC initialization failed) endl; nRetCode = 1; } //DataBase Open... if(DbOpen()) cout DataBase Open Open Ok endl; else { cout DataBase Open Error\n endl; return -1; } while( 1 ) { ret = SockInit(); //建立socket连接 if ( ret 0 ) Sleep(3000); else break; } while( 1 ) { if ( CkseqtmpSelect() == FALSE ) { // CKSEQTMP FLAG03=0 SELECT Sleep(3000); continue; } while( 1 ) { // PRINTER STATUS Check prt_ret = PrintStatus(); if ( prt_ret == 1 ) { closesocket(sid); WSACleanup(); while( 1 ) { ret = SockInit(); if ( ret 0 ) Sleep(3000); else break; } break; } else { printf(Printer Status Check !!!\n); Sleep(3000); } } printf(%s-%s-%s-%s-%s-%s-%s-%s-%s\n, seq, body, eng, tm, tl, icol, ecol, alc, bhmcdate); memset(sbuf, 0x00, sizeof(sbuf)); sprintf(sbuf, %c%c1, ESC, W); ret = send( sid, sbuf, strlen(sbuf), 0 ); if ( cnt == 0 || atoi(seq) 2 ) { if ( atoi(seq) 2 ) { cnt = 0; page = 1; memset(sbuf, 0x00, sizeof(sbuf)); sprintf(sbuf, %c%c%c, FF, CR, LF); ret = send( sid, sbuf, strlen(sbuf), 0 ); } memset(sbuf, 0x00, sizeof(sbuf)); sprintf(sbuf, [ BUMPER ASSY WORK ORDER ]%c%c%c%c%c%c, CR, LF, CR, LF, CR, LF); ret = send( sid, sbuf, strlen(sbuf), 0 ); strDate.Format(%s-%s-%s, bhmcdate.Left(4), bhmcdate.Mid(4,2), bhmcdate.Mid(6,2) ); memset(sbuf, 0x00, sizeof(sbuf)); sprintf(sbuf, PAGE : %3d DATE : %s%c%c, page, strDate,