huhorler的博客

网上下的lua包都没有lib 和exe，所以自己生成了exe和lib

#include "stdafx.h" #include<stdlib.h> #include <stdio.h> #include <winsock.h> #include <mysql.h> #include <windows.h> #include <iostream> #pragma comment(lib, "libmysql.lib") int main(int argc, char* argv[]) { unsigned short Port = 3306; char *IPAddress = "localhost"; char *UserName = "root"; char *Password = "sa"; char *DBName = "test"; int i; printf("Start... "); MYSQL *con1 ; MYSQL_RES *res; MYSQL_FIELD *fild; MYSQL_ROW row; unsigned int num_fields; con1 = mysql_init((MYSQL*) 0); con1 = mysql_real_connect(con1,IPAddress,UserName,Password, NULL, Port, NULL, 0); if(!con1) { printf("no con"); } else { printf("con..."); } con1->reconnect = 1; mysql_select_db(con1, DBName) ; //mysql_query(con1, "useUnicode=true&characterEncoding=utf-8"); mysql_query(con1,"set names gbk"); if (!mysql_query(con1, "SELECT * FROM user")) { res = mysql_store_result(con1); num_fields = mysql_num_fields(res); int rows = mysql_num_rows(res); printf("查询到%lu行\n",rows); while(fild = mysql_fetch_field(res)) { printf("%s\t",fild->name); } printf("\n"); for (int k =0;k<rows;k++) { row = mysql_fetch_row(res); for (int l=0;l<num_fields;l++) { if (l==0) { printf("d\t",atoi(row[l])); continue; } printf("%s\t",row[l]); } printf("\n"); } /*while ((row = mysql_fetch_row(res))) { unsigned long *lengths; lengths = mysql_fetch_lengths(res); for(i = 0; i < num_fields; i++) { printf("%d,%s ", (int) lengths[i], row[i] ? row[i] : "NULL"); } printf("\n"); }*/ } else { printf("Couldn't execute \"SELECT * FROM user\" on server.\n"); } mysql_free_result(res); mysql_close(con1); std::cin.get(); }

#include "stdafx.h" #include #include #include #include #include #include #pragma comment(lib, "libmysql.lib") int main(int argc, char* argv[]) { unsigned short Port = 3306; char *IPAddress = "localhost"; char *UserName = "root"; char *Password = "sa"; char *DBName = "test"; int i; printf("Start... "); MYSQL *con1 ; MYSQL_RES *res; MYSQL_FIELD *fild; MYSQL_ROW row; unsigned int num_fields; con1 = mysql_init((MYSQL*) 0); con1 = mysql_real_connect(con1,IPAddress,UserName,Password, NULL, Port, NULL, 0); if(!con1) { printf("no con"); } else { printf("con..."); } con1->reconnect = 1; mysql_select_db(con1, DBName) ; //mysql_query(con1, "useUnicode=true&characterEncoding=utf-8"); mysql_query(con1,"set names gbk"); if (!mysql_query(con1, "SELECT * FROM user")) { res = mysql_store_result(con1); num_fields = mysql_num_fields(res); int rows = mysql_num_rows(res); printf("查询到%lu行\n",rows); while(fild = mysql_fetch_field(res)) { printf("%s\t",fild->name); } printf("\n"); for (int k =0;k<rows;k++) { row = mysql_fetch_row(res); for (int l=0;l<num_fields;l++) { if (l==0) { printf("d\t",atoi(row[l])); continue; } printf("%s\t",row[l]); } printf("\n"); } /*while ((row = mysql_fetch_row(res))) { unsigned long *lengths; lengths = mysql_fetch_lengths(res); for(i = 0; i < num_fields; i++) { printf("%d,%s ", (int) lengths[i], row[i] ? row[i] : "NULL"); } printf("\n"); }*/ } else { printf("Couldn't execute \"SELECT * FROM user\" on server.\n"); } mysql_free_result(res); mysql_close(con1); std::cin.get(); }