C#封装mysql类，连接数据库，执行数据库语句

最新推荐文章于 2023-03-13 22:50:11 发布

漫步的社会人

最新推荐文章于 2023-03-13 22:50:11 发布

阅读量354

点赞数

分类专栏： sql C# 文章标签： C# mysql

本文链接：https://blog.csdn.net/ad13adsa/article/details/103181485

版权

C# 同时被 2 个专栏收录

21 篇文章 1 订阅

订阅专栏

sql

5 篇文章 0 订阅

订阅专栏

class MysqlClass
{
private MySqlConnection SqlConn;

public MysqlClass(string ServerIp,string Port, string SQLUserName, string SQLUserPass, string DataBase)
       {
this.SqlConn = new MySqlConnection(MysqlClass.MsSqlConn(ServerIp,Port, SQLUserName, SQLUserPass, DataBase));
       }
       private static string MsSqlConn(string strIp,string Port, string UserId, string Pwd, string DataName)
       {
           return string.Concat(new string[]
           {
               "server =",
               strIp,
           ";port = ",
Port,
";user = ",
UserId,
";password=",
Pwd,
";database =",
               DataName,
";"

           });
       }
       public int ExecuteNonQuery(string sql)
       {
           MySqlCommand sqlCommand = new MySqlCommand(sql, this.SqlConn);
           int result;
           try
           {
               this.SqlConn.Open();
               sqlCommand.CommandTimeout = 60;
               result = sqlCommand.ExecuteNonQuery();
           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
               MySqlConnection.ClearPool(this.SqlConn);
               result = 0;
           }
           finally
           {
               this.SqlConn.Close();
           }
           return result;
       }

       public object ExecuteScalar(string sql)
       {
           MySqlCommand sqlCommand = new MySqlCommand(sql, this.SqlConn);
           object result;
           try
           {
               this.SqlConn.Open();
               sqlCommand.CommandTimeout = 60;
               result = sqlCommand.ExecuteScalar();
           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
               MySqlConnection.ClearPool(this.SqlConn);
               result = null;
           }
           finally
           {
               this.SqlConn.Close();
           }
           return result;
       }

       public DataTable GetDataTable(string sql)
       {
           DataTable dataTable = new DataTable();
           DataTable result;
           try
           {
               this.SqlConn.Open();
               MySqlDataAdapter sqlDataAdapter = new MySqlDataAdapter(sql, this.SqlConn);
               sqlDataAdapter.Fill(dataTable);
               result = dataTable;
           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
               MySqlConnection.ClearPool(this.SqlConn);
               result = null;
           }
           finally
           {
               this.SqlConn.Close();
           }
           return result;
       }

       public bool ExecuteNonQueryByTransaction(List<string> SQLStringList)
       {
           MySqlCommand sqlCommand = new MySqlCommand();
           this.SqlConn.Open();
           sqlCommand.Connection = this.SqlConn;
           MySqlTransaction sqlTransaction = this.SqlConn.BeginTransaction();
           sqlCommand.Transaction = sqlTransaction;
           bool result;
           try
           {
               for (int i = 0; i < SQLStringList.Count; i++)
               {
                   string text = SQLStringList[i].ToString();
                   if (text.Trim().Length > 1)
                   {
                       sqlCommand.CommandText = text;
                       sqlCommand.ExecuteNonQuery();
                   }
               }
               sqlTransaction.Commit();
               result = true;
           }
           catch (Exception ex)
           {
               sqlTransaction.Rollback();
               MySqlConnection.ClearPool(this.SqlConn);
               MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
               result = false;
           }
           finally
           {
               this.SqlConn.Close();
           }
           return result;
       }