RSS Chomp

<%@ page contentType='text/html; charset=UTF-8' %> <%@page language="java"%><%@page language="java" import="java.util.*"%> <%@page language="java" import="java.io.*" %> <%@page language="java" import="java.sql.*" %> <%@page language="java" import="rsschomp.*" %> <%@page language="java" import="java.net.*" %> <%@page language="java" import="java.net.HttpURLConnection" %> <%@page language="java" import="java.net.URL" %> <%@page language="java" import="java.sql.*" %> <%@page language="java" import="java.io.InputStreamReader" %> <%@page language="java" import="javax.servlet.http.HttpServletRequest" %> <%@page language="java" import="java.nio.charset.Charset" %> <% response.setHeader("Cache-Control","no-cache"); //HTTP 1.1 response.setHeader("Pragma","no-cache"); //HTTP 1.0 response.setDateHeader ("Expires", 0); //prevents caching at the proxy server %> <% String sDBUID = "rsschomp_rsschom"; //user id for database... (root) String sDBPWD = "dominion1"; //database password. not user String sDBName = "rsschomp_rsschomp"; /* String sDBUID = "rsschomp_rsschom"; //user id for database... (root) String sDBPWD = "dominion1"; //database password. not user String sDBName = "rsschomp_rsschomp"; */ String sHostName = "localhost"; String sJDBCDriver = "com.mysql.jdbc.Driver"; String sConnectionString = "jdbc:mysql://"+sHostName+":3306/"+sDBName+"?autoReconnect=true"; int iItemsToShow = 12; int i = 0; String[] sTitle; sTitle = new String[iItemsToShow]; String[] sDesc; sDesc = new String[iItemsToShow]; String sFeed = ""; try{ Connection connection; Class.forName(sJDBCDriver).newInstance(); connection = DriverManager.getConnection("jdbc:mysql://" + sHostName + "/" + sDBName + "?user=" + sDBUID + "&password=" + sDBPWD+"&useUnicode=true&characterEncoding=utf8"); String sSQL=""; sSQL = "SELECT * FROM RSS_FEEDS "; sSQL += " WHERE ACTIVE = 'Y' "; sSQL += " ORDER BY CLICKS DESC limit "+iItemsToShow+" "; PreparedStatement ps; ps = connection.prepareStatement(sSQL); //ps.setString(1, sSearch); ResultSet rs =ps.executeQuery(); //now read the XML from our database while (rs.next()) { sTitle[i] = rs.getString("RSSName"); sTitle[i] = sTitle[i].replaceAll("&","&"); sDesc[i] = rs.getString("RSSDescription"); if (sDesc[i]==null){ sDesc[i] = ""; } i++; } connection.close(); } catch (Exception e){ out.println("Database connection error: "+e.getMessage()); } %> RSS Chomp

RSS Chomp [alpha]

Today's Top Articles

Top RSS Feeds

Chompable RSS

RSS Search

Google Search RSS Feeds

Top RSS Feeds

<% for (int j=0; j

<%=sTitle[j]%>
<%=sDesc[j]%>

<% }//end of if }//end of loop %>