Oracle之使用proc增删改查

来源：互联网发布：打印机显示网络编辑：程序博客网时间：2024/06/06 03:59

#define _CRT_SECURE_NO_WARNINGS#include <stdio.h>#include <stdlib.h>#include <string.h>#include "sqlca.h"#pragma comment(lib,"orasql11.lib")//serverid 宿主变量EXEC SQL BEGIN DECLARE SECTION;char * serverid = "scott/scott@orcl";int empno;//员工编号char ename[20];//员工名字int deptno;//部门编号int sal;//薪水EXEC SQL END DECLARE SECTION;void main(){//嵌入式SQL必须以EXEC SQL开头EXEC SQL connect :serverid;//检测是否成功连接数据库if(sqlca.sqlcode != 0){printf("sql connect error\n");}printf("connect success\n");//字段赋值empno = 7556;strcpy(ename,"LUCY");deptno = 10;//增加数据EXEC SQL insert into emp(empno, ename, deptno ) values (:empno, :ename, :deptno);EXEC SQL commit;printf("insert success\n");//删除数据EXEC SQL delete from emp where empno = 7556;EXEC SQL commit;printf("delete success\n");//修改数据sal = 1000;EXEC SQL update emp set sal = :sal where empno = 7556;EXEC SQL commit;printf("update success\n");//查询数据EXEC SQL select empno,ename,deptno,sal into :empno,:ename,:deptno,:sal from emp where empno = 7499;printf("%d\t%s\t%d\t%d\n",empno,ename,deptno,sal);//提交事务并断开连接EXEC SQL COMMIT RELEASE;system("pause");}

阅读全文

0 0