dbfunc.pc

来自「oracle常用脚本」· PC 代码 · 共 33 行

#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 "dbcom.h"
#include "dbfunc.h"

#define MODULE_NAME "DBFUNC"


int DbsEMP_SEL_Info(emp_t *p_emp)
{
    EXEC SQL select * into :p_emp
               from emp
               where no=:p_emp->no;
    SQL_CODE_PROCESS("EMP", "SEL");
}


int DbsEMP_UPD_Info(emp_t *p_emp)
{
    EXEC SQL update emp
               set upd_ts=to_date(sysdate, 'yyyymmddhh24miss')
               where no=:p_emp->no;
    SQL_CODE_PROCESS("EMP", "UPD");
}