public List<ScoreBoard> getScoreBoard() {
List<ScoreBoard> scoreBoardList = new ArrayList<ScoreBoard>();
String selectQuery = "SELECT * FROM " + SCOREBOARD_TABLE;
SQLiteDatabase db = dbHelper.getWritableDatabase();
Cursor cursor = db.rawQuery(selectQuery, null);
if (cursor.moveToFirst()) {
do {
ScoreBoard scoreBoard = new ScoreBoard();
scoreBoard.setId(Integer.parseInt(cursor.getString(0)));
scoreBoard.setGroupName(cursor.getString(1));
scoreBoard.setClassName(cursor.getString(2));
scoreBoard.setScore((Integer.parseInt(cursor.getString(3))));
scoreBoard.setTime(cursor.getString(4));
scoreBoardList.add(scoreBoard);
} while (cursor.moveToNext());
}
return scoreBoardList;
}
