C++ (Cpp) exe_sql示例

示例#1

int main(int argc, char *argv[]) {
	/*测试下向里面插入数据*/
	char *query;
	char *exe = "insert into stucent values('lala','hahhahah!');";
	exe_sql(exe);
	/*测试下查询*/
	query="select * from stucent;";
	query_sql(query);
	return 0;
} 

示例#2

文件： MarkovDataPreprocess.cpp 项目： RaulWei/MarkovDataPreprocess

// 将包从文件导入数据库
void movePackToDB()
{
	char no[100];
	char date[100];
	char time[100];
	char source[100];
	char destination[100];
	char protocol[100];
	char length[100];
	char info[2000];
	char insert_sql[1000]={'\0'};

	FILE *file;
	file = freopen("captureStream","r+",stdin);
	if (file == NULL){
		printf("open file error.\n");
	}
	while (scanf("%s%s%s%s -> %s%s%s%*c%[^\n]",no,date,time,source,destination,protocol,length,info) != EOF){
		strcpy(insert_sql,"insert into ssltable_netease_music values('");
		strcat(insert_sql,no);
		strcat(insert_sql,"','");
		strcat(insert_sql,date);
		strcat(insert_sql," ");
		strcat(insert_sql,time);
		strcat(insert_sql,"','");
		strcat(insert_sql,source);
		strcat(insert_sql,"','");
		strcat(insert_sql,destination);
		strcat(insert_sql,"','");
		strcat(insert_sql,protocol);
		strcat(insert_sql,"','");
		strcat(insert_sql,length);
		strcat(insert_sql,"','");
		strcat(insert_sql,info);
		strcat(insert_sql,"')");

		//printf(insert_sql);
		exe_sql(insert_sql);
	}
	
	fclose(stdin);
	fclose(file);

	freopen("CON","r",stdin);
}