要如何把陣列的數值一筆一筆傳到SQLITE內??

http://stackoverflow.com/questions/754684/how-to-insert-a-sqlite-record-with-a-datetime-set-to-now-in-android-applicatio

SQLiteDatabase.execSQL so you can enter a raw SQL query.

1. mDb.execSQL("INSERT INTO "+DATABASE_TABLE+" VALUES (null, datetime()) ");

複製代碼

Or the java date time capabilities :

1. // set the format to sql date time
   
2. SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
   
3. Date date = new Date();
   
4. ContentValues initialValues = new ContentValues();
   
5. initialValues.put("date_created", dateFormat.format(date));
   
6. long rowId = mDb.insert(DATABASE_TABLE, null, initialValues);

複製代碼