C语言实现访问及查询MySQL数据库的方法

// AccessToMySQL.cpp : 定义控制台应用程序的入口点。//#include "stdafx.h"#include <Windows.h>#include <mysql.h>#pragma comment(lib,"libmysql.lib")MYSQL mysql;MYSQL_RES* result;MYSQL_ROW row;int main(void){  //init the mysql parameter  mysql_init(&mysql);  //connect the database  if(!mysql_real_connect(&mysql,"127.0.0.1","root","111","mytest",3306,NULL,0))  {    printf(mysql_error(&mysql));    printf("/nCannot access to the database!!!/n");    system("pause");    exit(-1);  }  //construct the query SQL statements  char* sql="select * from student where name='";  char dest[100]={""};  strcat(dest,sql);  printf("Please enter the student name:");  char name[10]={""};  gets(name);  strcat(dest,name);  strcat(dest,"'");  //excute the SQL statements  if(mysql_query(&mysql,dest))  {    printf("Cannot access the database with excuting /"%s/".",dest);    system("pause");    exit(-1);  }  //deal with the result  result=mysql_store_result(&mysql);  if(mysql_num_rows(result))  {    while((row=mysql_fetch_row(result)))    {      printf("%s/t%s/t%s/n",row[0],row[1],row[2]);    }  }  //release the resource  mysql_free_result(result);  mysql_close(&mysql);  system("pause");  return 0;}