android 项目 local_Test_exam 代码分享

最新推荐文章于 2021-05-26 10:21:57 发布
最新推荐文章于 2021-05-26 10:21:57 发布
阅读量851 收藏 3
点赞数 1
分类专栏： Android 文章标签： android应用 界面 sqlite
版权声明：本文为博主原创文章，遵循 CC 4.0 BY 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/worldmakewayfordream/article/details/52238736
版权

本android项目是致力于建立一个本地的sqlite数据库，然后存储考试的题目，android应用调用sqlite数据库中的数据，生成相应的答题界面。该应用参考极客学院安卓答题系统。

下面是代码解析



项目主要是有界面是activity_exam.xml 和 activity_index.xml组成

（1）activity_exam.xml 展示界面



代码如下：

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    tools:context="com.exam.administrator.exam.IndexActivity">

    <Button
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Start Exam"
        android:id="@+id/button"
        android:layout_alignParentTop="true"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="68dp" />
</RelativeLayout>







（2）activity_question.xml界面和代码如下





<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    android:orientation="vertical"
    tools:context="com.exam.administrator.exam.ExamActivity">
    <ScrollView
        android:layout_weight="1"
        android:layout_width="match_parent"
        android:layout_height="match_parent">
    <LinearLayout
        android:orientation="vertical"
        android:layout_width="match_parent"
        android:layout_height="wrap_content">
        <TextView
            android:text="Question Description"
            android:id="@+id/question"
            android:layout_width="match_parent"
            android:layout_height="wrap_content" />
        <RadioGroup
            android:id="@+id/radioGroup"
            android:layout_width="match_parent"
            android:layout_height="wrap_content">
            <RadioButton
                android:text="AnswerA"
                android:id="@+id/answerA"
                android:layout_width="match_parent"
                android:layout_height="wrap_content" />
            <RadioButton
                android:text="AnswerB"
                android:id="@+id/answerB"
                android:layout_width="match_parent"
                android:layout_height="wrap_content" />
            <RadioButton
                android:text="AnswerC"
                android:id="@+id/answerC"
                android:layout_width="match_parent"
                android:layout_height="wrap_content" />
            <RadioButton
                android:text="AnswerD"
                android:id="@+id/answerD"
                android:layout_width="match_parent"
                android:layout_height="wrap_content" />
        </RadioGroup>
        <TextView
                android:text="Question Exlaination"
                android:visibility="invisible"
                android:id="@+id/explanation"
                android:layout_width="match_parent"
                android:layout_height="wrap_content" />
    </LinearLayout>
    </ScrollView>
    <LinearLayout
        android:layout_weight="7"
        android:orientation="horizontal"
        android:layout_width="match_parent"
        android:layout_height="match_parent">
        <Button
            android:id="@+id/previous"
            android:text="previous"
            android:layout_weight="1"
            android:layout_width="match_parent"
            android:layout_height="wrap_content" />
        <Button
            android:id="@+id/next"
            android:text="next"
            android:layout_weight="1"
            android:layout_width="match_parent"
            android:layout_height="wrap_content" />
    </LinearLayout>
</LinearLayout>


（3）逻辑处理部分

接下来就是4个逻辑处理部分了

DBservice 负责数据库数据的存取

Question 为自定义数据类型，存储信息

在indexActivity类中创建sqlite数据库，并设置startExam按钮的相应事件，跳转到答题界面

examActivity类为题目展示阶段，将数据库中的问题取出展示到android应用上


DBService.java 代码

package com.exam.administrator.exam;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import java.util.ArrayList;
import java.util.List;

/**
 * Created by Administrator on 2016/8/15.
 */
