|
TOP
|
|
[转]什么是Pro*C/C++，嵌入式SQL，第一个pro*c程序，pro*c++,Makefile,Proc增删改查(二)
|
注意上面红线部分和执行C的不相同 |
| 接着编译cc文件： g++ dm02_hello.cc -o dm02_hello -I/home/oracle_11/app/oracle/product/11.2.0/db_1/precomp/public -L/home/oracle_11/app/oracle/product/11.2.0/db_1/lib –lclntsh 
|
9.编写一个最简单的MakeFile
| all:dm01_hello dm02_hello dm01_hello: @echo 'proc dm01_hello begin' proc dm01_hello.pc @echo 'gcc dm01_hello begin' gcc dm01_hello.c -o dm01_hello -I${ORACLE_HOME}/precomp/public -L${ORACLE_HOME}/lib -lclntsh dm02_hello: @echo 'proc dm02_hello begin' proc iname=./dm02_hello.pc oname=dm02_hello.cc PARSE=NONE CODE=CPP @echo 'gcc dm02_hello begin' g++ dm02_hello.cc -o dm02_hello -I${ORACLE_HOME}/precomp/public -L${ORACLE_HOME}/lib -lclntsh clean: @rm dm01_hello @rm dm02_hello |
| 执行命令： make 
|
10 数据库的增删改查：
| 编写公共的Makefile |
| all: dm01_dbop dm01_dbop: @echo 'proc dm01_dbop begin' proc dm01_dbop.pc @echo 'gcc dm01_dbop begin' gcc dm01_dbop.c -o dm01_dbop -I${ORACLE_HOME}/precomp/public -L${ORACLE_HOME}/lib –lclntsh clean: @rm dm01_dbop |
| 插入数据： |
| #include <stdio.h> #include <string.h> #include <string.h> #include "sqlca.h" //定义宿主变量 serverid EXEC SQL BEGIN DECLARE SECTION ; char *serverid = "scott/tiger@orcl"; int deptno; char dname[20]; char loc[20] ; int deptno2; char dname2[20]; char loc2[20] ; EXEC SQL END DECLARE SECTION; int main() { int ret = 0; printf("hello....\n"); //在C中是宿主变量 printf("serverid:%s \n", serverid); //嵌入式SQL语言必须要以 EXEC SQL开头 //:serverid EXEC SQL connect :serverid; if (sqlca.sqlcode != 0) { ret = sqlca.sqlcode; printf("EXEC SQL connect:err, %d\n", ret); return ret; } printf("connect ok\n"); deptno = 50; strcpy(dname, "50name"); strcpy(loc, "50loc"); //增加数据 EXEC SQL insert into dept (deptno, dname, loc) values(:deptno, :dname, :loc); EXEC SQL commit; EXEC SQL COMMIT RELEASE; //提交事务断开连接 return ret; } |
| 运行结果: 
|
删除
| Makefile略 |
| #include <stdio.h> #include <string.h> #include <string.h> #include "sqlca.h" //定义宿主变量 serverid EXEC SQL BEGIN DECLARE SECTION ; char *serverid = "scott/tiger@orcl"; int deptno; char dname[20]; char loc[20] ; int deptno2; char dname2[20]; char loc2[20] ; EXEC SQL END DECLARE SECTION; int main() { int ret = 0; printf("hello....\n"); //在C中是宿主变量 printf("serverid:%s \n", serverid); //嵌入式SQL语言必须要以 EXEC SQL开头 //:serverid EXEC SQL connect :serverid; if (sqlca.sqlcode != 0) { ret = sqlca.sqlcode; printf("EXEC SQL connect:err, %d\n", ret); return ret; } printf("connect ok\n"); deptno = 50; strcpy(dname, "50name"); strcpy(loc, "50loc"); EXEC SQL delete from dept where deptno=:deptno; EXEC SQL commit; EXEC SQL COMMIT RELEASE; //提交事务断开连接 return ret; } |
| 运行结果： 
|
更新：
| Makefile公用上面的 |
| #include <stdio.h> #include <string.h> #include <string.h> #include "sqlca.h" //定义宿主变量 serverid EXEC SQL BEGIN DECLARE SECTION ; char *serverid = "scott/tiger@orcl"; int deptno; char dname[20]; char loc[20] ; int deptno2; char dname2[20]; char loc2[20] ; EXEC SQL END DECLARE SECTION; //更新 int main() { int ret = 0; printf("hello....\n"); //在C中是宿主变量 printf("serverid:%s \n", serverid); //嵌入式SQL语言必须要以 EXEC SQL开头 //:serverid EXEC SQL connect :serverid; if (sqlca.sqlcode != 0) { ret = sql |
|