#ifndef __MYSQL_CENTER_H__
#define __MYSQL_CENTER_H__

#include <windows.h>
#include "stdio.h"
#include "winsock.h"
#include "mysql.h"

#include "./common/json/cJSON.h"

#include <stdio.h>
#include <iostream>

class MySqlCenter
{
public:

	static MySqlCenter* GetInstance();

	int loadCof(char *filename);

	/*TCP IP端口*/
	/*Unix Socket 连接类型*/
	/*运行成ODBC数据库标志*/
	int connect(
		const char *unix_socket=NULL,
		unsigned long clientflag=0);

	/***tmp
	是sql语句
	如sprintf(tmp,"select * from %s",tablename);
	**/
	int insert(char *tmp);

	/***tmp 是sql语句**/
	int select(char *tmp);

	MYSQL_RES* getOperateResult();

	char  _dbuser[128];
	char  _dbpasswd[128];
	char  _dbip[128];
	char  _dbname[128];
	char  _tablename[128];

	int _port;

private:
	MySqlCenter(void);
	~MySqlCenter(void);

	static MySqlCenter *_instance;

	MYSQL * _con;

	char *_query;

	void decodeJsonStr(char *text);
};

#endif