Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public Cliente getCpf(String cpf) {
- String sql = "SELECT * FROM Cliente as C JOIN Pessoa as P ON P.cod_pessoa = C.cod_pessoa JOIN Endereco as E ON P.cod_endereco = E.cod_endereco where c.cpf = ?";
- try{
- Connection conexao = DriverManager.getConnection(
- "jdbc:postgresql://200.129.242.4:55432/mauricio030", "mauricio030", "123456");
- PreparedStatement ps = conexao.prepareStatement(sql);
- ps.setString(6, cpf);
- ResultSet rs = ps.executeQuery();
- if(rs.next()){
- Cliente c = new Cliente();
- c.setCod_cliente(rs.getInt("cod_cliente"));
- c.setDinheiro(rs.getFloat("dinheiro"));
- c.setCpf(rs.getString("cpf"));
- c.setNome(rs.getString("nome"));
- c.setTelefone(rs.getString("telefone"));
- java.util.Date data = new java.util.Date(rs.getDate("data_nascimento").getTime());
- c.setData_nascimento(data);
- c.setIdade(rs.getInt("idade"));
- c.endereco = new Endereco();
- c.endereco.setCep(rs.getString("cep"));
- c.endereco.setRua(rs.getString("rua"));
- c.endereco.setNumero(rs.getString("numero"));
- c.endereco.setBairro(rs.getString("bairro"));
- c.endereco.setCidade(rs.getString("cidade"));
- return c;
- }
- conexao.close();
- } catch (Exception erro) {
- erro.printStackTrace();
- }
- return null;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement