simple sqlite database example in android

. imageView);} private class ButtonOnClickListener implements View. onClickListener {public void onClick (View v) {if (isDownload) {new Thread () {public void run () {mBitmap = getBitmap ("http://s12.sinaimg.cn/mid Dle/4b181bd0gbf6cb07c2a1b 690 "); handler. sendEmptyMessage (DOWNLOAD_FINISH );}}. start () ;}if (isSave) {DBservice service = new DBservice (MainActivity. this); Photo photo = new Photo (1, mBitmap); service. save (photo, photoByte); isLoadFromDB = true; isSave = false; mButton. set

Android-sqlite Commercial Database OperationsA specific data operationIncrease/*** Insert User Instance* @param puser* @return*/Public long Insertuser (User puser){if (msqlitedatabase! = NULL Puser! = null){Insert a recordContentvalues _contentvalues = new Contentvalues ();_contentvalues.put (Column_username, Puser.getmusername ());_contentvalues.put (Column_use

Refer to Android Development Authority Guide1 SQLite tool SQLite database browsersqlite expert extends sionalsqlite extends sqlitespy 2 sqliteopenhelperoncreate (sqlitedatabase dB) // check the database file name. this method is called if the

); } @Override Public voidonCreate (Sqlitedatabase db) {//automatically create tables when using the database for the first timeDb.execsql (Create_table_sql); } @Override Public voidOnupgrade (Sqlitedatabase db,intOldversion,intnewversion) {System.out.println ("--------OnUpdate called--------" + oldversion + "--->" +newversion); }} Public classResultactivityextendsActivity {Listlist; @Override Public voidonCreate (Bundle savedinstancestate) {Super. On

= Helper.getreadabledatabase ();cursor cursor = db.rawquery ("Select *from person", NULL);arraylistwhile (Cursor.movetonext ()){int id = cursor.getint (cursor.getcolumnindex ("id"));String name = cursor.getstring (Cursor.getcolumnindex ("name"));String number = cursor. GetString (Cursor.getcolumnindex ("number"));person person = new person (ID, name, number);List.add (person);}return list;}}ThingsOpen ThingsDb.begintransaction ();Try{Mark Things executed successfullyDb.settransactionsuccessful

getreadabledatabase directly to get the database Sqlitedatabase object. Here is how to voluntarily choose to have an SD card, there is an SD card, not stored in memory.Public Dbopenhelper (Context context) {//define ConstructorsSuper (context, DBNAME, null,version);//Overriding the constructor of a base class}This constructor is changed to the endPublic Dbopenhelper (Context context,string name) {//define ConstructorsSuper (context, name, null,versio

. Field numberINNER JOIN table X on Member. Field number = table x. Field numberStatement 7. Add a small example here the nested SELECT statement, query results, as a table B, to query Select a. Product number, A. Initial quantity + B.numfrom Warehouse A, (select product number, SUM (quantity) as num from Danju GROUP by product number As b,where A. Product number =b. Product numberSummarizeThe connection query is the core of the SQL query, and th

In development, it is sometimes necessary to use the DB file database. Therefore, it is necessary to import it into the project, and then write its usage program to the application's DB file for use.The code is very easy. can be used directly.There are two steps required to use:1. Create the raw file. Import the DB file. For example, the following:2. Codepublic class Dbopenhelper {private final int buffer_s

More content Welcome to my personal website: www.qingshuimonk.com viewSQLite is a lightweight relational database that currently supports five types of null,integer,real (floating point), text (string literal), BLOB (binary text).The created database file is located in the/data/data/package-name/databases directory.Files can be accessed through the File Explorer in Eclipse.Steps for the

(index); Is the data that gets the specified subscript index to int type; int id = cursor.getint (cursor.getcolumnindex ("id")) ; String named = cursor.getstring (Cursor.getcolumnindex ("name")); String number = cursor.getstring (Cursor.getcolumnindex ("number"));//Instantiate query result data Object person = new person (ID, named, number);} Close the database connection, release the Resource Db.close ();//Return the data result object return person