<%@ page import="java.io.File" %> <%@ page import="java.sql.Connection" %> <%@ page import="java.util.List" %> <%@ page import="org.crosswire.data.DataObject" %> <%! public static class CrossNews extends DataObject { public CrossNews() {} @Override public synchronized Connection getDBConnection() { return DataObject.getDefaultDBConnection("crossNews"); } } %> The SWORD Project <% String spsection="news"; %> <%@ include file="include/sword_header.jsp" %>

News Archives

<% try { CrossNews query = new CrossNews(); List newsItems = query.getDataSet("SELECT NEWSID, CATNAME, IMAGEURL, NEWSDATE, AUTHOR, SUBJECT, DETAILS FROM NEWSITEM, CATEGORY WHERE CATEGORY.CATID = NEWSITEM.CATID ORDER BY NEWSDATE DESC"); int i = 0; for (CrossNews newsItem : newsItems) { boolean hasImage = false; String imgURL = newsItem.getStringValue("IMAGEURL"); if (imgURL != null) { imgURL = imgURL.trim(); if (imgURL.length() > 2) hasImage = true; } if (i >= 10) { %> <% } ++i; } } catch (Exception e) { e.printStackTrace(); } %>

<%= newsItem.getStringValue("SUBJECT") %>
<%= (hasImage) ? (" ") : "" %>	Posted <%= newsItem.getStringValue("NEWSDATE") %> by, <%= newsItem.getStringValue("AUTHOR") %> <%= newsItem.getStringValue("DETAILS") %>

<%@ include file="include/sword_footer.jsp" %>