//添加引用 System.Configuration
public static string connstr = ConfigurationManager.ConnectionStrings["connstr"].ToString();
/// <summary>
/// 执行增、删、改
/// </summary>
/// <param name="sqlstr"></param>
/// <returns></returns>
private static int UpDate(string sqlstr)
{
MySqlConnection conn = new MySqlConnection(connstr);
MySqlCommand comm = new MySqlCommand(sqlstr, conn);
try
{
conn.Open();
int result = comm.ExecuteNonQuery();
return result;
}
catch (System.Exception ex)
{
// 写入系统日志
throw ex;
}
finally
{
conn.Close();
}
}
/// <summary>
/// 查询:获取单一结果
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static object GetSingleResult(string sqlstr)
{
MySqlConnection conn = new MySqlConnection(connstr);
MySqlCommand comm = new MySqlCommand(sqlstr, conn);
try
{
conn.Open();
object result = comm.ExecuteScalar();
return result;
}
catch (System.Exception ex)
{
// 写入系统日志
throw ex;
}
conn.Close();
}
/// <summary>
/// 查询:获取结果集合
/// </summary>
/// <param name="sqlstr"></param>
/// <returns></returns>
public static MySqlDataReader GetDataReader(string sqlstr)
{
MySqlConnection conn = new MySqlConnection(connstr);
MySqlCommand comm = new MySqlCommand(sqlstr, conn);
try
{
conn.Open();
return comm.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (System.Exception ex)
{
// 写入系统日志
conn.Clone();
throw ex;
}
finally
{
conn.Close();
}
}