C/C++中使用Mysql的API连接数据库

/************************************************************************/
/* MYSQL_API使用准备工作：
1.引入mysql文件中的include头文件位置
2.引入mysql->lib->opt中的lib文件位置
3.把mysql->lib->opt->libmysql.dll文件复制到工程debug目录下
/************************************************************************/
#include "iostream"
#include "stdio.h"
#include <windows.h>
#include <stdio.h>
#include <string.h>
#include <mysql.h>
#include "String"

//define定义SQL_SELECT or SQL_WRITE

using namespace std;

#pragma comment(lib, "libmysql.lib")


void main()
{
    MYSQL mysql;
    mysql_init(&mysql);

    char *url = "localhost";
    char *username = "root";
    char *password = "root";
    char *dbname = "yyy";
    if (!mysql_real_connect(&mysql,url,username,password,dbname,0,NULL,0))
    {
        printf(  "Error  connecting  to  database:  %s/n",mysql_error(&mysql));
    }
    else
    {
        printf("Connected.../n"); 
    }
#ifdef SQL_SELECT
    char *sql = "select * from cash";

    if (mysql_query(&mysql,sql) != 0)    //mysql_query返回0表示查询成功
    {
        printf("Error  making  query:  %s/n", mysql_error(&mysql)); 
        return;
    }
    else
    {
        printf("[%s]  made.../n",sql);
    }

    MYSQL_RES *rs = mysql_store_result(&mysql);
    if (rs == NULL)
    {
        cout << "select ERROR" << "/n";
        return;
    }
    else
    {
        cout << "ResultSet create successful" << "/n";
    }

    MYSQL_ROW row;
    while (row = mysql_fetch_row(rs))
    {
        for (int i = 0; i<=mysql_num_fields(rs)-1; ++i)
        {
            cout << row[i] << "/t";
        }
        cout <<"/n";
    }
    mysql_free_result(rs);
#endif

#ifdef SQL_WRITE
    string uname = "zz";
    string sql = "delete from cash where username= '" + uname + "' ";
    cout << sql << endl;
    if (mysql_query(&mysql,sql.c_str()) != 0)
    {
        cout << "write oper is fault" << "/n";
        return;
    }
    else
    {
        cout << "operator success" << "/n";
    }
#endif
    mysql_close(&mysql);

}