public class DBService {
    private SQLiteDatabase db;
    public DBService(){
        db = SQLiteDatabase.openDatabase("/data/data/com.exam.administrator.exam/databases/question.db",null, SQLiteDatabase.OPEN_READWRITE);
    }
    public List<Question> getQuestion(){
        List<Question> list = new ArrayList<Question>();
        Cursor cursor = db.rawQuery("Select * from question", null);
        if(cursor.getCount() > 0){
            cursor.moveToFirst();
            int count = cursor.getCount();
            for(int i = 0; i < count; i++){
                cursor.moveToPosition(i);
                Question question = new Question();
                question.question = cursor.getString(cursor.getColumnIndex("question"));
                question.answerA = cursor.getString(cursor.getColumnIndex("answerA"));
                question.answerB = cursor.getString(cursor.getColumnIndex("answerB"));
                question.answerC = cursor.getString(cursor.getColumnIndex("answerC"));
                question.answerD = cursor.getString(cursor.getColumnIndex("answerD"));
                question.answer = cursor.getInt(cursor.getColumnIndex("answer"));
                question.ID = cursor.getInt(cursor.getColumnIndex("ID"));
                question.explanation = cursor.getString(cursor.getColumnIndex("explanation"));
                question.selectedAnswer = -1;
                list.add(question);
            }
        }
        return list;

    }
}
examActivity.java代码 
package com.exam.administrator.exam;

import android.content.DialogInterface;
import android.preference.DialogPreference;
import android.provider.MediaStore;
import android.support.v7.app.AlertDialog;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.RadioButton;
import android.widget.RadioGroup;
import android.widget.TextView;
import android.widget.Toast;

import java.util.ArrayList;
import java.util.List;

public class ExamActivity extends AppCompatActivity {
    private int count;
    private int current;
    private boolean wrongMode;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_exam);
        DBService  dbService = new DBService();
        final List<Question> list = dbService.getQuestion();
        count = list.size();
        current = 0;
        wrongMode = false;
        final TextView tv_question = (TextView)findViewById(R.id.question);
        final RadioButton[] radioButtons = new RadioButton[4];
        radioButtons[0] = (RadioButton)findViewById(R.id.answerA);
        radioButtons[1] = (RadioButton)findViewById(R.id.answerB);
        radioButtons[2] = (RadioButton)findViewById(R.id.answerC);
        radioButtons[3] = (RadioButton)findViewById(R.id.answerD);
        Button btn_next = (Button)findViewById(R.id.next);
        Button btn_previous =(Button)findViewById(R.id.previous);
        final TextView tv_explanation = (TextView)findViewById(R.id.explanation);
        final RadioGroup radioGroup = (RadioGroup)findViewById(R.id.radioGroup);

        Question q = list.get(0);
        tv_question.setText(q.question);
        tv_explanation.setText(q.explanation);
        radioButtons[0].setText(q.answerA);
        radioButtons[1].setText(q.answerB);
        radioButtons[2].setText(q.answerC);
        radioButtons[3].setText(q.answerD);
        btn_next.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                if(current < count -1){
                    current++;
                    String string = "" + count;
                    //Toast.makeText(ExamActivity.this, string,Toast.LENGTH_SHORT).show();
                    Question q = list.get(current);
                    tv_question.setText(q.question);
                    radioGroup.clearCheck();
                    radioButtons[0].setText(q.answerA);
                    radioButtons[1].setText(q.answerB);
                    radioButtons[2].setText(q.answerC);
                    radioButtons[3].setText(q.answerD);
                    tv_explanation.setText(q.explanation);
                    if(q.selectedAnswer != -1){
                        radioButtons[q.selectedAnswer].setChecked(true);
                    }
                }else if(current == count-1 && wrongMode == true){
                    new AlertDialog.Builder(ExamActivity.this)
                            .setTitle("Remider")
                            .setMessage("End of the question, quit or not?")
                            .setPositiveButton("Yes", new DialogInterface.OnClickListener() {
                                @Override
                                public void onClick(DialogInterface dialog, int which){
                                    ExamActivity.this.finish();
                                }
                            }).setNegativeButton("No", null)
                            .show();
                }
                else{
                   // Toast.makeText(ExamActivity.this, "Yes",Toast.LENGTH_SHORT).show();
                    final List<Integer> wrongList = checkAnswer(list);
                    if(wrongList.size() == 0){
                        new AlertDialog.Builder(ExamActivity.this)
                                .setTitle("reminder")
                                .setMessage("All are Right")
                                .setPositiveButton("Ok", new DialogInterface.OnClickListener(){
                                    @Override
                                    public void onClick(DialogInterface dialog, int which){
                                        ExamActivity.this.finish();
                                    }
                                }).show();
                    }else{
                    new AlertDialog.Builder(ExamActivity.this)
                            .setTitle("reminder")
                            .setMessage((list.size()-wrongList.size()) + " right answers. " +
                                    wrongList.size() + " wrong answers. Do you want to review?")
                            .setPositiveButton("YES", new DialogInterface.OnClickListener() {
                                @Override
                                public void onClick(DialogInterface dialogInterface, int i) {
                                    wrongMode = true;
                                    List<Question> newList = new ArrayList<Question>();
                                    for(int j = 0; j < wrongList.size(); j++){
                                        newList.add(list.get(wrongList.get(j)));
                                    }
                                    list.clear();
                                    for(int j = 0; j < newList.size(); j++){
                                        list.add(newList.get(j));
                                    }
                                    current = 0;
                                    count = list.size();

                                    Question q = list.get(current);
                                    tv_question.setText(q.question);
                                    radioGroup.clearCheck();
                                    radioButtons[0].setText(q.answerA);
                                    radioButtons[1].setText(q.answerB);
                                    radioButtons[2].setText(q.answerC);
                                    radioButtons[3].setText(q.answerD);
                                    tv_explanation.setText(q.explanation);
                                    tv_explanation.setVisibility(View.VISIBLE);
                                    if(q.selectedAnswer != -1){
                                        radioButtons[q.selectedAnswer].setChecked(true);
                                    }
                                }
                            }).setNegativeButton("NO", new DialogInterface.OnClickListener(){
                                @Override
                                public void onClick(DialogInterface dialogInterface, int i){
                                    ExamActivity.this.finish();
                                }
                            }).show();
                }}
            }
        });
        btn_previous.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                if(current > 0){
                    current--;
                    Question q = list.get(current);
                    radioGroup.clearCheck();
                    tv_question.setText(q.question);
                    radioButtons[0].setText(q.answerA);
                    radioButtons[1].setText(q.answerB);
                    radioButtons[2].setText(q.answerC);
                    radioButtons[3].setText(q.answerD);
                    tv_explanation.setText(q.explanation);
                    if(q.selectedAnswer != -1){
                        radioButtons[q.selectedAnswer].setChecked(true);
                    }
                }
            }
        });
        radioGroup.setOnCheckedChangeListener(new RadioGroup.OnCheckedChangeListener() {
            @Override
            public void onCheckedChanged(RadioGroup radioGroup, int i) {
                for(int j = 0; j < 4; j++){
                    if(radioButtons[j].isChecked() == true){
                        list.get(current).selectedAnswer = j+1;
                        break;
                    }
                }
            }
        });
    }
    private List<Integer> checkAnswer(List<Question> list){
        List<Integer> wrongList = new ArrayList<Integer>();
        for(int i = 0; i < list.size(); i++){
            if(list.get(i).answer != list.get(i).selectedAnswer){
                wrongList.add(i);
            }
        }
        return wrongList;
    }
}

