OCI连接oracle 12C

前端之家收集整理的这篇文章主要介绍了OCI连接oracle 12C前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

注册CSDN也好几年了,一直都没写过博客,今天就写一个吧。好了言归正传,由于公司业务的需要从windows平台转到linux下,之前呢,也没怎么接触过linux服务端的编程,只好硬着头皮上了。

本人用的系统是ubuntu 16.04,开发工具呢,选来选去,感觉还是Eclipse好用。数据库当然就是oracle 12C了。

首先呢,去oracle官网下载必要的软件包,下载地址:http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html,帐号就自己注册一个吧。

1.oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm

2.oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm

3.oracle-instantclient12.1-odbc-12.1.0.2.0-1.x86_64.rpm

4.oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm

然后安装这几个包:

alien -i oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm

.

.

.

依次安装,中途没有遇到什么问题。

然后测试一下是不是能远程连接oracle了,我是64位系统,所以是sqlplus64

sqlplus64 username/password@192.168.1.222/数据库实例名


能成功连接的话,说明安装成功了,接着开始编程吧

代码参考的:http://bbs.csdn.net/topics/380262703,然后自己修改了一些,谢谢各位的帮忙了

库目录的默认路径:/usr/lib/oracle/12.1/client64/lib

文件的默认路径:/usr/include/oracle/12.1/client64


/*************************
编译语句
gcc -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -I${ORACLE_HOME}/rdbms/public -I${ORACLE_HOME}/rdbms/demo -L${ORACLE_HOME}/lib -lclntsh  test1.c

OCI重定义数据类型:

typedef unsigned     char         ub1;
typedef signed     char         sb1;
typedef unsigned     short     ub2;
typedef signed     short     sb2;
typedef unsigned     int         ub4;
typedef signed     int         sb4;
typedef ub4                     duword;
typedef sb4                     dsword;
typedef dsword                 dword;

*************************/
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <oci.h>

/*user name and password*/
static text* username=(text *)"dma";
static text* password=(text *)"123456";
static text* oracle=(text *)"192.168.1.135/orcl";

/* Define sql statements to be used in program. */
static text* sql=(text *)"insert into company(companyid,companyname) values (:1,:2)";

/*handle define*/
static OCIEnv             *p_env;                                        //OCI environment handle
static OCIError         *p_err;                                        //OCI error handle
static OCISvcCtx        *p_svc;                                        //OCI service context handel
static OCIServer        *p_ser;                                        //OCI server handle
static OCISession        *p_usr;                                        //OCI user session handle
static OCIStmt            *p_sql;                                        //OCI statement handle
static OCIDefine        *p_dfn = (OCIDefine *)NULL;            //OCI define handle
static OCIBind            *p_bnd = (OCIBind *)NULL;                //OCI bind handle


/*create OCI environment*/
int create_env()
{
    int swResult;            //Return value
    if(swResult = OCIEnvCreate(&p_env,OCI_DEFAULT,NULL,NULL))
        {
            printf("environment create error!\n\n");
            return -1;
        }
    else
        {
            printf("environment create success!\n\n");
            return 0;
        }
}

/*init handle*/
int init_handle()
{
    int swResult;
    if(swResult = OCIHandleAlloc(p_env,(dvoid *)&p_ser,OCI_HTYPE_SERVER,NULL))    //服务器句柄
        {
            printf("init server handle error!\n\n");
            return -1;
        }
    else
        {
            printf("init server handle success!\n\n");
        }

    if(swResult = OCIHandleAlloc(p_env,(dvoid *)&p_err,OCI_HTYPE_ERROR,NULL))    //错误句柄
        {
            printf("init error handle error!\n\n");
            return -1;
        }
    else
        {
            printf("init error handle success!\n\n");
        }
    if(swResult = OCIHandleAlloc(p_env,(dvoid *)&p_usr,OCI_HTYPE_SESSION,NULL))    //事务句柄
        {
            printf("init session handle error!\n\n");
            return -1;
        }
    else
        {
            printf("init session handle success!\n\n");
        }
    if(swResult = OCIHandleAlloc(p_env,(dvoid *)&p_svc,OCI_HTYPE_SVCCTX,NULL))    //上下文句柄
        {
            printf("init service context handle error!\n\n");
            return -1;
        }
    else
        {
            printf("init service context handel success!\n\n");
        }
    if(swResult = OCIHandleAlloc(p_env,(dvoid *)&p_sql,OCI_HTYPE_STMT,NULL))        //sql语句句柄
        {
            printf("init statement handle error!\n\n");
            return -1;
        }
    else
        {
            printf("init statement handle success!\n\n");
        }
    return 0;
}

