SQLite数据库存储

一.任务

        在环境变量Path中配置Platform-tools的路径，输入   adb shell，输入   cd /data/data/cn.bzu.tong.sqlite/databases，输入    sqlite3 BookStore.db，输入 .table查看数据库中的表，输入.scheme,查看建表语句，输入 select * from Book查看表中内容

二  运行结果，图片展示

1  add  data.

2.  cerate    databases

3.  quary  data

4  update  data

5.  delete  data

三  核心代码

1   MainActivity.java

package cn.wulian.liulunan.sqlite;    import android.app.Activity;  import android.content.ContentValues;  import android.database.Cursor;  import android.database.sqlite.SQLiteDatabase;  import android.os.Bundle;  import android.util.Log;  import android.view.Menu;  import android.view.View;  import android.view.View.OnClickListener;  import android.widget.Button;  import cn.bzu.tong.sqlist.R;  import cn.bzu.tong.sqlite.db.DBHelper;    public class MainActivity extends Activity {        private DBHelper dbHelper;      private Button createDatabase,addData,updateData,deleteData,queryData;      @Override      protected void onCreate(Bundle savedInstanceState) {          super.onCreate(savedInstanceState);          setContentView(R.layout.activity_main);          dbHelper = new DBHelper(this,"BookStore.db",null, 2);          queryData = (Button) findViewById(R.id.query_data);          deleteData = (Button) findViewById(R.id.delete_data);          updateData = (Button) findViewById(R.id.update_data);          addData = (Button) findViewById(R.id.add_data);          createDatabase = (Button) findViewById(R.id.creat_database);          createDatabase.setOnClickListener(new OnClickListener() {                            @Override              public void onClick(View view) {                    dbHelper.getWritableDatabase();              }          });          addData.setOnClickListener(new OnClickListener() {                            @Override              public void onClick(View view) {                    SQLiteDatabase db = dbHelper.getWritableDatabase();                  ContentValues values = new ContentValues();                  //开始组装第一条数据                  values.put("name", "The Da Vinci Code");                  values.put("author", "Dan Brown");                  values.put("pages", 454);                  values.put("price", 16.96);                  db.insert("Book", null, values);//插入第一条数据                  values.clear();                  //开始组装第二条数据                  values.put("name", "The Lost Symbol");                  values.put("author", "Dan Brown");                  values.put("pages", 510);                  values.put("price", 19.95);                  db.insert("Book", null, values);//插入第二条数据              }          });          updateData.setOnClickListener(new OnClickListener() {                            @Override              public void onClick(View view) {                    SQLiteDatabase db = dbHelper.getWritableDatabase();                  ContentValues values = new ContentValues();                  values.put("price", 10.99);                  db.update("Book", values, "name=?", new String[]{"The Da Vinci Code"});              }          });          deleteData.setOnClickListener(new OnClickListener() {                            @Override              public void onClick(View view) {                    SQLiteDatabase db = dbHelper.getWritableDatabase();                  db.delete("Book", "pages > ?", new String[]{"400"});//范围              }          });          queryData.setOnClickListener(new OnClickListener() {                            @Override              public void onClick(View view) {                    SQLiteDatabase db = dbHelper.getWritableDatabase();                  //查询Book表中所有数据                  Cursor cursor = db.query("Book",null,null,null,null,null,null);                  if(cursor.moveToFirst()){                      do{                          //遍历Cursor对象，取出数据并打印                          String name = cursor.getString(cursor.getColumnIndex("name"));                          String author = cursor.getString(cursor.getColumnIndex("author"));                          int pages = cursor.getInt(cursor.getColumnIndex("pages"));                          double price = cursor.getDouble(cursor.getColumnIndex("price"));                          Log.d("MainActivity", "book name is "+name);                          Log.d("MainActivity", "book author is "+author);                          Log.d("MainActivity", "book page is "+pages);                          Log.d("MainActivity", "book price is "+price);                                                }while(cursor.moveToNext());                  }                  cursor.close();              }          });      }          @Override      public boolean onCreateOptionsMenu(Menu menu) {          // Inflate the menu; this adds items to the action bar if it is present.          getMenuInflater().inflate(R.menu.main, menu);          return true;      }        }  

2.  activity_main.xml

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"      xmlns:tools="http://schemas.android.com/tools"      android:layout_width="match_parent"      android:layout_height="match_parent"      tools:context=".MainActivity"      android:orientation="vertical" >        <Button          android:id="@+id/creat_database"          android:layout_width="match_parent"          android:layout_height="wrap_content"          android:text="Create database" />      <Button           android:id="@+id/add_data"          android:layout_width="match_parent"          android:layout_height="wrap_content"          android:text="Add Data"/>      <Button           android:id="@+id/update_data"          android:layout_width="match_parent"          android:layout_height="wrap_content"          android:text="Update Data"/>      <Button           android:id="@+id/delete_data"          android:layout_width="match_parent"          android:layout_height="wrap_content"          android:text="Delete Data"/>      <Button           android:id="@+id/query_data"          android:layout_width="match_parent"          android:layout_height="wrap_content"          android:text="Query Data"/>          </LinearLayout>