提供了编程的基础技术教程

zl程序教程

您现在的位置是：首页 >  数据库

当前栏目

.net连接Mysql封装类代码可直接调用

mysqlNet封装连接代码 调用 直接
2023-06-13 09:15:03 时间
微软的visualstudio没有自带连接Mysql的驱动，要去网上下载一个mysql-connector-net-6.4.3驱动，然后安装就可以使用。
下面是我封装好的连接数据库的类，直接调用即可。
复制代码代码如下:

usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingSystem.Configuration;
usingMySql.Data.MySqlClient;
namespaceDAL
{
 publicclassGetConnection
   {
       privatestaticMySqlConnection _connection;
     ///<summary>
     ///获取数据库连接桥
     ///</summary>
       privatestaticMySqlConnectionConnection
       {
           get
           {
              //stringconnectionString=ConfigurationManager.AppSettings["ConnectionString"];
               stringconnectionString="server=localhost;userid=root;password=root;database=system;pooling=false";
               //server=222.222.222.222;port=3306;uid=user;pwd=;database=basename;远程连接的
               //stringconnectionString="DataSource=202.192.72.22;InitialCatalog=wwj;PersistSecurityInfo=True;UserID=wwj;Password=wwj123";
               if(_connection==null)
               {
                   _connection=newMySqlConnection(connectionString);
                   _connection.Open();
               }
               if(_connection.State==ConnectionState.Closed)
               {
                   _connection.Open();
               }
               if(_connection.State==ConnectionState.Broken)
               {
                   _connection.Close();
                   _connection.Open();
               }
               returnGetConnection._connection;
           }
       }
     ///<summary>
     ///获取表数据
     ///</summary>
     ///<paramname="sql"></param>
     ///<returns></returns>
       publicstaticMySqlDataReaderGetDataRead(stringsql)
       {
           MySqlCommandcommand=newMySqlCommand(sql,Connection);
           MySqlDataReaderread=command.ExecuteReader();
           returnread;
       }
       publicstaticintNoSelect(stringsql)
       {
           MySqlCommandcommand=newMySqlCommand(sql,Connection);
           introw=command.ExecuteNonQuery();
           returnrow;
       }
       publicstaticDataTableGetDataTable(stringsql)
       {
           MySqlCommandcommand=newMySqlCommand(sql,Connection);
           DataTabledt=newDataTable();
           MySqlDataAdaptersda=newMySqlDataAdapter(command);
           sda.Fill(dt);
           returndt;
       }
       ///<summary>
       ///执行sql语句，返回一行一列。。
       ///</summary>
       ///<paramname="sql">SQL语句</param>
       ///<returns></returns>
       publicstaticstringGetScalar(stringsql)
       {
           MySqlCommandcommand=newMySqlCommand(sql,Connection);
           returncommand.ExecuteScalar().ToString();
       }
   }
}

比如说你想执行删除的，你可以调用GetConnection.NoSelect("deletefromUserInfowhereId=1");读数据库的某一张表，可以调用GetConnection.GetDataTable("select*fromUserInfo");调用都很方便。

相关文章