/*connect server*/
int conn_server()
{
    int swResult;
    if(swResult = OCIlogon(p_env,p_err,&p_svc,(text *)username,strlen(username),(text *)password,strlen(password),(text *)oracle,strlen(oracle)))
        {
            printf("connect error!\n\n");
            return -1;
        }
    else
        printf("connect success!\n\n");
    return 0;
}

/*sql statements*/
int oci_exec()
{
    int swResult;
    //准备sql语句
    if(swResult = OCIStmtPrepare(p_sql,sql,strlen(sql),OCI_NTV_Syntax,OCI_DEFAULT))
        {
            printf("prepare sql statements error!\n\n");
        }
    else
        {
            printf("prepare sql statements success!\n\n");
        }

    //设置绑定变量
    int getId ;
    char getName[10];

    OCIBind     *p_bndp1 = NULL;
    OCIBind     *p_bndp2 = NULL;

    printf("输入ID,NAME:\n");
    scanf("%d %s",&getId,getName);

    if(swResult = OCIBindByPos(p_sql,&p_bndp1,1,(dvoid *)&getId,(sb4)sizeof(getId),sqlT_INT,OCI_DEFAULT))
        {
            printf("Bind p1 error!\n\n");
            return -1;
        }
    else
        {
            printf("bind success!\n\n");
        }

    if(swResult = OCIBindByPos(p_sql,&p_bndp2,2,&getName,(sb4)sizeof(getName),sqlT_STR,(dvoid *) 0,(ub2 *) 0,(ub4) 0,(ub4 *) 0,OCI_DEFAULT))
        {
            printf("Bind p2 error!\n\n");
            return -1;
        }
    else
        {
            printf("bind success!\n\n");
        }


    //执行sql statements
    if(swResult = OCIStmtExecute(p_svc,p_sql,OCI_DEFAULT))
        {
            printf("execute sql statement error!\n\n");
            return -1;
        }
    else
        {
            printf("execute sql statement success!\n\n");
        }
    return 0;
}


/*quit server*/
void quit_server()
{
    OCIlogoff(p_svc,p_err);
    printf("Quit success!\n");
}

/*free handle*/
void free_handle()
{
    OCIHandleFree(p_ser,OCI_HTYPE_SERVER);            //释放服务器句柄
    OCIHandleFree(p_err,OCI_HTYPE_ERROR);            //释放错误句柄
    OCIHandleFree(p_usr,OCI_HTYPE_SESSION);        //释放事务句柄
    OCIHandleFree(p_svc,OCI_HTYPE_SVCCTX);            //释放上下文句柄
    OCIHandleFree(p_sql,OCI_HTYPE_STMT);            //释放sql语句句柄
}

int main()
{
    if(create_env() == -1)                //创建环境
        return -1;
    if(init_handle() == -1)                //初始化句柄
        return -1;
    if(conn_server() == -1)                //连接数据库
        return -1;
    if(oci_exec() == -1)
        return -1;
    quit_server();                            //退出数据库
    free_handle();                            //释放句柄
    return 0;
}

编译运行,哈哈,到这里应该就成功了!

这里要感谢google,遇到问题多思考,总会解决的!

原文链接:https://www.f2er.com/oracle/210593.html

猜你在找的Oracle相关文章