indexActivity.java 

package com.exam.administrator.exam;

import android.content.Context;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;


public class IndexActivity extends AppCompatActivity {
    @Override
    protected void onCreate(Bundle savedInstanceState){
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_index);
        // open or create question database
        SQLiteDatabase db = openOrCreateDatabase("question.db", Context.MODE_PRIVATE, null);
        db.execSQL("DROP TABLE IF EXISTS question");
        // create question table
        db.execSQL("CREATE TABLE `question` (`ID`	INTEGER, `question`	TEXT, `answerA`	TEXT, `answerB`	TEXT, `answerC`	TEXT, `answerD`	TEXT, `answer`	NUMERIC, `explanation`	TEXT, PRIMARY KEY(ID))");
        Question question1 = new Question();
        Question question2 = new Question();
        Question question3 = new Question();
        question1.question = "Oracle中VARCHAR2类型的最大长度是";
        question1.answerA = "4000";
        question1.answerB = "3000";
        question1.answerC = "1000";
        question1.answerD = "2000";
        question1.answer = 1;
        question1.explanation = "4000";
        question1.ID= 1;

        question2.question = "在Java中，负责对字节代码解释执行的是";
        question2.answerA = "应用服务器";
        question2.answerB = "虚拟机";
        question2.answerC = "垃圾回收器";
        question2.answerD = "编译器";
        question2.answer = 2;
        question2.explanation = "虚拟机";
        question2.ID = 2;

