android - how do i randomize without repetitions questions in a quiz app? -


between these 2 functions 1 should implement randomize questions database more efficiently.

getquestion # 1

public void getquestion() {      random r = new random();     int n = r.nextint(2);     dbase = this.getreadabledatabase();     ctr++;      //cursor cursor = dbase.rawquery("select * " + table_quest + " `qid` = " + n + ";", null);     cursor cursor = dbase.rawquery("select * "+table_quest+" order random()"+""+ ";", null);      if (cursor.movetofirst()) {         if(cursor.getint(6) == 1) {             ta.txtquestion.setvisibility(view.visible);             ta.txtquestion.settext(cursor.getstring(1).tostring());            /* log.e("image", "i here");             ta.img.setvisibility(view.visible);             int imageresource = draw.getresources().getidentifier("@drawable/"+cursor.getstring(1), null, package);             drawable res = draw.getresources().getdrawable(imageresource);             ta.img.setimagedrawable(res);             //ta.img.setimageresource(imageresource);*/         } else {             ta.txtquestion.setvisibility(view.visible);             ta.txtquestion.settext(cursor.getstring(1).tostring());         }         ta.button1.settext(cursor.getstring(3).tostring());         ta.button2.settext(cursor.getstring(4).tostring());         ta.button3.settext(cursor.getstring(5).tostring());         ta.ans = cursor.getstring(2).tostring();         log.e("current question id", integer.tostring(n));         testactivity.txtcounter.settext(integer.tostring(ctr));     } }

get question number 2

 public list<question> getallquestions() {     list<question> queslist = new arraylist<question>();     // select query     string selectquery = "select  * " + table_quest;     dbase = this.getreadabledatabase();     cursor cursor = dbase.rawquery(selectquery, null);     // looping through rows , adding list     if (cursor.movetofirst()) {         {            // question quest = new question();             //quest.setid(cursor.getint(0));             question quest = new question();             quest.setid(cursor.getint(0));             quest.setquestion(cursor.getstring(1));             quest.setanswer(cursor.getstring(5));             quest.setopta(cursor.getstring(2));             quest.setoptb(cursor.getstring(3));             quest.setoptc(cursor.getstring(4));              queslist.add(quest);         } while (cursor.movetonext());     }     // return quest list     return queslist; }

so question is... 1 better use , missing make work?


-

Comments

Post a Comment

Popular posts from this blog

java - SSE Emitter : Manage timeouts and complete() -

i writing web app multiple listeners(evcentsource sse clients js) connected server . want store sse emitter per connected listener : can done in memory or other means assigning id each client able achieve far now question ; how send response/event specific client connected web app ? while doing sseemmiters stored either getting completed or timed out. how prevent ? how keep sseemmiter available open infinite time (till client closes) , send events selectively .
Read more

jquery - uncaught exception: DataTables Editor - remote hosting of code not allowed -

i'm trying implement crud operation using datatableseditor using datatables.but i'm getting error messages: 1)uncaught exception: datatables editor - remote hosting of code not allowed. please see http://editor.datatables.net details on how purchase editor license 2)typeerror: a.editor undefined 3) $.fn.datatable.editor not constructor" what reason? here configuration: <%@ page language="java" contenttype="text/html; charset=iso-8859-1" pageencoding="iso-8859-1"%> <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> <title>insert title here</title> <link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.12/css/jquery.datatables.min.css"> <link re...
Read more

java - How to resolve error - package com.squareup.okhttp3 doesn't exist? -

i trying convert json java object use of gson in maven, following youtube video guidance - https://www.youtube.com/watch?v=vqgghm9pwe0 , theres error occurs when in main class error - package com.squareup.okhttp3 doesn't exist. code below: java package com.codebeasty.json; import com.squareup.okhttp3.okhttpclient; public class main { private static okhttpclient client = new okhttpclient(); public static void main (string [] args) { } } i put in dependency in pom.xml: <dependencies> <dependency> <groupid>com.squareup.okhttp3</groupid> <artifactid>okhttp</artifactid> <version>3.4.2</version> </dependency> <dependency> <groupid>com.google.code.gson</groupid> <artifactid>gson</artifactid> <version>2.8.0</version> </dependency> </dependencies> i dont understand why doesn't recognize com.squareup. there may need download? have downl...
Read more