SSeLNikj

1import android.content.ContentValues;
2import android.content.Context;
3import android.database.Cursor;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6
7public class DBHelper extends SQLiteOpenHelper {
8
9    private static final String dbName = "db_name.db";
10    private static final String tableName = "table_name";
11    private static final String SQL_DROP_TABLE = "DROP TABLE IF EXISTS " + tableName;
12    private static final String SQL_CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + tableName +
13            "(id INTEGER PRIMARY KEY, valor TEXT)";
14
15    public DBHelper(Context context) {
16        super(context, dbName, null, 1);
17        onCreate(this.getWritableDatabase());
18    }
19
20    @Override
21    public void onCreate(SQLiteDatabase db) {
22        db.execSQL(SQL_CREATE_TABLE);
23    }
24
25    @Override
26    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
27        db.execSQL(SQL_DROP_TABLE);
28        onCreate(db);
29    }
30    public void insert(String valor) {
31        // Get data repository in write mode
32        SQLiteDatabase db = this.getWritableDatabase();
33        
34        ContentValues values = new ContentValues();
35
36        values.put("valor", valor);
37
38        db.insert(tableName, null, values);
39    }
40    
41    public Cursor selectAsterisco() {
42        // Get data repository in read mode
43        SQLiteDatabase db = this.getReadableDatabase();
44
45        // Return all records
46        return db.rawQuery( "SELECT * FROM "+ tableName, null );
47    }
48}