mysql sdr int_MySQL数据库辅助类

/**

*创建人：CalvinR

*说明：数据库辅助类

**/

namespaceStudy.Utilities.MySql_Connect

{///

///MySqlHelper 的摘要说明///

public classMySqlHelper

{private MySqlConnection conn = null;private MySqlCommand cmd = null;privateMySqlDataReader sdr;private MySqlDataAdapter sda = null;publicMySqlHelper()

{string connStr = ConfigurationManager.ConnectionStrings["connectString"].ConnectionString; //获取MySql数据库连接字符串

conn = new MySqlConnection(connStr); //数据库连接

}///

///打开数据库链接///

///

privateMySqlConnection Open()

{if (conn.State ==ConnectionState.Closed)

{

conn.Open();

}returnconn;

}///

///关闭数据库链接///

private voidClose()

{if (conn.State ==ConnectionState.Open)

{

conn.Close();

}

}///

///执行不带参数的增删改SQL语句或存储过程///

/// 增删改SQL语句或存储过程的字符串

/// 命令类型

/// 受影响的函数

public int ExecuteNonQuery(stringcmdText, CommandType ct)

{intres;using (cmd = newMySqlCommand(cmdText, Open()))

{

cmd.CommandType=ct;

res=cmd.ExecuteNonQuery();

}returnres;

}///

///执行带参数的增删改SQL语句或存储过程///

/// 增删改SQL语句或存储过程的字符串

/// 往存储过程或SQL中赋的参数集合

/// 命令类型

/// 受影响的函数

public int ExecuteNonQuery(stringcmdText, MySqlParameter[] paras, CommandType ct)

{intres;using (cmd = newMySqlCommand(cmdText, Open()))

{

cmd.CommandType=ct;

cmd.Parameters.AddRange(paras);

res=cmd.ExecuteNonQuery();

}returnres;

}///

///执行不带参数的查询SQL语句或存储过程///

/// 查询SQL语句或存储过程的字符串

/// 命令类型

/// 查询到的DataTable对象

public DataTable ExecuteQuery(stringcmdText, CommandType ct)

{

DataTable dt= newDataTable();

cmd= newMySqlCommand(cmdText, Open());

cmd.CommandType=ct;using (sdr =cmd.ExecuteReader(CommandBehavior.CloseConnection))

{

dt.Load(sdr);

}returndt;

}///

///执行带参数的查询SQL语句或存储过程///

/// 查询SQL语句或存储过程的字符串

/// 参数集合

/// 命令类型

///

public DataTable ExecuteQuery(stringcmdText, MySqlParameter[] paras, CommandType ct)

{

DataTable dt= newDataTable();

cmd= newMySqlCommand(cmdText, Open());

cmd.CommandType=ct;

cmd.Parameters.AddRange(paras);using (sdr =cmd.ExecuteReader(CommandBehavior.CloseConnection))

{

dt.Load(sdr);

}returndt;

}///

///执行指定数据库连接字符串的命令,返回DataSet.///

/// 一个有效的数据库连接字符串

/// 返回一个包含结果集的DataSet

public DataSet ExecuteDataset(stringstrSql)

{

DataSet ds= newDataSet();

sda= newMySqlDataAdapter(strSql, Open());try{

sda.Fill(ds);

}catch(Exception ex)

{throwex;

}finally{

Close();

}returnds;

}

}

}