#### 圖片
#### 代碼
~~~
#define _CRT_SECURE_NO_WARNINGS
#include <stdio.h>
#include <stdlib.h>
#include <winsock.h>
#include <mysql.h>
int main() {
printf("Content-type:text/html\n\n");
for (int i = 0; i < 1; i++) {
printf("hello c (%d) <br/>\n", i);
}
MYSQL *mysql = mysql_init(NULL);
if (mysql_real_connect(mysql, "localhost", "root", "root", "xj2014", 3306, NULL, 0)) {
printf("數據庫連接成功\n");
if (mysql_set_character_set(mysql, "gbk")) {
printf("編碼設置失敗:%s\n",mysql_error(mysql));
exit(1);
}
if (mysql_query(mysql, "select num,name,classs from userinfo limit 10")) {
printf("查詢出錯:%s\n", mysql_error(mysql));
exit(1);
};
MYSQL_RES* res = mysql_store_result(mysql);
MYSQL_ROW row;
while (row = mysql_fetch_row(res)) {
printf("\n學號=%s\t姓名=%s\t班級=%s", row[0], row[1],row[2]);
}
mysql_free_result(res);
mysql_close(mysql);
} else {
printf("數據庫連接失敗\n");
exit(1);
}
Sleep(500);
return 0;
}
~~~
