Пример #1
0
  // retrieve a user by id
  public User findUserById(int id) {
    User user = new User();

    String sql = "select * from user where id = ?";
    try {
      Connection connection = ds.getConnection();
      PreparedStatement statement = connection.prepareStatement(sql);
      statement.setInt(1, id);
      ResultSet result = statement.executeQuery();
      if (result.next()) {
        user.setId(result.getInt("id"));
        user.setEmail(result.getString("email"));
        user.setFirstName(result.getString("firstName"));
        user.setLastName(result.getString("lastName"));
        user.setUsername(result.getString("username"));
        user.setPassword(result.getString("password"));
      }

      sql = "select * from likes, movie where likes.userId = ? and movie.id=likes.movieId";
      statement = connection.prepareStatement(sql);
      statement.setInt(1, user.getId());
      ResultSet results = statement.executeQuery();
      List<Movie> movies = new ArrayList<Movie>();
      while (results.next()) {
        Movie movie = new Movie();
        movie.setId(results.getInt("id"));
        movie.setTitle(results.getString("title"));
        movie.setMovieId(results.getString("movieId"));
        movies.add(movie);
      }
      user.setLikes(movies);

    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
    return user;
  }
Пример #2
0
 // retrieve all users
 public List<User> findAllUsers() {
   List<User> movies = new ArrayList<User>();
   String sql = "select * from user";
   try {
     Connection connection = ds.getConnection();
     PreparedStatement statement = connection.prepareStatement(sql);
     ResultSet results = statement.executeQuery();
     while (results.next()) {
       User user = new User();
       user.setId(results.getInt("id"));
       user.setFirstName(results.getString("firstName"));
       user.setLastName(results.getString("lastName"));
       user.setUsername(results.getString("username"));
       user.setPassword(results.getString("password"));
       user.setEmail(results.getString("email"));
       movies.add(user);
     }
   } catch (SQLException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
   }
   return movies;
 }