#include <stdio.h>
#include <WinSock.h>
#include <Windows.h>
#include <mysql.h>
#include<iostream>
using namespace std;
MYSQL mysql;  //mysql連接
MYSQL_RES* res; //一個(gè)結(jié)果集結(jié)構(gòu)體   
MYSQL_ROW row; //char** 二維數(shù)組，存放一條條記錄  
const char DataBase_UserName[] = "root";    //數(shù)據(jù)庫用戶名username
const char DataBase_Password[] = "@";   //數(shù)據(jù)庫密碼，填自己的密碼
const char DataBase_Host[] = "localhost";  //數(shù)據(jù)庫連接地址
//注意有時(shí)候使用主機(jī)ip會(huì)報(bào)錯(cuò)，此時(shí)可以將ip改為localhost
const char DataBase_Name[] = "test_db";  //database name
unsigned int DataBase_Port = 3306;            //server port
bool ConnectDatabase(); //函數(shù)申明
void FreeConnect();   //釋放資源
void main()
{<!--{C}%3C!%2D%2D%20%2D%2D%3E-->
ConnectDatabase(); //連接數(shù)據(jù)庫
//查詢數(shù)據(jù)
//選擇該數(shù)據(jù)庫中的一個(gè)表的所有數(shù)據(jù) sheet8 是一個(gè)數(shù)據(jù)表
mysql_query(&mysql, "SELECT * from sheet8"); 
//獲取結(jié)果集
res = mysql_store_result(&mysql);
//顯示數(shù)據(jù)
//給ROW賦值，判斷ROW是否為空，不為空就打印數(shù)據(jù)。
while (row = mysql_fetch_row(res))
{<!--{C}%3C!%2D%2D%20%2D%2D%3E-->
printf("%s ", row[0]);//打印ID
printf("%s ", row[1]);//打印ID
cout << endl;
}
getchar();
}
bool ConnectDatabase()
{<!--{C}%3C!%2D%2D%20%2D%2D%3E-->
//初始化mysql
mysql_init(&mysql);   //連接mysql，數(shù)據(jù)庫
if (!(mysql_real_connect(&mysql, DataBase_Host, DataBase_UserName, DataBase_Password, DataBase_Name, DataBase_Port, NULL, 0))) //中間分別是主機(jī)，用戶名，密碼，數(shù)據(jù)庫名，端口號（可以寫默認(rèn)0或者3306等），可以先寫成參數(shù)再傳進(jìn)去
{<!--{C}%3C!%2D%2D%20%2D%2D%3E-->
printf("Error connecting to database:%s\n", mysql_error(&mysql));
return false;
}
else
{<!--{C}%3C!%2D%2D%20%2D%2D%3E-->
MessageBoxA(NULL, "連接MYSQL數(shù)據(jù)成功！", "消息", MB_OK);
printf("Connected...\n");
return true;
}
}
//釋放資源
void FreeConnect()
{<!--{C}%3C!%2D%2D%20%2D%2D%3E-->
//釋放資源
//mysql_free_result(res);
mysql_close(&mysql);
}

private void AllSearch_Load(object sender, EventArgs e)
{
        MySqlConnection conn;
        string constr = "server=localhost;database=data;uid=choujieyun;pwd=12345678;";
        conn = new MySqlConnection(constr);
        conn.Open();
        MySqlCommand co = new MySqlCommand("select * from 表名;", conn);
        MySqlDataAdapter adapt = new MySqlDataAdapter();
        adapt.SelectCommand = co;
        DataSet ds = new DataSet();
        adapt.Fill(ds, "學(xué)生表");    
        dataGridView1.DataSource = ds.Tables["學(xué)生表"];
        DataSet ds = new DataSet();
        adapt.Fill(ds, "課程表"); 
        dataGridView1.DataSource = ds.Tables["課程表"];
         DataSet ds = new DataSet();
        adapt.Fill(ds, "教師表"); 
        dataGridView1.DataSource = ds.Tables["教師表"];
         DataSet ds = new DataSet();
        adapt.Fill(ds, "成績表"); 
        dataGridView1.DataSource = ds.Tables["成績表"];
        conn.Close();
}

