jsp+mysql+css电影评价个性化推荐系统

主页

登录

用户个人信息管理


检索

个性化推荐

	Statement statement4 = conn.createStatement();
			String sql4 = "SELECT action,science,sciencefiction,adventure,comedy,thriller,terror from boswerrecord where id="+ id + "";
			System.out.println(sql4);
			ResultSet rs4 = statement4.executeQuery(sql4);
			ResultSetMetaData data = rs4.getMetaData();
			String[] listname = new String[10];
			int[] list = new int[10];
			int m = 0;
			int n = 1;
            while(rs4.next()){
			
			while (m < 7) {
				list[m] = rs4.getInt(n);
				m++;
				n++;
			}
			;
			int t, p, q;
			t=0;
			for (p = 0; p < 6; p++) {
				for(q=1;q<7;q++) {
					if(list[p]<list[q]){
					t = list[q];
					list[q] = list[p];
					list[p] = t;}
				}

			};
			

			for (t = 0; t < 4; t++) {
				p = 1;
				while (p < 8) {
					if (rs4.getInt(p) == list[t]) {
						listname[t] = data.getColumnName(p);
					}
					p=p+1;
				}
			}};rs4.close();

            
			String f1 = listname[0];
			String f2 = listname[1];
			String f3 = listname[2];
			String f4 = listname[3];
			
           
			//查询浏览次数
			Statement statement6 = conn.createStatement();
			String sql6="select * from record where id="+id+"";	
			ResultSet rs6 =statement6.executeQuery(sql6);
			
		
			Integer u=2;
			double avg=0.0;
			ResultSetMetaData data6 = rs6.getMetaData();
			String[] filmname=new String[100];
			int v=2,s=0;
			String ssql="";
		
			
			while(rs6.next()){
				//计算平均值
				for(;u<17;u++){
					avg=avg+rs6.getInt(u);
					};
					avg=avg/18;	
					System.out.print(avg);
				for(;v<16;v++){
				if(rs6.getInt(v)>avg){
					filmname[s]=data6.getColumnName(v);
					System.out.println(filmname[s]);
					if(s==0){
						ssql="filmname<>'"+filmname[0]+"'";
						
					}else{
						ssql=ssql+" AND "+" filmname<> '"+filmname[s]+"' ";
						
					}
					s++;
				}else{};
			};System.out.println(ssql);};
				rs6.close();
			
				
				
			
			
			

				Statement statement5 = conn.createStatement();
				String sql5 = "select * from film where (tag1= '" + f1 + "' or tag1= '" + f2 + "' or tag1= '" + f3 + "' or tag1= '"
						+ f4 + "' or tag2= '" + f1 + "' or tag2= '" + f2 + "' or tag2= '" + f3 + "' or tag2= '" + f4 + "') AND "+ssql+"";
				System.out.println(sql5);
				ResultSet rs5 = statement5.executeQuery(sql5);
				int r = 0;
				while (rs5.next() && r < 5) {
			
            
            	 
			%>
			<div class="movie">

				<a href="movie1.jsp?id=${param.id}&filmid=<%=rs5.getString(1)%>"><img
					src="<%=rs5.getString(9)%>"><br> <Strong>filmname:<%=rs5.getString(2)%></Strong><br>
					filmyear:<%=rs5.getString(5)%><br>
					filmgrade:<%=rs5.getString(4)%></a><br>


			</div>
			<br>
			<%
				r = r + 1;
					}
					;
					rs5.close();
                   
			%>
			

分页