jsp教材管理系统Myeclipse开发mysql数据库web结构java编程计算机网页项目源码

package com.util; import java.sql.ResultSet; import java.util.HashMap; import java.util.HashSet; import java.util.Iterator; import java.util.Map; import java.util.Set; //协同算法 public class Data { static String[] films =null;//{ "十面埋伏", "一路向北", "那些年我们一起追过的女孩", "CCAV", "非诚勿扰" };//用户 static String[] users = null;//{ "aaa", "bbb", "ccc", "ddd", "葛二蛋" }; 商品 static Map score = new HashMap(); static Set userSet = new HashSet(); static Set filmSet = new HashSet(); static { DBO db=new DBO(); String sql=""; ResultSet rs=null; ///商品 int i=0; sql="select * from jiaocai where 1=1"; try{ rs=db.query(sql); while(rs.next()){ userSet.add(rs.getString("jcid"));//商品 // users[i]=rs.getString("spid"); i++; } }catch(Exception e){ e.printStackTrace(); } users=new String[i-1]; sql="select * from xuesheng where 1=1"; i=0; try{ rs=db.query(sql); while(rs.next()){ filmSet.add(rs.getString("yhm"));//用户 //films[i]=rs.getString("yhm"); i++; } }catch(Exception e){ e.printStackTrace(); } films=new String[i-1]; score = getScore(); } public static String outNearbyUserList(String user) { DBO db=new DBO(); Map scores = new HashMap(); String sql=""; ResultSet rs=null; ///商品 int i=0; sql="select * from jiaocai where 1=1"; try{ rs=db.query(sql); while(rs.next()){ // userSet.add(rs.getString("spid"));//商品 // users[i]=rs.getString("spid"); // i++; if (rs.getString("jcid").equalsIgnoreCase(user)) { continue; } double score = getOSScore(user, rs.getString("jcid")); System.out.println("score="+score); scores.put(rs.getString("jcid"), String.valueOf(score)); } db.close(); }catch(Exception e){ e.printStackTrace(); } /* for (String tempUser : users) { if (tempUser.equalsIgnoreCase(user)) { continue; } double score = getOSScore(user, tempUser); System.out.println("score="+score); scores.put(tempUser, score); } */ System.out.println(scores.toString()); TreeMapTest mp=new TreeMapTest(); String a= mp.getMin(scores); System.out.println("a="+a); return a; } private static Double getOSScore(String user1, String user2) { HashMap user1Score = (HashMap) score.get(user1); HashMap user2Score = (HashMap) score.get(user2); double totalscore = 0.0; Iterator it = user1Score.keySet().iterator(); while (it.hasNext()) { String film = (String) it.next(); int a1 = (Integer) user1Score.get(film); int a2 = (Integer) user1Score.get(film); int b1 = (Integer) user2Score.get(film); int b2 = (Integer) user2Score.get(film); int a = a1 * a2 - b1 * b2; //System.out.println(Math.abs(a)); totalscore += Math.sqrt(Math.abs(a)); } return totalscore; } private static Map getScore() { Map score = new HashMap(); // aaa HashMap tempScore = null; DBO db=new DBO(); String sql="select * from jiaocai "; String sq=""; ResultSet rs=null; ResultSet r=null; ResultSet rr=null; db.open(); int num=0; try{ rs=db.query(sql); int j=0; while(rs.next()){ tempScore= new HashMap(); sql="select * from xuesheng "; db.open(); r=db.query(sql); while(r.next()){ sq="select count(1) as num from liulan where jc='"+rs.getString("jcid")+"' and yh='"+r.getString("yhm")+"'"; db.open(); rr=db.query(sq); if(rr.next()){ num=rr.getInt("num"); } tempScore.put(r.getString("yhm"), num); } score.put(rs.getString("jcid"), tempScore); j++; } }catch(Exception e){ e.printStackTrace(); }finally{ db.close(); } return score; } public static void main(String[] args) { // System.out.println( "1号 与其他人的相似度（分值越低越相似）："); Data.outNearbyUserList("11"); //Data.outNearbyUserList(Data.users[0].length()); } }