public Data select(String query, Data data) { cmd = null; Data result = new Data(); cmd = new MySqlCommand(query, connect); String key = null; MySqlDbType types = MySqlDbType.VarChar; int size = -1; Object[] keys = data.getKeys(); Object value = null; int now = 0; if (keys != null) { int length = keys.Length; for (int i = 0; i < length; i++) { key = "@" + keys[i].ToString(); value = data.getValue(keys[i]); size = data.getSize(keys[i]); types = data.getType(keys[i]); if (size > 0) { cmd.Parameters.Add(key, types); } else { cmd.Parameters.Add(key, types, size); } cmd.Parameters[key].Value = value; } } read = cmd.ExecuteReader(); try { while (read.Read()) { int readCount = read.FieldCount; for (int i = 0; i < readCount; i++) { result.add(now, read.GetName(i), read.GetValue(i)); } ++now; } } catch (Exception e) { Console.WriteLine(e.Message); errorMsg = e.Message; } finally { if (cmd != null) { cmd.Parameters.Clear(); } if (read != null) { read.Close(); } } return result; }
//==============================================MySQL Commands===========================================// public int insert(string query, Data data) { cmd = null; int result = 0; cmd = new MySqlCommand(query, connect); string key = null; MySqlDbType types = MySqlDbType.VarChar; int size = -1; Object[] keys = data.getKeys(); object value = null; int length = keys.Length; if (keys != null) { for (int i = 0; i < length; i++) { key = "@" + keys[i].ToString(); value = data.getValue(keys[i]); size = data.getSize(keys[i]); types = data.getType(keys[i]); if (size > 0) { cmd.Parameters.Add(key, types); } else { cmd.Parameters.Add(key, types, size); } cmd.Parameters[key].Value = value; } } result = cmd.ExecuteNonQuery(); cmd.BeginExecuteNonQuery(); return result; }