注意:需要安装Oracle客户端
先将项目改成64位
创建项目之后,点击属性也,VC++目录下的包含目录,添加Oracle客户端的以下目录(我的Oracle安装在D盘,你们的根据安装位置而定,找到这个目录就可以了) D:\app\Administrator\product\11.2.0\client_1\oci\include
# 将配置库目录 D:\app\Administrator\product\11.2.0\client_1\oci\lib\msvc\vc9
链接器-》输入-》附加依赖下添加 oraocci11.lib oraocci11d.lib
#include <iostream> #include <occi.h> #include <string> #include <stdlib.h> #include <string.h> using namespace std; using namespace oracle::occi; int main() { //初始化环境 Environment* env = Environment::createEnvironment(); if (env == NULL) { cout << "createEnvironment error" << endl; return -1; } //连接oracle数据库 string usr = "scott"; string passwd = "tiger"; string connstr = "192.168.139.129:1521/snorcl11g"; Connection* conn = env->createConnection(usr, passwd, connstr); if (conn == NULL) { cout << "connect database error" << endl; return -1; } cout << "连接成功" << endl; // 插入一条数据,根据自己数据库的表写sql语句 string sql = "insert into dept values(99, '99nongwu', '99tianjin')"; Statement* stmt = conn->createStatement(sql); stmt->execute(); //关闭数据库连接 env->terminateConnection(conn); //关闭释放资源 Environment::terminateEnvironment(env); system("pause"); return 0; }