dml1.pc

来自「orale培训教材包括了所有的sql说明和实例」· PC 代码 · 共 55 行

/*
 * name:pro*c c程序，使用scott完成数据库连接，向sm_emp插入
 * file name :dml.pc
 */

/*必须首先包含相应头文件,stdlib.h中包括了string.h*/
#include <stdlib.h>
#include <stdio.h>

/*宿主变量声明区*/
EXEC SQL BEGIN DECLARE SECTION;



/*用户USERNAME,PASSWORD*/
char* userid;


EXEC SQL END DECLARE SECTION;


/*需包含SQLCA.H,使用以下两种方法都可以*/
/*EXEC SQL INCLUDE SQLCA.H;*/
#include <sqlca.h>


int main(int argc, char *argv[])
{
	
    /*用户USERNAME和PASSWORD*/
    userid="scott/tiger";
    
    /*server = "ora8";*/

    /*使用用户名,口令连接本地服务器*/
    EXEC SQL CONNECT :userid;

   
    printf("user scott connected to oracle\n");

    
    /*方法1：嵌入式SQL语句插入纪录 empid='0000000008'*/
    EXEC SQL INSERT INTO SM_EMP (empid,name,salary,telno)  VALUES('0000000008','008',888,'88888888');
    printf("\ninsert ok");
      
    EXEC SQL DELETE FROM sm_emp WHERE empid='0000000007';
    /*delete record*/
    printf("\ndelete ok");

    /*结束数据库连接,commit*/
    EXEC SQL COMMIT  WORK RELEASE;
	printf ("\nEnd of the Pro*C Sample example program.\n");
	return 0;
}