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;
}
