dbcom.pc

oracle常用脚本

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <strings.h>
#include <math.h>

#include "sqlca.h"
#include "sqlda.h"

#include "dbcom.h"
#include "dbfunc.h"

#define MODULE_NAME "DBCOM"


int DbsConnect(char *connect)
{
    char buf[100], *p_str,dbuser[10], password[10];

    if(connect==NULL)  return -1;
    strcpy(buf, connect);
    p_str=strtok(buf, "/");
    if(p_str==NULL)  return -1;
    strcpy(dbuser, p_str);
    p_str=strtok(NULL, "/");
    if(p_str==NULL)  return -1;
    strcpy(password, p_str);

    EXEC SQL connect :dbuser identified by :password;

    SQL_CODE_PROCESS("SYS", "CON");
}


int DbsDisconn()
{
    EXEC SQL commit work release;

    SQL_CODE_PROCESS("SYS", "CON");
}


int DbsCommit()
{
    EXEC SQL commit;

    SQL_CODE_PROCESS("SYS", "COM");
}


int DbsRollback()
{
    EXEC SQL rollback;

    SQL_CODE_PROCESS("SYS", "ROL");
}