package?com.tong.projecte04_2;

import?android.app.Activity;
import?android.database.sqlite.SQLiteDatabase;
import?android.os.Bundle;
import?android.view.Menu;
import?android.view.MenuItem;

public?class?MainActivity?extends?Activity?{

	@Override
	protected?void?onCreate(Bundle?savedInstanceState)?{
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		//創建一個數據庫，并打開
		SQLiteDatabase?db=?openOrCreateDatabase("user.db",?MODE_PRIVATE,?null);
	//創建一個表,在表中添加一個主鍵三個字段，第一個主鍵id前必須加_,否則查詢數據的時候就會出錯
		db.execSQL("create?table?if?not?exists?usertb?(?_id?integer?prinary?key?autoincrement,?name?text?not?null?,?sex?text?not?null?,?age?integer?not?null?)");
//		//往表中添加數據
		db.execSQL("insert?into?usertb(name,sex,age)?values('張三','女',20)");
	}	
}