示例#1
0
  public List<ClientBean> getClients() {
    String query = "select id, firstname, lastname, email, phonenumber from clients;";
    Statement statement = null;
    try {
      statement = connection.createStatement();
      final ResultSet resultSet = statement.executeQuery(query);
      List<ClientBean> result = new ArrayList<>();
      boolean hasNext = resultSet.first();
      while (hasNext) {
        int id = resultSet.getInt(1);
        ClientBean client = new ClientBean(id);
        String firstName = resultSet.getString(1);
        client.setFirstName(firstName);
        String lastName = resultSet.getString(2);
        client.setLastName(lastName);
        String email = resultSet.getString(3);
        client.setEmail(email);
        String phoneNumber = resultSet.getString(4);
        client.setPhone(phoneNumber);
        result.add(client);
        hasNext = resultSet.next();
      }
      return result;

    } catch (SQLException e) {
      e.printStackTrace();
    }

    return new ArrayList<>();
  }
示例#2
0
  public ClientBean getClient(int id) {
    String query = "select id, firstname, lastname, email, phonenumber from clients where id=?;";
    try {
      final PreparedStatement preparedStatement = connection.prepareStatement(query);
      preparedStatement.setInt(1, id);
      final ResultSet resultSet = preparedStatement.executeQuery();
      if (resultSet.first()) {
        ClientBean client = new ClientBean(id);
        String firstName = resultSet.getString(2);
        client.setFirstName(firstName);
        String lastName = resultSet.getString(3);
        client.setLastName(lastName);
        String email = resultSet.getString(4);
        client.setEmail(email);
        String phoneNumber = resultSet.getString(5);
        client.setPhone(phoneNumber);
        return client;
      }

    } catch (SQLException e) {
      e.printStackTrace();
    }
    return new ClientBean();
  }