dbtest.c

来自「公司业务而自己写的网关通讯程序,网关是平台的.不过对OCI有兴趣的不妨看看. O」· C语言 代码 · 共 33 行

#include <stdio.h>
#include <stdlib.h>
#include "db.h"
#include "log.h"
#include "oci.h"
static CONST OraText *database = (OraText *)"ora9.talkweb.com";
static CONST OraText *username =(OraText *)"scott";
static CONST OraText *password =(OraText *)"tiger";
static CONST OraText *appusername =(OraText *)"APPUSER"; 
static CONST OraText *apppassword =(OraText *)"APPPASSWORD";

int main(int argc, char* argv[])
{
if(!initpool()){
//    exec("insert into t_test(id,name,status) values(1,'lightwiter')");
//    exec("update t_test set id = 9");
	INFO("delete all record");
//    exec("delete from t_test");
    char result[5000];
    memset(result,0,5000);
    INFO("select");
//    exec("insert into t_test(id,name,status) values(1000,'蒋宏伟',sysdate)");
    if(!Select("select * from t_test",result)){
        INFO("OK!");
    INFO(result);
    }
    INFO("delete");
//    exec("delete from t_test");
    closepool();
}
}