        question3.question = "一个栈的输入序列为1 2 3 4 5，则下列序列中不可能是栈得输出序列的是";
        question3.answerA = "5 4 1 3 2";
        question3.answerB = "2 3 4 1 5";
        question3.answerC = "1 5 4 3 2";
        question3.answerD = "2 3 1 4 5";
        question3.answer = 1;
        question3.explanation = "5 4 1 3 2";
        question3.ID = 3;

        db.execSQL("INSERT INTO question VALUES(?,?,?,?,?,?,?,?)", new Object[]{question1.ID, question1.question,question1.answerA,question1.answerB,question1.answerC,question1.answerD, question1.answer, question1.explanation});
        db.execSQL("INSERT INTO question VALUES(?,?,?,?,?,?,?,?)", new Object[]{question2.ID, question2.question,question2.answerA,question2.answerB,question2.answerC,question2.answerD, question2.answer, question2.explanation});
        db.execSQL("INSERT INTO question VALUES(?,?,?,?,?,?,?,?)", new Object[]{question3.ID, question3.question,question3.answerA,question3.answerB,question3.answerC,question3.answerD, question3.answer, question3.explanation});


        /*Cursor c= db.rawQuery("select * from question",null);
        while(c.moveToNext()){
            int ID = c.getInt(c.getColumnIndex("ID"));
            String question = c.getString(c.getColumnIndex("question"));
            String answerA = c.getString(c.getColumnIndex("answerA"));
            String answerB = c.getString(c.getColumnIndex("answerB"));
            String answerC = c.getString(c.getColumnIndex("answerC"));
            String answerD = c.getString(c.getColumnIndex("answerD"));
            Log.i("db","ID=>" + ID + ", quesiton=>" + question + ", answerA=>" + answerA + ", answerB=>" + answerB + ", answerC=>" + answerC + ", answerD=>" + answerD );
            System.out.println(question);
        }*/
        //c.close();
        db.close();
        Button btn = (Button)findViewById(R.id.button);
        btn.setOnClickListener(new View.OnClickListener(){
            @Override
            public void onClick(View view) {
                Intent intent = new Intent(IndexActivity.this, ExamActivity.class);
                startActivity(intent);
            }
        });
    }
}

Question.java代码 

package com.exam.administrator.exam;

/**
 * Created by Administrator on 2016/8/15.
 */
public class Question {
    public String question;
    public String answerA;
    public String answerB;
    public String answerC;
    public String answerD;
    public int answer;
    public String explanation;
    public int ID;
    public int selectedAnswer;
}



















