• <ins id="pjuwb"></ins>
    <blockquote id="pjuwb"><pre id="pjuwb"></pre></blockquote>
    <noscript id="pjuwb"></noscript>
          <sup id="pjuwb"><pre id="pjuwb"></pre></sup>
            <dd id="pjuwb"></dd>
            <abbr id="pjuwb"></abbr>

            寶杉的博客

            UNIX/LINUX;ACE;SNMP;C++
            posts - 33, comments - 23, trackbacks - 0, articles - 0

            example1

            Posted on 2007-08-20 17:01 寶杉 閱讀(701) 評(píng)論(2)  編輯 收藏 引用 所屬分類(lèi): OTL

            #include <iostream>
            using namespace std;
            #include <stdio.h>

            #define OTL_ORA7 // Compile OTL 3.1/OCI7
            #include <otlv4.h> // include the OTL 4 header file

            otl_connect db; // connect object

            void insert()
            // insert rows into table
            {
             otl_stream o(50, // buffer size
                          "insert into test_tab values(:f1<float>,:f2<char[31]>)",
                             // SQL statement
                          db // connect object
                         );
             char tmp[32];

             for(int i=1;i<=100;++i){
              sprintf(tmp,"Name%d",i);
              o<<(float)i<<tmp;
             }
            }

            void select()
            {
             otl_stream i(50, // buffer size
                          "select * from test_tab where f1>=:f<int> and f1<=:f*2",
                             // SELECT statement
                          db // connect object
                         );
               // create select stream
             
             float f1;
             char f2[31];

             i<<8; // assigning :f = 8
               // SELECT automatically executes when all input variables are
               // assigned. First portion of output rows is fetched to the buffer

             while(!i.eof()){ // while not end-of-data
              i>>f1>>f2;
              cout<<"f1="<<f1<<", f2="<<f2<<endl;
             }

             i<<4; // assigning :f = 4
               // SELECT automatically executes when all input variables are
               // assigned. First portion of output rows is fetched to the buffer

             while(!i.eof()){ // while not end-of-data
              i>>f1>>f2;
              cout<<"f1="<<f1<<", f2="<<f2<<endl;
             }

            }

            int main()
            {
             otl_connect::otl_initialize(); // initialize OCI environment
             try{

              db.rlogon("scott/tiger"); // connect to Oracle

              otl_cursor::direct_exec
               (
                db,
                "drop table test_tab",
                otl_exception::disabled // disable OTL exceptions
               ); // drop table

              otl_cursor::direct_exec
               (
                db,
                "create table test_tab(f1 number, f2 varchar2(30))"
                );  // create table

              insert(); // insert records into table
              select(); // select records from table

             }

             catch(otl_exception& p){ // intercept OTL exceptions
              cerr<<p.msg<<endl; // print out error message
              cerr<<p.stm_text<<endl; // print out SQL that caused the error
              cerr<<p.var_info<<endl; // print out the variable that caused the error
             }

             db.logoff(); // disconnect from Oracle

             return 0;

            }

            Feedback

            提交失敗后,可以通過(guò)“恢復(fù)上次提交”恢復(fù)剛剛提交的內(nèi)容
            fatal error C1083: Cannot open include file: 'otlv4.h': No such file or directory
            亚洲午夜福利精品久久| 久久久久久免费一区二区三区| 精品久久香蕉国产线看观看亚洲| 少妇内射兰兰久久| 久久se精品一区精品二区国产| 国产精品天天影视久久综合网| 亚洲国产精品一区二区久久| 亚洲色欲久久久久综合网| 少妇内射兰兰久久| 久久国产精品免费一区| 国产A级毛片久久久精品毛片| 97久久久久人妻精品专区 | 伊人久久大香线蕉av一区| 日本精品久久久久中文字幕8| 日韩久久无码免费毛片软件| 99久久久精品| 亚洲人成精品久久久久| 国产精品无码久久久久 | 国产精品99久久久久久人| 香蕉99久久国产综合精品宅男自| 精品国产VA久久久久久久冰 | 国产精品成人99久久久久| 77777亚洲午夜久久多人| 久久青青草原精品国产不卡| 久久中文字幕一区二区| 伊人久久精品无码av一区| 亚洲国产精品嫩草影院久久| 国产精品gz久久久| 久久亚洲国产欧洲精品一| 久久精品麻豆日日躁夜夜躁| 亚洲国产精品无码久久久秋霞2| 欧美久久一级内射wwwwww.| 777久久精品一区二区三区无码| 精品久久久久久无码专区不卡| 欧美伊人久久大香线蕉综合| 色播久久人人爽人人爽人人片aV| 韩国三级中文字幕hd久久精品| 一本伊大人香蕉久久网手机| 欧美一区二区精品久久| 久久久久综合网久久| 日本福利片国产午夜久久|