IntervalDS编程示例

IntervalDS数据类型参数绑定

/*创建环境句柄、到数据库的连接 和 statement*/
Environment *env = Environment::createEnvironment();
Connection *conn = env->createConnection(user,pwd,link);
Statement *stmt = conn->createStatement();

string csql = "create table occi_test(a int, b interval day to second)";
string dsql = "drop table occi_test";
string test_sql ="select a, b from occi_test where a =1 ";
ResultSet *rs;
stmt->execute(dsql);
stmt->execute(csql);

/*insert语句通过id变量绑定参数*/
stmt->setSQL("insert into occi_test values(1, :1)");
stmt->setIntervalDS(1, IntervalDS(env,1,2,3,4,5));
stmt->execute();

/*select语句通过id变量绑定参数*/
stmt->setSQL(test_sql);
stmt->setInt(1, 1);
rs = stmt->executeQuery();

while(rs->next())
{
      IntervalDS test_ids;
      test_ids = rs->getIntervalDS(2);
      /*此处day=1，hour=2，minute=3，second=4，fracsec=5*/
}

stmt->closeResultSet(rs);
stmt->execute(dsql);

/*释放statement、数据库连接 和 环境句柄*/
conn->terminateStatement(stmt);
env->terminateConnection(conn);
Environment::terminateEnvironment(env);