KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > h2 > samples > Newsfeed


1 /*
2  * Copyright 2004-2006 H2 Group. Licensed under the H2 License, Version 1.0 (http://h2database.com/html/license.html).
3  * Initial Developer: H2 Group
4  */

5 package org.h2.samples;
6
7 import java.io.FileOutputStream JavaDoc;
8 import java.io.InputStream JavaDoc;
9 import java.io.InputStreamReader JavaDoc;
10 import java.io.OutputStreamWriter JavaDoc;
11 import java.io.Writer JavaDoc;
12 import java.sql.Connection JavaDoc;
13 import java.sql.DriverManager JavaDoc;
14 import java.sql.ResultSet JavaDoc;
15
16 import org.h2.tools.RunScript;
17 import org.h2.util.StringUtils;
18
19 public class Newsfeed {
20     public static void main(String JavaDoc[] args) throws Exception JavaDoc {
21         Class.forName("org.h2.Driver");
22         Connection JavaDoc conn = DriverManager.getConnection("jdbc:h2:mem:", "sa", "");
23         InputStream JavaDoc in = Newsfeed.class.getResourceAsStream("newsfeed.sql");
24         ResultSet JavaDoc rs = RunScript.execute(conn, new InputStreamReader JavaDoc(in, "ISO-8859-1"));
25         while(rs.next()) {
26             String JavaDoc file = rs.getString("FILE");
27             String JavaDoc content = rs.getString("CONTENT");
28             if(file.equals("-newsletter-")) {
29                 System.out.println(convertHtml2Text(content));
30             } else {
31                 FileOutputStream JavaDoc out = new FileOutputStream JavaDoc(file);
32                 Writer JavaDoc writer = new OutputStreamWriter JavaDoc(out, "UTF-8");
33                 writer.write(content);
34                 writer.close();
35                 out.close();
36             }
37         }
38         conn.close();
39     }
40
41     private static String JavaDoc convertHtml2Text(String JavaDoc html) {
42         String JavaDoc s = html;
43         s = StringUtils.replaceAll(s, "<b>", "");
44         s = StringUtils.replaceAll(s, "</b>", "");
45         s = StringUtils.replaceAll(s, "<ul>", "");
46         s = StringUtils.replaceAll(s, "</ul>", "");
47         s = StringUtils.replaceAll(s, "<li>", "- ");
48         s = StringUtils.replaceAll(s, "<a HREF=\"", "( ");
49         s = StringUtils.replaceAll(s, "\">", " ) ");
50         s = StringUtils.replaceAll(s, "</a>", "");
51         s = StringUtils.replaceAll(s, "<br>", "");
52         if(s.indexOf('<') >= 0 || s.indexOf('>') >= 0) {
53             throw new Error JavaDoc("Unsupported HTML Tag: < or > in " + s);
54         }
55         return s;
56     }
57 }
58
Popular Tags