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;
}