mycommon.h

连接MYSQL数据库

//Checked : 2001/03/29
#ifndef _MY_COMMON_HEADER_
#define _MY_COMMON_HEADER_

#define INFO_SUCCESS

#include "include\mysql.h"

typedef struct tag_ServerInfo
{
	CString strServer;
	MYSQL   *pMysql;
	CString strHost;
	unsigned int nPort;
	bool    bTrusted; 
	CString strUser;
	CString strPasswd;
} ServerInfo;

typedef struct tag_FieldInfo
{
	CString  strFieldName;
	CString  strFieldType;
	CString  strFieldLength;  //If type is a numeric , 
	                          //it's the length of integer part 
	CString  strFieldPrecision;
	CString  strDefault;
	bool     bNull,bKey,bNum;  
} FieldInfo;

int ShowRecords(MYSQL_RES *pRes,CListCtrl& lstRecords,bool bShowNULL = false);
void GenerateTableSQL(LPSTR pszSQL,LPSTR pszTableName,CPtrList& lstField);

#endif //_MY_COMMON_HEADER_