Pro * C ¼òµ¥Àý×Ó
#include <stdio.h>
exec sql begin declare section;
char userid[11]="hr/oracle";
char std_name[10];
int std_number;
int dept_number;
exec sql end declare section;
char temp[3];
void sql_error();
#include <sqlca.h>
main()
{
std_number=060415;
exec sql whenever sqlerror do sql_error("oracle error");
exec sql connect :userid;
printf("connect.\n");
exec sql declare gxj_cursor cursor for
select last_name
from employees
where employee_id=:dept_number;
printf("employee number?");
gets(temp);
dept_number=atoi(temp);
exec sql open gxj_cursor;
printf("student name\n");
printf("----------------------------\n");
exec sql whenever not found do break;
while(1)
{
exec sql fetch gxj_cursor into :std_name;
printf("%s\n",std_name);
}
exec sql close gxj_cursor;
exec sql commit work release;
exit(0);
}
void
sql_error(msg)
char * msg;
{
char buf[500];
int buflen,msglen;
exec sql whenever sqlerror continue;
exec sql rollback work release;
buflen=sizeof(buf);
sqlglm(buf,&buflen,&msglen);
printf("%s\n",msg);
printf("%*.s\n",msglen,buf);
exit(1);
}
1. edit a pc file, for example test.pc
2. proc test.pc
3. gcc test.c -I/u01/app/oracle/product/10.2.0/db_1/precomp/public -L/u01/app/oracle/product/10.2.0/db_1/lib -lclntsh ÆäÖÐ-IÖ¸¶¨include·¾¶, -LÖ¸¶¨ÐèÒªµÄ¿âÎļþ·¾¶
Ïà¹ØÎĵµ£º
ÎÒÖ»ÓÃÁËÆäÖеÄ15Ìõ£¬¾Í½ÚÊ¡ÁË40%µÄ¿Õ¼äÄØ£¬Ç¿ÁÒÍÆ¼ö
Ö÷Òª½²½²windows²Ù×÷ϵͳÔÚCÅ̿ռ䲻×ãµÄÇé¿öÏ£¬ÎÒÃÇ¿ÉÒÔͨ¹ýÄÇЩ¾ßÌåÊÖ¶ÎÀ´Ôö¼ÓCÅ̿ռ䡣
1.´ò¿ª“ÎҵĵçÄÔ”-“¹¤¾ß”-“Îļþ¼ÐÑ¡Ïî”-“²é¿´”-ÔÚ“ÏÔʾËùÓÐÎļþºÍÎļþ¼Ð”Ñ¡Ïîǰ´ò¹´-“È ......
ÎÒÕâÁ½ÌìÔÚCSDNÂÛ̳¿ªÁËÒ»¸öÉ¢·ÖÌù£¬ÏëÐû´«Ò»ÏÂÎÒµÄÊé¡£´ó¶àÊýÅóÓÑ»¹ÊǺÜÓѺõ쬶ÔÎÒµÄÖ§³ÖºÍ¹ÄÀøºÜ¶à£¬ÎÒÒ²ºÜ¸Ð¼¤¡£
ÍøÖ·ÔÚÕâÀhttp://topic.csdn.net/u/20091216/22/5a6594be-21e6-459e-ab41-57755273f465.html
µ±È»£¬Ò²ÓÐÅóÓÑÈÏΪФijÈË´µÅ££¬Ëµ0bug²»¿ÉÄÜ£¬²¢ÇÒÒþÒþÓÐPKµÄÒâ˼£¬ÎÒÄØÃ»°ì·¨£¬Ð´Á˸ö˵Ã÷¡£
ÕâÀïÏëÁ ......
ÓÃlinux C ϵĺ¯Êýµ÷Óô´½¨ÖÐÎÄĿ¼¡¢ÎļþµÈ£¬×Ö·û´®µÄ±àÂë¸ñʽҪÇóÊÇutf-8¸ñʽµÄ¡£
±ÈÈçÏëҪʹÓà int mkdir(const char *pathname, mode_t mode); ´´½¨Ò»¸öÖÐÎĵÄĿ¼¡£ÄÇôpathnameµÄ±àÂë¸ñʽҪÇóÊÇutf-8µÄ£¬¶ø²»ÄÜÊÇgb3212/gbkµÄ£¬·ñÔò¾ÍÊÇÂÒÂë¡£
ÄÇôÈç¹ûlinux CÏÂÈçºÎ½øÐÐgbk<---->utf-8±àÂëת»»µÄ±àÂë×°»»µÄ ......