create table temp_test(iid_number number, name_varchar2 varchar2(32),
num_53 number(5,3), char_5 char(5), long_type long, raw_20 raw(20),
blob_type blob, integer_type integer , stat_time_date date);
Environment *env;
Connection *conn;Statement *stmt;
ResultSet *rs;
env = Environment::createEnvironment();//创建环境变量
conn = env->createConnection(username,password,connstring); //创建数据库连接对象
stmt = conn->createStatement();//创Statement对象
string sql = "select * from temp_test";
stmt->setSQL(sql);//准备SQL语句
// 逐行获取表字段
try
{
rs = stmt->executeQuery();//执行SQL语句,返回结果集