C語言訪問MySQL資料庫的方法,c語言mysql資料庫
1、添加標頭檔路徑(MySQL安裝路徑中的include路徑)
2、添加庫檔案(直接從MySQL安裝路徑中copy libmysql.lib即可)
3、編程操作資料庫
代碼
// 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 parametermysql_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 statementschar* 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 statementsif(mysql_query(&mysql,dest)){printf("Cannot access the database with excuting \"%s\".",dest);system("pause");exit(-1);}//deal with the resultresult=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 resourcemysql_free_result(result);mysql_close(&mysql);system("pause");return 0;}