OCCI操作Oracle 数据库
用OCCI操作oracle数据库,
如何判断返回集中一个字段是日期类型的字段?
[解决办法]
利用ResultSet.getColumnListMetaData()
vector <MetaData > listOfColumns = rs- >getColumnListMetaData(); unsigned int uiColumnNum = listOfColumns.size(); TRACE( "字段数=%u\n ", uiColumnNum); for (i=0; i <uiColumnNum; i++) { MetaData columnObj = listOfColumns[i]; TRACE( "%d 列名:%s\n ", i+1, columnObj.getString (MetaData::ATTR_NAME).c_str()); TRACE( "%d 类型:%d, %s\n ", i+1, columnObj.getInt(MetaData::ATTR_DATA_TYPE), getTypeString(columnObj.getInt(MetaData::ATTR_DATA_TYPE)).c_str()); TRACE( "%d 大小:%d\n ", i+1, columnObj.getInt(MetaData::ATTR_DATA_SIZE)); TRACE( "%d 精度:%d\n ", i+1, columnObj.getInt(MetaData::ATTR_PRECISION)); TRACE( "%d 数值范围:%d\n ", i+1, columnObj.getInt(MetaData::ATTR_SCALE)); if( columnObj.getBoolean(MetaData::ATTR_IS_NULL) ) TRACE( "%d 允许为空\n ", i+1); else TRACE( "%d 不允许为空\n ", i+1); }