IntervalYM编程示例

IntervalYM数据类型参数绑定

/*创建环境句柄、到数据库的连接 和 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 year to month)";
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->setIntervalYM(1, IntervalYM(env,1,2));
stmt->execute();

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

while(rs->next())
{
      IntervalYM test_iym;
      test_iym = rs->getIntervalYM(2);
      /*此处Year=1，Month=2*/
}

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

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