asp.net中C#串連mysql資料庫程式碼

代碼如下

複製代碼

#include <stdio.h> #include <stdlib.h> #include <mysql/mysql.h>   int main(void) {         const char *host = "localhost";         const char *user = "root";         const char *pass = "yourpassword";         const char *db   = "mysql";         /* 定義mysql變數 */         MYSQL mysql;         MYSQL_RES *rs;         MYSQL_ROW row;         mysql_init(&mysql); /* 初始化 */         /* 串連資料庫 */         if (!mysql_real_connect(&mysql, host, user, pass, db, 0, NULL, 0))         {                 printf("%s", mysql_error(&mysql));         }         // get more result test         /*         char *sql = "select user,host from user";         if (mysql_query(&mysql, sql)!=0)          { //查詢                 printf( "%s", mysql_errno(&mysql), mysql_error(&mysql));         }         rs = mysql_store_result(&mysql); // 擷取查詢結果         while ((row = mysql_fetch_row(rs)))          {      // 擷取每一行記錄                 printf( "%s----%sn", row[0], row[1]);         }         */         // get one result test         char *sql = "select user from user where host='127.0.0.1'";         if (mysql_query(&mysql, sql)!=0)         { //查詢                                                                                                                   1,7           Top         if (mysql_query(&mysql, sql)!=0)         { //查詢                 printf( "%s", mysql_errno(&mysql), mysql_error(&mysql));         }         rs = mysql_store_result(&mysql); // 擷取查詢結果         row=mysql_fetch_row(rs);         printf("%sn",row[0]);         //*/         mysql_free_result(rs); /* 釋放結果集 */         mysql_close(&mysql); /* 關閉串連 */         return 1; }