/// <summary>
/// 执行SQL文本
/// </summary>
/// <param name="resultProcess">执行结果处理</param>
/// <param name="address">地址</param>
/// <param name="port">端口</param>
/// <param name="charSet">字符集</param>
/// <param name="database">数据库</param>
/// <param name="userId">用户</param>
/// <param name="password">密码</param>
/// <param name="sqlText">SQL文本</param>
/// <param name="parameter">参数</param>
/// <returns>是否成功</returns>
public static bool Execute(Action <MySql.Data.MySqlClient.MySqlDataReader> resultProcess, string address, string port, string charSet, string database, string userId, string password, string sqlText, params object[] parameter)
{
return(DatabaseAssistant.DoExecute
(
() =>
{
MySql.Data.MySqlClient.MySqlDataReader reader = command.ExecuteReader();
int n = reader.FieldCount;
try
{
resultProcess(reader);
}
catch (Exception exception)
{
DatabaseAssistant.ReportException(exception);
}
reader.Close();
},
string.Format(DatabaseAssistant.ConnectionText, address, port, charSet, database, userId, password),
sqlText,
parameter
));
}
/// <summary>
/// 执行SQL文本
/// </summary>
/// <param name="address">地址</param>
/// <param name="port">端口</param>
/// <param name="charSet">字符集</param>
/// <param name="database">数据库</param>
/// <param name="userId">用户</param>
/// <param name="password">密码</param>
/// <param name="sqlText">SQL文本</param>
/// <param name="parameter">参数</param>
/// <returns>是否成功</returns>
public static bool Execute(string address, string port, string charSet, string database, string userId, string password, string sqlText, params object[] parameter)
{
return(DatabaseAssistant.DoExecute
(
() => { command.ExecuteNonQuery(); },
string.Format(DatabaseAssistant.ConnectionText, address, port, charSet, database, userId, password),
sqlText,
parameter
));
}