http://blog.163.com/earth_of_fire/blog/static/1368943200791211622278/(总结)
http://blog.163.com/earth_of_fire/blog/static/1368943200791223416510/(数据列表)
http://blog.163.com/earth_of_fire/blog/static/13689432007918112936198/(select)
http://www.cnblogs.com/hustskyking/p/webAudio-listen.html
http://blog.csdn.net/evgd2288/article/details/6607035 (好)
http://hi.baidu.com/mgqw864/item/e54b48552b8a56978d12ed7f()
http://blog.csdn.net/wbj1234566/article/details/2003200()
http://read.pudn.com/downloads51/sourcecode/windows/database/176187/OCIExample/OCIExampleDlg.cpp__.htm:
http://www.pudn.com/downloads51/sourcecode/windows/database/detail176187.html
http://read.pudn.com/downloads195/sourcecode/database/916923/testoci/testociDlg.cpp__.htm
http://www.pudn.com/downloads195/sourcecode/database/detail916923.html
- void COCIExampleDlg::OnButtonConnect()
- {
-
- this->UpdateData ();
-
-
- wsprintf((char*)textSQL, "SELECT * FROM Score %s",SQL);
-
- if(status=OCIStmtPrepare(stmthp, errhp,textSQL, strlen((char*)textSQL),OCI_NTV_SYNTAX, OCI_DEFAULT))
- {
- ErrorProc (errhp, status) ;
- return;
- }
-
-
- if (status=OCIStmtExecute(svchp, stmthp,errhp, (ub4)0, 0, NULL, NULL, OCI_DEFAULT))
- {
- ErrorProc (errhp, status) ;
- return;
- }
-
-
-
- ErrorProc(errhp, OCIAttrGet(stmthp,OCI_HTYPE_STMT,&col_num, 0, OCI_ATTR_PARAM_COUNT,errhp ));
- int ColumnNumbers=(int) col_num;
- text *namep;
- ub4 sizep;
- text tempText[100];
-
-
- int nindex=m_CombolFieldName.GetCurSel();
- if(nindex<0) nindex=0;
- m_CombolFieldName.ResetContent();
- for(int i=0;i<(int)col_num; i++)
- {
-
- ErrorProc(errhp, OCIParamGet(stmthp,OCI_HTYPE_STMT, errhp, (void**)&colhp, ub4(i+1)));
-
-
- ErrorProc(errhp, OCIAttrGet(colhp, OCI_DTYPE_PARAM,&collen[i], 0, OCI_ATTR_DATA_SIZE, errhp ));
-
-
- ErrorProc(errhp, OCIAttrGet(colhp, OCI_DTYPE_PARAM,&coltype[i],0, OCI_ATTR_DATA_TYPE, errhp));
-
-
- if (coltype[i]==SQLT_DATE)collen[i] =50;
-
-
- colbuf[i]=(text*)new text[(int)collen[i]+1];
-
-
- ErrorProc(errhp, OCIAttrGet(colhp, OCI_DTYPE_PARAM,(dvoid*)&namep, (ub4*)&sizep, OCI_ATTR_NAME, errhp ));
- strncpy((char*)tempText, (char*)namep, (size_t)sizep) ;
- tempText [sizep]= ‘\0‘;
- m_grid.SetTextMatrix(0,i+1,(const char *)tempText);
- m_CombolFieldName.AddString((const char *)tempText);
- }
- m_CombolFieldName.SetCurSel (nindex);
-
-
- for(i=0; i<(int)col_num; i++)
- {
- if (status=OCIDefineByPos (stmthp,&defhp[i],errhp, i+1,(ub1*)colbuf[i],
- collen[i]+1,SQLT_STR,&ind[i], 0, 0, OCI_DEFAULT))
- {
- ErrorProc(errhp, status);
- return;
- }
- }
-
-
- int row=0;
- CString tempstr;
- while((OCIStmtFetch(stmthp, errhp,1,OCI_FETCH_NEXT,OCI_DEFAULT))!=OCI_NO_DATA)
- {
- row = row+1;
- m_grid.SetRows(row+1);
- tempstr.Format ("%d",row);
- m_grid.SetTextMatrix(row,0,tempstr);
- for(i=0; i<(int)col_num; i++)
- {
- tempstr=(char*)colbuf[i];
- tempstr.TrimRight(‘ ‘);
-
- m_grid.SetTextMatrix(row,i+1,tempstr);
- }
-
- }
-
- SQL="";
-
- }
oracle oci 调用 1
原文:http://www.cnblogs.com/pengkunfan/p/3558306.html