android app jorte

package com.example.sqlitetutorials;

 

import android.content.ContentValues;

import android.content.Context;

import android.database.Cursor;

import android.database.SQLException;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import android.util.Log;

 

public class DBAdapter

{

    private static final String DB_NAME     = "contact_db";

    private static final int    DB_VER      = 1;

 

    public static final String  TABLE_NAME  = "contact";

    public static final String  COL_ID      = "_id";

    public static final String  COL_NAME    = "name";

    public static final String  COL_TELP    = "telp";

 

    private static final String TAG         = "ContactDBAdapter";

    private DatabaseHelper      dbHelper;

    private SQLiteDatabase      db;

 

    private static final String DB_CREATE   = "create table contact (_id integer primary key, name text not null, telp text not null);";

 

    private final Context       context;

 

    private static class DatabaseHelper extends SQLiteOpenHelper

    {

 

        public DatabaseHelper(Context context)

        {

            // TODO Auto-generated constructor stub

            super(context, DB_NAME, null, DB_VER);

        }

 

        @Override

        public void onCreate(SQLiteDatabase db)

        {

            // TODO Auto-generated method stub

            db.execSQL(DB_CREATE);

        }

 

        @Override

        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)

        {

            // TODO Auto-generated method stub

            Log.d(TAG, "upgrade DB");

            db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);

            onCreate(db);

 

        }

 

    }

 

    public DBAdapter(Context context)

    {

        this.context = context;

        // TODO Auto-generated constructor stub

    }

 

    public DBAdapter open() throws SQLException

    {

        dbHelper = new DatabaseHelper(context);

        db = dbHelper.getWritableDatabase();

        return this;

    }

 

    public void close()

    {

        dbHelper.close();

    }

 

    public void createContact(Contact contact)

    {

        ContentValues val = new ContentValues();

        val.put(COL_NAME, contact.getName());

        val.put(COL_TELP, contact.getTelp());

        db.insert(TABLE_NAME, null, val);

    }

 

    public boolean deleteContact(int id)

    {

        return db.delete(TABLE_NAME, COL_ID + "=" + id, null) > 0;

    }

 

    public Cursor getAllContact()

    {

        return db.query(TABLE_NAME, new String[]

        {

                COL_ID, COL_NAME, COL_TELP

        }, null, null, null, null, null);

    }

 

    public Cursor getSingleContact(int id)

    {

        Cursor cursor = db.query(TABLE_NAME, new String[]

        {

                COL_ID, COL_NAME, COL_TELP

        }, COL_ID + "=" + id, null, null, null, null);

 

        if (cursor != null)

            cursor.moveToFirst();

 

        return cursor;

    }

 

    public boolean updateContact(Contact contact)

    {

        ContentValues val = new ContentValues();

        val.put(COL_NAME, contact.getName());

        val.put(COL_TELP, contact.getTelp());

 

        return db.update(TABLE_NAME, val, COL_ID + "=" + contact.getId(), null) > 0;

    }

 

}