android中SQLite实现

package com.example.administrator.myapplication;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class BookmarkSQLiteOpenHelper extends SQLiteOpenHelper{
    public BookmarkSQLiteOpenHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version){
        super(context,name,factory,version);
    }

    @Override
    public void onCreate(SQLiteDatabase db){
        String sql="create table bookmark(id integer primary key autoincrement,favicon varchar(100),title varchar(100),url varchar(100))";
        db.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){}
}

bookmarkSQLiteOpenHelper=new BookmarkSQLiteOpenHelper(this,"browser.db",null,1);

void insertBookmark(Bookmark bookmark){
        SQLiteDatabase db=bookmarkSQLiteOpenHelper.getWritableDatabase();
        db.execSQL("insert into bookmark(favicon,title,url)values(?,?,?)",new String[]{bookmark.getFavicon(),bookmark.getTitle(),bookmark.getUrl()});
    }