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

2019-12-10 19:54:12丽君
  • 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();