首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >我一直在做作业,我无法在sqlite数据库android中保存图像路径

问我一直在做作业,我无法在sqlite数据库android中保存图像路径
EN

Stack Overflow用户
提问于 2019-06-10 14:05:44
回答 2查看 226关注 0票数 1

我是安卓的新手,我需要帮助做家庭作业,我需要用问题做小测验,有些问题需要图片,我在互联网上发现了一些东西,但我不知道下一步该做什么,我想从绘图中获取图像并保存在数据库中,当问题出现在imageview中时

代码语言:javascript
复制
    package com.autoskola;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.graphics.Bitmap;


import com.autoskola.QuizContract.*;

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

public class QuizDbHelper extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "TeorijskiTestovi.db";
    public static final int DATABSE_VERSION = 1;


    private SQLiteDatabase db;

    public QuizDbHelper( Context context) {
        super(context, DATABASE_NAME, null,DATABSE_VERSION);
    }

数据库制作

代码语言:javascript
复制
 @Override
    public void onCreate(SQLiteDatabase db) {
        this.db = db;
        //Pravljenje sqlite database
        final String SQL_CREATE_QUESTIONS_TABLE = "CREATE TABLE " +
                QuestionsTable.TABLE_NAME + " ( " +
                QuestionsTable._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                QuestionsTable.COLUMN_QUESTION + " TEXT, " +
                QuestionsTable.COLUMN_OPTION1 + " TEXT, " +
                QuestionsTable.COLUMN_OPTION2 + " TEXT, " +
                QuestionsTable.COLUMN_OPTION3 + " TEXT, " +
                QuestionsTable.COLUMN_ANSWER_NR + " INTEGER, " +
                QuestionsTable.COLUMN_IMAGE + " BLOB NOT NULL" +
                ")";
        db.execSQL(SQL_CREATE_QUESTIONS_TABLE);
        fillQuestionsTable();
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
       // za dalje azuriranje verzije i promene u db, izbrisace postojucu tabelu i napraviti novu
        db.execSQL("DROP TABLE IF EXISTS " + QuestionsTable.TABLE_NAME );
        onCreate(db);
    }

我做了一些问题,我放了一些随机的图片,我把图片放在字符串中,这样它就不都是红色的了

代码语言:javascript
复制
// metoda za pravljenje pitanja
    private void fillQuestionsTable() {
        Question q1 = new Question("A is correct", "A", "B", "C", 1,"R.drawable.bmw");
        addQuestion(q1);
        Question q2 = new Question("B is correct", "A", "B", "C", 2,"R.drawable.bmw");
        addQuestion(q2);
        Question q3 = new Question("C is correct", "A", "B", "C", 3,"R.drawable.bmw");
        addQuestion(q3);
        Question q4 = new Question("A is correct again", "A", "B", "C", 1, "R.drawable.bmw");
        addQuestion(q4);
        Question q5 = new Question("B is correct again", "A", "B", "C", 2,"R.drawable.bmw");
        addQuestion(q5);
    }

    // metoda za dodavanje pitanja u db
    private void addQuestion(Question question) {
        ContentValues cv = new ContentValues();
        cv.put(QuestionsTable.COLUMN_QUESTION, question.getQuestion());
        cv.put(QuestionsTable.COLUMN_OPTION1, question.getOption1());
        cv.put(QuestionsTable.COLUMN_OPTION2, question.getOption2());
        cv.put(QuestionsTable.COLUMN_OPTION3, question.getOption3());
        cv.put(QuestionsTable.COLUMN_ANSWER_NR, question.getAnswerNr());
        cv.put(QuestionsTable.COLUMN_IMAGE, question.getImageQ());
        db.insert(QuestionsTable.TABLE_NAME, null, cv);
    }

为问题检索数据

代码语言:javascript
复制
// retrive data
    public List<Question> getAllQuestions() {
        List<Question> questionList = new ArrayList<>();
        db = getReadableDatabase();
        Cursor c = db.rawQuery("SELECT * FROM " + QuestionsTable.TABLE_NAME, null);
        //
        if(c.moveToFirst()) {
            do {
                Question question = new Question();
                question.setQuestion(c.getString(c.getColumnIndex(QuestionsTable.COLUMN_QUESTION)));
                question.setOption1(c.getString(c.getColumnIndex(QuestionsTable.COLUMN_OPTION1)));
                question.setOption2(c.getString(c.getColumnIndex(QuestionsTable.COLUMN_OPTION2)));
                question.setOption3(c.getString(c.getColumnIndex(QuestionsTable.COLUMN_OPTION3)));
                question.setAnswerNr(c.getInt(c.getColumnIndex(QuestionsTable.COLUMN_ANSWER_NR)));
                question.setImageQ(c.getString(c.getColumnIndex(QuestionsTable.COLUMN_IMAGE)));
                questionList.add(question);
            }while(c.moveToNext());
        }

        c.close();
        return  questionList;
    }


}

我的DbBitmapUtility课程

代码语言:javascript
复制
package com.autoskola;

import android.graphics.Bitmap;
import android.graphics.BitmapFactory;

import java.io.ByteArrayOutputStream;

public class DbBitmapUtility {

    // konvertovanje  bitmap u byte array
    public static byte[] getBytes(Bitmap bitmap) {
        ByteArrayOutputStream stream = new ByteArrayOutputStream();
        bitmap.compress(Bitmap.CompressFormat.JPEG, 0, stream);
        return stream.toByteArray();
    }

    // konvertovanje byte array u bitmap
    public static Bitmap getImage(byte[] image) {
        return BitmapFactory.decodeByteArray(image, 0, image.length);
    }


}
EN

回答 2

Stack Overflow用户

回答已采纳

发布于 2019-06-10 14:12:28

最好的方法是将图像保存在文件夹中,并将该图像的路径保存在数据库中。当提出问题时,从数据库获取该图像的位置,并从指定的文件夹加载该图像。

票数 1
EN

Stack Overflow用户

发布于 2019-06-10 14:07:43

应该将指向图像的链接存储在数据库中,并使用毕加索或滑行将其加载到ImageView中。

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/56528009

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档