創(chuàng)建表的語句很簡單，格式如下
create table 表名(字段名 類型，字段名 類型，…)；
package com.uyac.andriodsqlite;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
/**
* Created by ShaoQuanwei on 2017/2/15.
*/
public class MySqliteHelper extends SQLiteOpenHelper {
/*表名*/
private final String TABLE_NAME_PERSON = "person";
/*id字段*/
private final String VALUE_ID = "_id";
private final String VALUE_NAME = "name";
private final String VALUE_ISBOY = "isboy";
private final String VALUE_AGE = "age";
private final String VALUE_ADDRESS = "address";
/*頭像字段*/
private final String VALUE_PIC = "pic";
/*創(chuàng)建表語句 語句對大小寫不敏感 create table 表名(字段名 類型，字段名 類型，…)*/
private final String CREATE_PERSON = "create table " + TABLE_NAME_PERSON + "(" +
VALUE_ID + " integer primary key," +
VALUE_NAME + " text ," +
VALUE_ISBOY + " integer," +
VALUE_AGE + " ingeter," +
VALUE_ADDRESS + " text,"+
VALUE_PIC + " blob"+
")";
public MySqliteHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
//創(chuàng)建表
db.execSQL(CREATE_PERSON);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
mySqliteHelper = new MySqliteHelper(context,Constants.DB_NAME,null,Constants.DB_VERSION);
當你new了之后，添加第一條數(shù)據(jù)時，才可以在data/data/包名/databases目錄下面可以發(fā)現(xiàn)你創(chuàng)建的數(shù)據(jù)庫名和表名。
- 當首次安裝時
02-17 10:41:01.187 25862-25862/com.uyac.andriodsqlite E/MySqliteHelper: -------> MySqliteHelper
02-17 10:41:01.480 25862-25862/com.uyac.andriodsqlite E/MySqliteHelper: -------> onCreate
- 當再次啟動數(shù)據(jù)庫版本保持不變時
02-17 10:45:52.976 29607-29607/com.uyac.andriodsqlite E/MySqliteHelper: -------> MySqliteHelper
- 當再次安裝數(shù)據(jù)庫版本升級時
02-17 10:41:59.286 27082-27082/com.uyac.andriodsqlite E/MySqliteHelper: -------> MySqliteHelper
02-17 10:41:59.421 27082-27082/com.uyac.andriodsqlite E/MySqliteHelper: -------> onUpgrade
sqlite也無非就創(chuàng)建、增、刪、改、查、更新。
