1 files changed, 34 insertions, 1 deletions
diff --git a/src/org/fox/ttrss/HeadlinesFragment.java b/src/org/fox/ttrss/HeadlinesFragment.java
index 08a70e10..cc1b0aac 100644
--- a/src/org/fox/ttrss/HeadlinesFragment.java
+++ b/src/org/fox/ttrss/HeadlinesFragment.java
@@ -3,22 +3,47 @@ package org.fox.ttrss;
 import android.app.Activity;
 import android.app.Fragment;
 import android.content.SharedPreferences;
+import android.database.Cursor;
+import android.database.sqlite.SQLiteDatabase;
 import android.os.Bundle;
 import android.preference.PreferenceManager;
 import android.view.LayoutInflater;
 import android.view.View;
 import android.view.ViewGroup;
+import android.widget.AbsListView;
+import android.widget.ListView;
+import android.widget.SimpleCursorAdapter;
 
 public class HeadlinesFragment extends Fragment {
 	private final String TAG = this.getClass().getSimpleName();
 	protected int m_feedId;
 	protected SharedPreferences m_prefs;
-
+	protected SQLiteDatabase m_db;
+	protected Cursor m_cursor;	
+	protected SimpleCursorAdapter m_adapter;
+	
 	@Override
 	public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {    	
 
 		View view = inflater.inflate(R.layout.headlines_fragment, container, false);
 
+		DatabaseHelper helper = new DatabaseHelper(getActivity());
+
+		m_db = helper.getReadableDatabase();		
+		m_cursor = m_db.query("articles", null, "feed_id = ?", new String[] { String.valueOf(m_feedId) }, null, null, "updated DESC");
+		
+		m_adapter = new SimpleCursorAdapter(getActivity(), R.layout.headlines_row, m_cursor,
+				new String[] { "title", "excerpt" }, new int[] { R.id.title, R.id.excerpt }, 0);
+
+		ListView list = (ListView) view.findViewById(R.id.headlines);
+		
+		if (list != null) {
+			list.setAdapter(m_adapter);		
+			//list.setOnItemClickListener(this);
+			list.setEmptyView(view.findViewById(R.id.no_headlines));
+			//list.setChoiceMode(AbsListView.CHOICE_MODE_SINGLE);
+		}
+
 		return view;    	
 	}
 
@@ -29,6 +54,14 @@ public class HeadlinesFragment extends Fragment {
 		m_prefs = PreferenceManager.getDefaultSharedPreferences(getActivity().getApplicationContext());
 	}
 
+	@Override
+	public void onDestroy() {
+		super.onDestroy();
+
+		m_cursor.close();
+		m_db.close();
+	}
+
 	public void initialize(int feedId) {
 		m_feedId = feedId;
 	}