/** * 得到 * * @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; }