linux c mysql 编程_Linux环境MySQL的C编程起步

我的Linux环境是debian 2.6.x

首先安装必需的开发包

sudo apt-get install gcc g++ libgcc1 libg++ make gdb

安装MYSQL的C语言开发包

sudo apt-get install libmysql++-dev libmysql++2c2a libmysqlclient15-dev libmysqlclient15off

把lib文件拷贝到公用

sudo cp /usr/lib/mysql/* /usr/lib/

建立一个新文件test.cpp

vim test.cpp

输入内容

#include

#include

#include "/usr/include/mysql/mysql.h"

int main() {

MYSQL mysql;

mysql_init(&mysql);

}

ctrl+O保存ctrl+x退出。

然后编译

g++ -lmysqlclient test.cpp -o test

运行

./test

如果什么都没提示，没错误，就说明成功了。

下面是自己写的一个小程序：查询mysql进行弱点关联。

#include

#include

#include

#include

#include "/usr/include/mysql/mysql.h"

void asso_1(){

MYSQL mysql_conn; /* Mysql connection handle */

MYSQL_RES *mysql_result1, *mysql_result2, *mysql_result3; /* Result handle */

MYSQL_ROW mysql_row1, mysql_row2, mysql_row3; /* Row data */

int f1, f2, num_row1, num_col1, num_row2, num_col2;

printf("Start association analyse type 1: Weekness association\n");

int i;

for (i = 0; i<20; i++) printf("# ");

printf("\n");

if (mysql_init(&mysql_conn) == NULL) printf("Initialization fails\n");

if (mysql_real_connect(&mysql_conn, "localhost", "root", "123456", "test", 3306, NULL, 0) == NULL) printf("Connection fails\n");

if (mysql_query(&mysql_conn, "SELECT scid,aid,proto,dip,dport FROM `scan_table`") != 0)

printf("Query fails\n");

mysql_result1 = mysql_store_result(&mysql_conn);

num_row1 = mysql_num_rows(mysql_result1); /* Get the no. of row */

num_col1 = mysql_num_fields(mysql_result1); /* Get the no. of column */

for (f1 = 0; f1 < num_row1; f1++) {

mysql_row1 = mysql_fetch_row(mysql_result1); /* Get a row */

printf ("%s %s %s %s\n",mysql_row1[1],mysql_row1[2],mysql_row1[3],mysql_row1[4]);

char *str;

str = (char *)malloc(1024);

strcpy(str,"SELECT * FROM ids_table WHERE aid=");

strcat(str,mysql_row1[1]);

strcat(str," and proto='");

strcat(str,mysql_row1[2]);

strcat(str,"' and dip='");

strcat(str,mysql_row1[3]);

strcat(str,"' and dport='");

strcat(str,mysql_row1[4]);

strcat(str,"'");

printf("%s\n",str);

if (mysql_query(&mysql_conn, str) != 0) printf("Query error!\n");

mysql_result2 = mysql_store_result(&mysql_conn);

num_row2 = mysql_num_rows(mysql_result2); /* Get the no. of row */

num_col2 = mysql_num_fields(mysql_result2); /* Get the no. of column */

mysql_row2 = mysql_fetch_row(mysql_result2); /* Get a row */

char *str2, *str3;

str2 = (char *)malloc(1024);

str3 = (char *)malloc(1024);

sprintf(str3, "%d", num_row2);

strcpy(str2,"INSERT INTO asso_table (scid,num,aid,proto,dip,dport) VALUES(");

strcat(str2,mysql_row1[0]);strcat(str2,",");

strcat(str2,str3);strcat(str2,",");

strcat(str2,mysql_row1[1]);strcat(str2,",'");

strcat(str2,mysql_row1[2]);strcat(str2,"','");

strcat(str2,mysql_row1[3]);strcat(str2,"','");

strcat(str2,mysql_row1[4]);strcat(str2,"')");

printf("%s\n",str2);

if (mysql_query(&mysql_conn, str2) != 0) printf("Insert error!\n");

}

mysql_free_result(mysql_result1);

mysql_free_result(mysql_result2);

mysql_close(&mysql_conn);

printf("Association analyse type 1 finished\n");

}

void asso(int type){

if (type == 1) asso_1();

}

int main(int argc, char **argv) {

int param;

printf("select association type:\n1: Weekness association\n2:\n3:\nInput number>");

scanf("%d",?m);

asso(param);

return 0;

}