在centos 6.6上搭建c++运行环境并连接oracle数据库
# yum install gcc-c++
备注:此时会将gcc-c++和libstdc++-devel都安装上。
2、查看g++是否安装成功
[root@myrhel 桌面]# g++ -v
使用内建 specs。
目标:x86_64-redhat-linux
配置为:../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-bugurl=http://bugzilla.redhat.com/bugzilla --enable-bootstrap --enable-shared --enable-threads=posix --enable-checking=release --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-gnu-unique-object --enable-languages=c,c++,objc,obj-c++,java,fortran,ada --enable-java-awt=gtk --disable-dssi --with-java-home=/usr/lib/jvm/java-1.5.0-gcj-1.5.0.0/jre --enable-libgcj-multifile --enable-java-maintainer-mode --with-ecj-jar=/usr/share/java/eclipse-ecj.jar --disable-libjava-multilib --with-ppl --with-cloog --with-tune=generic --with-arch_32=i686 --build=x86_64-redhat-linux
线程模型:posix
gcc 版本 4.4.7 20120313 (red hat 4.4.7-11) (gcc)
3、测试
(1)测试c语言程序testc.c
#include
int main()
{
printf(hello c!\n);
return 0;
}
运行:
# gcc testc.c -o testc
# ./testc
(2)测试c++程序test.cpp
#include
using namespace std;
int main()
{
cout cout cout return 10;
}
运行:
# g++ -o test1 test.cpp
# ./test1
4 安装oracleclient
主要安装oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm和oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm。
# rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
# rpm –ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
5 配置
(1)配置ld.so.conf文件,填入如下内容:
# vi /etc/ld.so.conf
include ld.so.conf.d/*.conf
/usr/lib/oracle/11.2/client64/lib
(2)配置/etc/hosts文件(此处填入linux系统主机的ip地址和主机名称),填入如下内容:
# vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.48.128 myrhel
6 测试与oracle数据库连接
(1)建立一个connclient.cpp文件,输入如下内容:
[root@myrhel test]# vi connclient.cpp
#include
#include
#include
using namespace std;
using namespace oracle::occi;
int main()
{
environment *env;
connection *conn;
statement *stmt;
string struser(scott);
string strpwd(orcl0991);
string strconn_string(10.208.17.206:1521/xe);
env = environment::createenvironment(environment::object);
conn = env->createconnection(struser, strpwd, strconn_string);
if(null!= conn)
cout
else
cout
string strsql(select deptno,dname from dept);
stmt = conn->createstatement(strsql);
resultset *rset = stmt->executequery();
while(rset->next()){
int deptno = rset->getint(1);
string dname = rset->getstring(2);
cout
}
stmt->closeresultset(rset);
conn->terminatestatement(stmt);
env->terminateconnection(conn);
environment::terminateenvironment(env);
return0;
}
(2)编译运行:
[root@myrhel test]# g++ -o connclient connclient.cpp -l /usr/lib/oracle/11.2/client64/lib -i /usr/include/oracle/11.2/client64/ -locci -lclntsh /usr/lib64/libstdc++.so.6
[root@myrhel test]# ./connclient
conn success
deptno=10,dname=accounting
deptno=20,dname=research
deptno=30,dname=sales
deptno=40,dname=operations