data_insert.c

用oci实现的对oracle的完全操作 有详细的注释

#include "oracle.h"
/* 插入数据 */
int DataInsert(char* iip,char* context,char* fromip)
{
	OCI_ENV *simple_env;
	simple_env = (OCI_ENV *)malloc(sizeof(OCI_ENV));
	memset(simple_env, 0, sizeof(OCI_ENV));
	/* 初始化环境 */
	int i,result;
	char *ip = "192.168.1.19";
	int port = 1521;
	char *user = "jcgs"; 
	char *pass = "jcgs0304";
	char *sid = "yangh";
	char cmd[90];
	sprintf(cmd,"insert into socket(ip, context,fromip) values('%s', '%s','%s')",ip,context,fromip);
	printf("%s\n",cmd);

	if((result = oci_init_env(simple_env, ip, port, user,pass, sid)) == 1)
	{
		printf("contect is faile!!\n");
		return 0;
	}

	if(oci_insert(simple_env, cmd))
	{
		perror("insert faile!\n");
		return 0;
	}
	return 1;
	oci_end(simple_env);					// 注销 
}