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 #include #include #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 #include #include #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 #include #include #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; printf("enter key ... update \n"); getchar(); getchar(); strcpy(loc, "50locloc"); EXEC SQL update dept set loc = :loc where deptno=:deptno; //EXEC SQL delete from dept where deptno=:deptno; EXEC SQL COMMIT RELEASE; //提交事务断开连接 return ret; } |
| 执行结果：
数据库中的结果：
|
查询并显示结果：
| #include #include #include #include "sqlca.h" //定义宿主变量 serverid EXEC SQL BEGIN DECLARE SECTION ; char *serverid = "scott/123456@orcl"; int deptno; char dname[20]; char loc[2 |