建表,模拟测试时使用:
create table TEST_DIRECTPATH
(
VAL_INT NUMBER(8,4),
VAL_STR VARCHAR2(30),
VAL_DATE DATE
)
1、插入日期型数据:
#include "stdafx.h"
#include <iostream>
#include <fstream>
#include <sstream>
#include "ocilib.hpp"
#pragma comment(lib, "ociliba.lib")
using namespace ocilib;
int _tmain(int argc, _TCHAR* argv[])
{
try
{
Environment::Initialize(Environment::Default | Environment::Threaded);
Environment::EnableWarnings(true);
Connection con("orcl", "scott", "tiger");
Statement st(con);
st.Prepare("insert into test_directpath(val_int, val_str,val_date) values(:val_int, :val_str,:val_date)");
float fValue = 3.1415926;
std: