db.pc

学习oracle的脚本,包括备份,proc编程的,例子,是学习oracle的好资料

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

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

#include "const.h"
#include "db.h"

#define MODULE_NAME "DB"
#define TABLE_NAME EMP

typedef struct
{
    sql_context context; 
} thread_connect_t;
extern thread_connect_t a_thread_connect[10];


int DbsEMP_SEL_Info(int thread_index, emp_t *p_emp)
{
    SQL_THREAD_SAFE_PREPARE;

    EXEC SQL CONTEXT USE :a_thread_connect[thread_index].context;
    EXEC SQL select * into :p_emp
               from emp
               where no=:p_emp->no;
    SQL_CODE_PROCESS("EMP", "SEL");
}


int DbsEMP_UPD_Info(int thread_index, emp_t *p_emp)
{
    SQL_THREAD_SAFE_PREPARE;

    EXEC SQL CONTEXT USE :a_thread_connect[thread_index].context;
    EXEC SQL update emp
               set upd_ts=to_date(sysdate, 'yyyymmddhh24miss')
               where no=:p_emp->no;
    SQL_CODE_PROCESS("EMP", "UPD");
}