Android开发之数据库备份

最新推荐文章于 2025-03-26 16:02:15 发布

墨明棋妙的兜兜

最新推荐文章于 2025-03-26 16:02:15 发布

阅读量6.1k

点赞数 4

CC 4.0 BY-SA版权

分类专栏： Android 文章标签： android 数据库备份读取Excel

本文链接：https://blog.youkuaiyun.com/cjm495580074/article/details/52063585

这篇博客介绍了如何在Android应用中将Excel数据导入并创建SQLite数据库，以及如何备份SQLite数据库。首先，定义了用于存储题目信息的实体类，然后封装SQLite数据库操作工具类。接着，使用jxl.jar库读取Excel文件并生成初始数据库。此外，还展示了如何在辅助Activity中备份数据库到SD卡，并在App启动时检查并导入预设数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Android开发之数据库备份

用过市面上刷题App/诸如驾考宝典这样的App/的用户应该知道，离线状态也是可以刷题的，这就表明了题库并不是在服务器或者云端数据库上，而是用本地的SQLite数据库存储的。可是如果别人给你的题库是个Excel表格，让你去开发成个App，该如何去做呢？接下来就以我曾经做过的C语言刷题App为例手把手教你如何读取Excel表格，并备份数据库。

1 自定义实体类
这个就好理解了，咱这回存的是题目，就自定义一个保存题目信息的实体类，具体里面存放什么信息因需求而定。

public class Question {

    private int questionId;
    private String questionContent;
    private String answerA;
    private String answerB;
    private String answerC;
    private String answerD;
    private int answerNum;
    private String coment;
    private String answerE;
    private String answerF;
    private int answerCorrect;
    private int answerChoose;
    private int haveFinished;
    private int isTrue;
    private int chapter;

    public Question(){}

    public int getQuestionId() {
        return questionId;
    }

    public void setQuestionId(int questionId) {
        this.questionId = questionId;
    }

    public String getQuestionContent() {
        return questionContent;
    }

    public void setQuestionContent(String questionContent) {
        this.questionContent = questionContent;
    }

    public String getAnswerA() {
        return answerA;
    }

    public void setAnswerA(String answerA) {
        this.answerA = answerA;
    }

    public String getAnswerB() {
        return answerB;
    }

    public void setAnswerB(String answerB) {
        this.answerB = answerB;
    }

    public String getAnswerC() {
        return answerC;
    }

    public void setAnswerC(String answerC) {
        this.answerC = answerC;
    }

    public String getAnswerD() {
        return answerD;
    }

    public void setAnswerD(String answerD) {
        this.answerD = answerD;
    }

    public int getAnswerNum() {
        return answerNum;
    }

    public void setAnswerNum(int answerNum) {
        this.answerNum = answerNum;
    }

    public String getComent() {
        return coment;
    }

    public void setComent(String coment) {
        this.coment = coment;
    }

    public String getAnswerE() {
        return answerE;
    }

    public void setAnswerE(String answerE) {
        this.answerE = answerE;
    }

    public String getAnswerF() {
        return answerF;
    }

    public void setAnswerF(String answerF) {
        this.answerF = answerF;
    }

    public int getAnswerCorrect() {
        return answerCorrect;
    }

    public void setAnswerCorrect(int answerCorrect) {
        this