SQLite Operation class:
Packagecom.example.administrator.myapplication;ImportAndroid.content.Context;Importandroid.database.sqlite.SQLiteDatabase;ImportAndroid.database.sqlite.SQLiteOpenHelper; Public classBookmarksqliteopenhelperextendssqliteopenhelper{ PublicBookmarksqliteopenhelper (context context, String name, Sqlitedatabase.cursorfactory factory,intversion) { Super(context,name,factory,version); } @Override Public voidonCreate (Sqlitedatabase db) {String SQL= "CREATE TABLE bookmark" (ID integer primary key autoincrement,favicon varchar (+), Title varchar (+), url varchar (100)) "; Db.execsql (SQL); } @Override Public voidOnupgrade (Sqlitedatabase db,intOldversion,intnewversion) {}}
SQLite initialization:
bookmarksqliteopenhelper=New bookmarksqliteopenhelper (This, "browser.db",null, 1);
SQLite Insert Data:
void Insertbookmark (Bookmark bookmark) { sqlitedatabase db= Bookmarksqliteopenhelper.getwritabledatabase (); Db.execsql ("INSERT into Bookmark (Favicon,title,url) VALUES (?,?,?)",new string[]{ Bookmark.getfavicon (), Bookmark.gettitle (), Bookmark.geturl ()}); }
SQLite implementation in Android