android 添加常值內容到sqlite表中android sd卡讀取資料庫

第一步： 建立表

CREATE TABLE DLION (     _id        INTEGER PRIMARY KEY AUTOINCREMENT,    content    TEXT,    questionId INTEGER,    answerId   INTEGER,    [right]    INTEGER );

第二步： 把編輯常值內容並放到 res/raw/test.txt

　　用 Notepad++ 開啟，把每一個將要放在表中儲存格的內容放一行(註： ^ 代表行首 $ 代表行尾)

　　　　去除行尾空格和空白行：按CTRL+H 選擇Regex-- 尋找目標：\s+$ 替換為空白

　　　　去除行首空格：按CTRL+H 選擇Regex-- 尋找目標：^\s+ 替換為空白

第三步： 開啟資料庫 詳情參照

　　android sd卡讀取資料庫

第四步： 添加資料到表

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();        }    }