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

下面是我封装好的连接Mysql数据库的类直接调用即可

微软的visual studio没有自带连接Mysql的驱动要去网上下载一个mysqlconnectornet驱动然后安装就可以使用
下面是我封装好的连接数据库的类直接调用即可

复制代码 代码如下:
using System;
using SystemCollectionsGeneric;
using SystemLinq;
using SystemText;
using SystemData;
using SystemDataSqlClient;
using SystemConfiguration;
using MySqlDataMySqlClient;
namespace DAL
{
public class GetConnection
{
private static MySqlConnection _connection;
/// <summary>
/// 获取数据库连接桥
/// </summary>
private static MySqlConnection Connection
{
get
{
//string connectionString = ConfigurationManagerAppSettings["ConnectionString"];
string connectionString = "server=localhost;user id=root; password=root; database=system; pooling=false";
//server=;port=;uid=user;pwd=;database=basename;远程连接的
  //string connectionString = "Data Source=;Initial  Catalog=wwj;Persist Security Info=True;User ID=wwj;Password=wwj";
if (_connection == null)
{
_connection = new MySqlConnection(connectionString);
_connectionOpen();
}
if (_connectionState == ConnectionStateClosed)
{
_connectionOpen();
}
if (_connectionState == ConnectionStateBroken)
{
_connectionClose();
_connectionOpen();
}
return GetConnection_connection;
}
}
/// <summary>
/// 获取表数据
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static MySqlDataReader GetDataRead(string sql)
{
MySqlCommand command = new MySqlCommand(sql Connection);
MySqlDataReader read = commandExecuteReader();
return read;
}
public static int NoSelect(string sql)
{
MySqlCommand command = new MySqlCommand(sql Connection);
int row = commandExecuteNonQuery();
return row;
}
public static DataTable GetDataTable(string sql)
{
MySqlCommand command = new MySqlCommand(sql Connection);
DataTable dt = new DataTable();
MySqlDataAdapter sda = new MySqlDataAdapter(command);
sdaFill(dt);
return dt;
}
/// <summary>
/// 执行sql语句返回一行一列
/// </summary>
/// <param name="sql">SQL语句</param>
/// <returns></returns>
public static string GetScalar(string sql)
{
MySqlCommand command = new MySqlCommand(sql Connection);
return commandExecuteScalar()ToString();
}
}
}

比 如说你想执行删除的你可以调用GetConnectionNoSelect("delete from UserInfo where  Id=");读数据库的某一张表可以调用GetConnectionGetDataTable("select * from  UserInfo");调用都很方便