// 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;
}
// 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;
}