using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Windows.Forms;
using?MySql.Data.MySqlClient;

namespace?My_SQL
{
????public?partial?class?Form1?:?Form
????{
????????//public?object?sender;
????????//public?EventArgs?e;

????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????????textBox1.Text?=?“test“;
????????????textBox2.Text?=?“root“;
????????????textBox3.Text?=?“1234qwer“;

????????????//創建庫
????????????textBox4.Text?=?““;
????????????textBox5.Text?=?“root“;
????????????textBox6.Text?=?“1234qwer“;

????????????//創建表
????????????textBox7.Text?=?“dog_name“;
????????????textBox8.Text?=?“dog_sex“;
????????????textBox9.Text?=?“dog_old“;


????????????//初始化表格表頭
????????????this.listView1.Columns.Add（“id“?120?HorizontalAlignment.Left）;?//一步添加
????????????this.listView1.Columns.Add（“姓名“?120?HorizontalAlignment.Left）;?//一步添加
????????????this.listView1.Columns.Add（“年齡“?120?HorizontalAlignment.Left）;?//一步添加
????????}

????????//【函數】連接數據庫
????????MySqlConnection?MySQL_Connect（）
????????{
????????????//打開通道，建立連接，可能出現異常使用try?catch語句
????????????MySqlConnection?conn;
????????????string?connstr?=?“data?source=localhost;database=“?+?textBox1.Text?+?“;?user=“?+?textBox2.Text?+?“;?password=“?+?textBox3.Text?+?“;?pooling=false;charset=utf8“;//pooling代表是否使用連接池
????????????conn?=?new?MySqlConnection（connstr）;
????????????conn.Open（）;

????????????try
????????????{
????????????????Console.WriteLine（“已經建立連接“）;
????????????????return?conn;
????????????}
????????????catch?（MySqlException?ex）
????????????{
????????????????MessageBox.Show（ex.Message）;
????????????????return?null;
????????????}
????????}


????????//【函數】讀MySQL數據庫
????????MySqlConnection?MySQL_Read（string?sql?ref?MySqlDataReader?reader）
????????{
????????????//連接數據庫
????????????MySqlConnection?conn?=MySQL_Connect（）;
????????????MySqlCommand?cmd;

????????????//發送指令
????????????cmd?=?new?MySqlCommand（sql?conn）;

????????????//執行ExecuteReader（）返回一個MySqlDataReader對象
????????????reader?=?cmd.ExecuteReader（）;

????????????//返回讀數據
????????????return?conn;
????????}

????????//【函數】寫MySQL數據庫
????????void?MySQL_Execute（MySqlConnection?connstring?sql）
????????{
????????????//發送指令
????????????MySqlCommand?cmd;

????????????cmd?=?new?MySqlCommand（sql?conn）;

????????????//執行插入、刪除、更改語句。執行成功返回受影響的數據的行數，返回1可做true判斷。執行失敗不返回任何數據，報錯，下面代碼都不執行
????????????cmd.ExecuteNonQuery（）;
????????}


????????//連接數據庫
????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????MySQL_Connect（）;
????????????MessageBox.Show（“連接數據庫成功！“）;
????????}

????????//讀數據庫表
????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????//發送指令
????????????string?sql?=?“select?*?from?test.name“;
????????????MySqlDataReader?r

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

????..A..H.?????49152??2020-10-30?21:47??My?SQL\.vs\My?SQL\v14\.suo

?????文件????????189??2020-03-14?19:26??My?SQL\My?SQL\App.config

?????文件??????17408??2020-10-30?21:47??My?SQL\My?SQL\bin\Debug\My?SQL.exe

?????文件????????189??2020-03-14?19:26??My?SQL\My?SQL\bin\Debug\My?SQL.exe.config

?????文件??????28160??2020-10-30?21:47??My?SQL\My?SQL\bin\Debug\My?SQL.pdb

?????文件??????22696??2020-10-30?21:47??My?SQL\My?SQL\bin\Debug\My?SQL.vshost.exe

?????文件????????189??2020-03-14?19:26??My?SQL\My?SQL\bin\Debug\My?SQL.vshost.exe.config

?????文件????????490??2019-03-19?12:46??My?SQL\My?SQL\bin\Debug\My?SQL.vshost.exe.manifest

?????文件?????457216??2015-07-03?16:52??My?SQL\My?SQL\bin\Debug\MySql.Data.dll

?????文件??????10152??2020-03-18?23:01??My?SQL\My?SQL\Form1.cs

?????文件??????17541??2020-03-15?16:30??My?SQL\My?SQL\Form1.Designer.cs

?????文件???????6017??2020-03-15?16:30??My?SQL\My?SQL\Form1.resx

?????文件???????4011??2020-03-14?20:10??My?SQL\My?SQL\My?SQL.csproj

?????文件?????457216??2015-07-03?16:52??My?SQL\My?SQL\MySql.Data.dll

?????文件???????1464??2020-03-14?23:00??My?SQL\My?SQL\obj\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????7181??2020-03-14?19:35??My?SQL\My?SQL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件????????659??2020-10-30?21:47??My?SQL\My?SQL\obj\Debug\My?SQL.csproj.FileListAbsolute.txt

?????文件???????1012??2020-03-15?16:33??My?SQL\My?SQL\obj\Debug\My?SQL.csproj.GenerateResource.Cache

?????文件??????11726??2020-03-14?20:10??My?SQL\My?SQL\obj\Debug\My?SQL.csprojResolveAssemblyReference.cache

?????文件??????17408??2020-10-30?21:47??My?SQL\My?SQL\obj\Debug\My?SQL.exe

?????文件??????28160??2020-10-30?21:47??My?SQL\My?SQL\obj\Debug\My?SQL.pdb

?????文件????????180??2020-03-15?16:33??My?SQL\My?SQL\obj\Debug\My_SQL.Form1.resources

?????文件????????180??2020-03-14?20:10??My?SQL\My?SQL\obj\Debug\My_SQL.Properties.Resources.resources

?????文件??????????0??2020-03-14?19:26??My?SQL\My?SQL\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

?????文件??????????0??2020-03-14?19:26??My?SQL\My?SQL\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

?????文件??????????0??2020-03-14?19:26??My?SQL\My?SQL\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs

?????文件????????518??2020-03-14?19:26??My?SQL\My?SQL\Program.cs

?????文件???????1320??2020-03-14?19:26??My?SQL\My?SQL\Properties\AssemblyInfo.cs

?????文件???????2825??2020-03-14?19:26??My?SQL\My?SQL\Properties\Resources.Designer.cs

?????文件???????5612??2020-03-14?19:26??My?SQL\My?SQL\Properties\Resources.resx

............此處省略18個文件信息