android 之sqlite数据库的创建

废话不多说，直接上代码：

package com.bool.utils;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class DBUtils extends SQLiteOpenHelper{
    public DBUtils(Context context){
        super(context,"person.db",null,1);
    }

    public void onCreate(SQLiteDatabase db){
        db.execSQL("create table person(" +
                "id integer primary key autoincrement," +
                "name varchar(20)," +
                "number varchar(20))");

    }

    public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){
        db.execSQL("alter table person add account varchar(29)");
    }
}

感悟:sqlite数据库由于其运行环境的独特，与sql server、mysql等即写即预览类型数据库略有不同，其语法都大同小异，个人感觉sqlite数据库因为运行环境的独特更多的是偏向理论逻辑。