用過OCCI的進(jìn)來解答啊。

LYN_BIGDREAM

我運(yùn)行demo的一段程序OCCI方式連接TimesTen11.2數(shù)據(jù)庫，運(yùn)行結(jié)果如下： 。不知道是否正確啊，貌似不對~~

LYN_BIGDREAM

源程序如下：
#include <iostream>
#include <occi.h>
using namespace oracle:cci;
using namespace std;

class  test
{
  private:

  Environment *env;
  Connection *conn;
  Statement *stmt;
  public:

  test (string user, string passwd, string db)
  {
    env = Environment::createEnvironment (Environment:EFAULT);
    conn = env->createConnection (user, passwd, db);
  }

  ~test ()
  {
    env->terminateConnection (conn);
    Environment::terminateEnvironment (env);
  }
/***insert***/
void insertRow ()
  {
    string sqlStmt = "INSERT INTO author_tab VALUES (001, 'first')";
    stmt = conn->createStatement (sqlStmt);
    try{
    stmt->executeUpdate ();
    cout << "insert - Success!" << endl;
    }catch(SQLException ex)
    {
     cout<<"Exception thrown for insertRow"<<endl;
     cout<<"Error number: "<<  ex.getErrorCode() << endl;
     cout<<ex.getMessage() << endl;
    }

    conn->terminateStatement (stmt);
  }
/***delete***/
void deleteRow (int c1, string c2)
  {
    string sqlStmt =
      "DELETE FROM author_tab WHERE author_id= AND author_name = :y";
    stmt = conn->createStatement (sqlStmt);
    try{
    stmt->setInt (1, c1);
    stmt->setString (2, c2);
    stmt->executeUpdate ();
    cout << "delete - Success" << endl;
    }catch(SQLException ex)
    {
     cout<<"Exception thrown for deleteRow"<<endl;
     cout<<"Error number: "<<  ex.getErrorCode() << endl;
     cout<<ex.getMessage() << endl;
    }

    conn->terminateStatement (stmt);
  }
/***update***/
void updateRow (int c1, string c2)
  {
    string sqlStmt =
      "UPDATE author_tab SET author_name = WHERE author_id = :y";
    stmt = conn->createStatement (sqlStmt);
    try{
    stmt->setString (1, c2);
    stmt->setInt (2, c1);
    stmt->executeUpdate ();
    cout << "update - Success" << endl;
    }catch(SQLException ex)
    {
     cout<<"Exception thrown for updateRow"<<endl;
     cout<<"Error number: "<<  ex.getErrorCode() << endl;
     cout<<ex.getMessage() << endl;
    }

    conn->terminateStatement (stmt);
  }
/***displey***/
void displayAllRows ()
  {
    string sqlStmt = "SELECT author_id, author_name FROM author_tab \
    order by author_id";
    stmt = conn->createStatement (sqlStmt);
    ResultSet *rset = stmt->executeQuery ();
    try{
    while (rset->next ())
    {
      cout << "author_id: " << rset->getInt (1) << "  author_name: "
        << rset->getString (2) << endl;
    }
    }catch(SQLException ex)
    {
     cout<<"Exception thrown for displayAllRows"<<endl;
     cout<<"Error number: "<<  ex.getErrorCode() << endl;
     cout<<ex.getMessage() << endl;
    }

    stmt->closeResultSet (rset);
    conn->terminateStatement (stmt);
  }
};//end test
/***main***/
int main (void)
{
string user="ttadmin";
string passwd="ttadmin";
string db ="";
try{
  cout << "Test - Exhibiting simple insert, delete & update operations"
       << endl;
  test *demo = new test (user, passwd, db);
cout << "Displaying all records before any operation" << endl;
  demo->displayAllRows ();

cout << "Inserting a record into the table author_tab "
    << endl;
  demo->insertRow ();

cout << "deleting a row with author_id as 222 from author_tab table" << endl;
  demo->deleteRow (01, "first";

cout << "updating a row with author_id as 444 from author_tab table" << endl;
  demo->updateRow (02, "new";

cout << "Displaying all records again" << endl;
  demo->displayAllRows ();

delete (demo);
  }
  catch (SQLException ex){
    cout << ex.getMessage() << endl;
  }
  cout << "Test - done" << endl;
}
求高手解答！非常感謝！小弟剛?cè)腴T~

asdmonster

提示很明顯啊，你的tns名指定錯(cuò)了。

string db ="";