public static ArrayList<Electrodomestico> getAllElectrodomestico(int montoMin,int montoMax,char consumo)
	{
		ArrayList<Electrodomestico> colElectrodomestico=new ArrayList<Electrodomestico>();
		String sqlFiltros="";
		if(montoMin>0)
			sqlFiltros=sqlFiltros.concat(" and preciobase>"+montoMin+" ");
		if(montoMax>0)
			sqlFiltros=sqlFiltros.concat(" and preciobase<"+montoMax+" ");
		if(consumo!=' ')
		{
			sqlFiltros=sqlFiltros.concat(" and consumo='"+consumo+"' ");
		}
		try {
			Connection con = conexion.conectarDB();

			Statement sql = con.createStatement();
			ResultSet cmd=sql.executeQuery("Select * from electrodomestico where tipo is not null  "+sqlFiltros+" order by descripcion;");
			while(cmd.next())
			{
				if(cmd.getString("Tipo").equals("Lavarropas"))
						{
					Lavarropas lav = new Lavarropas(cmd.getInt("carga"),  cmd.getInt("preciobase"), cmd.getString("color"), cmd.getString("consumo").charAt(0),  cmd.getInt("peso"));
					lav.setCodElectrodomestico(cmd.getInt("idelectrodomestico"));
					lav.setDescripcion(cmd.getString("descripcion"));
					lav.setTipo(cmd.getString("Tipo"));
					colElectrodomestico.add(lav);
						}
					else
						{
						Boolean sin=false;
						if(cmd.getInt("tdt")>0)
						sin=true;
						Television tel = new Television(cmd.getInt("pulgadas"), sin, cmd.getInt("preciobase"), cmd.getString("color"), cmd.getString("consumo").charAt(0),  cmd.getInt("peso"));
						tel.setCodElectrodomestico(cmd.getInt("idelectrodomestico"));
						tel.setDescripcion(cmd.getString("descripcion"));
						tel.setTipo(cmd.getString("Tipo"));
						colElectrodomestico.add(tel);
						}
					
					
				
				
				
			}
		
		} catch (Exception ex) {
			// TODO Auto-generated catch block
			JOptionPane.showMessageDialog(null,ex.getMessage());
		}
		return colElectrodomestico;
	}