From 3b1023c45a919f25ef38c080f2ac2c0dc5d5e7ca Mon Sep 17 00:00:00 2001 From: "David A. Madore" Date: Sun, 28 Aug 2011 19:52:02 +0200 Subject: (Preliminary) handling of weblog entry selection and summary. --- org/madore/damlengine/WeblogSelect.java | 43 +++++++++++++++++++++++++++++++++ 1 file changed, 43 insertions(+) create mode 100644 org/madore/damlengine/WeblogSelect.java (limited to 'org/madore/damlengine/WeblogSelect.java') diff --git a/org/madore/damlengine/WeblogSelect.java b/org/madore/damlengine/WeblogSelect.java new file mode 100644 index 0000000..ad61cbc --- /dev/null +++ b/org/madore/damlengine/WeblogSelect.java @@ -0,0 +1,43 @@ +package org.madore.damlengine; + +import java.util.HashSet; +import java.util.ArrayList; +import java.sql.Connection; +import java.sql.PreparedStatement; +import java.sql.ResultSet; + +public final class WeblogSelect { + + private WeblogSelect() { // Forbid instantiation + throw new AssertionError("WeblogSelect cannot be instantiated"); + } + + public static void main(String[] args) + throws Exception { + + String year = "2011"; + String month = "08"; + + final Connection conn = WeblogDatabaseConnection.getConnection(); + + final PreparedStatement selSt + = conn.prepareStatement("SELECT id , content FROM entries WHERE edate LIKE ? ORDER BY id DESC"); + selSt.setString(1,year+"-"+month+"-__"); + + final ResultSet selRes = selSt.executeQuery(); + final Context.WeblogSelectionContext wsc + = new Context.WeblogMonthSelectionContext(year,month); + wsc.sel = new HashSet(); + wsc.xmlData = new ArrayList(); + while ( selRes.next() ) { + int id = selRes.getInt(1); + String content = selRes.getString(2); + wsc.sel.add(new Integer(id)); + wsc.xmlData.add(content); + } + + DamlEngine.fullProcess("weblog-month-template.daml", System.out, wsc); + + } + +} -- cgit v1.2.3