protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { int id = Integer.parseInt(request.getParameter("id")); String nome = request.getParameter("txt_nome"); String tel = request.getParameter("txt_tel"); int cep = Integer.parseInt(request.getParameter("endereco")); int bai = Integer.parseInt(request.getParameter("bairro")); int cid = Integer.parseInt(request.getParameter("cidade")); int numero = Integer.parseInt(request.getParameter("txt_num")); Cliente c = new Cliente(); Connection con = CriarConexao.getConexao(); ClienteDao dao = new ClienteDao(con); c.setId(id); c.setNome(nome); c.setTelefone(tel); c.setCep(cep); c.setBairro(bai); c.setCidade(cid); c.setNumero(numero); dao.atualizar(c); RequestDispatcher dispatcher = request.getRequestDispatcher("/List_cliente2"); request.setAttribute("msg", nome + " Atualizado com Sucesso"); dispatcher.forward(request, response); }
public void MenuCliente() { cli = new Cliente(); while (op != 4) { op = Integer.parseInt( JOptionPane.showInputDialog("1 - CPF \n2 - Conta\n 3 - Senha \n 4 - Finalizar ")); switch (op) { case 1: a = Double.parseDouble(JOptionPane.showInputDialog("Digite o cpf ")); cli.setCpf(a); break; case 2: contnumber = Integer.parseInt(JOptionPane.showInputDialog("Digite a conta ")); cli.setPassword(contnumber); break; case 3: pass = Integer.parseInt(JOptionPane.showInputDialog("Digite a senha ")); cli.setId(pass); break; case 4: break; default: JOptionPane.showMessageDialog(null, "Opcao Invalida"); break; } } c = new Conta(cli, 100); }
@Override public Ordine getOrdineByCodice(String codice) throws PersistenceException { Ordine ordine = null; Connection connection = this.datasource.getConnection(); PreparedStatement statement = null; try { String query = "select ordini.codice,ordini.id as id,data,stato,cliente,nome,partitaiva,indirizzo " + "from ordini LEFT OUTER JOIN clienti on cliente = clienti.id WHERE ordini.codice=?"; statement = connection.prepareStatement(query); statement.setString(1, codice); ResultSet result = statement.executeQuery(); if (result.next()) { ordine = new Ordine(); ordine.setCodiceOrdine(codice); ordine.setStato(result.getString("stato")); ordine.setId(result.getInt("id")); ordine.setData(new java.util.Date(result.getDate("data").getTime())); Cliente cliente = new Cliente(); cliente.setId(result.getInt("cliente")); cliente.setNome(result.getString("nome")); cliente.setIndirizzo(result.getString("indirizzo")); cliente.setPiva(result.getString("partitaiva")); ordine.setCliente(cliente); } } catch (SQLException e) { throw new PersistenceException(e.getMessage()); } finally { try { if (statement != null) statement.close(); if (connection != null) connection.close(); } catch (SQLException e) { throw new PersistenceException(e.getMessage()); } } return ordine; }