- @Override
- protected void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- //打开或创建test.db数据库
- SQLiteDatabase db = openOrCreateDatabase("test.db", Context.MODE_PRIVATE, null);
- db.execSQL("DROP TABLE IF EXISTS person");
- //创建person表
- db.execSQL("CREATE TABLE person (_id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR, age SMALLINT)");
- Person person = new Person();
- person.name = "john";
- person.age = 30;
- //插入数据
- db.execSQL("INSERT INTO person VALUES (NULL, ?, ?)", new Object[]{person.name, person.age});
- person.name = "david";
- person.age = 33;
- //ContentValues以键值对的形式存放数据
- ContentValues cv = new ContentValues();
- cv.put("name", person.name);
- cv.put("age", person.age);
- //插入ContentValues中的数据
- db.insert("person", null, cv);
- cv = new ContentValues();
- cv.put("age", 35);
- //更新数据
- db.update("person", cv, "name = ?", new String[]{"john"});
- Cursor c = db.rawQuery("SELECT * FROM person WHERE age >= ?", new String[]{"33"});
- while (c.moveToNext()) {
- int _id = c.getInt(c.getColumnIndex("_id"));
- String name = c.getString(c.getColumnIndex("name"));
- int age = c.getInt(c.getColumnIndex("age"));
- Log.i("db", "_id=>" + _id + ", name=>" + name + ", age=>" + age);
- }
- c.close();
- //删除数据
- db.delete("person", "age < ?", new String[]{"35"});
- //关闭当前数据库
- db.close();
- //删除test.db数据库
- // deleteDatabase("test.db");
- }
- package com.scott.db;
- import android.content.Context;
- import android.database.sqlite.SQLiteDatabase;
- import android.database.sqlite.SQLiteOpenHelper;
- public class DBHelper extends SQLiteOpenHelper {
- private static final String DATABASE_NAME = "test.db";
- private static final int DATABASE_VERSION = 1;
- public DBHelper(Context context) {
- //CursorFactory设置为null,使用默认值
- super(context, DATABASE_NAME, null, DATABASE_VERSION);
- }
- //数据库第一次被创建时onCreate会被调用
- @Override
- public void onCreate(SQLiteDatabase db) {
- db.execSQL("CREATE TABLE IF NOT EXISTS person" +
- "(_id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR, age INTEGER, info TEXT)");
- }
- //如果DATABASE_VERSION值被改为2,系统发现现有数据库版本不同,即会调用onUpgrade
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- db.execSQL("ALTER TABLE person ADD COLUMN other STRING");
- }
- }