Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class populatingLectures extends ListActivity{
- private static String[] FROM = {SUBJECT, TOPIC, LECTURENUMBER, DATE };
- private static int[] TO = {R.id.subject, R.id.topic,
- R.id.lecturenumber, R.id.date };
- private static String[] data = { SUBJECT, TOPIC, LECTURENUMBER, _DATA };
- private static String ORDER_BY = DATE + " DESC";
- private SoftCopyDatabase lectures;
- String gotId;
- @Override
- public void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- SoftCopyDatabase lectures = new SoftCopyDatabase(this);
- try {
- Cursor cursor = getLectures();
- showLectures(cursor);
- } finally {
- lectures.close();
- }
- }
- public void onStart() {
- super.onStart();
- lectures = new SoftCopyDatabase(this);
- try {
- Cursor cursor = getLectures();
- showLectures(cursor);
- } finally {
- lectures.close();
- }
- }
- private Cursor getLectures() {
- SQLiteDatabase db = lectures.getReadableDatabase();
- Cursor cursor = db.query(TABLE_NAME,null, "subject=?", new String[] {OpenClick.subjectName}, null, null,
- ORDER_BY);
- startManagingCursor(cursor);
- return cursor;
- }
- private void showLectures(Cursor cursor) {
- SimpleCursorAdapter adapter = new SimpleCursorAdapter(this,
- R.layout.item_lectures, cursor, FROM, TO);
- setListAdapter(adapter);
- }
- private Cursor getFileName(String ID) {
- SQLiteDatabase db = lectures.getReadableDatabase();
- Cursor cursor = db.query(TABLE_NAME, data, "_ID=?",
- new String[] { ID }, null, null, null);
- startManagingCursor(cursor);
- return cursor;
- }
- @Override
- protected void onListItemClick(ListView listView, View view, int position,
- long id) {
- super.onListItemClick(listView, view, position, id);
- //...CODE TO START NEW ACTIVITY
- }
- }
- }
- finally {
- lectures.close();
- }
- lectures.close()
Add Comment
Please, Sign In to add comment