public String getRecommendListForCommonNeighbors() {
		String recommend = "";
		try {
			Class.forName("com.mysql.jdbc.Driver");
			connect = DriverManager.getConnection("jdbc:mysql://localhost/NETWORK_TEST?"
		              + "user=root&password=root");
			connect.setAutoCommit(false);
			statement = connect.createStatement();
			
			for (String node : this.nodeList) {
				String sql = "select g1.START_NODE as node, g2.START_NODE as recommend, count(*) as CNF "
						+ "from network_test." + this.table
						+ " as g1 join network_test." + this.table
						+ " as g2 where g1.START_NODE <> g2.START_NODE"
						+ " and g1.END_NODE = g2.END_NODE and g1.START_NODE = '" + node + "' "
						+ "and (g1.START_NODE, g2.START_NODE) not in (select * from network_test." + this.table
						+ ") group by g2.START_NODE order by CNF desc limit 10";
				resultSet = statement.executeQuery(sql);
				recommend += node + ":";
				while (resultSet.next()) {					
					String recommendNode = resultSet.getString("Recommend");
					recommend += recommendNode + ",";										
				}
				recommend += "\n";
			}			
			
			
			connect.commit();
			statement.close();
			connect.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		} finally {
			try {
				if(statement!=null)
					statement.close();
			} catch(SQLException se2) {
			}// nothing we can do
			try{
				if(connect!=null)
					connect.close();
			} catch(SQLException se) {
				se.printStackTrace();
			}
		}
		return recommend;
	}