Android Open Source - supersearch Searches Data

• Back to Development/tool  ↑

From Project

Back to project page supersearch.

License

The source code is released under:

GNU General Public License

Java Source Code

package org.lvlv.supersearch;
//from ww  w. ja  va  2 s .c  o  m
import android.database.sqlite.SQLiteOpenHelper;
import static android.provider.BaseColumns._ID;
import static org.lvlv.supersearch.Constants.TABLE_NAME;
import static org.lvlv.supersearch.Constants.NAME;
import static org.lvlv.supersearch.Constants.URL;
import static org.lvlv.supersearch.Constants.TERM;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;


public class SearchesData extends SQLiteOpenHelper {
  private static final String DATABASE_NAME = "searches.db";
  private static final int DATABASE_VERSION = 1;
  
  public SearchesData(Context ctx) {
    super(ctx, DATABASE_NAME, null, DATABASE_VERSION );
  }
  
  @Override
  public void onCreate(SQLiteDatabase db) {
    db.execSQL("CREATE TABLE "+ TABLE_NAME + " (" 
        + _ID  + " INTEGER PRIMARY KEY AUTOINCREMENT, "
        + NAME + " VARCHAR(25) NOT NULL, "
        + URL  + " VARCHAR(255) NOT NULL, "
        + TERM + " VARCHAR(25) DEFAULT 'Search');"
    );
  }
  
  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
    onCreate(db);
  }
  
  public void addSearch(String name, String url, String term) {
    // I guess Java  doesn't have defaults
    if (term.equals("")) {
      term = "Search";
    }
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(NAME, name);
    values.put(URL, url);
    values.put(TERM, term);
    db.insertOrThrow(TABLE_NAME, null, values);
  }
  
  public void deleteSearch(int id) {
       SQLiteDatabase db = this.getWritableDatabase();
       db.delete(
           TABLE_NAME, 
           "_ID = ?", 
           new String[] {String.valueOf(id)}
       );
  }
  
  public void updateSearch(int id, String name, String url, String term) {
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(NAME, name);
    values.put(URL, url);
    values.put(TERM, term);
    db.update(
        TABLE_NAME, 
        values, 
        "_ID = ?", 
        new String[] {String.valueOf(id)}
    );
  }
  
  

}

Java Source Code List

• Back to Development/tool  ↑