//プロジェクト名mysql001 C++ソースファイルmysql001.cpp libmysql.lib
#include <stdio.h>
#include <windows.h>
#include <mysql.h>
#pragma comment(lib, "libmysql.lib")
extern "C" {
__declspec(dllexport) long sqlopen(char * string01,char * string02,char * string03,char * string04);
__declspec(dllexport) int sqlquery(long hsql,char * string01);
__declspec(dllexport) long sqlresopen(long hsql);
__declspec(dllexport) char * sqlresult(long result,char * delimiter,char * buf01);
__declspec(dllexport) void sqlresclose(long result);
__declspec(dllexport) void sqlclose(long hsql);
long sqlopen(char * string01,char * string02,char * string03,char * string04)
{
	MYSQL		* hsql;
	hsql=mysql_init(NULL);
	hsql=mysql_real_connect(hsql,string01,string02,string03,string04,0,NULL,0);
	return (long)hsql;
}
int sqlquery(long hsql,char * string01)
{
	int c;
	c=mysql_query((MYSQL *)hsql,string01);
	return c;
}
long sqlresopen(long hsql)
{
	MYSQL_RES * result;
	result = mysql_store_result((MYSQL *)hsql);
	return (long)result;
}
char * sqlresult(long result,char * delimiter,char * buf01)
{
	unsigned int lenmax=(strlen(buf01)-2);
	* buf01='\0';
	MYSQL_ROW	resrow;
	int	j,rescolmax;
	rescolmax=(int)mysql_num_fields((MYSQL_RES *)result);
	resrow=mysql_fetch_row((MYSQL_RES *)result);
	if(resrow==NULL) return buf01;
	for(j=0;j<rescolmax;j++){
		if(j!=0)
		{
			if((strlen(buf01)+strlen(delimiter))<lenmax)
			{
				strcat(buf01,delimiter);
			}
			else
			{
				* buf01='\0';
				return buf01;
			}
		}
		if(resrow[j]!=NULL)
		{
			if((strlen(buf01)+strlen(resrow[j]))<lenmax)
			{
				strcat(buf01,resrow[j]);
			}
			else
			{
				* buf01='\0';
				return buf01;
			}
		}
		else
		{
			if((strlen(buf01)+4)<lenmax)
			{
				strcat(buf01,"NULL");
			}
			else
			{
				* buf01='\0';
				return buf01;
			}
		}
	}
	return buf01;
}
void sqlresclose(long result)
{
	mysql_free_result((MYSQL_RES *)result);
	return;
}
void sqlclose(long hsql)
{
	mysql_close((MYSQL *)hsql);
	return;
}
}