OperationDatabase

 

package come.example;

import android.app.Activity;
import android.content.ContentValues;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;

import com.db.DatabaseHelper;

public class Operation extends Activity{
 DatabaseHelper database =null;

 @Override
 protected void onCreate(Bundle savedInstanceState) {
  // TODO Auto-generated method stub
  super.onCreate(savedInstanceState);
  database = new DatabaseHelper(this);
  insertData();
 }
 /**
  * 向数据库中插入一组数据
  */
 public void insertData(){
  SQLiteDatabase db = database.getWritableDatabase();
  //byte[] array =null;
  ContentValues values = new ContentValues();
  values.put("_id",1);
  values.put("power",  new byte[]{0x00});
  values.put("done", new byte[]{0x1});
  values.put("dtwo", new byte[]{0x2});
  values.put("dthree", new byte[]{0x3});
  values.put("mute", new byte[]{0x00});
  values.put("dfour",new byte[]{0x4});
  values.put("dfive",new byte[]{0x5});
  values.put("dsix",new byte[]{0x6});
  values.put("pandp",new byte[]{0x00});
  values.put("dseven",new byte[]{0x7});
  values.put("deight", new byte[]{0x8});
  values.put("dnine",new byte[]{0x9});
  values.put("arrow", new byte[]{0x00});
  values.put("dzero", new byte[]{0x00});
  values.put("keyinput", new byte[]{0x00});
  values.put("keyreverse", new byte[]{0x00});
  values.put("keyok", new byte[]{0x00});
  values.put("keydirection",new byte[]{0x00});
  values.put("keymenu", new byte[]{0x00});
  values.put("keyback", new byte[]{0x00});
  values.put("keyexit", new byte[]{0x00});
  db.insert("demo",null, values); 
 }

 public Cursor getDataCursor(){
  SQLiteDatabase db = database.getWritableDatabase();
 Cursor cursor = db.rawQuery("select * from demo ", null);
  if(cursor!=null){
   if(cursor.moveToFirst()){
    return cursor;
   }
  }
  return null;
 }
 @Override
 protected void onDestroy() {
  // TODO Auto-generated method stub
  super.onDestroy();
  if(database!=null){
   database.close();
  }
 }
}