C/C++ codeEnvironment *env = Environment::createEnvironment( " ZHS16GBK " , " UTF8 " );
// // Environment *env=Environment::createEnvironment(Environment::DEFAULT);
string mc;
{
Connection *conn = env->createConnection( "uid" , "pwd" , "//***.***.***.***:port/servername" );localhost:1521/servername
try
{
Statement *stmt = conn->createStatement( " select * from table" );
ResultSet *rs = stmt->executeQuery();
// int i = 1;
while (rs->next())
{
CString str;
mc = rs->getString( 1 );
str.Format("%s", mc.c_str());
//mc = rs->getString( 1 );
::AfxMessageBox(str);
}
stmt->closeResultSet(rs);
stmt = conn->createStatement( " insert into table(ziduan) values('11002') " );
rs = stmt->executeQuery();
stmt->closeResultSet(rs);
conn->terminateStatement(stmt);
}
catch (SQLException e)
{
cout << e.what();
}
env->terminateConnection(conn);
}
Environment::terminateEnvironment(env);