A remander for C to mysql

来源：互联网发布：知乎营销软件编辑：程序博客网时间：2024/06/03 23:01

debian-lenny

安装mysql-server: apt-get install mysql-server

安装mysql-client: apt-get install mysql-client

安装开发库： apt-get install libmysqlclient15-dev

以下代码简单显示select 语句的结果：

#include <stdio.h>#include <stdlib.h>#include "mysql.h"void display_header(MYSQL_RES *res_ptr);void display_row(MYSQL * conn_ptr, MYSQL_ROW row_ptr);int main(void) {MYSQL conn_mysql, * conn_ptr;MYSQL_RES *res_ptr;MYSQL_ROW row_ptr;int ret;conn_ptr = &conn_mysql;mysql_init(conn_ptr);if (mysql_real_connect(conn_ptr, "127.0.0.1", "double", "desdouble", "test", 0, NULL, 0)) {printf("Connect to mysql database successfull!/n");ret = mysql_query(conn_ptr, "select * from friend");if (!ret) {printf("Select query successfully!/n");res_ptr = mysql_use_result(conn_ptr);if (res_ptr) {printf("mysql_use_result OK!/n");display_header(res_ptr);while((row_ptr = mysql_fetch_row(res_ptr))) {printf("/nFetched data.../n");display_row(conn_ptr, row_ptr);}}else {if (mysql_errno(conn_ptr))fprintf(stderr, "Error %d: %s/n", mysql_errno(conn_ptr), mysql_error(conn_ptr));}mysql_free_result(res_ptr);}else {if (mysql_errno(conn_ptr))fprintf(stderr, "Error %d: %s/n", mysql_errno(conn_ptr), mysql_error(conn_ptr));}}else {if(mysql_errno(conn_ptr))fprintf(stderr, "Error %d: %s/n", mysql_errno(conn_ptr), mysql_error(conn_ptr));}mysql_close(conn_ptr);return 0;}void display_header(MYSQL_RES * res_ptr) {MYSQL_FIELD *field_ptr;while((field_ptr = mysql_fetch_field(res_ptr))) {printf("Name: %s/n", field_ptr->name);printf("/tType: ");if (IS_NUM(field_ptr->type)) printf("Numberic");else {switch(field_ptr->type) {case FIELD_TYPE_VAR_STRING : printf("VARCHAR"); break;case FIELD_TYPE_LONG : printf("LONG"); break;default: printf("Unknown %d", field_ptr->type);}}if (field_ptr->flags & AUTO_INCREMENT_FLAG)printf("/t AUTO_INCREMENT/n");elseprintf("/n");}return ;}void display_row(MYSQL *conn_ptr, MYSQL_ROW row_ptr) {int i;for (i = 0; i < mysql_field_count(conn_ptr); i++) {printf("%s/t", row_ptr[i]);}return ;}