mars android开发之八：SQLite

(一) getWritableDatabase()和getReadableDatabase()方法区别
Android使用getWritableDatabase()和getReadableDatabase()方法都可以获取一个用于操作数据库的SQLiteDatabase实例。(getReadableDatabase()方法中会调用getWritableDatabase()方法)
其中getWritableDatabase() 方法以读写方式打开数据库，一旦数据库的磁盘空间满了，数据库就只能读而不能写，倘若使用的是getWritableDatabase() 方法就会出错。

getReadableDatabase()方法则是先以读写方式打开数据库，如果数据库的磁盘空间满了，就会打开失败，当打开失败后会继续尝试以只读方式打开数据库。如果该问题成功解决，则只读数据库对象就会关闭，然后返回一个可读写的数据库对象。

(二)sqlite实现增删改查实例

MainActivity.java

package com.example.sqlite;

import android.os.Bundle;
import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;

public class MainActivity extends Activity {

	Button createDatabaseButton;
	Button updateDatabaseButton;
	Button insertButton;
	Button updateButton;
	Button queryButton;

	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		createDatabaseButton = (Button) findViewById(R.id.createDatabaseButton);
		updateDatabaseButton = (Button) findViewById(R.id.updateDatabaseButton);
		insertButton = (Button) findViewById(R.id.insertButton);
		updateButton = (Button) findViewById(R.id.updateButton);
		queryButton = (Button) findViewById(R.id.queryButton);
		createDatabaseButton.setOnClickListener(new OnClickListener() {
			
			@Override
			public void onClick(View arg0) {
				DBHelper dbHelper = new DBHelper(MainActivity.this);
				SQLiteDatabase db = dbHelper.getReadableDatabase();
			}
		});
		updateDatabaseButton.setOnClickListener(new OnClickListener() {
			
			@Override
			public void onClick(View v) {
				DBHelper dbHelper = new DBHelper(MainActivity.this,2);
				SQLiteDatabase db = dbHelper.getReadableDatabase();
			}
		});
		insertButton.setOnClickListener(new OnClickListener() {
			
			@Override
			public void onClick(View v) {
				DBHelper dbHelper = new DBHelper(MainActivity.this);
				SQLiteDatabase db = dbHelper.getWritableDatabase();
				ContentValues values = new ContentValues();
				values.put("id", 1);
				values.put("name", "zhangsan");
				db.insert("user", null, values);
			}
		});
		updateButton.setOnClickListener(new OnClickListener() {
			
			@Override
			public void onClick(View v) {
				DBHelper dbHelper = new DBHelper(MainActivity.this);
				SQLiteDatabase db = dbHelper.getWritableDatabase();
				ContentValues values = new ContentValues();
				values.put("name", "zhangsanfeng");
				db.update("user", values, "id=?", new String[]{"1"});
			}
		});
		queryButton.setOnClickListener(new OnClickListener() {
			
			@Override
			public void onClick(View v) {
				DBHelper dbHelper = new DBHelper(MainActivity.this);
				SQLiteDatabase db = dbHelper.getReadableDatabase();
				Cursor cursor = db.query("user", new String[]{"id","name"}, "id=?", new String[]{"1"}, null, null, null);
				while(cursor.moveToNext()){
					String name = cursor.getString(cursor.getColumnIndex("name"));
					System.out.println("query--->"+name);
				}
			}
		});
	}
}

DBHelper.java

package com.example.sqlite;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper extends SQLiteOpenHelper{
	
	public static final String DATABASE_NAME = "user.db";
	public static final int DATABASE_VERSION = 1;

	public DBHelper(Context context) {
		super(context, DATABASE_NAME, null, DATABASE_VERSION);
	}
	
	

	public DBHelper(Context context,int version) {
		super(context, DATABASE_NAME, null, version);
	}



	@Override
	public void onCreate(SQLiteDatabase db) {
		System.out.println("create a Database");
		db.execSQL("create table user(id integer,name varchar(20))");
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		System.out.println("update a Database");
	}

}

activity_main.xml

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="fill_parent"
    android:layout_height="match_parent"
    android:orientation="vertical">

    <Button 
        android:id="@+id/createDatabaseButton"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="createDatabase"/>

    <Button 
        android:id="@+id/updateDatabaseButton"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="updateDatabase"/>
    
    <Button 
        android:id="@+id/insertButton"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="insert"/>
    
    <Button 
        android:id="@+id/updateButton"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="update"/>
    
    <Button 
        android:id="@+id/queryButton"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="query"/>
</LinearLayout>