SQLite数据库的一些应用(应用单例模式)

1.首先是创建数据库

package com.zdsoft.notes.database;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class MyDBHelper extends SQLiteOpenHelper {
   private static MyDBHelper myDBHelper;
  /**
   * 账户类型
   * */
   private static final String  ADD_ACCOUNT_TYPE= "create table account_type("+ "_id INTEGER PRIMARY KEY AUTOINCREMENT," + "name text,"+"balance text);";
    /**
     * 记事薄表-建表语句
     */
    private static final String ADD_NOTES="create table notes ("+"_id INTEGER PRIMARY KEY AUTOINCREMENT,"+"times varchar(20),"+"title varchar(3999),"+"content varchar(3999));";
    /**
     * 账单表-建表语句
     */
    private static final String ADD_BILLS="create table bills ("+"_id INTEGER PRIMARY KEY AUTOINCREMENT,"+"image varchar(20),"+"times varchar(20),"+"number varchar(20),"+"nametype varchar(30),"+"state varchar(30));";
      //  所有表的id字段
    public  static  final String   ID="_id";
     //账户表名称
    public  static  final String   ADD_ACCOUNT="account_type";
    //账户表的账户名称字段
    public  static  final String   ADD_ACCOUNT_NAME="name";
    //账户表的账户名称字段
    public  static  final String   ADD_ACCOUNT_BALANCE="balance";
    //记事簿表名称
    public  static  final String   NOTES="notes";
    //记事簿S时间字段
    public  static  final String   TIMES="times";
    //记事簿标题字段
    public  static  final String   TITLE="title";
    //记事簿表内容字段
    public  static  final String   CONTENT="content";
    //账单表名称
    public  static  final String   BILLS="bills";
    //账单表图片字段
    public  static  final String   IMAGES="image";
    //账单表消费金额字段
    public  static  final String   NUMBER="number";
    //账单表消费属性字段
    public  static  final String   NAME_TYPE="nametype";
    //账单表消费类型字段
    public  static  final String   STATE="state";
    private MyDBHelper(Context context) {
        super(context, "utils", null, 1);
    }
    public  static  MyDBHelper getInstance(Context context){
      if (myDBHelper==null){
         myDBHelper=new MyDBHelper(context);
      }
       return  myDBHelper;
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    }
}
在增删改查类中引用数据库的实例
package com.zdsoft.notes.service;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import com.zdsoft.notes.bean.Notes;
import com.zdsoft.notes.database.MyDBHelper;
import java.util.ArrayList;
import java.util.List;




public class NotesService {
   //双重检索的单例
   static NotesService notesService;
   MyDBHelper myDBHelper;
  SQLiteDatabase db;
   private  NotesService(Context context){
     myDBHelper=MyDBHelper.getInstance(context);
   }
  /**
   * 双重检索*/
   public  static NotesService getInstance(Context context){
      if(notesService==null){
         synchronized (NotesService.class){
           if(notesService==null){
             notesService=new NotesService(context);
           }
         }
      }
     return notesService;
   }


/**
 * 查询所有记事簿的方法*/
  public ArrayList<Notes> getAll(){
    ArrayList<Notes> arrayList=new ArrayList<Notes>();
    db= myDBHelper.getReadableDatabase();
    Cursor cursor=db.query(MyDBHelper.NOTES,null,null,null,null,null,"orderById=desc");
    while (cursor.moveToNext()){
      Notes notes=new Notes();
      String title=cursor.getString(cursor.getColumnIndex(MyDBHelper.TITLE));
      String times=cursor.getString(cursor.getColumnIndex(MyDBHelper.TIMES));
      String content=cursor.getString(cursor.getColumnIndex(MyDBHelper.CONTENT));
      notes.setContent(content);
      notes.setDate(times);
      notes.setTitle(title);
      arrayList.add(notes);
    }
    cursor.close();
    return arrayList;
  }


  public  void  addNotes(Notes notes){
    db=myDBHelper.getReadableDatabase();
    ContentValues contentValues=new ContentValues();
    contentValues.put(MyDBHelper.TITLE,notes.getTitle());
    contentValues.put(MyDBHelper.CONTENT,notes.getContent());
    contentValues.put(MyDBHelper.TIMES,notes.getDate());
   long l= db.insert(MyDBHelper.NOTES,null,contentValues);
    if(l<=0){
    }
  }


}

双重检索的单例,避免创建多个实例