/// <summary>
/// getArrayResult: 得到数组结果集
/// </summary>
/// <param name="sql">要执行的sql语句</param>
/// <returns></returns>
public override ArrayList getArrayListResult(string sql)
{
ArrayList dataSrc = null;
DBUtil.onExecSqlBefore(_CLASS, "getArrayListResult", sql);
try
{
using (MySqlConnection sqlConn = new MySqlConnection(dbInfo.toMyConnectionString()))
{
sqlConn.Open();
MySqlCommand sqlComm = sqlConn.CreateCommand();
sqlComm.CommandText = sql;
using (IDataReader dr = sqlComm.ExecuteReader(CommandBehavior.Default))
{
dataSrc = DBUtil.DataReaderToArrayList(dr);
dr.Close();
}
sqlConn.Close();
}
}
catch (Exception ex)
{
DBUtil.onExecSqlError(_CLASS, "getArrayListResult", sql, ex.Message);
}
return(dataSrc);
}
/// <summary>
/// execArrayList: 执行sql语句并得到ArrayList形式的结果集, ArrayList中每一个元素都是一个ArrayList的对象, 二这个对象中又是每一行数据是字符串数组(string [] row)的集合
/// </summary>
/// <param name="sql">要执行的sql语句</param>
/// <returns>ArrayList对象</returns>
public ArrayList execArrayList(string sql)
{
ArrayList dataSrc = null;
try {
DBUtil.onExecSqlBefore(_CLASS, "execArrayList", sql);
cmd.CommandText = @sql;
state = ConnectionState.Executing;
using (MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.Default))
{
dataSrc = DBUtil.DataReaderToArrayList(dr);
dr.Close();
}
}catch (Exception e) {
DBUtil.onExecSqlError(_CLASS, "execArrayList", sql, e.Message);
}
return(dataSrc);
}