#include<Windows.h>

#include<string>

#include<iostream>

#include<mysql.h>

#include<stdio.h>

#include<io.h>

int main()

{

    //connectionparams

    char *host = "localhost";

    char *user = "root";

    char *pass = "***";//你的mysql服务器密码

    char *db = "***";  //使用的database数据库

    unsigned int port = ; //server port

    MYSQL *sock;

    MYSQL_RES *res;

    MYSQL_FIELD * fd;

    MYSQL_ROW row;

    char szSqlText[] = "";

    int i;

    int tcreate = ;

    sock = mysql_init();// return An initialized MYSQL* handle or null when there is no enough memory

    if (sock && mysql_real_connect(sock, host, user, pass, db, , NULL, ))

    {

        std::cout << "connect mysql succeed!" << std::endl;

        mysql_set_character_set(sock,"utf8");

    //    mysql_query(sock, "set names gb2312");

        /* character-set-server/default-character-set：服务器字符集，默认情况下所采用的。

           character-set-database：数据库字符集。

           character-set-table：数据库表字符集。

           优先级依次增加。所以一般情况下只需要设置character-set-server，

           而在创建数据库和表时不特别指定字符集，这样统一采用character-set-server字符集。*/

        //mysql_query(sock, "SET NAMES GBK"); //设置编码格式,否则在cmd下无法显示中文

        //connectioncharacter set

        //waitfor possibility to check system/mysql mysqlets

        if (tcreate)

        {

            sprintf_s(szSqlText, , "create table id (ID varchar(10) not null primary key,cenroid float,width int(11)");  //构造SQL语句 新建一张表

            std::cout << "Create table id!" << std::endl;

            getchar();

            tcreate = ;

            if (mysql_query(sock, szSqlText))//执行Dsql语句,并判断是否出错

            {

                std::cout << "can't create table,maybe the data property is wrong :  " << mysql_error(sock) << std::endl;

                // tcreate = 0;

                mysql_close(sock);

                return FALSE;

            }

        }

            sprintf_s(szSqlText, ,//向mytable这个表插入数据 注意格式

                "insert into id1 values('sL','69','60')");

            std::cout << "Insert data to table!" << std::endl;

            getchar();

            if (mysql_query(sock, szSqlText))

            {

                std::cout << "Can't insert data to table" << mysql_error(sock) << std::endl;

                getchar();

                mysql_close(sock);

                return FALSE;

            }

            sprintf_s(szSqlText, , "select* from id1");

            std::cout << "select* from id1!" << std::endl;

            getchar();

            if (mysql_query(sock, szSqlText))//进行数据检索并检查有无错误

            {

                mysql_close(sock);

                return FALSE;

            }

            else

            {

                std::cout << "mysql_store_result!" << std::endl;

                res = mysql_store_result(sock);//取得查询结果,保存查询到的数据到res

                i = (int)mysql_num_rows(res);//取得有效记录数

                std::cout << "Query: " << szSqlText << "\n" << i << " records found:" << std::endl;

                for (i = ; fd = mysql_fetch_field(res); i++)//获取列名

                    std::cout << fd->name << "\t";

                std::cout << std::endl;//输出各字段名

                while (row = mysql_fetch_row(res))//获取具体的数据,依次读取各条记录

                    std::cout << row[] << "\t" << row[] << "\t" << row[] << "\t" << std::endl;

                mysql_free_result(res); //释放结果资源

                getchar();

            }

        }

        else//连接数据库出错

        {

            std::cout << "cannot connect to the sock sever " << mysql_error(sock) << std::endl;

            getchar();

            mysql_close(sock);

            return FALSE;

        }

        mysql_close(sock);//断开连接

        //    system("pause");

        return TRUE;

    }