yangshuolll
关注
专栏目录
local_test:本地测试
04-29
local_test 测试用途。
ExamActivity
08-14
第三方服务之Bmob后端云的答题系统小项目
android考试源代码,android学习考试问答测试app完整源码
weixin_29858081的博客
05-26 1177
android学习考试问答测试app完整源码，可用于考试模拟测试、技能评估、驾校考试等各种问答场景，所有问题和答案都存储在密码保护的EXCEL表里，此表可以与任何公共云公布，每个级别可以设置在特定的时间内完成，可以添加图像的检测和分类主题。All Questions & Answers are stored in Password protected Sheet. This sheet c...
local test
todd_liu的专栏
09-01 576
Java version 1.6.0_13 Java HotSpot(TM) Client VM 11.3-b02 Sun Microsystems Inc. Direct access using member field:  47 125 47 46 46  av
Android实战—答题系统的简单实现
热门推荐
xushunag的博客
12-08 2万+
Question： package com.example.lenovo.exam; /** * Created by lenovo on 2017/12/4. */ //保存从数据库中读取的记录 public class Question { public String question; public String answerA; public String
Android代码-flutter_local_notifications.
08-08
Flutter Local Notifications Plugin A cross platform plugin for displaying local notifications. Supported Platforms Android API 16 (4.1 , the minimum version supported by Flutter). Uses the ...
socket_test.zip_android_android LocalSocket_socket
09-23
在AndroidManifest.xml中，可能需要添加`<uses-permission android:name="android.permission.LOCAL_SOCKETS" />`权限，以便应用可以使用LocalSocket。 在实际开发中，LocalSocket常用于Android系统的组件间通信，...
Android代码-local_notifications
08-07
Otherwise, check out flutter_local_notifications. Introduction LocalNotifications is an easy way to create notifications on both Android and iOS. Platforms Currently the following platforms are ...
cicd_local_test:cicd_local_test
05-28
cicd_local_test cicd_local_test测试cicd
TLS_TEST.rar_TLS_Thread Local Storage
09-24
在提供的压缩包文件中，“www.pudn.com.txt”可能包含了有关TLS或线程局部存储的资源链接或讨论，而“TLS_TEST”可能是一个示例程序或者测试用例，展示了如何在实际代码中实现和应用TLS和Thread Local Storage。...
Android的在线考试app
yaoji8151的博客
07-06 1692
效果图 项目编写顺序 集成Retrofit网络请求插件 集成数据库操作Greendao插件 定时器编写 编写题目悬浮框 1、集成Retrofit网络请求插件 引用依赖并加入网络请求权限： build.gradle dependencies { implementation 'io.reactivex.rxjava2:rxjava:2.2.1' implementation 'io.reactivex.rxjava2:rxandroid:2.1.0' //retrofit
android测试详解_2-Building Local Unit Tests-本地单元测试
zrbcsdn的专栏
07-08 1023
英文官方链接现在前面你应该编写并使用测试，作为android应用开发环节的一部分，好的测试能帮助我们在开发过程中早一些捕捉到bugs，并且树立你信心。 为了核实app中的特殊行为，检验在不同android设置中的兼容性，你可以写一个test case.本文将教你如何使用google提供的JUnit 4框架、测试APIs和工具创建一个test case，以及如何运行测试。 如果你的单元测试没有
Android测试系列之Local Unit Test
知识共享，你我皆是知识的搬运工
02-28 8448
本地化的单元测试用的最多的就是Junit,在Java中，JUnit测试框架使用的是最流行和应用最广泛的，JUnit最新的版本是JUnit 4,该版本的测试用例编写起来更简单，运行效率更高。
Android开发Service的那些事
weixin_42051691的博客
03-14 1581
Service是一个和Activity相似的组件，没有界面。因此需要在Activity方法进行开启，其中开启方式有两种，两种全是调用Context中的方法1，startService(new Intent(MusicActivity.this, MusicService.class)); 2，bindService(new Intent(MusicActivity.this, MusicServi...
Android在线源码
专注Android开发
02-26 950
https://gitorious.org/android-eeepc/base/source/76eef491e1a453174f6372d18cf500d13521fb23:core/java/android
使用Android Studio进行本地单元测试（Local Unit Tests）
大雀儿飞飞的专栏
09-19 4681
使用Android Studio进行本地单元测试（Local Unit Tests）由于目前Google已经停止了对Eclipse ADT插件的更新，因此迫使Android的开发者迁移到Android Studio中。Android Studio基于JetBrains IntelliJ IDEA，后者号称世界上最聪明最好用的Java开发IDE。虽然Android Studio提供了很多选项可以为Ec
Android 答题系统源码,答题demo(第六周)
qq_21036939的博客
12-09 1万+
这本是上周分的任务,是个模拟面试模块,工作量还是不小的 期间参考了网上一些大神写的答题系统
android 选择答题功能,Android实现简单的答题系统
weixin_32268169的博客
05-25 4783
本文实例为大家分享了Android实现答题系统的具体代码，供大家参考，具体内容如下Question：package com.example.lenovo.exam;/*** Created by lenovo on 2017/12/4.*///保存从数据库中读取的记录public class Question {public String question;public String answer...
经典Android试题及答案
fzw的专栏
06-25 1万+
经典Android试题及答案   1.        下列哪些语句关于内存回收的说明是正确的? (b ) A、 程序员必须创建一个线程来释放内存   B、内存回收程序负责释放无用内存    C、内存回收程序允许程序员直接释放内存    D、内存回收程序可以在指定的时间释放内存对象  2.        下面异常是属于Runtime Exception 的是（abcd）(多选
线程局部存储应用解析：TLS_TEST教程
资源摘要信息:"TLS_TEST.rar_TLS_Thread Local Storage" TLS（Thread Local Storage），即线程局部存储，是一种在多线程编程中提供线程内存储的机制。在多线程程序中，多个线程可能会共享相同的内存空间和资源，TLS...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值