@Override public Client findClient(Integer codeClient) throws DAOException { Connection connection; Client client = new Client(); try { connection = JDBCUtil.getConnection(); PreparedStatement prepareStatement = connection.prepareStatement("SELECT * FROM Client c WHERE c.codecl=?"); prepareStatement.setInt(1, codeClient); ResultSet resultSet = prepareStatement.executeQuery(); resultSet.next(); client.setCodeClient(resultSet.getInt("codecl")); client.setNomClient(resultSet.getString("nomcl")); client.setAdresse(resultSet.getString("adresse")); client.setVille(resultSet.getString("ville")); } catch (InstantiationException | IllegalAccessException | ClassNotFoundException | SQLException e) { throw new DAOException(e.getMessage(), e.getCause()); } return client; }
@Override public List<Client> findAllByName() throws DAOException { Connection connection; List<Client> clients = new ArrayList<>(); try { connection = JDBCUtil.getConnection(); PreparedStatement prepareStatement = connection.prepareStatement("SELECT * FROM Client c ORDER BY c.nomcl"); ResultSet resultSet = prepareStatement.executeQuery(); while (resultSet.next()) { Client client = new Client(); client.setCodeClient(resultSet.getInt("codecl")); client.setNomClient(resultSet.getString("nomcl")); client.setAdresse(resultSet.getString("adresse")); client.setVille(resultSet.getString("ville")); clients.add(client); } } catch (InstantiationException | IllegalAccessException | ClassNotFoundException | SQLException e) { throw new DAOException(e.getMessage(), e.getCause()); } return clients; }