C/c++语言里面怎么样在局域网中连接数据库呀,我只知道本地连接,但是如果要连接别人电脑上的数据库的话要怎么表达呢?用mysql的数据库的?高手教教我啊#include "/usr/include/mysql/mysql.h"
#include <stdio.h>void main(){
MYSQL *mysql;
MYSQL_RES *res;
MYSQL_ROW row;
char *query;
int t,r; mysql_init(mysql);
if (!mysql_real_connect(mysql,"localhost","root",
NULL,"mytest",3306,NULL,0))
{
printf( "Error connecting to database: %s\n",mysql_error(mysql));
}
else printf("Connected...\n"); query="select * from no_use"; t=mysql_real_query(mysql,query,(unsigned int) strlen(query));
if (t)
{
printf("Error making query: %s\n",
mysql_error(mysql));
}
else printf("Query made...\n");
res=mysql_use_result(mysql);
for(r=0;r<=mysql_field_count(mysql);r++){
row=mysql_fetch_row(res);
if(row<0) break;
for(t=0;t<mysql_num_fields(res);t++){
printf("%s ",row[t]);
}
printf("\n");
}
mysql_close(mysql);
}
代码要怎么改呢?
#include <stdio.h>void main(){
MYSQL *mysql;
MYSQL_RES *res;
MYSQL_ROW row;
char *query;
int t,r; mysql_init(mysql);
if (!mysql_real_connect(mysql,"localhost","root",
NULL,"mytest",3306,NULL,0))
{
printf( "Error connecting to database: %s\n",mysql_error(mysql));
}
else printf("Connected...\n"); query="select * from no_use"; t=mysql_real_query(mysql,query,(unsigned int) strlen(query));
if (t)
{
printf("Error making query: %s\n",
mysql_error(mysql));
}
else printf("Query made...\n");
res=mysql_use_result(mysql);
for(r=0;r<=mysql_field_count(mysql);r++){
row=mysql_fetch_row(res);
if(row<0) break;
for(t=0;t<mysql_num_fields(res);t++){
printf("%s ",row[t]);
}
printf("\n");
}
mysql_close(mysql);
}
代码要怎么改呢?
NULL,"mytest",3306,NULL,0))
只要把这面这句的localhost改为要连接机子的ip地址,root,null,mytest对应地改为要连接的数据库用户名、密码、数据库名即可。