public List listaCliente(String nome){
        ResultSet rs;
        List lista = new ArrayList();
        String sql = "SELECT * FROM cliente WHERE NOME like '%"+ nome +"%' ORDER BY NOME";
        try{
            stmt = Myconnection.getStatement();
            rs = stmt.executeQuery(sql);
            while(rs.next()){
                                 
                Cliente m = new Cliente(rs.getString("NOME"), rs.getString("ENDERECO"),rs.getString("TELEFONE"));
                int id = Integer.parseInt(rs.getString("id"));
//                System.out.println(rs.getString("NOME"));
//                System.out.println(rs.getString("ENDERECO"));
//                System.out.println(rs.getString("TELEFONE"));
                m.setId(id);
                lista.add(m);
            }
            stmt.close();
        }catch(Exception e){
            System.err.println(e.getClass().getName() + ": " + e.getMessage());
        }            
        return lista;
    }