sqlite与android交互(封装)

package com.tp.soft.util;

import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;

import com.example.dbcity.R;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.os.Environment;

public class DBConn {
    private static String DB_NAME = "test.db";
    private static String PACKAGE = "com.example.dbcity";
    private static String PATH = "/data" +
                Environment.getDataDirectory().getPath()+
                File.separator + PACKAGE;
    private Context context;
    private SQLiteDatabase database;
    public DBConn(Context context){
        this.cOntext= context;
    }
    
    public static final DBConn getInstance(Context context){
        DBConn conn = new DBConn(context);
        return conn;
    }
    public SQLiteDatabase getDb(){
        database = openDB(PATH + File.separator + DB_NAME);
        return database;
    }
    
    public SQLiteDatabase openDB(String dbFile){
        try{
            if(!isExitFile(dbFile)){
                InputStream is = context.getResources().openRawResource(R.raw.test);
                FileOutputStream fos = new FileOutputStream(dbFile);
                byte[] buffer = new byte[1024];
                int len = -1;
                while((len = is.read(buffer)) != -1){
                    fos.write(buffer, 0, len);
                }
                is.close();
                fos.close();
            }
            
            database = SQLiteDatabase.openOrCreateDatabase(dbFile, null);
            return database;
        }catch (Exception e) {
            e.printStackTrace();
            return null;
        }
    }
    
    public boolean isExitFile(String path){
        File file = new File(path);
        return file.exists();
    }
}

package com.tp.soft.util;

import java.util.ArrayList;
import java.util.List;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class DBManage {
    private SQLiteDatabase db;
    
    public DBManage(Context context) {
        DBConn conn = DBConn.getInstance(context);
        db = conn.getDb();
    }

    public List queryData(String sql, String[] selectionArgs, String property){
        Cursor cursor = null;
        List list = new ArrayList();
        try{
            cursor = db.rawQuery(sql, selectionArgs);
            while(cursor.moveToNext()){
                String str = cursor.getString(cursor.getColumnIndex(property));
                list.add(str);
            }
        }catch (Exception e) {
            e.printStackTrace();
        }finally{
            if(null != cursor){
                cursor.close();
            }
        }
        return list;
    }
    
}

proSelect = (Spinner) findViewById(R.id.proSelect);
        DBManage dbManage = new DBManage(this);
        List proList = dbManage.queryData("select * from au_user", null, "username");
        ArrayAdapter arrayAdapter = new ArrayAdapter(this, android.R.layout.simple_gallery_item, proList);
        proSelect.setAdapter(arrayAdapter);