mysql dbhelper 下载_DbHelperMySQL

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using MySql.Data.MySqlClient;

using System.Data;

///

///DbHelperMySQL 的摘要说明

///

public class DbHelperMySQL

{

public DbHelperMySQL()

{

}

#region  建立MySql数据库连接

///

/// 建立数据库连接.

///

/// 返回MySqlConnection对象

public static MySqlConnection getmysqlcon()

{

//http://sosoft.cnblogs.com/

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

MySqlConnection myCon = new MySqlConnection(M_str_sqlcon);

return myCon;

}

#endregion

#region  执行MySqlCommand命令

///

/// 执行MySqlCommand

///

/// SQL语句

public static void getmysqlcom(string M_str_sqlstr)

{

MySqlConnection mysqlcon = getmysqlcon();

mysqlcon.Open();

MySqlCommand mysqlcom = new MySqlCommand(M_str_sqlstr, mysqlcon);

mysqlcom.ExecuteNonQuery();

mysqlcom.Dispose();

mysqlcon.Close();

mysqlcon.Dispose();

}

#endregion

#region  创建MySqlDataReader对象

///

/// 创建一个MySqlDataReader对象

///

/// SQL语句

/// 返回MySqlDataReader对象

public static MySqlDataReader getmysqlread(string M_str_sqlstr)

{

MySqlConnection mysqlcon = getmysqlcon();

MySqlCommand mysqlcom = new MySqlCommand(M_str_sqlstr, mysqlcon);

mysqlcon.Open();

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

return mysqlread;

}

#endregion

}