sql.hpp

#pragma once

#include <iostream>
#include <samchon/library/TSQLi.hpp>

using namespace std;
using namespace samchon::library;

namespace samchon
{
namespace examples
{
namespace sql
{
    void main()
    {
        using namespace std;
        using namespace samchon::library;

        shared_ptr<SQLi> sqli(new TSQLi());

        try
        {
            sqli->connect("211.239.161.211", "REDPRINTING_TEST", "redprinting_test", "redprinting");

            auto stmt = sqli->createStatement();
            size_t uid = 5;
            wstring name = L"°í±æµ¿";
            wstring department = L"È«º¸ºÎ;

            stmt->prepare(L"INSERT INTO ÇѱÛÅ×À̺í (¹øÈ£, À̸§, ºÎ¼­) VALUES (?, ?, ?)", uid, name, department);
            stmt->execute();

            stmt->executeDirectly(u8"SELECT * FROM ÇѱÛÅ×À̺í");

            while (stmt->fetch())
            {
                int uid = stmt->at<int>(0);
                const string &name = stmt->at<string>(1);
                const string &department = stmt->at<string>(2);

                cout << uid << endl;
                cout << name << endl;
                cout << department << endl;
            }
        }
        catch (exception &e)
        {
            cout << e.what() << endl;
        }
    };
}
}
}";

            stmt->prepare(L"INSERT INTO ÇѱÛÅ×À̺í (¹øÈ£, À̸§, ºÎ¼­) VALUES (?, ?, ?)", uid, name, department);
            stmt->execute();

            stmt->executeDirectly(u8"SELECT * FROM ÇѱÛÅ×À̺í);

            while (stmt->fetch())
            {
                int uid = stmt->at<int>(0);
                const string &name = stmt->at<string>(1);
                const string &department = stmt->at<string>(2);

                cout << uid << endl;
                cout << name << endl;
                cout << department << endl;
            }
        }
        catch (exception &e)
        {
            cout << e.what() << endl;
        }
    };
}
}
}");

            while (stmt->fetch())
            {
                int uid = stmt->at<int>(0);
                const string &name = stmt->at<string>(1);
                const string &department = stmt->at<string>(2);

                cout << uid << endl;
                cout << name << endl;
                cout << department << endl;
            }
        }
        catch (exception &e)
        {
            cout << e.what() << endl;
        }
    };
}
}
}