dbonmysql.h

本程序详细 演示了 vc如何连接数据库

// DbOnMySql.h: interface for the DbOnMySql class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_DBONMYSQL_H__D38088DE_C3BC_406A_AA7A_CC88F9AA8E91__INCLUDED_)
#define AFX_DBONMYSQL_H__D38088DE_C3BC_406A_AA7A_CC88F9AA8E91__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

#include <winsock.h>
#include <mysql.h>
#include <list>

/* 定义记录结构 */
class RecStruct
{
public:
	char stuId[5 + 1];
	char stuName[8 + 1];
	char stuSex[2 + 1];
	char birth[21 + 1];
	char brief[200 + 1];

	/* 实始化成员 */
	RecStruct()
	{
		memset(stuId, 0, sizeof(stuId));
		memset(stuName, 0, sizeof(stuName));
		memset(stuSex, 0, sizeof(stuSex));
		memset(birth, 0, sizeof(birth));
		memset(brief, 0, sizeof(brief));
	}
};

class DbOnMySql  
{
public:
	std::list<RecStruct>  GetAllRec();
	void Close();
	BOOL ConnDB(const char *host, const char *user, 
		const char *passwd, const char* dbName);
	DbOnMySql();
	virtual ~DbOnMySql();

private:
	MYSQL m_mysql;
};

#endif // !defined(AFX_DBONMYSQL_H__D38088DE_C3BC_406A_AA7A_CC88F9AA8E91__INCLUDED_)