android编程实现添加文本内容到sqlite表中的方法
本文实例讲述了android编程实现添加文本内容到sqlite表中的方法。分享给大家供大家参考,具体如下:
第一步:创建表
CREATETABLEDLION( _idINTEGERPRIMARYKEYAUTOINCREMENT, contentTEXT, questionIdINTEGER, answerIdINTEGER, [right]INTEGER );
第二步:把编辑文本内容并放到res/raw/test.txt
用Notepad++打开,把每一个将要放在表中单元格的内容放一行
去除行尾空格和空白行:按CTRL+H选择正则表达式--查找目标:\s+$替换为空
去除行首空格:按CTRL+H选择正则表达式--查找目标:^\s+替换为空
第三步:打开数据库详情参照:
《android编程实现sd卡读取数据库的方法》
第四步:添加数据到表
publicvoidaddContent(){ try{ BufferedReaderlocalBufferReader=newBufferedReader( newInputStreamReader(getResources().openRawResource( R.raw.test))); db=openDatabase(); for(inti=length+1;;i++){ //添加问题到数据库 StringquestionStr=localBufferReader.readLine(); if(questionStr==null){ localBufferReader.close(); db.close(); break; } Log.v("insert","insertquestionContent"+questionStr +"success!"); db.execSQL("insertintoDLION(questionId,content)values("+i +",'"+questionStr+"')"); //添加答案1到数据库 StringanswerStr1=localBufferReader.readLine(); if(answerStr1==null){ localBufferReader.close(); db.close(); break; } Log.v("insert","insertanswerContent1"+answerStr1 +"success!"); db.execSQL("insertintoDLION(answerId,content)values("+i +",'"+answerStr1+"')"); //添加答案2到数据库 StringanswerStr2=localBufferReader.readLine(); if(answerStr2==null){ localBufferReader.close(); db.close(); break; } Log.v("insert","insertanswerContent2"+answerStr2 +"success!"); ContentValuesanswerContent2=newContentValues(); answerContent2.put("answerId",i); answerContent2.put("content",answerStr2); db.insert("DLION","_id",answerContent2); //添加答案3到数据库 StringanswerStr3=localBufferReader.readLine(); if(answerStr3==null){ localBufferReader.close(); db.close(); break; } Log.v("insert","insertanswerContent3"+answerStr3 +"success!"); ContentValuesanswerContent3=newContentValues(); answerContent3.put("answerId",i); answerContent3.put("content",answerStr3); db.insert("DLION","_id",answerContent3); //添加答案4到数据库 StringanswerStr4=localBufferReader.readLine(); if(answerStr4==null){ localBufferReader.close(); db.close(); break; } Log.v("insert","insertanswerContent4"+answerStr4 +"success!"); ContentValuesanswerContent4=newContentValues(); answerContent4.put("answerId",i); answerContent4.put("content",answerStr4); db.insert("DLION","_id",answerContent4); } }catch(Exceptione){ //TODO:handleexception e.printStackTrace(); } }
希望本文所述对大家Android程序设计有所帮助。