Android Open Source - PokerMachine Sql Helper

• Back to Game/poker  ↑

From Project

Back to project page PokerMachine.

License

The source code is released under:

Apache License

Java Source Code

package com.eb.poker;
/*from   w  ww . j av a2 s.co  m*/
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteStatement;
import android.util.Log;
import java.util.ArrayList;
import java.util.List;

public class SqlHelper {
  private static final String DATABASE_NAME = "example.db";
     private static final int DATABASE_VERSION = 1;
     private static final String TABLE_NAME = "table1";

     private Context context;
     private SQLiteDatabase db;

     private SQLiteStatement insertStmt;
     private static final String INSERT = "insert into " + TABLE_NAME + "(name) values (?)";

     public SqlHelper(Context context) {
        this.context = context;
        OpenHelper openHelper = new OpenHelper(this.context);
        this.db = openHelper.getWritableDatabase();
        this.insertStmt = this.db.compileStatement(INSERT);
     }
     
     public SQLiteDatabase getDb() {
        return this.db;
     }

     public long insert(String name) {
        this.insertStmt.bindString(1, name);
        return this.insertStmt.executeInsert();
     }
     
     public void deleteAll() {
        this.db.delete(TABLE_NAME, null, null);
     }

     public List<String> selectAll() {
        List<String> list = new ArrayList<String>();
        Cursor cursor = this.db.query(TABLE_NAME, new String[] { "name" }, null, null, null, null, "name desc");
        if (cursor.moveToFirst()) {
           do {
              list.add(cursor.getString(0)); 
           } while (cursor.moveToNext());
        }
        if (cursor != null && !cursor.isClosed()) {
           cursor.close();
        }
        return list;
     }

     private static class OpenHelper extends SQLiteOpenHelper {

        OpenHelper(Context context) {
           super(context, DATABASE_NAME, null, DATABASE_VERSION);
        }

        @Override
        public void onCreate(SQLiteDatabase db) {
           db.execSQL("CREATE TABLE " + TABLE_NAME + " (id INTEGER PRIMARY KEY, name TEXT)");
        }

        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
           Log.w("Example", "Upgrading database, this will drop tables and recreate.");
           db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
           onCreate(db);
        }
     }

}

Java Source Code List

• Back to Game/poker  ↑