Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to use SQLite", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to use SQLite" this article.

General steps:

Create a SQLiteDatabase object

Perform the add and delete operation by overriding the SQLiteHelper class

Writing construction method

The onCreate () method, that is, the method that is called the first time the table is used (the general statement for creating the table)

OnUpgrade () method, which is called when the version is updated

Execute the query operation directly (the return value is cursor)

Call the moveToXX () method to find the relevant data directly from the cursor and return a Boolean value (the cursor is scrollable and does not require While ()).

Example code:

Override the SQLiteHelper class

Package com.study.entity;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;public class Dao extends SQLiteOpenHelper {public Dao (Context context) {super (context, "db_con", null, 1) / / TODO Auto-generated constructor stub} @ Override public void onCreate (SQLiteDatabase sdb) {/ / TODO Auto-generated method stub sdb.execSQL ("CREATE TABLE t_contact (_ id intger primary key autoincrement,name varchar (50), phone varchar (50)"); sdb.execSQL ("insert into t_contact (name,phone) values ('williammu','18297927880')") } @ Override public void onUpgrade (SQLiteDatabase sdb, int oldVersion Int newVersion) {/ / TODO Auto-generated method stub / / if (oldVersion = = 1 & & newVersion = = 2) {/}} / * * get all contacts * * @ return Cursor * / public Cursor GetAll () {SQLiteDatabase sdb = getReadableDatabase () Cursor cur = sdb.rawQuery ("SELECT * FROM t_contact", null); return cur;} / * * add contacts * / public void insertContacts () {Contact contact=new Contact (); SQLiteDatabase sdb = getWritableDatabase () Sdb.execSQL ("INSERT INTO t_contact (name,phone) VALUES ('" + contact.getName () + ",'" + contact.getPhone () + "'));}} above is all the content of this article" how to use SQLite ". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.