Android开发当中SQLite数据库的应用

这个应该算是小型数据库了。

我在DJANGO开发中已不怎么用它啦。

APP中，试一下用法吧。

package com.tw.flag.ch15_sqlite;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.widget.TextView;

public class MainActivity extends AppCompatActivity {
    static final String db_name="testDB";
    static final String tb_name="test";
    SQLiteDatabase db;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        db = openOrCreateDatabase(db_name, Context.MODE_PRIVATE, null);
        String createTable="CREATE TABLE IF NOT EXISTS " +
                tb_name +
                "(name VARCHAR(32), " +
                "phone VARCHAR(16), " +
                "email VARCHAR(64))";
        db.execSQL(createTable);

        Cursor c = db.rawQuery("SELECT * FROM " + db_name, null);
        if (c.getCount() == 0) {
            addData("Flag Publishing Co.", "02-23423433", "service@flag.com.tw");
            addData("PCDIY Magzine", "02-33267979", "service@pcdiy.com.tw");
            c = db.rawQuery("SELECT * FROM " + db_name, null);
        }

        if (c.moveToFirst()) {
            String str = "总共有 " + c.getCount() + " 项数据\n";
            str += "-------------";
            do {
                str += "name: " + c.getString(0) + "\n";
                str += "phone: " + c.getString(1) + "\n";
                str += "email: " + c.getString(2) + "\n";
                str += "-------------";
            } while (c.moveToNext());
            TextView txv = (TextView) findViewById(R.id.txv);
            txv.setText(str);
        }
        db.close();
    }
    private void addData(String name, String phone, String email) {
        ContentValues cv = new ContentValues(3);
        cv.put("name", name);
        cv.put("phone", phone);
        cv.put("email", email);
        db.insert(tb_name, null, cv);
    }
}