Linux Unix下ODBC的安装、配置与编程_5.doc

这里附上例程供大家参考学习： /* 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下进行 ODBC编程 QT 3.0提供了 Data Table、Data Browser和 Data View三个与数据库相关的控件。你可以在 QT的 Project设置你要连接的数据库， Driver一栏中选择 QODBC3即可，其它选项你一看就明白了。上述的三个数据库控件的使用方法可以参见 QT中相应文档，也很好使用的。参考资料：微软的 ODBC主页：http:/www.