sqlite数据库是android使用的轻量级的关系型数据库
关于松散数据类型,这个跟JS数据类型比较相似
测试代码:
数据库帮助类
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class MyDatebaseHelper extends SQLiteOpenHelper {
public static final String DATABASE_NAME = "test.db";
public static final String DATABASE_MAINTABLE = "main";
public static final String MAINTABLE_ID = "_id";
public static final String MAINTABLE_NUM = "num";
private static final String SQL_CREATE_MIANTABLE = "CREATE TABLE " +
DATABASE_MAINTABLE + "(" +
MAINTABLE_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
MAINTABLE_NUM + " INTEGER NOT NULL" +
");";
public MyDatebaseHelper(Context context, String name,
CursorFactory factory, int version) {
super(context, name, factory, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(SQL_CREATE_MIANTABLE);
}
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
}
}
其中num为测试列,数据类型为integer,下面进行插入操作
public class StatrActivity extends Activity {
private MyDatebaseHelper dbHelper = null;
private SQLiteDatabase dataBase = null;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_statr);
this.dbHelper = new MyDatebaseHelper(this, MyDatebaseHelper.DATABASE_NAME, null, 1);
dataBase = dbHelper.getWritableDatabase();
testInsert();
}
private void testInsert() {
ContentValues values = new ContentValues();
values.put(MyDatebaseHelper.MAINTABLE_NUM, "5");
dataBase.insert(MyDatebaseHelper.DATABASE_MAINTABLE, null, values);
values.put(MyDatebaseHelper.MAINTABLE_NUM, "harry");
dataBase.insert(MyDatebaseHelper.DATABASE_MAINTABLE, null, values);
dataBase.close();
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.activity_statr, menu);
return true;
}
}
This document describes the support for SQL foreign key constraints introduced in SQLite version 3.6.19.
外键是在3.6.19版本加入的,如果想要使用这个特新,需考虑覆盖设备