public void cadastro(Cliente cliente) {
String sql =
"insert into cliente "
+ "(nome,cpf,telefone,email,endereco,numeroCartao,bandeira,codigoVerificacao,validade,senha)"
+ " values(?,?,?,?,?,?,?,?,?,?)";
try {
PreparedStatement stmt = connection.prepareStatement(sql);
stmt.setString(1, cliente.getNome());
stmt.setString(2, cliente.getCpf());
stmt.setString(3, cliente.getTelefone());
stmt.setString(4, cliente.getEmail());
stmt.setString(5, cliente.getEndereco());
stmt.setString(6, cliente.getNumeroCartao());
stmt.setString(7, cliente.getBandeira());
stmt.setString(8, cliente.getCodigoVerificacao());
stmt.setString(9, cliente.getValidade());
stmt.setString(10, cliente.getSenha());
stmt.execute();
stmt.close();
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
