using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Collections;
using?System.Configuration;
using?MySql.Data;
using?MySql.Data.MySqlClient;
using?ConsoleApplication3;

namespace?Sql
{
????class?Program
????{
????????public?static?void?Main（string[]?args）
????????{
????????????//????//【1】封裝數據庫的連接字符串，并創建連接對象
????????????//????string?constructorString?=?“server=localhost;User?Id=root;password=lwd19980322;Database=myemployees“;
????????????//????//調用MySqlConnection含參的構造方法
????????????//????MySqlConnection?myConnnect?=?new?MySqlConnection（constructorString）;
????????????//????//【2】創建Command對象
????????????//????//MySqlCommand?myCmd?=?new?MySqlCommand（）;
????????????//????//myCmd.CommandText?=?constructorString;
????????????//????//myCmd.Connection?=?myConnnect;
????????????//????//string?sql?=?“insert?into?jobs（job_idjob_titlemin_salarymax_salary）“;
????????????//????//sql?+=?“?values（‘AD鈣奶‘‘ad鈣奶總經理‘50000100000）“;?
????????????//????//string?sql?=?“select?job_id=?count（*）from?jobs“;?
????????????//????string?sql?=?“select?job_idjob_titlemin_salary?from?jobs“;
????????????//????//調用含兩個參數的構造方法（Mysql命令，連接對象）
????????????//????MySqlCommand?myCmd?=?new?MySqlCommand（sql?myConnnect）;
????????????//????//【3】打開數據庫連接
????????????//????myConnnect.Open（）;
????????????//????//【4】執行數據操作，返回受影響的行數（int）
????????????//????//int?result?=?myCmd.ExecuteNonQuery（）;
????????????//????//Console.WriteLine（“受影響的行數=“+result）;
????????????//????////執行這個方法后，返回的是單行單列
????????????//????//object?result?=?myCmd.ExecuteScalar（）;
????????????//????////執行一個查詢，返回一個多行多列的結果集，即是一個對象，這個結果并沒有給客戶端，而是通過SqlDataReader對象
????????????//???MySqlDataReader?reader?=?myCmd.ExecuteReader（）;
????????????//????//循環讀取結果Read（）方法返回的是一個bool值
????????????//????while（reader.Read（））
????????????//????{
????????????//????????//使用索引器讀取
????????????//????????Console.WriteLine（reader[0]+“\t“?+reader[1]+“\t“+reader[2]?）;
????????????//????}

????????????//????//【5】關閉連接，首先關閉讀取器對象，再關閉Command對象、Connect對象
????????????//????reader.Close（）;
????????????//????myCmd.Dispose（）;
????????????//????myConnnect.Close（）;
????????????//????Console.ReadLine（）;
????????????//}
????????????string?sql?=?“select?job_idjob_titlemin_salary?from?jobs“;
????????????MySqlDataReader?reader?=?SQLhelper.GetReader（sql）;
????????????while?（reader.Read（））
????????????{
????????????????//使用索引器讀取
????????????????Console.WriteLine（reader[0]?+?“\t“?+?reader[1]?+?“\t“?+?reader[2]）;
????????????}
????????????Console.ReadLine（）;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-05-23?13:13??ConsoleApplication3\
?????目錄???????????0??2018-05-23?13:13??ConsoleApplication3\.vs\
?????目錄???????????0??2018-05-23?13:13??ConsoleApplication3\.vs\ConsoleApplication3\
?????目錄???????????0??2018-05-23?13:13??ConsoleApplication3\.vs\ConsoleApplication3\v14\
?????文件???????46080??2018-05-26?09:18??ConsoleApplication3\.vs\ConsoleApplication3\v14\.suo
?????目錄???????????0??2018-05-26?08:58??ConsoleApplication3\ConsoleApplication3\
?????文件????????1024??2018-05-23?13:13??ConsoleApplication3\ConsoleApplication3.sln
?????目錄???????????0??2018-05-23?13:13??ConsoleApplication3\ConsoleApplication3\bin\
?????目錄???????????0??2018-05-25?07:57??ConsoleApplication3\ConsoleApplication3\bin\Debug\
?????文件????????6656??2018-05-26?08:58??ConsoleApplication3\ConsoleApplication3\bin\Debug\ConsoleApplication3.exe
?????文件???????15872??2018-05-26?08:58??ConsoleApplication3\ConsoleApplication3\bin\Debug\ConsoleApplication3.pdb
?????文件???????22688??2018-05-26?08:58??ConsoleApplication3\ConsoleApplication3\bin\Debug\ConsoleApplication3.vshost.exe
?????文件?????????490??2017-09-29?21:43??ConsoleApplication3\ConsoleApplication3\bin\Debug\ConsoleApplication3.vshost.exe.manifest
?????文件??????423936??2016-06-17?23:34??ConsoleApplication3\ConsoleApplication3\bin\Debug\MySql.Data.dll
?????文件??????336896??2016-06-17?23:34??ConsoleApplication3\ConsoleApplication3\bin\Debug\MySql.Data.Entity.dll
?????文件??????348672??2016-06-17?23:34??ConsoleApplication3\ConsoleApplication3\bin\Debug\MySql.Data.Entity.EF6.dll
?????文件???????93696??2016-06-17?23:34??ConsoleApplication3\ConsoleApplication3\bin\Debug\MySql.Web.dll
?????文件????????3096??2018-05-25?09:52??ConsoleApplication3\ConsoleApplication3\ConsoleApplication3.csproj
?????目錄???????????0??2018-05-23?13:13??ConsoleApplication3\ConsoleApplication3\obj\
?????目錄???????????0??2018-05-25?08:32??ConsoleApplication3\ConsoleApplication3\obj\Debug\
?????文件????????1157??2018-05-26?08:58??ConsoleApplication3\ConsoleApplication3\obj\Debug\ConsoleApplication3.csproj.FileListAbsolute.txt
?????文件???????30694??2018-05-25?08:32??ConsoleApplication3\ConsoleApplication3\obj\Debug\ConsoleApplication3.csprojResolveAssemblyReference.cache
?????文件????????6656??2018-05-26?08:58??ConsoleApplication3\ConsoleApplication3\obj\Debug\ConsoleApplication3.exe
?????文件???????15872??2018-05-26?08:58??ConsoleApplication3\ConsoleApplication3\obj\Debug\ConsoleApplication3.pdb
?????文件????????6712??2018-05-25?08:56??ConsoleApplication3\ConsoleApplication3\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????目錄???????????0??2018-05-23?13:13??ConsoleApplication3\ConsoleApplication3\obj\Debug\TempPE\
?????文件????????3027??2018-05-26?08:58??ConsoleApplication3\ConsoleApplication3\Program.cs
?????目錄???????????0??2018-05-23?13:13??ConsoleApplication3\ConsoleApplication3\Properties\
?????文件????????1346??2018-05-23?13:13??ConsoleApplication3\ConsoleApplication3\Properties\AssemblyInfo.cs
?????文件????????4343??2018-05-25?13:57??ConsoleApplication3\ConsoleApplication3\SQLhelper.cs