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

来源：互联网发布：网络教学系统编辑：程序博客网时间：2024/06/05 09:17

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

我在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);    }}

cb747006c03c79d5a621cc990a184ed291e11b5f

阅读全文

0 0