mysql操作代码

int _tmain(int argc, _TCHAR* argv[])
{
    MYSQL MyData;

    if (0 != mysql_library_init(0, NULL, NULL))
    {
        cout << "mysql_library_init 失败！" << endl;
        cout << mysql_error(&MyData) << endl;
        return -1;
    }

    if (NULL == mysql_init(&MyData))
    {
        cout << "mysql_ini 失败！" << endl;
        cout << mysql_error(&MyData) << endl;
        return -1;
    }

    if (0 != mysql_options(&MyData, MYSQL_SET_CHARSET_DIR, "gbk"))
    {
        cout << "设置gbk字符集失败！" << endl;
        cout << mysql_error(&MyData) << endl;
        return -1;
    }

    if (NULL == mysql_real_connect(&MyData, "localhost", "root", "123", "test", 6666, NULL, 0))
    {
        cout << "连接数据库失败！" << endl;
        cout << mysql_error(&MyData) << endl;
    }

    string SqlStr = "create table bblovedd";
    SqlStr += "(";
    SqlStr += "name varchar(30),";
    SqlStr += "id int not null primary key";
    SqlStr += ")";

    if (0 != mysql_query(&MyData, SqlStr.c_str()))
    {
        cout << "创建表失败！" << endl;
        cout << mysql_error(&MyData) << endl;
        return -1;
    }
   
    SqlStr = "insert into bblovedd values ('wangjb', 20090703)";
    if (0 != mysql_query(&MyData, SqlStr.c_str()))
    {
        cout << "插入数据失败！" << endl;
        cout << mysql_error(&MyData) << endl;
        return -1;
    }

    SqlStr = "select * from bblovedd";
    MYSQL_RES *result = NULL;
    if (0 != mysql_query(&MyData, SqlStr.c_str()))
    {
        cout << "查询数据失败！" << endl;
        cout << mysql_error(&MyData) << endl;
        return -1;
    }

    result = mysql_store_result(&MyData);
    my_ulonglong RowCount = mysql_num_rows(result);
    cout << "Row count:" << RowCount << endl;

    unsigned int FieldCount = mysql_num_fields(result);
    MYSQL_FIELD *field = NULL;

    for (unsigned int i = 0; i < FieldCount; i++)
    {

        field = mysql_fetch_field_direct(result, i);
        cout << field->name << '/t';
    }
    cout << endl;

    MYSQL_ROW row = NULL;
    row = mysql_fetch_row(result);
    while (row)
    {
        for (unsigned int i = 0; i < FieldCount; i++)
            cout << row[i] << '/t';
        cout << endl;
        row = mysql_fetch_row(result);
    }
   
    SqlStr = "drop table bblovedd";
    if (0 != mysql_query(&MyData, SqlStr.c_str()))
    {
        cout << "删除表格失败！" << endl;
        cout << mysql_error(&MyData) << endl;
        return -1;
    }

    mysql_free_result(result);
    mysql_close(&MyData);
    mysql_server_end();

    return 0;
}