Android SQLite Database

Last Update:2015-10-18 Source: Internet

Author: User

Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

The SQLite database is small and consumes only hundreds of K of memory, and both Android and iOS are SQLite databases.Page:<pre><LinearLayoutxmlns:android= "http://schemas.android.com/apk/res/android"Android:layout_width= "match_parent"Android:layout_height= "match_parent"android:orientation= "vertical"> <ButtonAndroid:id= "@+id/btninsertdata"Android:layout_width= "match_parent"Android:layout_height= "wrap_content"Android:text= "add data" /> <ButtonAndroid:id= "@+id/btndeletedata"Android:layout_width= "match_parent"Android:layout_height= "wrap_content"Android:text= "delete data" /> <ButtonAndroid:id= "@+id/btnupdatedata"Android:layout_width= "match_parent"Android:layout_height= "wrap_content"Android:text= "modify data" /> <ButtonAndroid:id= "@+id/btnquerydata"Android:layout_width= "match_parent"Android:layout_height= "wrap_content"Android:text= "query data" /> </LinearLayout></pre>Java<pre> packagecom.sxt.day06_09;Importjava.util.ArrayList;Importjava.util.List;ImportCom.sxt.day06_09.entity. studentbean;Importandroid.app.Activity;Importandroid.database.Cursor;Importandroid.database.sqlite.SQLiteDatabase;Importandroid.os.Bundle;Importandroid.util.Log;Importandroid.view.View;Importandroid.view.View.OnClickListener; public classMainactivityextendsActivity {Static FinalString db_name= "students.db"; Static FinalString table_name= "student"; Static FinalString id= "_id";//only underline ID can be written Static FinalString name= "NAME"; Static FinalString sex= "SEX"; Static FinalString birthday= "BIRTHDAY"; Static FinalString height= "HEIGHT"; @Overrideprotected voidonCreate (Bundle Savedinstancestate) {Super. OnCreate (savedinstancestate); Setcontentview (r.layout.activity_main); Creatdatabase ();//Create a databaseSetlistener (); } Private voidSetlistener () {setinsertclicklistener (); Setdeleteclicklistener (); Setqueryclicklistener (); } Private voidsetqueryclicklistener () {findviewbyid (r.id.btnquerydata). setonclicklistener (NewOnclicklistener () {@Override public voidonClick (View v) {sqlitedatabase db= Openorcreatedatabase (db_name, mode_private,NULL); String SQL= "select * from" +table_name+ "where" +name+ "like?"; String SQL1= "select * from" +table_name; Cursor C= Db.rawquery (sql,Newstring[]{"'% Phenanthrene '"}); Cursor C= Db.rawquery (sql,NULL);//the query can only be used rawquery, and the returned cursor is the query result setList<studentbean> students=NewArraylist<studentbean>(); BooleanFlag =C.movetofirst (); while(c.movetonext ()) {//traverse each row intId=c.getint (c.getcolumnindex (ID));//Gets the ID column of a rowString name=c.getstring (c.getcolumnindex (NAME)); String Sex=c.getstring (c.getcolumnindex (SEX)); String Birthday=c.getstring (c.getcolumnindex (BIRTHDAY)); Doubleheight=c.getdouble (c.getcolumnindex (HEIGHT)); Studentbean Bean=Newstudentbean (id, name, sex, birthday, height); Students.add (bean); } for(studentbean bean:students) {log.i ("main", Bean.tostring ()); } c.close ();//Freeing Resources } }); } Private voidsetdeleteclicklistener () {findviewbyid (r.id.btndeletedata). setonclicklistener (NewOnclicklistener () {@Override public voidonClick (View v) {sqlitedatabase db= Openorcreatedatabase (db_name, mode_private,NULL); String SQL= "delete from" +table_name+ "where" +name+ "like '% phenanthrene '"; Db.execsql (sql); } }); } Private voidsetinsertclicklistener () {findviewbyid (r.id.btninsertdata). setonclicklistener (NewOnclicklistener () {@Override public voidonClick (View v) {sqlitedatabase db=openorcreatedatabase (db_name, mode_private,NULL); InsertData (db); //the database path is: data/data/com.ityw.exer15_1/databases/students.db } }); } //Create a database Private voidcreatdatabase () {sqlitedatabase db= Openorcreatedatabase (db_name, mode_private,NULL);//Create a databaseString sql= "create table if not exists" +table_name+ "(" +id+ "integer primary key autoincrement," +n ame+ "varchar", "+sex+" varchar (2), "+birthday+" datetext, "+height+" real) "; Db.execsql (sql); } Private voidinsertdata (sqlitedatabase db) {String SQL= "insert into" +table_name+ "(" +NAME+ "," +sex+ "," +birthday+ "," +height+ ") values (" + "' Zhang Fei ', ' male ', ' 1990-5-5 ', 1.99)"; Db.execsql (sql); SQL= "insert into" +table_name+ "(" +NAME+ "," +sex+ "," +birthday+ "," +height+ ") values (" + "' Faye ', ' female ', ' 1990-8-5 ', 1.69)"; Db.execsql (sql); SQL= "insert into" +table_name+ "(" +NAME+ "," +sex+ "," +birthday+ "," +height+ ") values (" + "' Liu Yifei ', ' female ', ' 1991-8-5 ', 1.71)"; Db.execsql (sql); }}</pre>Android SQLite Database

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More

Android SQLite Database

Contact Us

A Free Trial That Lets You Build Big!

Sales Support

After-Sales Support