public static ArrayList<Television> getAllTelevision(int montoMin,int montoMax,char consumo)
	{
		ArrayList<Television> colElectrodomestico=new ArrayList<Television>();
		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='Television' "+sqlFiltros+";");
			while(cmd.next())
			{
				
					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;
	}