public List<Lanche> listar(String nome) throws SQLException {
        String sql = "select * from lanches where lan_nome ilike ? order by lan_nome";
        PreparedStatement pstmt = this.conexao.prepareStatement(sql);
        pstmt.setString(1, nome);

        ResultSet rs = pstmt.executeQuery();
        List<Lanche> lanches = new ArrayList<>();

        while (rs.next()) {
            Lanche lanche = new Lanche();
            lanche.setId(rs.getInt("lan_id"));
            lanche.setNome(rs.getString("lan_nome"));
            lanche.setIngredientes(rs.getString("lan_ingredientes"));
            lanche.setValor(rs.getDouble("lan_valor"));
            lanches.add(lanche);
        }
        rs.close();
        pstmt.close();
        return lanches;
    }