/** rss item 문자열 생성 */ private static String rssItemStr(RssItem item) { StringBuilder buffer = new StringBuilder(); buffer.append(" "); // 들여쓰기용 buffer.append("<item>"); if (item.getTitle() != null && !"".equals(item.getTitle())) buffer.append("<title>" + "<![CDATA[" + item.getTitle() + "]]>" + "</title>"); if (item.getLink() != null && !"".equals(item.getLink())) buffer.append("<link>" + item.getLink() + "</link>"); if (item.getDescription() != null && !"".equals(item.getDescription())) buffer.append( "<description>" + "<![CDATA[" + item.getDescription().replaceAll(BR, "") + "]]>" + "</description>"); if (item.getAuthor() != null && !"".equals(item.getAuthor())) buffer.append("<author>" + item.getAuthor() + "</author>"); if (item.getCategory() != null && !"".equals(item.getCategory())) buffer.append("<category>" + "<![CDATA[" + item.getCategory() + "]]>" + "</category>"); if (item.getLink() != null && !"".equals(item.getLink())) buffer.append("<guid>" + item.getLink() + "</guid>"); if (item.getPubDate() != null) buffer.append("<pubDate>" + toRfc822DateFormat(item.getPubDate()) + "</pubDate>"); buffer.append("</item>"); return buffer.toString(); }
public boolean insertToDB(RssItem item) { // query if it already exit Cursor cursor = getContentResolver() .query( RSSApp.RssItems.CONTENT_URI, PROJECTION, RSSApp.RssItems.COLUMN_NAME_PUBDATE + "=" + "'" + item.getPubDate() + "'", null, null); int count = 0; if (cursor != null) { count = cursor.getCount(); } if (count == 0) { ContentValues values = new ContentValues(); values.put(RSSApp.RssItems.COLUMN_NAME_TITLE, item.getTitle()); values.put(RSSApp.RssItems.COLUMN_NAME_DESCRIPTION, item.getDescription()); values.put(RSSApp.RssItems.COLUMN_NAME_PUBDATE, item.getPubDate()); Uri newUri = getContentResolver().insert(RSSApp.RssItems.CONTENT_URI, values); if (newUri != null) { log("insertToDB: " + newUri); return true; } else { log("insertToDb: fail!"); } } else { mHandler.post( new Runnable() { @Override public void run() { Toast.makeText(getApplicationContext(), "no more update !", Toast.LENGTH_SHORT) .show(); } }); log("DB already has this record : title = " + item.getTitle()); } return false; }