/**
* 得到
*
* @param top
* @param where
*/
public List<Blog> GetBlogListByWhere(String limit, String where, String[] args) {
List<Blog> listBlog = new ArrayList<Blog>();
String orderBy = "BlogID desc";
Cursor cursor = db.query(Config.DB_BLOG_TABLE, null, where, args, null, null, orderBy, limit);
while (cursor != null && cursor.moveToNext()) {
Blog entity = new Blog();
String addTimeStr = cursor.getString(cursor.getColumnIndex("Published"));
Date addTime = AppUtil.ParseDate(addTimeStr);
entity.SetAddTime(addTime);
entity.SetAuthor(cursor.getString(cursor.getColumnIndex("AuthorName")));
entity.SetAuthorUrl(cursor.getString(cursor.getColumnIndex("AuthorUrl")));
entity.SetAvator(cursor.getString(cursor.getColumnIndex("AuthorAvatar")));
entity.SetBlogContent(cursor.getString(cursor.getColumnIndex("Content")));
entity.SetBlogId(cursor.getInt(cursor.getColumnIndex("BlogId")));
entity.SetBlogTitle(cursor.getString(cursor.getColumnIndex("BlogTitle")));
String blogUrl = "";
if (cursor.getString(cursor.getColumnIndex("BlogUrl")) != null) {
blogUrl = cursor.getString(cursor.getColumnIndex("BlogUrl"));
}
entity.SetBlogUrl(blogUrl);
entity.SetCateId(cursor.getInt(cursor.getColumnIndex("CateId")));
String cateName = "";
if (cursor.getString(cursor.getColumnIndex("CateName")) != null) {
cateName = cursor.getString(cursor.getColumnIndex("CateName"));
}
entity.SetCateName(cateName);
entity.SetCommentNum(cursor.getInt(cursor.getColumnIndex("Comments")));
entity.SetDiggsNum(cursor.getInt(cursor.getColumnIndex("Digg")));
boolean isFull = cursor.getString(cursor.getColumnIndex("IsFull")).equals("1");
entity.SetIsFullText(isFull);
entity.SetSummary(cursor.getString(cursor.getColumnIndex("Summary")));
Date updateTime = new java.util.Date();
if (cursor.getString(cursor.getColumnIndex("Updated")) != null) {
updateTime = AppUtil.ParseDate(cursor.getString(cursor.getColumnIndex("Updated")));
}
entity.SetUpdateTime(updateTime);
entity.SetViewNum(cursor.getInt(cursor.getColumnIndex("View")));
boolean isRead = cursor.getString(cursor.getColumnIndex("IsReaded")).equals("1");
entity.SetIsReaded(isRead);
entity.SetUserName(cursor.getString(cursor.getColumnIndex("UserName")));
listBlog.add(entity);
}
cursor.close();
return listBlog;
}
