c# mysql类使用_C#操作MySQL类

using System;

using System.Collections;

using System.Collections.Generic;

using System.Data;

using System.Linq;

using System.Text;

using System.Text.RegularExpressions;

using System.Threading.Tasks;

using MySql.Data;

using MySql.Data.MySqlClient;

namespace WindowsFormsApp1

{

public class MySqlHelper

{

MySqlConnection mysqlConnection;

DataSet dataSet;

string IP = "";       //连接名

string UserName = ""; //用户名

string Password = ""; //密码

string Database = "";//数据库

///

/// 建立mysql连接

///

public MySqlHelper()

{

try

{

mysqlConnection = new MySqlConnection("datasource=" + IP + ";username=" + UserName + ";password=" + Password + ";database=" + Database + ";charset=utf8");

}

catch (MySqlException ex)

{

Console.WriteLine(ex.Message);

}

}

public MySqlHelper(string IP, string UserName, string Password, string Database)

{

try

{

string connectionString = "datasource=" + IP + ";username=" + UserName + ";password=" + Password + ";database=" + Database + ";charset=gb2312";

mysqlConnection = new MySqlConnection(connectionString);

}

catch (MySqlException ex)

{

Console.WriteLine(ex.Message);

}

}

public string MysqlInfo()

{

string mysqlInfo = null;

try

{

mysqlConnection.Open();

mysqlInfo += "Connection Opened." + Environment.NewLine;

mysqlInfo += "Connection String:" + mysqlConnection.ConnectionString.ToString() + Environment.NewLine;

mysqlInfo += "Database:" + mysqlConnection.Database.ToString() + Environment.NewLine;

mysqlInfo += "Connection ServerVersion:" + mysqlConnection.ServerVersion.ToString() + Environment.NewLine;

mysqlInfo += "Connection State:" + mysqlConnection.State.ToString() + Environment.NewLine;

}

catch (MySqlException ex)

{

Console.WriteLine("MySqlException Error:" + ex.ToString());

}

finally

{

mysqlConnection.Close();

}

return mysqlInfo;

}

///

/// 执行sql语句无返回结果

///

public int MysqlCommand(string MysqlCommand)

{

try

{

mysqlConnection.Open();

Console.WriteLine("MysqlConnection Opened.");

MySqlCommand mysqlCommand = new MySqlCommand(MysqlCommand, mysqlConnection);

return mysqlCommand.ExecuteNonQuery();

}

catch (MySqlException ex)

{

Console.WriteLine("MySqlException Error:" + ex.ToString());

if (Regex.IsMatch(ex.ToString(), ""))

{

Console.WriteLine(ex.Message);

}

}

finally

{

mysqlConnection.Close();

}

return -1;

}

///

/// 执行select 语句返回执行结果

///

public DataView MysqlDataAdapter(string table)

{

DataView dataView = new DataView();

try

{

mysqlConnection.Open();

MySqlDataAdapter mysqlDataAdapter = new MySqlDataAdapter("Select * from " + table, mysqlConnection);

dataSet = new DataSet();

mysqlDataAdapter.Fill(dataSet, table);

dataView = dataSet.Tables[table].DefaultView;

}

catch (MySqlException ex)

{

Console.WriteLine(ex.Message);

}

finally

{

mysqlConnection.Close();

}

return dataView;

}

///

/// 统计记录个数 参数：select count(*) from isns_users

///

public long MysqlCountRow(string sql)

{

DataView dataView = new DataView();

try

{

mysqlConnection.Open();

MySqlCommand mycm = new MySqlCommand(sql, mysqlConnection);

// MySqlDataReader msdr = mycm.ExecuteReader();

long recordCount = (long)mycm.ExecuteScalar();

return recordCount;

}

catch (MySqlException)

{

return -1;

// Console.WriteLine(ex.Message);

}

finally

{

mysqlConnection.Close();

}

// return 0;

}

}

}