package org.madore.damlengine; import java.util.HashMap; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public final class WeblogSummary { public static final class EntrySummary { int id; String date; String lang; String title; String titleXml; String doSinglePage; public EntrySummary(int id, String date, String lang, String title, String titleXml, String doSinglePage) { this.id = id; this.date = date; this.lang = lang; this.title = title; this.titleXml = titleXml; this.doSinglePage = doSinglePage; } } public HashMap entries; private static WeblogSummary singleton; private WeblogSummary() { this.entries = new HashMap(); } public static WeblogSummary getSummary() { if ( singleton != null ) return singleton; singleton = new WeblogSummary(); try { final Connection conn = WeblogDatabaseConnection.getConnection(); final PreparedStatement selSt = conn.prepareStatement("SELECT id , edate , lang , title , title_xml , do_single_page FROM entries"); final ResultSet selRes = selSt.executeQuery(); while ( selRes.next() ) { int id = selRes.getInt(1); String date = selRes.getString(2); String lang = selRes.getString(3); String title = selRes.getString(4); String titleXml = selRes.getString(5); String doSinglePage = selRes.getString(6); singleton.entries.put(new Integer(id), new EntrySummary(id, date, lang, title, titleXml, doSinglePage)); } } catch (SQLException e) { // Well, we'll have no summary. Too bad, but better than abort. singleton = null; } return singleton; } }