wap网站开发,工信部会抽查网站么,万网网站设计,做的网站在百度找不到了前提条件1. Linux环境已经存在#xff0c;安装好了Oracle本demo 运行环境本地环境 RedHat LINUX AS 4 ,ORACLE 10G本地数据库sid orcl,ip:127.0.0.1,用户名:kingbi#xff0c;密码#xff1a;kingbi,表dsd_test. 显示表dsd_test 的所有记录.步骤#xff1a;(1) 创建表 …前提条件1. Linux环境已经存在安装好了Oracle本demo 运行环境本地环境 RedHat LINUX AS 4 ,ORACLE 10G本地数据库sid orcl,ip:127.0.0.1,用户名:kingbi密码kingbi,表dsd_test. 显示表dsd_test 的所有记录.步骤(1) 创建表 create table dsd_test(aa char(3)); insert into dsd_test values(123);insert into dsd_test values(456);被配置本地命名服务($ORACLE_HOME/network/admin/tnsnames.oraORCL (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST localhost.localdomain)(PORT 1521))(CONNECT_DATA (SERVER DEDICATED)(SERVICE_NAME orcl)))(2) 修改配置文件 /etc/profile (用root用户修改增加 2句代码...export PATH USER LOGNAME MAIL HOSTNAME HISTSIZE INPUTRCexport ORACLE_HOME........ #以下2行为新加export LD_LIBRARY_PATH$ORACLE_HOME/lib:/usr/lib #这句很关键.....(3) 更改$ORACLE_HOME/precomp/admin/pcscfg.cfg (include 开头的语句为新加的,/usr/lib/gcc/i386-redhat-linux/3.4.3/include 也是新加的) www.linuxidc.comsys_include(/ade/aime_rdbms_9819/oracle/precomp/public,/usr/include,/usr/lib/gcc-lib/i486-SUSE-linux/2.95.3/include,/usr/lib/gcc-lib/i386-redhat-linux/3.2.3/include,/usr/lib/gcc-lib/i386-redhat-linux7/2.96/include,/usr/lib/gcc/i386-redhat-linux/3.4.3/include)include$ORACLE_HOME/libinclude$ORACLE_HOME/precomp/precomp/includeinclude$ORACLE_HOME/precomp/oracore/includeinclude$ORACLE_HOME/precomp/oracore/publicinclude$ORACLE_HOME/precomp/rdbms/includeinclude$ORACLE_HOME/precomp/rdbms/publicinclude$ORACLE_HOME/precomp/rdbms/demoinclude$ORACLE_HOME/precomp/nlsrtl/includeinclude$ORACLE_HOME/precomp/nlsrtl/publicinclude$ORACLE_HOME/precomp/network_src/includeinclude$ORACLE_HOME/precomp/network_src/publicinclude$ORACLE_HOME/precomp/network/includeinclude$ORACLE_HOME/precomp/network/publicinclude$ORACLE_HOME/precomp/plsql/publicltypeshort(4) 编写c 程序 test.pc文件 www.linuxidc.com#include EXEC SQL INCLUDE SQLCA;int main(){//声明SQL变量EXEC SQL BEGIN DECLARE SECTION;VARCHAR user[20],pass[20],tnsname[20];//VARCHAR预编译后为struct { unsigned short len; unsigned char arr[20];}char ename[20];EXEC SQL END DECLARE SECTION;//声明结束int i0;strcpy(user.arr,kingbi);user.len(unsigned short)strlen((char *)user.arr);strcpy(pass.arr,kingbi);pass.len(unsigned short)strlen((char *)pass.arr);strcpy(tnsname.arr,orcl);tnsname.len(unsigned short)strlen((char *)tnsname.arr);//连接数据库EXEC SQL CONNECT :user IDENTIFIED BY :pass USING :tnsname;//执行查询EXEC SQL declare emp_cursor cursor forselect aa from kingbi.test;EXEC SQL open emp_cursor;EXEC SQL WHENEVER NOT FOUND DO break;while(1){EXEC SQL fetch emp_cursor into :empno,:ename;printf(the name is %s\n,ename);ii1;}printf(Yeah!We get %d records\n,i);EXEC SQL close emp_cursor;EXEC SQL commit work release;}(5) 预编译 编译后会生成 .c文件proc test.pc(6)编译gcc -o test test.c $ORACLE_HOME/lib/libclntsh.so(6) 运行生成的可执行文件./test输出the name is 123the name is 456Yeah!We get 2 records
