110,536
社区成员
发帖
与我相关
我的任务
分享
public class MySqlHelper
{
public string DBIpAddress
{
get;
set;
}
public string DatabaseName
{
get;
set;
}
public string UserName
{
get;
set;
}
public string Password
{
get;
set;
}
public int Port
{
get;
set;
}
private string connStr = null;
public MySqlHelper(string dbIpAddr, string dbName, string userName, string password,int port)
{
this.DBIpAddress = dbIpAddr;
this.DatabaseName = dbName;
this.UserName = userName;
this.Password = password;
this.Port = port;
this.BuildConnStr();
}
private void BuildConnStr()
{
this.connStr = String.Format("Database='{0}';Data Source='{1}';User Id='{2}';Password='{3}';charset='utf8';pooling=true;port='{4}'",
this.DatabaseName, this.DBIpAddress, this.UserName, this.Password,this.Port);
}
public int ExUpdate(string sql, MySqlParameter[] param)
{
try
{
using (var conn = new MySqlConnection(this.connStr))
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
if (param != null)
{
cmd.Parameters.AddRange(param);
}
conn.Open();
int result = cmd.ExecuteNonQuery();
return result;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return -1;
}
public DataSet ExSelect(string sql, MySqlParameter[] param)
{
using (var conn = new MySqlConnection(this.connStr))
{
try
{
DataSet ds = new DataSet();
MySqlCommand cmd = new MySqlCommand(sql, conn);
if (param != null)
{
cmd.Parameters.AddRange(param);
}
MySqlDataAdapter sda = new MySqlDataAdapter(cmd);
sda.Fill(ds);
return ds;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return null;
}
}
}