winfrom连接mysql帮助类_C#连接操作MySQL数据库 帮助类

usingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingMySql.Data.MySqlClient;///

///@author: 房上的猫///

///@博客地址:https://www.cnblogs.com/lsy131479/

///

namespaceConsoleApp1

{public classMySQLDBHelp

{#region 建立MySql数据库连接

///

///建立数据库连接.///

/// 返回MySqlConnection对象

publicMySqlConnection getmysqlcon()

{string M_str_sqlcon = "server=localhost;port=3306;user id=root;password=root;database=abc"; //根据自己的设置

MySqlConnection myCon = newMySqlConnection(M_str_sqlcon);returnmyCon;

}#endregion

#region 执行MySqlCommand命令

///

///执行MySqlCommand///

/// SQL语句

public void getmysqlcom(stringM_str_sqlstr)

{

MySqlConnection mysqlcon= this.getmysqlcon();

mysqlcon.Open();

MySqlCommand mysqlcom= newMySqlCommand(M_str_sqlstr, mysqlcon);

mysqlcom.ExecuteNonQuery();

mysqlcom.Dispose();

mysqlcon.Close();

mysqlcon.Dispose();

}#endregion

#region 创建MySqlDataReader对象

///

///创建一个MySqlDataReader对象///

/// SQL语句

/// 返回MySqlDataReader对象

public MySqlDataReader getmysqlread(stringM_str_sqlstr)

{

MySqlConnection mysqlcon= this.getmysqlcon();

MySqlCommand mysqlcom= newMySqlCommand(M_str_sqlstr, mysqlcon);

mysqlcon.Open();

MySqlDataReader mysqlread=mysqlcom.ExecuteReader(CommandBehavior.CloseConnection);returnmysqlread;

}#endregion}

}