在SQLite数据库中实现html标签 [英] Implement html tags in SQLite database

问题描述

我已经在SQLite数据库中输入了一些用html标记包裹的文本，我想在电话中显示这些文本.例如:我已经在SQLite数据库中输入了10<sup>-7</sup>，我想在手机中渲染10 ^-7 .

I have entered some text wrapped with html tags in SQLite database, and I want to display those text in phone. for example: I have entered 10<sup>-7</sup> in SQLite database, I want to render 10^-7 in phone.

这是来自DB Browser的SQLite的SQLite图像:

This is the image of SQLite from DB Browser for SQLite:

这是DBHelper的一部分:

This is part of the DBHelper:

public List<Quizplay> getQuestionGuj(int cate_id, int sub_cate_id, int noOfQuestion, int level) {

        List<Quizplay> quizplay = new ArrayList<Quizplay>();
        int total = noOfQuestion;
        String sql = "select *  FROM " + TBL_QUESTION + " where (" + CATE_ID + "=" + cate_id + " and "
                + SUB_CATE_ID + " =" + sub_cate_id + " and "
                + LEVEL + "=" + level + ") ORDER BY RANDOM() LIMIT " + total;
        SQLiteDatabase db = this.getReadableDatabase();
        //SQLiteDatabase db = SQLiteDatabase.openDatabase("/data/data/" + packageName + "/databases/" + DATABASE_NAME, null, 0);
        Cursor cursor = db.rawQuery(sql, null);

        if (cursor.moveToFirst()) {
            do {
                Quizplay question = new Quizplay();
                question.setId(cursor.getInt(cursor.getColumnIndex("id")));
                question.setQuestion(cursor.getString(cursor.getColumnIndex("question")));
                question.addOption(cursor.getString(cursor.getColumnIndex("option_a")));
                question.addOption(cursor.getString(cursor.getColumnIndex("option_b")));
                question.addOption(cursor.getString(cursor.getColumnIndex("option_c")));
                question.addOption(cursor.getString(cursor.getColumnIndex("option_d")));
                String rightAns = cursor.getString(cursor.getColumnIndex("right_answer"));
                if (rightAns.equalsIgnoreCase("A")) {
                    question.setTrueAns(cursor.getString(cursor.getColumnIndex("option_a")));
                } else if (rightAns.equalsIgnoreCase("B")) {
                    question.setTrueAns(cursor.getString(cursor.getColumnIndex("option_b")));
                } else if (rightAns.equalsIgnoreCase("C")) {
                    question.setTrueAns(cursor.getString(cursor.getColumnIndex("option_c")));
                } else {
                    question.setTrueAns(cursor.getString(cursor.getColumnIndex("option_d")));
                }
                if (question.getOptions().size() == 4) {
                    quizplay.add(question);
                }

            } while (cursor.moveToNext());
        }
        cursor.close();
        db.close();
        Collections.shuffle(quizplay);
        quizplay = quizplay.subList(0, noOfQuestion);
        return quizplay;
    }

推荐答案

好！我的意思是，您想在测验应用程序中添加超级脚本和子脚本. 您应该在sqlite db文件中添加上标和下标字母，而不是使用乳胶， 您可以在线找到许多发电机 https://lingojam.com/SuperscriptGenerator 这是我个人的最爱！ 生成并将字母复制并粘贴到您的sqlite数据库中.

Okay! I got your point, you want to add super and sub scripts in your quiz app. Rather than using latex, you should add superscript and subscript letters in your sqlite db file, you can find many generators online https://lingojam.com/SuperscriptGenerator this is my personal favorite! generate and copy paste the letter in your sqlite db.

这篇关于在SQLite数据库中实现html标签的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！