【android】SQlite数据库基本使用方法

android中使用SQLite数据库的话使用的是SQLiteOpenHelper基类。

Db.java

package com.example.hujiaxuan.ambition;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * Created by hujiaxuan on 2014/12/5.
 */
public class Db extends SQLiteOpenHelper
{
    public Db(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, "db", null, 1);
    }
    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
        sqLiteDatabase.execSQL("CREATE TABLE user(" +
                "_id INTEGER PRIMARY KEY AUTOINCREMENT," +
                "count Text DEFAULT \"\"," +
                "password Text DEFAULT \"\")");
        sqLiteDatabase.execSQL("CREATE TABLE msg(" +
                "_id INTEGER PRIMARY KEY AUTOINCREMENT," +
                "ambition Text DEFAULT \"\"," +
                "time Text DEFAULT \"\")");<span style="white-space:pre">			</span>//c创建了两张表
    }
    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i2) {
    }
}

使用数据库添加：

private SQLiteDatabase dbRead,dbWrite; //dbRead用于读出数据，dbWrite用于插入数据

db=new Db(this,"db",null,1);
        dbRead=db.getReadableDatabase();
        dbWrite=db.getWritableDatabase(); //通过Db类创建数据库

    dbRead=db.getReadableDatabase();
        dbWrite=db.getWritableDatabase();

  ContentValues cv=new ContentValues();
            cv.put("ambition",etAmbition.getText().toString());
            cv.put("time",etTime.getText().toString());
            dbWrite.insert("msg",null,cv);<span style="white-space:pre">		</span>//数据添加

</pre><pre code_snippet_id="544432" snippet_file_name="blog_20141206_7_557851" name="code" class="java">  int itemId=c.getInt(c.getColumnIndex("_id"));
                           dbWrite.delete("msg","_id=?",new String[]{itemId+""});//数据删除

</pre><pre code_snippet_id="544432" snippet_file_name="blog_20141206_9_6964872" name="code" class="java">

SQLite的详细用法