コード例 #1
0
 // 根据用户的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;
 }
コード例 #2
0
 // 根据推荐的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;
 }
コード例 #3
0
 // 关闭数据库
 public void closeAll() {
   try {
     if (rs != null) {
       rs.close();
       rs = null;
     }
     if (ps != null) {
       ps.close();
       ps = null;
     }
     if (conn != null) {
       conn.close();
       conn = null;
     }
   } catch (Exception e) {
     // TODO: handle exception
     e.printStackTrace();
   }
 }
コード例 #4
0
  // 根据推荐的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;
  }