c++怎么读取mysql多行数据

lunqp 2017-05-23 07:54:55

如果我要查找mysql里面的多行数据该怎么处理呢？我现在只知道读取出一条数据怎么做，读多行数据怎么做呢？谢谢啊

...全文

306 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

赵4老师 2017-05-24

打赏
举报

1楼代码使用astyle整理格式后：

#include <windows.h>
#include "stdio.h"
#include "winsock.h"
#include "mysql.h"
//#pragma comment (lib, "libmysql.lib")
//#pragma comment (lib, "mysqlclient.lib")
int main() {
    MYSQL * con; //= mysql_init((MYSQL*) 0);
    MYSQL_RES *res;
    MYSQL_ROW row;
    char tmp[400];
    //database configuartion
    char dbuser[30] = "root";
    char dbpasswd[30] = "root";
    char dbip[30] = "127.0.0.1";
    char dbname[50] = "udp_db";
    char tablename[50] = "tbl_user1";
    char *query = NULL;
    int x;
    int y;
    int rt;//return value
    unsigned int t;
    int count = 0;
    printf("input x,y\n");
    scanf_s("%d %d", &x, &y);
    fflush(stdin);
    printf("input over\n");
    con = mysql_init((MYSQL*)0);
    if (con != NULL && mysql_real_connect(con, dbip, dbuser, dbpasswd, dbname, 3306/*TCP IP端口*/, NULL/*Unix Socket 连接类型*/, 0/*运行成ODBC数据库标志*/)) {
        if (!mysql_select_db(con, dbname)) {
            printf("Select successfully the database!\n");
            con->reconnect = 1;
            query = "set names \'GBK\'";
            //mysql_query(con,"set names \'GBK\'");
            rt = mysql_real_query(con, query, strlen(query));
            if (rt) {
                printf("Error making query: %s !!!\n", mysql_error(con));
            } else {
                printf("query %s succeed!\n", query);
            }
        }
    } else {
        MessageBoxA(NULL, "Unable to connect the database,check your configuration!", "", NULL);
    }
    //sprintf(tmp,"update %s set 商品=\'%s\',卖出=%d,成交=%d,涨跌=%d,买进=%d,总量=%d,涨幅=%f,时间=\'%s\' where  %s",tablename,goods,sold,deal,fluctuate,buy,total,delta,time,UpdateCon);
    sprintf_s(tmp, "insert into %s values(%s,%d,%d)", tablename, "null", x, y); //注意如何向具有自增字段的数据库中插入记录
    //MessageBoxA(NULL,tmp,tmp,MB_OK);
    //mysql_query(con,tmp);
    rt = mysql_real_query(con, tmp, strlen(tmp));
    if (rt) {
        printf("Error making query: %s !!!\n", mysql_error(con));
    } else {
        printf("%s executed!!!\n", tmp);
    }
    sprintf_s(tmp, "select * from %s", tablename);
    rt = mysql_real_query(con, tmp, strlen(tmp));
    if (rt) {
        printf("Error making query: %s !!!\n", mysql_error(con));
    } else {
        printf("%s executed!!!\n", tmp);
    }
    res = mysql_store_result(con);//将结果保存在res结构体中
    while (row = mysql_fetch_row(res)) {
        /**
        * MYSQL_ROW STDCALL mysql_fetch_row(MYSQL_RES *result);
        * 检索行
        */
        for (t = 0; t<mysql_num_fields(res); t++) {
            printf("%s  ", row[t]);
        }
        printf(".............\n");
        count++;
    }
    printf("number of rows %d\n", count);
    printf("mysql_free_result...\n");
    mysql_free_result(res);
    mysql_close(con);
    return 0;
}

astyle自动整理c,c++,java源代码格式命令行工具源代码。用astyle --help查看使用帮助。 http://download.csdn.net/detail/zhao4zhong1/5605415

妥妥CC 2017-05-23

打赏
举报

这儿有个例子 #include <windows.h> #include "stdio.h" #include "winsock.h" #include "mysql.h" //#pragma comment (lib, "libmysql.lib") //#pragma comment (lib, "mysqlclient.lib") int main() { MYSQL * con; //= mysql_init((MYSQL*) 0); MYSQL_RES *res; MYSQL_ROW row; char tmp[400]; //database configuartion char dbuser[30] = "root"; char dbpasswd[30] = "root"; char dbip[30] = "127.0.0.1"; char dbname[50] = "udp_db"; char tablename[50] = "tbl_user1"; char *query = NULL; int x; int y; int rt;//return value unsigned int t; int count = 0; printf("input x,y\n"); scanf_s("%d %d", &x, &y); fflush(stdin); printf("input over\n"); con = mysql_init((MYSQL*)0); if (con != NULL && mysql_real_connect(con, dbip, dbuser, dbpasswd, dbname, 3306/*TCP IP端口*/, NULL/*Unix Socket 连接类型*/, 0/*运行成ODBC数据库标志*/)) { if (!mysql_select_db(con, dbname)) { printf("Select successfully the database!\n"); con->reconnect = 1; query = "set names \'GBK\'"; //mysql_query(con,"set names \'GBK\'"); rt = mysql_real_query(con, query, strlen(query)); if (rt) { printf("Error making query: %s !!!\n", mysql_error(con)); } else { printf("query %s succeed!\n", query); } } } else { MessageBoxA(NULL, "Unable to connect the database,check your configuration!", "", NULL); } //sprintf(tmp,"update %s set 商品=\'%s\',卖出=%d,成交=%d,涨跌=%d,买进=%d,总量=%d,涨幅=%f,时间=\'%s\' where %s",tablename,goods,sold,deal,fluctuate,buy,total,delta,time,UpdateCon); sprintf_s(tmp, "insert into %s values(%s,%d,%d)", tablename, "null", x, y); //注意如何向具有自增字段的数据库中插入记录 //MessageBoxA(NULL,tmp,tmp,MB_OK); //mysql_query(con,tmp); rt = mysql_real_query(con, tmp, strlen(tmp)); if (rt) { printf("Error making query: %s !!!\n", mysql_error(con)); } else { printf("%s executed!!!\n", tmp); } sprintf_s(tmp, "select * from %s", tablename); rt = mysql_real_query(con, tmp, strlen(tmp)); if (rt) { printf("Error making query: %s !!!\n", mysql_error(con)); } else { printf("%s executed!!!\n", tmp); } res = mysql_store_result(con);//将结果保存在res结构体中 while (row = mysql_fetch_row(res)) { /** * MYSQL_ROW STDCALL mysql_fetch_row(MYSQL_RES *result); * 检索行 */ for (t = 0; t<mysql_num_fields(res); t++) { printf("%s ", row[t]); } printf(".............\n"); count++; } printf("number of rows %d\n", count); printf("mysql_free_result...\n"); mysql_free_result(res); mysql_close(con); return 0; }