//引入的命名空間
using?System.Data.SqlClient;//用于SQL?Sever數(shù)據(jù)訪問的命名空間
using?System.Data;???????????????//DataSet類的命名空間
using?System.Windows.Forms;??//DataGridView控件類的命名空間
//數(shù)據(jù)庫查詢
//執(zhí)行指定的SQL命令語句(insert,delete,update等),并返回命令所影響的行數(shù)
public?static?int?executeCommand(string?sqlStr)
{
????SqlConnection?sqlConnection1?=?new?SqlConnection("server=dell-PC;database=11071312HotelSys;uid=sa;pwd=xiaoyi9421");//創(chuàng)建數(shù)據(jù)庫連接(字符串中是我個(gè)人的數(shù)據(jù)庫信息)
????sqlConnection1.Open();??????//打開數(shù)據(jù)庫連接
????SqlCommand?sqlCommand1?=?new?SqlCommand(sqlStr,?sqlConnection1);??//執(zhí)行SQL命令
????int?Succnum?=?sqlCommand1.ExecuteNonQuery();
????return?Succnum;
}
//查詢(select)指定的數(shù)據(jù)記錄（多行多列）,并填充到數(shù)據(jù)控件DataGridView中
public?static?void?queryDataToGrid(string?sqlStr,?DataGridView?dataGridView1)
{
????SqlConnection?sqlConnection1?=?new?SqlConnection("server=dell-PC;database=11071312HotelSys;uid=sa;pwd=xiaoyi9421");//創(chuàng)建數(shù)據(jù)庫連接
????SqlDataAdapter?sqlDataAdapter1?=?new?SqlDataAdapter(sqlStr,?sqlConnection1);//利用已創(chuàng)建好的sqlConnection1,創(chuàng)建數(shù)據(jù)適配器sqlDataAdapter1
????DataSet?dataSet1?=?new?DataSet();??//創(chuàng)建數(shù)據(jù)集對象
????sqlDataAdapter1.Fill(dataSet1);????//執(zhí)行查詢,查詢的結(jié)果存放在數(shù)據(jù)集里
????dataGridView1.DataSource?=?dataSet1.Tables[0];?//把數(shù)據(jù)集中的查詢結(jié)果綁定dataGridView1中
}
//查詢(select)指定的數(shù)據(jù)（單個(gè)數(shù)據(jù),假設(shè)為string類型）,并返回
public?static?string?queryData(string?sqlStr)
{
????SqlConnection?sqlConnection1?=?new?SqlConnection("server=dell-PC;database=11071312HotelSys;uid=sa;pwd=xiaoyi9421");//創(chuàng)建數(shù)據(jù)庫連接
????SqlDataAdapter?sqlDataAdapter1?=?new?SqlDataAdapter(sqlStr,?sqlConnection1);//利用已創(chuàng)建好的sqlConnection1,創(chuàng)建數(shù)據(jù)適配器sqlDataAdapter1
????DataSet?dataSet1?=?new?DataSet();??//創(chuàng)建數(shù)據(jù)集對象
????sqlDataAdapter1.Fill(dataSet1);????//執(zhí)行查詢,查詢的結(jié)果存放在數(shù)據(jù)集里
????return?dataSet1.Tables[0].Rows[0]["列名"].ToString();?//把查詢結(jié)果的第一行指定列下的數(shù)據(jù)以string類型返回
}
//數(shù)據(jù)庫添加
private?void?btn_add_Click(object?sender,?EventArgs?e)
????????{
????????????string?sql?=?"insert?into?課程表(CourseId，CourseName,Teald)?values(‘0004'，‘物理'，‘0004');
????????????????int?i=help.changeSqlData(sql);
????????????if?(i?==?0)?MessageBox.Show("添加失敗",?"提示：");
????????????else?MessageBox.Show("添加成功",?"提示：");
????????}
//數(shù)據(jù)庫刪除
private?void?btn_delete_Click(object?sender,?EventArgs?e)
? ? ? ? {
????????????string?sql?=?"delete?from 學(xué)生表?where StuId='0008';
????????????int?i=help.changeSqlData(sql);
????????????if?(i?==?0)?MessageBox.Show("刪除失敗",?"提示：");
????????????else?MessageBox.Show("刪除成功",?"提示：");
????????}
//數(shù)據(jù)庫修改
private?void?btn_update_Click(object?sender,?EventArgs?e)
? ? ? ? {
????????????string?sql?=?"update 學(xué)生表?set StuAge="19" where StuId="0008";
????????????int?i?=?help.changeSqlData(sql);
????????????if?(i?==?0)?MessageBox.Show("修改失敗",?"提示：");
????????????else?MessageBox.Show("修改成功",?"提示：");
????????}