Android Open Source - DroidChineseCheckers Checkers Db Helper

• Back to Game/solitaire  ↑

From Project

Back to project page DroidChineseCheckers.

License

The source code is released under:

Apache License

Java Source Code

/*******************************************************************************
 * Copyright 2011 Federico Paolinelli//from www .j a v  a 2 s  .  c om
 * 
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * 
 *   http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 ******************************************************************************/
package com.whiterabbit.checkers.boards;

import android.content.ContentValues;
import android.content.Context;
import android.content.SharedPreferences;
import android.database.Cursor;


public class CheckersDbHelper extends CheckersStorage {
  public class ScoreRes{
    public int maxScore;
    public int minTime;
    public ScoreRes(int maxScore, int minTime) {
      super();
      this.maxScore = maxScore;
      this.minTime = minTime;
    }
  }
  
  
    public static final String PREF_NAME = "Preferences";
    public static final String LAST_BOARD_USED = "LastBoard";
    
    public CheckersDbHelper(Context context) {
        super(context);
    }
    
    public Cursor getSavedBoard(String name){
       Cursor res = mDb.query(BOARD_TABLE, new String[] {BOARD_ROW_ID,
                    BOARD_NAME_KEY,
                    BOARD_DUMP_KEY,
                    BOARD_SAVEDDATE_KEY,
                    BOARD_WIDTH_KEY,
                    BOARD_HEIGTH_KEY,
                    BOARD_SCORE_KEY,
                    BOARD_TIME_KEY}, BOARD_NAME_KEY + " = '" + name + "'", null, null, null, null);
        if(res != null){
            res.moveToFirst();
        }
        
        return res;
    }
    
    
    public boolean removeBoard(String name)
    {
        return mDb.delete(BOARD_TABLE, BOARD_NAME_KEY+ "= '" + name + "'", null) > 0;
    }
    
    public static void setLastBoardUsed(String boardName, Context ctx){
        int mode = Context.MODE_PRIVATE;
        SharedPreferences mySharedPreferences = ctx.getSharedPreferences(PREF_NAME, mode);        
        SharedPreferences.Editor editor = mySharedPreferences.edit();   
        editor.putString(LAST_BOARD_USED, boardName);
        editor.commit();
    }
    
    public static void resetLastBoard(Context ctx){
        setLastBoardUsed("", ctx);
    }
    
    /**
     * Returns the max score of the given board
     */
    public ScoreRes getBoardMaxScore(String name){
        Cursor res = mDb.query(BOARDSCORE_TABLE, new String[] {
                    BOARDSCORE_ROW_ID,
                    BOARDSCORE_NAME_KEY,
                    BOARDSCORE_MAXSCORE_KEY,
                    BOARDSCORE_MINTIME_KEY}, BOARDSCORE_NAME_KEY + " = '" + name + "'", null, null, null, null);
        
        if(res == null)
            return new ScoreRes(0,0);
        
        res.moveToFirst();
        if(res.getCount() <= 0){
            res.close();
            return new ScoreRes(0,0);
        }
        
        int result = res.getInt(BOARDSCORE_MAXSCORE_COLUMN);
        int minTime = res.getInt(BOARDSCORE_MINTIME_COLUMN);
        res.close();
        return new ScoreRes(result, minTime);
    }
    
    public void setBoardMaxScore(String name, long maxScore, long minTime){
        String where = BOARDSCORE_NAME_KEY + " = '" + name + "'";
        ContentValues contentValues = new ContentValues();
        contentValues.put(BOARDSCORE_NAME_KEY, name);
        contentValues.put(BOARDSCORE_MAXSCORE_KEY, maxScore);
        contentValues.put(BOARDSCORE_MINTIME_KEY, minTime);
        int updated = mDb.update(BOARDSCORE_TABLE, contentValues, where, null);
        
        if(updated <= 1){
            addBoardScore(name, Long.valueOf(maxScore), Long.valueOf(minTime));
        }
        
        
        
        
    }

}

Java Source Code List

• Back to Game/solitaire  ↑