#android建立一個資料庫以及加入資料至資料庫
以下為建立資料表格使用ANDROID 內建的SQLite 以下需額外建立一個Class 此處為建立表格 public class MyDBHelper extends SQLiteOpenHelper { private SQLiteDatabase db; public MyDBHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) { super(context, name, factory, version); db = this.getReadableDatabase(); } @Override public void onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE IF NOT EXISTS"+ " ALARM " +"(_id INTEGER PRIMARY KEY , " + "Aname VAR UNIQUE , " + "Atime TIME)"); } 以下為尋找欄位與更新欄位 public Cursor filList(long id) throws SQLException{ Cursor cursor = db.query( "ALARM", new String[] {"_id","Atime"}, "_id =" +id, null, null, null, null, null ); if (cur...