// 根据用户的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(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;
}
// 根据推荐的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;
}
// 关闭数据库
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();
}
}