Advertisement
Guest User

Tutorial AndroidOS SQLite

a guest
Jun 28th, 2013
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 2.33 KB | None | 0 0
  1. package com.tutorial.contatore;
  2.  
  3. import android.content.ContentValues;
  4. import android.content.Context;
  5. import android.database.Cursor;
  6. import android.database.sqlite.SQLiteDatabase;
  7. import android.database.sqlite.SQLiteDatabase.CursorFactory;
  8. import android.database.sqlite.SQLiteOpenHelper;
  9.  
  10. public class dbManage {
  11.     private SQLiteHelper sqLiteHelper;
  12.     private SQLiteDatabase sqLiteDatabase; 
  13.     private Context context;
  14.  
  15.     private static final String MYDATABASE_NAME = "db";
  16.     private static final int MYDATABASE_VERSION = 2;
  17.     private static final String MYDATABASE_TABLE = "main";
  18.    
  19.     private static final String SCRIPT_CREATE_DATABASE =
  20.             "create table " + MYDATABASE_TABLE + " ("
  21.             + "nome text primary key, "
  22.             + "valore integer not null"
  23.             + ");";
  24.    
  25.     public dbManage(Context context) {
  26.         this.context=context;
  27.     }
  28.    
  29.     public dbManage openToRead() throws android.database.SQLException {
  30.         sqLiteHelper = new SQLiteHelper(context, MYDATABASE_NAME, null, MYDATABASE_VERSION);
  31.         sqLiteDatabase = sqLiteHelper.getReadableDatabase();
  32.         return this;
  33.     }
  34.  
  35.     public dbManage openToWrite() throws android.database.SQLException {
  36.         sqLiteHelper = new SQLiteHelper(context, MYDATABASE_NAME, null, MYDATABASE_VERSION);
  37.         sqLiteDatabase = sqLiteHelper.getWritableDatabase();
  38.         return this;
  39.     }
  40.  
  41.     public void close(){
  42.         sqLiteHelper.close();
  43.     }
  44.  
  45.     public long insert(String n, int v){
  46.         ContentValues contentValues = new ContentValues();
  47.         contentValues.put("nome", n);
  48.         contentValues.put("valore", v);
  49.         return sqLiteDatabase.insert(MYDATABASE_TABLE, null, contentValues);
  50.     }
  51.  
  52.     public int deleteAll(){
  53.         return sqLiteDatabase.delete(MYDATABASE_TABLE, null, null);
  54.     }
  55.  
  56.     public Cursor queueAll(){
  57.         String[] columns = new String[]{"nome","valore"};
  58.         Cursor cursor = sqLiteDatabase.query(MYDATABASE_TABLE, columns, null, null, null, null, null);
  59.         return cursor;
  60.     }
  61.  
  62.     class SQLiteHelper extends SQLiteOpenHelper {
  63.      
  64.         public SQLiteHelper(Context context, String name,CursorFactory factory, int version) {
  65.             super(context, name, factory, version);
  66.         }              
  67.  
  68.         @Override
  69.         public void onCreate(SQLiteDatabase db) {db.execSQL(SCRIPT_CREATE_DATABASE);}
  70.  
  71.         @Override
  72.         public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  73.             db.execSQL("DROP TABLE IF EXISTS main");
  74.             onCreate(db);
  75.         }
  76.     }
  77. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement