public static final DB_NAME = school.db; public static final DB_VERSION = 1; public static final TABLE_NAME = student; public static final ID_FIELD = id; public static final NAME_FIELD = name; public DBHelper(Context context){ super(context, DB_NAME, , DB_VERSION); } @Override public void onCreate(SQLiteDatabase sqLiteDatabase) { // SQL for table creation String creation = CREATE TABLE + TABLE_NAME + ( + ID_FIELD + INTEGER PRIMARY KEY, + NAME_FIELD + TEXT); sqLiteDatabase.execSQL(creation); } @Override public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) { String[] name = {TABLE_NAME}; // prepared statements sqLiteDatabase.execSQL(DROP TABLE IF EXISTS ?, name); onCreate(sqLiteDatabase); } public void add(String name){ SQLiteDatabase db = getWritableDatabase(); ContentValues cv = new ContentValues(); cv.put(NAME_FIELD, name); db.insert(TABLE_NAME, , cv); } public int delete(String name){ SQLiteDatabase db = getWritableDatabase(); String clause = NAME_FIELD + = ?; String[] args = {name}; return db.delete(TABLE_NAME, clause, args); } public int find(String name){ SQLiteDatabase db = getWritableDatabase(); String selection = NAME_FIELD + = ?; String[] args = {name}; Cursor c = db.query(TABLE_NAME, , selection, args, , , , ); int result = -1; if(c.moveToFirst()){ result = c.getInt(0); } return result; } // Outside private Properties properties; private static final String PROPERTIES_FILE = properties.xml; // onCreate File file = new File(getFilesDir(), PROPERTIES_FILE); properties = new Properties(); try { if (file.exists()) { FileInputStream fis = openFileInput(PROPERTIES_FILE); properties.loadFromXML(fis); fis.close(); } else { saveProperties(); } }catch(IOException ioe){ ioe.printStackTrace(); } //Function private void saveProperties() throws IOException { FileOutputStream fos = openFileOutput(PROPERTIES_FILE, Context.MODE_PRIVATE); properties.storeToXML(fos, ); fos.close(); } public void saveProperty(View v){ properties.setProperty(demo, editText.getText().toString()); } public void loadProperty(View v){ properties.getProperty(demo); } public void saveToStorage(View v){ saveProperties(); }
©