proc学习的总结

什么事情都要自己去尝试一下，难者不会会者不难，でしょう？

只是用来熟悉一下环境和语言，要学的东西还有好多哦

下边就是程序了

#include <stdio.h>
#include <string.h>
#include <stdlib.h>
#include <sqlda.h>
#include <sqlcpr.h>

typedef char asciz[20];
typedef char vc2_arr[11];

EXEC SQL BEGIN DECLARE SECTION;
/* User-defined type for null-terminated strings */
EXEC SQL TYPE asciz  IS STRING(20) REFERENCE;

/* User-defined type for a VARCHAR array element. */
EXEC SQL TYPE vc2_arr IS VARCHAR2(11) REFERENCE;

asciz     username;
asciz     password;
asciz     serverid;
int       dept_no;              /* which department to query? */
int       emp_no;    
vc2_arr   job;
asciz     ename;
EXEC SQL END DECLARE SECTION;

long      SQLCODE;

/* Handle errors. Exit on any error. */
void sql_error()
{
    char msg[512];
    size_t buf_len, msg_len;

    EXEC SQL WHENEVER SQLERROR CONTINUE;

    buf_len = sizeof(msg);
    sqlglm(msg, &buf_len, &msg_len);

    printf("\nORACLE error detected:");
    printf("\n%.*s \n", msg_len, msg);

    EXEC SQL ROLLBACK WORK RELEASE;
    exit(1);
}

void main()
{
    char  temp_buf[32];

/* Connect to ORACLE. */
    EXEC SQL WHENEVER SQLERROR DO sql_error();

    strcpy(username, "nes");
    strcpy(password, "nes");
    strcpy(serverid, "ORCL");

    EXEC SQL CONNECT :username IDENTIFIED BY :password USING :serverid;
    printf("\nConnected to ORACLE as user: %s\n\n", username);
    EXEC SQL DECLARE c1 CURSOR FOR
        SELECT empno, ename, sal FROM emp;

    EXEC SQL OPEN c1;
    printf("Enter department number: ");
    gets(temp_buf);
    emp_no = atoi(temp_buf);
               
/*        入力データをデータベースに追加する。*/
       EXEC SQL insert into EMP  (DEPTNO,ENAME,JOB,EMPNO) values (001,'Jacky','worker',:emp_no);

        printf("\n\n\n\n");
        printf("%s\n","データを追加しました。");
       printf("%-10.10s%-10.10s%-10.10s%s\n", "DEPTNO","ENAME", "JOB", "EMPNO");
       printf("%-10.10s%-10.10s%-10.10s%s\n", "--------","--------", "---", "------");
        printf("%-10.10s%-10.10s%-10.10s %d \n","1","Jacky","worker",emp_no);

/*        入力データをデータベースに更新する。*/
       EXEC SQL update EMP  set DEPTNO = 2  WHERE EMPNO=:emp_no;
    
       EXEC SQL SELECT DEPTNO,ENAME,JOB,EMPNO INTO
        :dept_no, :ename,  :job, :emp_no FROM EMP WHERE EMPNO=:emp_no;

        printf("\n\n\n\n");
        printf("%s\n","データを更新しました。DEPTNOを”2”に更新しました。");
       printf("%-10.10s%-10.10s%-10.10s%-10.10s\n", "DEPTNO","ENAME", "JOB", "EMPNO");
       printf("%-10.10s%-10.10s%-10.10s%-10.10s\n", "--------","--------", "---", "------");
        printf("%d          %-10.10s%-10.10s %d \n",dept_no,ename,job,emp_no);
       
/*        入力データをデータベースに削除する。*/
        EXEC SQL delete EMP WHERE EMPNO=:emp_no;

        printf("\n\n\n\n");
        printf("%s\n","データを削除しました。");       

/* Disconnect from the database. */
    EXEC SQL COMMIT WORK RELEASE;
    exit(0);
}

在project----setting----link中添加oraSQL10.lib（针对10g）就ok了