MySqlConnestion

C++ Wrapper for MySQL C API

Requirements:

  • C++14 compiler (Windows or Linux)
  • MySQL or MariaDB Connector/C

Web Site

http://hlspx.ocry.com/mysqlconnestion/

Documentation

http://hlspx.ocry.com/mysqlconnestion/documentation/

Sample Code:

include <iostream>
#include "MySqlConnection.h"

using namespace Kiff;

int main()
{
	const char *sql =
		"DROP table if exists person; "
		"create table person (name varchar(256), age int unsigned, weight double) ENGINE=InnoDB  DEFAULT CHARSET=utf8; "
		"insert into person(name,age,weight) values('Mary',25,73.8);";

	MySqlConnection conn("server=localhost;User Id=test;Password=12345;character set=utf8;database=conntest");
	conn.ExecuteNonQuery(sql);

	const char *name = "Bob";
	int age = 33;
	double weigh = 88.4;
	conn.ExecuteNonQuery("insert into person(name,age,weight) values(?,?,?)", name, age, weigh);

	double minage = 30;
	std::string nm;

	MySqlDataReader *rd = conn.ExecuteReader("select name from person where age > ?", minage);
	while (rd->Read())
	{
		rd->GetValues(nm);
		std::cout << nm << std::endl;
	}
	delete rd;
}

Source:  hlspx/MySqlConnection

Author:

Alexey Tretyakov

mailto:hlspx@mail.ru

Leave a Reply

Your email address will not be published. Required fields are marked *