/// <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); }