【.NET老猿學安卓系列】資料庫讀寫

標籤：android   style   blog   color   ar   os   使用   sp   資料   

第一步，就是下面這個類：


package com.fengzili.dbTesting;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper; //看好這個明明空間import  android.util.Log;/** * Created by Administrator on 2014/11/4. */public class PersonHelper extends  SQLiteOpenHelper{    public  PersonHelper(Context context){        super(context,"person.db",null,1);    }    @Override    public void onCreate(SQLiteDatabase sqLiteDatabase) {        sqLiteDatabase.execSQL("create table person(id integer primary key,name nvarchar(20),number nvarchar(20))");  //初始化資料庫結構    }    @Override    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i2) {        Log.e("fengzili","資料庫從"+i+"升級到了"+i2);    }}

//簡單版的增刪改查package com.com.fengzili.dao;import android.content.ContentValues;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.util.Log;import com.fengzili.dbTesting.PersonHelper;/** * Created by Administrator on 2014/11/4.主要學習下如何用現成的系統函數簡化SQL語句編寫，當然熟練以後還是寫sQL比較直觀，封裝的話說也沒傳說中那麼美好 */public class PersonDao {    private PersonHelper helper;    public void InsertNewRecord(String name,String number)    {        SQLiteDatabase sld= this.getHelper().getWritableDatabase();        sld.execSQL("insert into person(name,number) values (?,?)",new Object[]{"馮","132"});        ContentValues cvs=new ContentValues(4);        cvs.put("name",name);        cvs.put("number",number);        sld.insert("Person","id",cvs);        sld.close();    }    public  void Update(String name,String newNumber)    {        SQLiteDatabase db=this.getHelper().getWritableDatabase();        ContentValues cvs=new ContentValues(4);        cvs.put("number",newNumber);        db.update("person",cvs,"name=?",new String[]{name});        db.close();    }    public void  ReadAll()    {        SQLiteDatabase db=this.getHelper().getReadableDatabase();        Cursor cur= db.query(false, "person", null, "id>?", new String[]{"0"}, null, null, null, "10");        while (cur.moveToNext())        {            Log.e("FengZiLi","PersonName:"+cur.getString(cur.getColumnIndex("name"))+"      number:"+cur.getString(cur.getColumnIndex("number")));        }    }    public void Delete(String name)    {    }    public PersonHelper getHelper() {        return helper;    }    public void setHelper(PersonHelper helper) {        this.helper = helper;    }}

代碼的使用：

 PersonDao psd=new PersonDao();                psd.setHelper(new PersonHelper(MyActivity.this));                psd.InsertNewRecord("張三丰","885");                psd.Update("張三丰","998");                psd.ReadAll();

 

【.NET老猿學安卓系列】資料庫讀寫