<%@ page errorPage="errorpage.jsp"%> <%@ page language="java" contentType="text/html"%> <%@ page import="java.sql.*" %> <%@ page import="java.util.*" %> <%@ include file="includes\connectionToDB.jsp" %> <%@ include file="includes\checkForCookie.jsp" %> RSS PORTAL SYSTEM <%@ include file="includes\colourScheme.jsp" %> <%@ include file="includes\title.jsp" %> <%@ include file="includes\menu.jsp" %> <%@ include file="includes\welcome.jsp" %> <% // USER IS LOGGED IN // if(session.getAttribute( "username" ) != null) { String userName = session.getAttribute( "username" ).toString(); Statement s_getDefaultFeed = con.createStatement(); ResultSet rs_getDefaultFeed = s_getDefaultFeed.executeQuery("SELECT u.feedurl FROM WebsiteUser w JOIN UserFeed u ON w.defaultFeed = u.Feedid WHERE username = '"+userName+"';"); boolean defaultSet = false; String defaultUrl = ""; String feedDetailContent = ""; while(rs_getDefaultFeed.next()) { defaultUrl = rs_getDefaultFeed.getString(1); defaultSet = true; } if(defaultSet) { feedDetailContent = ""; } else if(!defaultSet) { feedDetailContent = ""; } out.print(""+ ""+ ""+ ""+ ""+ ""+ "
"+ ""+ ""+ ""+ ""+ ""+ ""+ ""+ "
"+ "
Feed Detail
"+ "
"+ ""); Statement s_getCatList = con.createStatement(); ResultSet rs_getCatList = s_getCatList.executeQuery("SELECT CatName, CatID FROM Category WHERE Username = '"+userName+"';"); while(rs_getCatList.next()) { out.print(""+ ""+ ""+ ""+ ""+ ""+ "
"+ ""); } out.print(""+ "
"+ "		"+ ""+ ""+ ""+ ""+ ""+ ""+ ""+ "
"+ "
Your Feeds
"+ "
"+ "
"+feedDetailContent+"
"+ "
"+ "
"+ "
"+ ""); } else { %> <%@ include file="includes\login.jsp" %> <% } %>