#include <windows.h>
#include <iostream>
#include <sqlplus.hh> //the mysql++ library files
#include "gwin.h" //the gwin library files

int main (int argc, char *argv[]) {

		Gwin.showConsole(); //gwin
	Gwin.text(10,10,"Hello World"); //gwin
 
	Keyboard.getch(); // this is the end of gwin, everything after is mysql++ stuff

  Connection connection(use_exceptions);
  try { 

    if (argc == 1) connection.connect("");
    else if (argc == 2) connection.connect("",argv[1]);
    else if (argc == 3) connection.connect("",argv[1],argv[2]);
    else if (argc <= 4) connection.connect("",argv[1],argv[2],argv[3]);

    
    try {
      connection.select_db("AdesTestDatabase");
    } catch (BadQuery er) {

      connection.create_db("AdesTestDatabase");
      connection.select_db("AdesTestDatabase");
    }
    
    Query query = connection.query();
    
    try { 
      query.execute("drop table stuff");
    } catch (BadQuery er) {}
    
    query << "create table stuff  (item char(20) not null)";
    query.execute(RESET_QUERY);
    
    query << "insert into %5:table values (%0q)";;
    query.parse();
    
    query.def["table"] = "Stuff";
    
    query.execute ("Amanda", 56);

  } catch (BadQuery er) {
    cerr << "Error: " << er.error << endl;
    return -1;
  }
}

#include <iostream>
#include "mysql++.h"
#include "gwin.h"

using std::cout;
using std::cerr;
using std::endl;
using namespace mysqlpp;

#define def_db_name	"mysql_cpp_data"
#define def_host_name	"localhost"
#define def_user_name	"admin"
#define def_password	""
#define def_svr_port	"3066"

int main()
{
	// gwin
	Gwin.showConsole();
	Gwin.text(10,10,"Hello World");
	Keyboard.getch();

	// mysql++
    Connection conn (def_db_name, def_host_name, def_user_name, def_password);
    Query q = conn.query();

	try
	{
		conn.create_db(def_db_name);
		conn.select_db(def_db_name);
	}
	catch(BadQuery er)
	{
		cerr << er.what() << endl;
	}

    q << "DROP TABLE IF EXISTS testtable";
    q.execute();

    q << "CREATE TABLE testtable (ID VARCHAR(7) NOT NULL PRIMARY KEY, "
      << "nick_name VARCHAR(20), "
      << "f_name VARCHAR(20))";
    q.execute();

    q << "INSERT INTO testtable (ID, f_name) VALUES ('1', 'Ruben')";
    q.execute();

    q << "INSERT INTO testtable VALUES ('2', 'DaWei', 'David')";
	q.execute();

    q << "show tables" << endl;
    cout << "Query : " << q.preview() << endl;

    Result res = q.store();
    if (!res.empty())
    {
		Row row = res[0];
        cout << "Table is : " << res[0] << endl;
    }
    conn.close();
    return 0;
}