金倉數據庫KingbaseESV6程序員參考手冊
KingbaseEs V6 Kimba 6 3.4.1 Rowset. ………38 34.2 Updatability……………… 3.4.3 Update mode… 垂垂垂。魯 ……39 3.4.4ADO ……………………39 3.4.5 ……………………………………………………………40 35 RoW 40 KingbaseES oledb., 40 42 VC++ ADO KDBOLE6……………………………………………………42 5.2VB ADO KDBOL6… ……………46 5.3 Visual c#Net KDBOLE6……………………………………………………………47 NET Data provider ……………………64 ………………………………………………64 非 …64 3. KingbaseES. NET Data Provider ……………………65 65 3.2 KingbaseES Connection…………………………………………………………65 3.3 KingbaseESCommand 67 34 Kingbaseesdatareader………………………………………68 3.5 KingbaseESParameter 68 3.6 KinghaseESTransactior ·垂垂看垂非。垂垂垂 3.7 KingbaseESDala Adaple 69 4.1 KingbaseES Connection 69 4.2 KingbaseESCommand ……………………70 4.3 KinybaseESParameter …72 4.4 KinghaseESDatareader ………74 4.5 KinghaseEStransaction 75 4 KingbaseESDala Adapter………………………………………… …………76 JDBC 78 1 2. JDBC DRIVER 78 Kingo 56 IngbaseES V6 Kingbasees jdbc driver 4,··D,4垂垂 2.2.1 Drivermanag ……………………………79 2.2.2 ………………………83 4。非垂D看垂 ·垂,。魯 83 2.3.1 Statement 83 2.3.2 Preparedstatement ………………………………………………85 2.3 3 Callablestatement 2.4 ……………………………………………………………87 87 2.4.2 看卓?！ぶ勾勾埂?●4垂。垂·垂非司垂 …………88 2.5 88 2.6 非垂垂 垂.司·非垂4·春垂 2.6.1 2.6.2 …………………89 2.7 2.7.1 ……89 2.7.2 2.8 …………………95 3. JDBC Driver ●看垂·垂垂 96 INDI)………………………………………………96 Data Source JNDI)………… ………………………………………………………………………………101 Application Server JDBC Driver… ……………103 4.1 Web Sphere5.1……………………………………………… 章,垂垂 103 4.2 Weblogic7.0… ………………………105 4.3 Tomcat. …109 K es 113 5.1 Hibernate3.0……… ●垂布 113 114 ……………………………………………………114 2. PowerDesigner KingbaseEs V6 Kimba 6 …………∷114 ··.:·· ……114 …116 Kingo 56 IngbaseES V6 ODBC KingbascES ODBC C ODBC Microsoft odbc 3.0 KingbaseeS 6 odbc driver SQL KingbaseES ODbC 3.0 KingbaseES ODBC KinybaseES ODBC api QLAllochandle 2) SQLALlocHandle SQLConnect, SQLBrowse Connect SOLDriverConnect 4) SQL SOL 5) 6) a) SQLAllocHandle (SQL_HANDLE_ ENV, NULL, &henv )<= SQLAllocEnv b) SQLAllocHandle (SQL_HANDLE_DBC, henv, &hdbc)<=> SQLAllocConnect C) SQLConnect d) sQLAllocHandle (SQL_ HANDLE_ STMT, hdbc, &hstmt )<= SQLAllocStmt SQL (SQLPrepare SQLExecDirect (SQLBindParameter g SQLGetDescField, SQLColAttribute, SQLDescribe Col h) SQLEXecute SQLEXecDirect (SQLFetch, SQLBindCol, SQLGetData. 001 ODBC KingbaseEs v6 Kimba 6 j) SQLFreeHandle (SQL_HANDLE_ STMT, hstmt )<= SQLFreeStmt k) SQLDisconnect 1) SQLFreeHandle (SQL_HANDLE_DBC, hdbc)<=> SQLFreeConnect m) SQLFreeHandle (SQL HANDLE ENV, henv )<=> SQLFreeEnv KingbaScES ODBC KingbasceS ODBC ODBC 1, SQLFetchScroll SQLBindCol A SQLFetchScroll SOLBindcol 3 SQLFetchScroll SQLFetch Scroll SQLFetchscroll 4-6 INT SQLBindcol int val3 >)Q: SQLBindParameter SQLBindParameter SOLBindParameter SQLBindParameter(stmt SQL PARAM INPUT. SQL_C_CHAR SOL CHAR 200. 0, 200 1, "Bill Gates") strcpy(coll," Bill Gates") SQLBindParameter (stmt SQL PARAM_ INPUT SQL C CHAR DBC Kingo 56 ingbaseEs V6 SQL _CHAR, &coll 200 &reallen 1: CREATE TABLE Foo(Bar CHAR(8) SOLFetch 3-1 SQLExecDirect SQLFetch int Select(SQLHDBC hdbc SQLHSTMT hstmt; SQLRETURn rC Buffer 91 SQLINTEGER chOl= SQL_ NTS strcpy(sqlstr, "SELECT bar FROM foo; ) rc= SQLAllocHandle(sQL- HANDLE_ STmT, hdbc, &hstmt) if(rc==SQL_上KROR) return -1: rC= SQLExecDirect(hstmt, sqlstr, SQL NTS) if (rC=- SQL_ _ERROR) It: rc=SQLBindCol(stmt, 1, SQL_C_CHAR, Sz Buffer, 9, &cbOol); if (rc = SQL_ ERROR) goto ErrorExit rc=SQL上etch( stmt); if(re≡=SQL_ ERROR) oto errorexit TorExit SQLFreeHandle(sQL_HANDLE_STMt, hstnt) return rc 003 ODBC KingbaseEs v6 Kimba 6 A “GBK” CHAR(n ODBC n GBK CHAR 2 C/C++ 2n+1。 : ODBC A SQLDriverConnect ODBC Driver SQLDrivcrConncct(hdbc NU DRIVER=(KingbaseES 6 ODBC Driver: SERVER=127.0.0.1 UIDESYSTEM: PWDEMANAGER: DATABASE=TEST: PORT=54 321, SQL_ _ NTS n_string string), &le SQL_ _DRIVER_ NOPROMPT) Windows XP+ sp2 MDAC2. 8? This version is incompatible with the version you are attempting to install"? A MDAC2.8。 MDAC SERVICE PACK Windows XP Sp2 MDAC2. 8? A: MDAC2. 8 ADO、 OLEDB、ODBC MDAC2 systemroot%0 windows\MDAC. INF (%Systemroot WindowsⅩP C:) Windows XP Professional service pack2 CD cAvasInc SP2 ADCJAVAS.IN MDAC2. 8 DBC 004 56 4. KingbaseES odbc 3.0 KingbaseES odbc 3.0 4.1 4-1 ODBC 0 128 4.2 1) SQLBindCol 2)SQLBindParameter SOI SOL 3) SQLGetData 4) BLOB BLOB 2) SQL insert into [table name] values(1, X'41424344) 5 CLOB BLOB CLOB SQL insert into [table name] values(l, ABCD) 4.2.1 SoLBindcol solgetdala ODBC C QLGetData SQLBindcol Target Y C date, SOLGetData SQLBindCol TargetType SQL -C DEFAULT, SQL_C_ CHAR, SQL_C_DATE, SQL_C_TIME, SQL__C_TIMESTAMP, SQL- C_TINYINT。 ODBC