Android Open Source - RSS-Steam S Q Lite Helper

From Project

Back to project page RSS-Steam.

License

The source code is released under:

Apache License

If you think the Android project RSS-Steam listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

package com.jddmxgg.ofertassteam;
/*from   w w w .j a  va2s .  c  om*/
import java.util.ArrayList;
import java.util.List;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class SQLiteHelper extends SQLiteOpenHelper
{

  String mCreateTable = "CREATE TABLE FEED(id INTEGER, title TEXT, description BLOB, link TEXT, month TEXT, day TEXT, color TEXT, PRIMARY KEY(id))";

  public SQLiteHelper(Context context, String name, CursorFactory factory, int version)
  {
    super(context, name, factory, version);
  }

  @Override
  public void onCreate(SQLiteDatabase db)
  {
    db.execSQL(mCreateTable);
  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
  {
    db.execSQL("DROP TABLE IF EXISTS FEED");
    db.execSQL(mCreateTable);
  }

  public List<RssItem> getValues()
  {
    List<RssItem> items = new ArrayList<RssItem>();

    String selectQuery = "SELECT * FROM FEED";
    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);
    if (cursor.moveToFirst())
    {
      do
      {
        RssItem item = new RssItem(cursor.getString(1), cursor.getString(3), cursor.getString(2), cursor.getString(4), cursor.getString(5), cursor.getString(6));
        items.add(item);
      } while (cursor.moveToNext());
    }

    cursor.close();
    return items;
  }

  public void insertValues(List<RssItem> items)
  {
    ContentValues cv = new ContentValues();

    SQLiteDatabase db = this.getWritableDatabase();
    db.execSQL("DROP TABLE IF EXISTS FEED");
    db.execSQL(mCreateTable);

    for (RssItem item : items)
    {
      cv.put("title", item.getTitle());
      cv.put("description", item.getDescription());
      cv.put("link", item.getLink());
      cv.put("month", item.getMonth());
      cv.put("day", item.getDay());
      cv.put("color", item.getColor());
      db.insert("FEED", null, cv);
    }
//    db.close();
  }
}

Java Source Code List