?

　編譯和連接程序

　　MySQL中有一個(gè)特殊的腳本,叫做mysql_config. 它會(huì)為你編譯MySQL客戶端,并連接到MySQL服務(wù)器提供有用的信息.你需要使用下面兩個(gè)選項(xiàng).

　　1. --libs 選項(xiàng) - 連接MySQL客戶端函數(shù)庫所需要的庫和選項(xiàng).

　　$ mysql_config --libs

　　2. --cflags 選項(xiàng) - 使用必要的include文件的選項(xiàng)等等.

　　$ mysql_config --cflags

　　你需要將上面兩個(gè)選項(xiàng)加入到對(duì)源文件的編譯命令中. 所以,要編譯上面的程序,要使用下面的命令:

　　$ g++ -o output-file $(mysql_config --cflags) test.c $(mysql_config --libs)

　　執(zhí)行編譯后的程序:

　　$ ./output.file

?

#include <mysql.h> #include <stdlib.h> #include <stdio.h> static char *server_args[] = { "this_program", /* this string is not used */ "--datadir=.", "--key_buffer_size=32M" }; static char *server_groups[] = { "embedded", "server", "this_program_SERVER", (char *)NULL }; int main(void) { if (mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups)) exit(1); MYSQL *conn; MYSQL_RES *res; MYSQL_ROW row; char *server = "localhost"; char *user = "admin"; char *password = "metrics"; /* 此處改成你的密碼 */ char *database = "test"; conn = mysql_init(NULL); /* Connect to database */ if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) { fprintf(stderr, "%s/n", mysql_error(conn)); exit(1); } /* send SQL query */ if (mysql_query(conn, "show tables")) { fprintf(stderr, "%s/n", mysql_error(conn)); exit(1); } res = mysql_use_result(conn); //utput table name */ printf("MySQL Tables in mysql database:/n"); while ((row = mysql_fetch_row(res)) != NULL) printf("%s /n", row[0]); printf ("Number of rows: %lu/n", (unsigned long) mysql_num_rows(res)); MYSQL_FIELD *field; while ((field = mysql_fetch_field(res))) { printf("field name %s/n", field->name); } int num_fields = mysql_num_fields(res); for (int i = 0; i < num_fields; i++) { field = mysql_fetch_field_direct(res, i); printf("Field %u is %s/n", i, field->name); } if (!mysql_set_character_set(conn, "utf8")) { MY_CHARSET_INFO cs; mysql_get_character_set_info(conn, &cs); printf("character set information:/n"); printf("character set name: %s/n", cs.name); printf("collation name: %s/n", cs.csname); printf("comment: %s/n", cs.comment); printf("directory: %s/n", cs.dir); printf("multi byte character min. length: %d/n", cs.mbminlen); printf("multi byte character max. length: %d/n", cs.mbmaxlen); } /* close connection */ mysql_free_result(res); mysql_close(conn); /* Use any MySQL API functions here */ mysql_server_end(); return EXIT_SUCCESS; }

運(yùn)行結(jié)果如下：

轉(zhuǎn)載于:https://www.cnblogs.com/zhwj184/archive/2009/11/24/3027541.html

總結(jié)

以上是生活随笔為你收集整理的linux c++连接mysql示例的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。