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; }
// 将包从文件导入数据库 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); }