android编程实现添加文本内容到sqlite表中的方法

本文实例讲述了android编程实现添加文本内容到sqlite表中的方法。分享给大家供大家参考，具体如下：

第一步： 创建表

create table dlion ( 
 _id  integer primary key autoincrement,
 content text,
 questionid integer,
 answerid integer,
 [right] integer 
);

第二步： 把编辑文本内容并放到 res/raw/test.txt

用 notepad++ 打开，把每一个将要放在表中单元格的内容放一行

去除行尾空格和空白行：按ctrl+h 选择正则表达式-- 查找目标：\s+$ 替换为空

去除行首空格：按ctrl+h 选择正则表达式-- 查找目标：^\s+ 替换为空

第三步： 打开数据库 详情参照：

《》

第四步： 添加数据到表

public void addcontent() {
 try {
   bufferedreader localbufferreader = new bufferedreader(
     new inputstreamreader(getresources().openrawresource(
       r.raw.test)));
   db = opendatabase();
   for (int i = length + 1;; i++) {
    // 添加问题到数据库
    string questionstr = localbufferreader.readline();
    if (questionstr == null) {
     localbufferreader.close();
     db.close();
     break;
    }
    log.v("insert", "insert questioncontent " + questionstr
      + " success!");
    db.execsql("insert into dlion(questionid,content) values(" + i
      + ",'" + questionstr + "')");
    // 添加答案1到数据库
    string answerstr1 = localbufferreader.readline();
    if (answerstr1 == null) {
     localbufferreader.close();
     db.close();
     break;
    }
    log.v("insert", "insert answercontent1 " + answerstr1
      + " success!");
    db.execsql("insert into dlion(answerid,content) values(" + i
      + ",'" + answerstr1 + "')");
    // 添加答案2到数据库
    string answerstr2 = localbufferreader.readline();
    if (answerstr2 == null) {
     localbufferreader.close();
     db.close();
     break;
    }
    log.v("insert", "insert answercontent2 " + answerstr2
      + " success!");
    contentvalues answercontent2 = new contentvalues();
    answercontent2.put("answerid", i);
    answercontent2.put("content", answerstr2);
    db.insert("dlion", "_id", answercontent2);
    // 添加答案3到数据库
    string answerstr3 = localbufferreader.readline();
    if (answerstr3 == null) {
     localbufferreader.close();
     db.close();
     break;
    }
    log.v("insert", "insert answercontent3 " + answerstr3
      + " success!");
    contentvalues answercontent3 = new contentvalues();
    answercontent3.put("answerid", i);
    answercontent3.put("content", answerstr3);
    db.insert("dlion", "_id", answercontent3);
    // 添加答案4到数据库
    string answerstr4 = localbufferreader.readline();
    if (answerstr4 == null) {
     localbufferreader.close();
     db.close();
     break;
    }
    log.v("insert", "insert answercontent4 " + answerstr4
      + " success!");
    contentvalues answercontent4 = new contentvalues();
    answercontent4.put("answerid", i);
    answercontent4.put("content", answerstr4);
    db.insert("dlion", "_id", answercontent4);
   }
 } catch (exception e) {
   // todo: handle exception
   e.printstacktrace();
  }
}

希望本文所述对大家android程序设计有所帮助。