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

来源：互联网发布：知乎女朋友不花钱编辑：程序博客网时间：2024/05/07 22:39

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的详细用法

0 0