在linux(或者Unix下)如何用c语言操作数据库 到oracle或sqlserver的目录下搜索*.c就找到了,很简单的,看着照猫画虎来一个就会了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 装一下 proc*c 工具下面有一下很简单的例子//////在vc中编译时加载oraSQL8.lib文件#pragma comment(lib,"oraSQL8.lib")#include "stdio.h"#include "string.h"#include "stdlib.h"#include "dos.h"EXEC SQL INCLUDE SQLCA;//////////数据库联接int Ora_conn(){ EXEC SQL BEGIN DECLARE SECTION; VARCHAR usr[20],pass[20],serv[20]; EXEC SQL END DECLARE SECTION; EXEC SQL WHENEVER SQLERROR GOTO sqlerr; strcpy(usr.arr,"lcj"); usr.len=(unsigned short)strlen((char*)usr.arr); strcpy(pass.arr,"lcj"); pass.len=(unsigned short)strlen((char*)pass.arr); strcpy(serv.arr,"zlodb"); serv.len=(unsigned short)strlen((char*)serv.arr); EXEC SQL CONNECT :usr IDENTIFIED BY :pass USING :serv; printf("Connect!\n"); return 1; sqlerr: EXEC SQL WHENEVER SQLERROR CONTINUE; printf("%s\n",sqlca.sqlerrm.sqlerrmc); return 0; }/////调用存储过程/*call_p(userid){ EXEC SQL BEGIN DECLARE SECTION; char userid_p[10]; EXEC SQL END DECLARE SECTION; strcpy(userid_p,userid); EXEC SQL EXECUTE BEGIN prtest(:userid_p,'124','1234'); END; END-EXEC; }*/void main(){ char pathstring[20]; char filecontent[200]; int total=0; EXEC SQL BEGIN DECLARE SECTION; /*sql中用到的变量*/ char s_mobile[12],s_mscontent[160],s_sendtype[20],s_destmobile[12],s_rowid[18]; char s_mstime[20]; int conn; EXEC SQL END DECLARE SECTION; conn=Ora_conn(); if (conn==1) { while(1) { EXEC SQL WHENEVER NOT FOUND GOTO notfoundall; EXEC SQL DECLARE c_ms_temp CURSOR FOR SELECT MOBILE,MSCONTENT,SENDTYPE,DESTMOBILE,MSTIME,ROWID FROM MS_TEMP; EXEC SQL OPEN c_ms_temp; while(1) { EXEC SQL FETCH c_ms_temp INTO :s_mobile,:s_mscontent,:s_sendtype,:s_destmobile,:s_mstime,:s_rowid; if( sqlca.sqlcode == 1403) { break; } //从ms_bf移到ms中 EXEC SQL INSERT INTO MS(MOBILE,MSCONTENT,SENDTYPE,DESTMOBILE,MSTIME) VALUES(:s_mobile,:s_mscontent,:s_sendtype,:s_destmobile,:s_mstime); //对上行表加入log表中 EXEC SQL INSERT INTO LOG VALUES(logseq,nextval,:s_mobile,:s_destmobile,sysdate,'',s_mscontent,'上行表'); EXEC SQL DELETE FROM MS_TEMP WHERE ROWID=:s_rowid; EXEC SQL COMMIT; //total=total+1; //printf("%s\t\t%s\t%s\t\n",userid,username,birthday); } continue; notfoundall: if (total==0) { printf("\n没有找到用户信息!\n\n\n"); } else { printf("\n共有%d条用户信息!\n\n\n",total); } printf("处理完成!!!"); delay(5000); printf("已经delay 5秒!!!!"); } } else{ printf("数据库联接失败!!!!"); } EXEC SQL COMMIT WORK RELEASE;} http://chinaunix.net/jh/19/72576.htmlhttp://chinaunix.net/jh/19/80950.html asktom的使用 一个奇怪的问题 Oracle 物化视图刷新 问题 急!!!求一个sql语句。这剩这么多分了…… 三个角了,散分 ORACLE开发去日本的好机会!!! 怎么写这个sql @SPCREATE,建立STATSPACK的问题(随便问问) 这个sql语句怎么改? 用Sqlldr向ORACLE导入ACCESS数据库发生错误:SQL*Loder-704,ORA-12560 两位年转换成四位时的问题 请教将varrary 做为PROCEDUR 的OUT参数时,varrary的初始化的问题
#pragma comment(lib,"oraSQL8.lib")#include "stdio.h"
#include "string.h"
#include "stdlib.h"
#include "dos.h"EXEC SQL INCLUDE SQLCA;//////////数据库联接
int Ora_conn()
{
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR usr[20],pass[20],serv[20];
EXEC SQL END DECLARE SECTION;
EXEC SQL WHENEVER SQLERROR GOTO sqlerr; strcpy(usr.arr,"lcj");
usr.len=(unsigned short)strlen((char*)usr.arr);
strcpy(pass.arr,"lcj");
pass.len=(unsigned short)strlen((char*)pass.arr);
strcpy(serv.arr,"zlodb");
serv.len=(unsigned short)strlen((char*)serv.arr);
EXEC SQL CONNECT :usr IDENTIFIED BY :pass USING :serv;
printf("Connect!\n");
return 1;
sqlerr:
EXEC SQL WHENEVER SQLERROR CONTINUE;
printf("%s\n",sqlca.sqlerrm.sqlerrmc);
return 0;
}/////调用存储过程
/*
call_p(userid)
{
EXEC SQL BEGIN DECLARE SECTION;
char userid_p[10];
EXEC SQL END DECLARE SECTION;
strcpy(userid_p,userid);
EXEC SQL EXECUTE
BEGIN
prtest(:userid_p,'124','1234');
END;
END-EXEC; }
*/
void main()
{
char pathstring[20];
char filecontent[200];
int total=0; EXEC SQL BEGIN DECLARE SECTION; /*sql中用到的变量*/
char s_mobile[12],s_mscontent[160],s_sendtype[20],s_destmobile[12],s_rowid[18];
char s_mstime[20];
int conn;
EXEC SQL END DECLARE SECTION;
conn=Ora_conn(); if (conn==1)
{
while(1)
{
EXEC SQL WHENEVER NOT FOUND GOTO notfoundall;
EXEC SQL DECLARE c_ms_temp CURSOR FOR SELECT MOBILE,MSCONTENT,SENDTYPE,DESTMOBILE,MSTIME,ROWID FROM MS_TEMP;
EXEC SQL OPEN c_ms_temp;
while(1)
{
EXEC SQL FETCH c_ms_temp INTO :s_mobile,:s_mscontent,:s_sendtype,:s_destmobile,:s_mstime,:s_rowid;
if( sqlca.sqlcode == 1403)
{
break;
}
//从ms_bf移到ms中
EXEC SQL INSERT INTO MS(MOBILE,MSCONTENT,SENDTYPE,DESTMOBILE,MSTIME) VALUES(:s_mobile,:s_mscontent,:s_sendtype,:s_destmobile,:s_mstime);
//对上行表加入log表中
EXEC SQL INSERT INTO LOG VALUES(logseq,nextval,:s_mobile,:s_destmobile,sysdate,'',s_mscontent,'上行表');
EXEC SQL DELETE FROM MS_TEMP WHERE ROWID=:s_rowid;
EXEC SQL COMMIT; //total=total+1;
//printf("%s\t\t%s\t%s\t\n",userid,username,birthday);
}
continue;
notfoundall:
if (total==0)
{
printf("\n没有找到用户信息!\n\n\n");
}
else
{
printf("\n共有%d条用户信息!\n\n\n",total);
}
printf("处理完成!!!");
delay(5000);
printf("已经delay 5秒!!!!"); }
}
else{
printf("数据库联接失败!!!!"); }
EXEC SQL COMMIT WORK RELEASE;
}
http://chinaunix.net/jh/19/80950.html