#include <zdbcpp.h>
using namespace zdbcpp;

 ConnectionPool pool("mysql://192.168.11.100:3306/test?user=root&password=dba");
 pool.start();
 Connection con = pool.getConnection();
 //we can set default prefetch to Connection
 //con.setDefaultRowPrefetch(100);
 
 //here, use c++ 11 variadic templates feature to bind parameter 
 ResultSet rset = con.executeQuery("select id, name, percent, image from zild_t where id < ? order by id;", 100);
 //row prefetch
 rset.setFetchSize(100);
 
 while (rset.next()) {
		int id = rset.getIntByName("id");
		const char *name = rset.getString(2);
		double percent = rset.getDoubleByName("percent");
		const char *blob = (char*)rset.getBlob(4, &imagesize);
		printf("\t%-5d%-16s%-10.2f%-16.38s\n", id, name ? name : "null", percent, imagesize ? blob : "");
 }

    char *data[]= {"Fry", "Leela", "Bender", "Farnsworth",
            "Zoidberg", "Amy", "Hermes", "Nibbler", "Cubert",
            "Zapp", "Joey Mousepad", "§Á¦²?", 0}; 
    
    ConnectionPool pool("mysql://192.168.11.100:3306/test?user=root&password=dba");
    pool.start();
    Connection con = pool.getConnection();
    con.beginTransaction();
    /* Insert values into database and assume that auto increment of id works */
    long long affected_rows = 0;
    for (int i = 0; data[i]; i++)
		con.execute("insert into zild_t (name, percent) values(?, ?);", data[i], i + 1 );   
		
    con.commit();

    char *images[]= {"Ceci n'est pas une pipe", "Mona Lisa",
            "Bryllup i Hardanger", "The Scream",
            "Vampyre", "Balcony", "Cycle", "Day & Night", 
            "Hand with Reflecting Sphere",
            "Drawing Hands", "Ascending and Descending", 0}; 
            
    ConnectionPool pool("mysql://192.168.11.100:3306/test?user=root&password=dba");
    pool.start();
    Connection con = pool.getConnection();
    
    PreparedStatement pre = con.prepareStatement("update zild_t set image=? where id=?;");
    for (int i = 0; images[i]; i++) {
        pre.setBlob(1, images[i], (int)strlen(images[i]) + 1);
        pre.setInt(2, i + 1);
        pre.execute();
    }

    try
    {
        con = pool.getConnection();
        con.executeQuery("blablabala;");
    }
    catch (sql_exception& e)
    {
        printf(e.what());
    }