• 全部
  • 问答

急!急!windows平台下怎样用Turbo c2.0连接mysql数据库??

caihuafeng 2003-12-17 01:18:11
急!急!windows平台下怎样用Turbo c2.0连接mysql数据库??
mysql数据库已经安装好了!
而且mysql.h,my_global.h头文件也已经包含了?
...全文
66 点赞 收藏 8
写回复
8 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
mjohhh 2003-12-18
老掉牙了,换一个 工具把
回复
挺拔的劲松 2003-12-17
Turbo c2.0连接mysql数据库??应该不行吧 ̄ ̄ ̄
关注 ̄ ̄ ̄ ̄ ̄ ̄没见过。
回复
tolixiaohui 2003-12-17
go mysql.com
find include files!~
回复
Thanks4Help 2003-12-17
gz
回复
caihuafeng 2003-12-17
在windows下window.h文件根本没有,lib库中libmySQL.a文件也没有
回复
watano 2003-12-17
你可以用dev-cpp嘛,很好用的。
回复
watano 2003-12-17
贴段代码给你(可不是我写的o)
/*
Name: MySQLClientTest
Author: Kip Warner (kip@zero47.com)
Date: 24/11/03 13:15
Description: Example to show usage of MySQL databases from client end.
I did not have much time. Sorry...
*/

// Includes...
#include <windows.h>
#include <MySQL\mysql.h>
#include <stdlib.h>
#include <stdio.h>
#include <conio.h>

// Database name...
char g_szHost[] = "localhost";
UINT g_unPort = MYSQL_PORT;
char g_szUserName[] = "charlieface";
char g_szPassword[] = "pudgy";
char g_szDatabase[] = "Candy";
char g_szSQLStatement[] = "SELECT * chocolates";

// Entry point...
int main(int nArguments, char *pszArguments[])
{
// Variables...
MYSQL *myDatabase = NULL;
MYSQL_RES *myResult = NULL;
MYSQL_FIELD *myField = NULL;
MYSQL_ROW myRow = NULL;
UINT unRecords = 0;
UINT unFields = 0;
UINT unIndex = 0;
UINT unFieldIndex = 0;

// Initialize MySQL...
myDatabase = mysql_init(NULL);

// Failed...
if(!myDatabase)
{
// Alert user...
printf("] Error: Unable to initialize MySQL API...\n");

// Cleanup, abort, terminate...
mysql_close(myDatabase);
getch();
return 0;
}

// Connect to server and check for error...
if(mysql_real_connect(myDatabase, g_szHost, g_szUserName, g_szPassword,
NULL, g_unPort, NULL, 0) != 0)
{
// Alert user...
printf("] Error: Unable to connect to server...\n");

// Cleanup, abort, terminate...
mysql_close(myDatabase);
getch();
return 0;
}

// Select database in server and check for error...
if(mysql_select_db(myDatabase, g_szDatabase) < 0)
{
// Alert user...
printf("] Error: Unable to select database...\n");

// Cleanup, abort, terminate...
mysql_close(myDatabase);
getch();
return 0;
}

// Query database and check for error...
if(mysql_query(myDatabase, g_szSQLStatement) != 0)
{
// Alert user...
printf("] Error: Unable to execute query...\n");

// Cleanup, abort, terminate...
mysql_close(myDatabase);
getch();
return 0;
}

// Retrieve query result from server...
myResult = mysql_store_result(myDatabase);

// Failed...
if(!myResult)
{
// Alert user...
printf("] Error: Unable to retrieve result...\n");

// Cleanup, abort, terminate...
mysql_close(myDatabase);
getch();
return 0;
}

// How many records were returned in the result set?

// Calculate...
unRecords = mysql_num_rows(myResult);

// Alert user...
printf("] Query: %d records found...\n", unRecords);

// How many fields are present in a record?

// Calculate...
unFields = mysql_num_fields(myResult);

// Alert user...
printf("] Query: There are %d fields in each record...", unFields);

// Output records...
for(unIndex = 0; unIndex < unRecords; unIndex++)
{
// Fetch row from results...
myRow = mysql_fetch_row(myResult);

// Fetch fields from row...
myField = mysql_fetch_fields(myResult);

// Show record...
printf("] Record: %d / %d\n", unIndex, unRecords);

// Output all fields in this row...
for(unFieldIndex = 0; unFieldIndex < unFields; unFieldIndex++)
{
// Output...
printf("\t%s", myField[unFieldIndex].name);
}
}

// Free result...
mysql_free_result(myResult);

// Close server connection...
mysql_close(myDatabase);
myDatabase = NULL;

// Alert user, exit...
printf("] Done, press any key to exit...\n");
getch();
return 0;
}

回复
watano 2003-12-17
你的LIB中有libmySQL.a、libmySQL.def、libmySQL.dll了吗?
回复
相关推荐
发帖
C语言
创建于2007-09-28

6.3w+

社区成员

C语言相关问题讨论
申请成为版主
帖子事件
创建了帖子
2003-12-17 01:18
社区公告
暂无公告