android数据库sqlite松散数据类型

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版本加入的，如果想要使用这个特新，需考虑覆盖设备