// 根据推荐的movie的ID,获得movie的详细信息 public ArrayList<MovieInfo> getMovieByMovieId(List<RecommendedItem> recommendations) { ArrayList<MovieInfo> movieList = new ArrayList<MovieInfo>(); try { String sql = ""; conn = ConnectToMySQL.getConnection(); for (int i = 0; i < recommendations.size(); i++) { sql = "select m.name,m.published_year,m.type from movies m where m.id=" + recommendations.get(i).getItemID() + ""; ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { MovieInfo movieInfo = new MovieInfo(); movieInfo.setName(rs.getString(1)); movieInfo.setPublishedYear(rs.getString(2)); movieInfo.setType(rs.getString(3)); movieInfo.setPreference(recommendations.get(i).getValue()); movieList.add(movieInfo); } } } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } finally { closeAll(); } return movieList; }
// 根据用户的id,获得用户的所有电影 public ArrayList<MovieInfo> getMovieByUserId(long userID) { ArrayList<MovieInfo> movieList = new ArrayList<MovieInfo>(); try { String sql = "select m.name,m.published_year,m.type,mp.preference from movie_preferences mp,movies m where mp.movieID=m.id and mp.userID=" + userID + " order by preference desc"; conn = ConnectToMySQL.getConnection(); ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { MovieInfo movieInfo = new MovieInfo(); movieInfo.setName(rs.getString(1)); movieInfo.setPublishedYear(rs.getString(2)); movieInfo.setType(rs.getString(3)); movieInfo.setPreference(rs.getInt(4)); movieList.add(movieInfo); } } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } finally { closeAll(); } return movieList; }
// 根据推荐的movie的ID,获得movie的详细信息 public ArrayList<MovieInfo> getMovieByMovieId(int id) { ArrayList<MovieInfo> movieList = new ArrayList<MovieInfo>(); try { conn = ConnectToMySQL.getConnection(); String sql = "select m.name,m.published_year,m.type from movies m where m.id=" + id + ""; ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { MovieInfo movieInfo = new MovieInfo(); movieInfo.setName(rs.getString(1)); movieInfo.setPublishedYear(rs.getString(2)); movieInfo.setType(rs.getString(3)); movieInfo.setPreference(5.0); movieList.add(movieInfo); } } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } finally { closeAll(); } return movieList; }