一. 任务在环境变量 Path 中配置 Platform-tools 的路径,输入 adb shell,输入 cd /data/data/cn.bzu.tong.sqlite/databases,输入 sqlite3 BookStore.db,输入 .table 查看 mysql"target="_blank"title="MySQL 知识库 "> 数据库中的表,输入. 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 就爱阅读 www.92to.com 网友整理上传, 为您提供最全的知识大全, 期待您的分享,转载请注明出处。
来源: