SQL重寫源代碼

在VC++6.0中創建新的Win32控制臺應用程序項目，並將該項目命名為ODBCTest。然後，將編寫好的ODBCTest.c文件添加到項目的源文件中，編譯並執行。執行完成後，SQL Server中學生表的數據就是Kingbase中學生表的數據備份。實驗源代碼。下面的源代碼給出了壹些註釋。供參考。# include # include # include # include # Define SnO _ len 30 # Define name _ len 50 # Define department _ len 100 # Define ssex _ len 5 int main(){/* step 1定義句柄和變量*//以king開頭的變量表示連接KINGBASEES的變量//以server開頭的變量表示連接SQLSERVER、SQLHENV kinghenv、serverhenv//環境句柄SQLHDBC kinghdbc，serverhdbc//連接句柄SQLHSTMT kinghstmt，serverhstmt//語句句柄SQLRETURN retSQLCHAR sName[名稱_長度]，SDE part[部門_長度]，sSex[sSex _長度]，sSno[SNO _長度]；SQLINTEGER sAgeSQLINTEGER cbAge = 0，cbSno = SQL_NTS，cbSex = SQL_NTS，cbName = SQL_NTS，CB departy = SQL _ NTS；/*第二步初始化環境*/ret = sqlallochandle(SQL _ handle _ env，SQL _ null _ handle，&；kinghenv)；ret = SQLAllocHandle(SQL _ HANDLE _ ENV，SQL_NULL_HANDLE，& ampserverhenv)；ret = SQLSetEnvAttr(kinghenv，SQL_ATTR_ODBC_VERSION，(void*)SQL_OV_ODBC3，0)；ret = SQLSetEnvAttr(serverhenv，SQL_ATTR_ODBC_VERSION，(void*)SQL_OV_ODBC3，0)；/*第三步:建立連接*/ret = sqlallochandle(SQL _ handle _ DBC，kinghenv，&；king hdbc)；ret = SQLAllocHandle(SQL _ HANDLE _ DBC，serverhenv，& ampserver hdbc)；ret = SQLConnect(kinghdbc，“KingbaseES ODBC”，SQL_NTS，“系統”，SQL_NTS，“經理”，SQL _ NTS)；如果(！SQL_SUCCEEDED(ret)) //連接失敗時返回錯誤值return-1；ret = SQLConnect(serverhdbc，" SQLServer "，SQL_NTS，" sa "，SQL_NTS，" sa "，SQL _ NTS)；如果(！SQL_SUCCEEDED(ret)) //連接失敗時返回錯誤值return-1；/*第四步:初始化語句handle */ret = sqlallochandle(SQL _ handle _ stmt，kinghdbc，&；kinghstmt)；ret = SQLSetStmtAttr(kinghstmt，SQL _ ATTR _行_綁定_類型，(SQL pointer)SQL _綁定_ BY _列，SQL _ IS _整數)；ret = SQLAllocHandle(SQL _ HANDLE _ STMT，serverhdbc，& ampserverhstmt)；/*步驟5:以兩種方式執行語句*/*用參數預編譯語句*/ret = sqlprepare (server hstmt，" insert into student (s