下面介紹兩種執(zhí)行SQL命令的方法，并作出相應(yīng)地總結(jié)，第一種介紹一種常規(guī)用法，下面進(jìn)行做簡要地分析，首先我們需要執(zhí)行打開數(shù)據(jù)庫操作首先創(chuàng)建一個MySqlConnection對象，在其構(gòu)造函數(shù)中傳入一個連接字符串，然后執(zhí)行Open操作打開數(shù)據(jù)庫，在正確打開數(shù)據(jù)庫之后我們才能進(jìn)行相關(guān)的動作，在ExecuteSQL這個函數(shù)中，

我們執(zhí)行MySqlCommand myCmd = new MySqlCommand(CmdString, conn)，從而創(chuàng)建MySqlCommand對象，其中傳入的兩個參數(shù)分別為sql命令和第一步建立的MySqlConnection對象，然后執(zhí)行int Cmd = myCmd.ExecuteNonQuery()這一句執(zhí)行相應(yīng)的命令，并返回受影響的行數(shù)，最后我們需要關(guān)閉數(shù)據(jù)庫連接，并釋放非托管資源，從而完成整個數(shù)據(jù)庫操作的過程;這個是比較常規(guī)的一種做法，也是我們使用比較多的一種形式。

public class DataBaseMySqlHelper{ string connstr; MySqlConnection conn; //Server=xxxxxxx;Database=xxxxxxx;Uid=xxxxxxx;Pwd=xxxxxxx;CharSet=gbk; //Server=xxx.xx.xxx.xx;Database=MSUP;Uid=dvision;Pwd=dvision;Port=xxxx;allow zero datetime = true; MainWindow _MainWindow; public DataBaseMySqlHelper(MainWindow mainWindow) {_MainWindow = mainWindow; connstr = _MainWindow._ConfigInfo.MySqlConnectionStrings; } public DataBaseMySqlHelper(MainWindow mainWindow, string connectionString) {_MainWindow = mainWindow;connstr = connectionString; } /// <summary> /// 打開數(shù)據(jù)庫連接 /// </summary> void Open() {try{ conn = new MySqlConnection(connstr); conn.Open();}catch (Exception ex){ System.Windows.Forms.MessageBox.Show(ex.Message);} } /// <summary> /// 關(guān)閉數(shù)據(jù)庫連接 /// </summary> void Close() {conn.Close(); } /// <summary> /// 返回影響數(shù)據(jù)庫的行數(shù)/// </summary> /// <param name='CmdString'></param> /// <returns></returns> public int ExecuteSQL(string CmdString) {try{ Open(); MySqlCommand myCmd = new MySqlCommand(CmdString, conn); int Cmd = myCmd.ExecuteNonQuery(); Close(); return Cmd;}catch (Exception ex){ _MainWindow.ShowErrorMessage(' MySql數(shù)據(jù)庫查詢失敗!'); return 0;} } /// <summary> /// 返回數(shù)據(jù)表 /// </summary> /// <param name='CmdString'></param> /// <returns></returns> public DataTable GetDataTable(string CmdString) {try{ Open(); DataSet myDs = new DataSet(); MySqlDataAdapter myDa = new MySqlDataAdapter(); myDa.SelectCommand = new MySqlCommand(CmdString, conn); myDa.Fill(myDs); Close(); return myDs.Tables[0];}catch (Exception e){ _MainWindow.ShowErrorMessage(' MySql數(shù)據(jù)庫查詢失敗!'); return null;} }}

第二種方式，這里也貼出關(guān)鍵代碼并做簡要的分析：這里的關(guān)鍵是MySqlParameter[]數(shù)組的使用，我們在執(zhí)行SQL語句的時候 DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);這里的parameters就是MySqlParameter[]數(shù)組，里面存儲的是每個字段的數(shù)據(jù)，我們將在下面的代碼中展示parameters的內(nèi)容，

/// <summary>/// 增加一條數(shù)據(jù)/// </summary>public void Add(Maticsoft.Model.cameradetail model){ StringBuilder strSql=new StringBuilder(); strSql.Append('insert into cameradetail_gis('); strSql.Append('EncodeDeviceUsername,MatrixIP,EncodeDevicePassword,id,Name,DisplayName,Location,Longitude,Latitude,CameraActive,ServerID,ForwardSvrIP,ForwardSvrPort,EncodeDeviceIP,EncodeDevicePort,CameraType,CameraModel,DeviceChannel,MatrixPort,MatrixChannelNum,VideoStoreServerIP,VideoStoreServerPort,VideoStoreServerUserID,VideoStoreServerPassword,EncodeDeviceModelNum,EncodeDeviceModelName,CameraInstallAddress,CameraStatus)'); strSql.Append(' values ('); strSql.Append('@EncodeDeviceUsername,@MatrixIP,@EncodeDevicePassword,@id,@Name,@DisplayName,@Location,@Longitude,@Latitude,@CameraActive,@ServerID,@ForwardSvrIP,@ForwardSvrPort,@EncodeDeviceIP,@EncodeDevicePort,@CameraType,@CameraModel,@DeviceChannel,@MatrixPort,@MatrixChannelNum,@VideoStoreServerIP,@VideoStoreServerPort,@VideoStoreServerUserID,@VideoStoreServerPassword,@EncodeDeviceModelNum,@EncodeDeviceModelName,@CameraInstallAddress,@CameraStatus)'); MySqlParameter[] parameters = { new MySqlParameter('@EncodeDeviceUsername', MySqlDbType.VarChar,64), new MySqlParameter('@MatrixIP', MySqlDbType.VarChar,16), new MySqlParameter('@EncodeDevicePassword', MySqlDbType.VarChar,64), new MySqlParameter('@id', MySqlDbType.VarChar,14), new MySqlParameter('@Name', MySqlDbType.VarChar,100), new MySqlParameter('@DisplayName', MySqlDbType.VarChar,100), new MySqlParameter('@Location', My