database.c

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

#include "oracle.h"
/*
	pNrc -> ipaddress

*/
int DataCheck(char *pNrc, BASE_DATA* pdata,OCI_DATA *sdata)		
{
	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 = "hengyan"; 
	char *pass = "hengyan";
	char *sid = "203.93.208.100";
	char cmd[90];
	sprintf(cmd,"select * from socket where ip = %s",pNrc);
	if((result = oci_init_env(simple_env, ip, port, user,pass, sid)) == 1)
	{
		printf("contect is faile!!\n");
		return 0;
	}

/* 更新 */
/*
	if(oci_query(simple_env, "update temp set a = 'value_new_a'"))
		perror("RR");
*/
/* 取数据 */

	if(oci_fetch_data(simple_env, cmd, sdata, pdata) == 1)
		return 1;
	else
		return 0;
/*释放内存*/
	oci_free_result(sdata);
/* 注销 */
	oci_end(simple_env);
}


/*
sword OCILogon2 ( OCIEnv          *envhp,
                  OCIError        *errhp,
                  OCISvcCtx       **svchp,
                  CONST OraText   *username,
                  ub4             uname_len,
                  CONST OraText   *password,
                  ub4             passwd_len,
                  CONST OraText   *dbname,
                  ub4             dbname_len );
                  ub4             mode );

sword OCILogon ( OCIEnv          *envhp,
                 OCIError        *errhp,
                 OCISvcCtx       **svchp,
                 CONST OraText   *username,
                 ub4             uname_len,
                 CONST OraText   *password,
                 ub4             passwd_len,
                 CONST OraText   *dbname,
                 ub4             dbname_len );

*/

/*

int main(int argc, char* argv[]) 
{
	char err_msg   [512];
	sword          r;
	struct oci_connection conn;

	if (argc < 2) 
	{
		printf("usage %s username/password[@dbname]\n", argv[0]);
		exit (-1);
	}
	text  username[30];
	text  password[30];
	text  dbname  [30];
	parse_connect_string(argv[1],username, password, dbname);
}

void parse_connect_string(
	char* connect_str,		// in   
	text  username[31],		// out 
	text  password[31],		// out  
	text  dbname  [31]		// out  
) {
	username[0] = 0;
	password[0] = 0;
	dbname  [0] = 0;
	text* to=username;
	while (*connect_str) 
	{
		if (*connect_str == '/') 
		{
			*to=0;
			to=password;
			connect_str++;
			continue;
		}
		if (*connect_str == '@') 
		{
			*to=0;
			to=dbname;
			connect_str++;
			continue;
		}
		*to=*connect_str;
		to++;
		connect_str++;
	}
	*to=0;
}

*/