SQLite使用

最新推荐文章于 2024-11-13 22:46:04 发布

cthawdf

最新推荐文章于 2024-11-13 22:46:04 发布

阅读量237

点赞数

分类专栏： Android 文章标签： sqlite string 数据库 null user 2010

本文链接：https://blog.csdn.net/cthawdf/article/details/7449972

版权

Android 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

1.创建SQLiteOpenHelper对象，通过SQLiteOpenHelper对象调用getReadableDatabase(),getWritableDatabase()方法获得(或创建)可读，可写的数据库对象

DataBaseHelper databaseHelper = new DataBaseHelper(SQLiteActivity.this,"Test_create_db",2); //DataBaseHelper extends SQLiteOpenHelper
SQLiteDatabase db = databaseHelper.getReadableDatabase(); //调用才创建数据库

2. 数据库插入，生成ContentValues对象，通过ContentValues对象想数据库中插入数据

ContentValues value = new ContentValues();
   value.put("id", 1);
   value.put("name", "zhangsan");

   DataBaseHelper databaseHelper = new DataBaseHelper(SQLiteActivity.this,"Test_create_db",2);
   SQLiteDatabase db = databaseHelper.getWritableDatabase();
   db.insert("user", null, value);

3.更改数据

DataBaseHelper databaseHelper = new DataBaseHelper(SQLiteActivity.this,"Test_create_db",2);
   SQLiteDatabase db = databaseHelper.getWritableDatabase();
   ContentValues value = new ContentValues();
   value.put("name", "zhangshanffeng");
   db.update("user", value, "id =?", new String []{"1"});

4. 查询数据

   DataBaseHelper databaseHelper = new DataBaseHelper(SQLiteActivity.this,"Test_create_db",2);
   SQLiteDatabase db = databaseHelper.getReadableDatabase();
   Cursor cursor = db.query("user", new String []{"id","name"}, "id=?", new String[]{"1"}, null, null, null);
   while(cursor.moveToNext())
   {
    String name = cursor.getString(cursor.getColumnIndex("name"));
    System.out.println("query-->"+name);
   }