private List<Result> selectFrom(List<Column> column, String Where) { List<Result> resultado = new List<Result> (); String sql = getSelect (column, Where); MyConnection mc = MyConnection.GetInstance (); MySqlDataReader dataReader = mc.GetResult (sql); while (dataReader.Read()) { Result r = new Result(); foreach(Column cc in column){ Value v = new Value(); v.setColumn(cc); v.setValue(cc.type, dataReader[cc.name]); r.addValue(v); } resultado.Add(r); } dataReader.Close(); mc.CloseConnection (); return resultado; }
public void addValue(Value value) { this.value.Add(value); }