IoT C++ 10/18 - MySQL Test

#include<iostream>
#include<iomanip>
#include<string>
#include<my_global.h>
#include<winsock2.h>
#include<mysql.h>
#include<conio.h>
#define snprintf _snprintf
using namespace std;
#pragma comment(lib, "libmysql.lib")

#define DB_HOST "[Server URL or IP Address]"
#define DB_USER "[DB UserName]"
#define DB_PASS "[Password]"
#define DB_NAME "[DB Name]"
#define DB_TABLE "select * from [Tabel name]"

int main(void)
{
    MYSQL *connection = NULL, conn;
    MYSQL_RES   *sql_result;
    MYSQL_ROW   sql_row;
    int query_stat;
    int select;

    mysql_init(&conn);
    connection = mysql_real_connect(&conn, DB_HOST, DB_USER, DB_PASS, DB_NAME, 3306, (char *)NULL, 0);
    mysql_set_character_set(&conn, "euckr");

    cout << "MySQL Server Version : " << mysql_get_server_info(&conn) << endl;
    cout << "MySQL Client Version : " << mysql_get_client_info() << endl << endl;

    if (connection == NULL)
    {
        cout << stderr << "MySQL Connection Error : " << mysql_error(&conn)<<endl;
        return 1;
    }

    while (1)
    {
        query_stat = mysql_query(connection, DB_TABLE);
        if (query_stat != 0)
        {
            cout << stderr << "MySQL Connection Error : " << mysql_error(&conn)<<endl;
            return 1;
        }
        sql_result = mysql_store_result(connection);

        cout << "==============MySQL 입출력 테스트 프로그램==============" << endl;
        cout << "MENU>1)리스트출력 | 2)리스트추가 | 3)리스트삭제 | 4)종료" << endl;

        cout << "INPUT>";  cin >> select;
        if (select == 4) break;
        if (cin.fail())
        {
            cout << "ERROR>잘못된 선택" << endl << endl;
            //cout<<"Error>PLZ ENTER NUM! NOT CHAR!"<<endl;
            cin.clear(); cin.ignore(256, '\n');
        }
        switch (select)
        {
        case 1:
            cout << "이름/주소/전화번호" << endl;
            while ((sql_row = mysql_fetch_row(sql_result)) != NULL)
            {
                cout << sql_row[0] << "|" << sql_row[1] << "|" << sql_row[2] << endl;
            }
            mysql_free_result(sql_result); break;
        case 2: {
            string name;
            string address;
            string tel;
            char query[255];
            cin.ignore();
            cout << "이름:";  getline(cin, name);
            cout << "주소:";  getline(cin, address);
            cout << "전화:";  getline(cin, tel);

            sprintf_s(query, "insert into test33 values " "('%s', '%s', '%s')", name.c_str(), address.c_str(), tel.c_str());
            query_stat = mysql_query(connection, query);
            if (query_stat != 0) {
                cout << stderr << "MySQL Connection Error : " << mysql_error(&conn) << endl;
                return 1;
            }break;
            //sql_result = mysql_store_result(connection); break;
        }
        case 3: cout << "ERROR>미구현" << endl; break;
        default: cout << "ERROR>잘못된 선택" << endl; break;
        }
        cout << endl;
    }
    cout << "프로그램 종료" << endl;
    mysql_close(connection);

    cout << "계속하실려면 아무키나 누르세요." << endl;
    _getch();
}