Linux Unix下ODBC的安裝、配置與編程_5.doc

這里附上例程供大家參考學(xué)習(xí)： /* odbc.c testing unixODBC */ #include #include #include #include #include SQLHENV V_OD_Env; / Handle ODBC environment long V_OD_erg; / result of functions SQLHDBC V_OD_hdbc; / Handle connection char V_OD_stat10; / Status SQL SQLINTEGER V_OD_err,V_OD_rowanz,V_OD_id; SQLSMALLINT V_OD_mlen,V_OD_colanz; char V_OD_msg200,V_OD_buffer200; int main(int argc,char *argv) / 1. allocate Environment handle and register version V_OD_erg=SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&V_OD_Env) ; if (V_OD_erg != SQL_SUCCESS) & (V_OD_erg != SQL_SUCCESS_WITH_INFO) printf(Error AllocHandlen); exit(0); V_OD_erg=SQLSetEnvAttr(V_OD_Env, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0); if (V_OD_erg != SQL_SUCCESS) & (V_OD_erg != SQL_SUCCESS_WITH_INFO) printf(Error SetEnvn); SQLFreeHandle(SQL_HANDLE_ENV, V_OD_Env); exit(0); / 2. allocate connection handle, set timeout V_OD_erg = SQLAllocHandle(SQL_HANDLE_DBC, V_OD_Env, &V_OD_hdbc); if (V_OD_erg != SQL_SUCCESS) & (V_OD_erg != SQL_SUCCESS_WITH_INFO) printf(Error AllocHDB %dn,V_OD_erg); SQLFreeHandle(SQL_HANDLE_ENV, V_OD_Env); exit(0); SQLSetConnectAttr(V_OD_hdbc, SQL_LOGIN_TIMEOUT, (SQLPOINTER *)5, 0); / 3. Connect to the datasource web V_OD_erg = SQLConnect(V_OD_hdbc, (SQLCHAR*) Test, SQL_NTS, (SQLCHAR*) root, SQL_NTS, (SQLCHAR*) , SQL_NTS); if (V_OD_erg != SQL_SUCCESS) & (V_OD_erg != SQL_SUCCESS_WITH_INFO) printf(Error SQLConnect %dn,V_OD_erg); SQLGetDiagRec(SQL_HANDLE_DBC, V_OD_hdbc,1, V_OD_stat, &V_OD_err,V_OD_msg,100,&V_OD_mlen); printf(%s (%d)n,V_OD_msg,V_OD_err); SQLFreeHandle(SQL_HANDLE_ENV, V_OD_Env); exit(0); printf(Connected !n); V_OD_erg=SQLAllocHandle(SQL_HANDLE_STMT, V_OD_hdbc, &V_OD_hstmt); if (V_OD_erg != SQL_SUCCESS) & (V_OD_erg != SQL_SUCCESS_WITH_INFO) printf(Fehler im AllocStatement %dn,V_OD_erg); SQLGetDiagRec(SQL_HANDLE_DBC, V_OD_hdbc,1, V_OD_stat,&V_OD_err,V_OD_msg,100,&V_OD_mlen); printf(%s (%d)n,V_OD_msg,V_OD_err); SQLFreeHandle(SQL_HANDLE_ENV, V_OD_Env); exit(0); SQLBindCol(V_OD_hstmt,1,SQL_C_CHAR, &V_OD_buffer,150,&V_OD_err); SQLBindCol(V_OD_hstmt,2,SQL_C_ULONG,&V_OD_id,150,&V_OD_err); V_OD_erg=SQLExecDirect(V_OD_hstmt,SELECT dtname,iduser FROM web order by iduser,SQL_NTS); if (V_OD_erg != SQL_SUCCESS) & (V_OD_erg != SQL_SUCCESS_WITH_INFO) printf(Error in Select %dn,V_OD_erg); SQLGetDiagRec(SQL_HANDLE_DBC, V_OD_hdbc,1, V_OD_stat,&V_OD_err,V_OD_msg,100,&V_OD_mlen); printf(%s (%d)n,V_OD_msg,V_OD_err); SQLFreeHandle(SQL_HANDLE_STMT,V_OD_hstmt); SQLFreeHandle(SQL_HANDLE_DBC,V_OD_hdbc); SQLFreeHandle(SQL_HANDLE_ENV, V_OD_Env); exit(0); V_OD_erg=SQLNumResultCols(V_OD_hstmt,&V_OD_colanz); if (V_OD_erg != SQL_SUCCESS) & (V_OD_erg != SQL_SUCCESS_WITH_INFO) SQLFreeHandle(SQL_HANDLE_STMT,V_OD_hstmt); SQLDisconnect(V_OD_hdbc); SQLFreeHandle(SQL_HANDLE_DBC,V_OD_hdbc); SQLFreeHandle(SQL_HANDLE_ENV, V_OD_Env); exit(0); printf(Number of Columns %dn,V_OD_colanz); V_OD_erg=SQLRowCount(V_OD_hstmt,&V_OD_rowanz); if (V_OD_erg != SQL_SUCCESS) & (V_OD_erg != SQL_SUCCESS_WITH_INFO) printf(Number of RowCount %dn,V_OD_erg); SQLFreeHandle(SQL_HANDLE_STMT,V_OD_hstmt); SQLDisconnect(V_OD_hdbc); SQLFreeHandle(SQL_HANDLE_DBC,V_OD_hdbc); SQLFreeHandle(SQL_HANDLE_ENV, V_OD_Env); exit(0); printf(Number of Rows %dn,V_OD_rowanz); V_OD_erg=SQLFetch(V_OD_hstmt); while(V_OD_erg != SQL_NO_DATA) printf(Result: %d %sn,V_OD_id,V_OD_buffer); V_OD_erg=SQLFetch(V_OD_hstmt); ; SQLFreeHandle(SQL_HANDLE_STMT,V_OD_hstmt); SQLDisconnect(V_OD_hdbc); SQLFreeHandle(SQL_HANDLE_DBC,V_OD_hdbc); SQLFreeHandle(SQL_HANDLE_ENV, V_OD_Env); return(0); 2QT下進(jìn)行 ODBC編程 QT 3.0提供了 Data Table、Data Browser和 Data View三個(gè)與數(shù)據(jù)庫相關(guān)的控件。你可以在 QT的 Project設(shè)置你要連接的數(shù)據(jù)庫， Driver一欄中選擇 QODBC3即可，其它選項(xiàng)你一看就明白了。上述的三個(gè)數(shù)據(jù)庫控件的使用方法可以參見 QT中相應(yīng)文檔，也很好使用的。參考資料：微軟的 ODBC主頁：http:/www.