数据库

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

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.Toast;

public class NameDBHelper extends SQLiteOpenHelper {

    public static final String TABLE_NAME = "sourcename";
    public static final String clume1 = "SBName";
    public static final String clume2 = "editName";
    private static final int DB_Version = 1;
    
    public static boolean mFlag = false;
    private Context mContext;

    public EditSourceNameDBHelper(Context context) {
        super(context, TABLE_NAME, null, DB_Version);
        this.mContext = context;
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        mFlag = true;
        db.execSQL("CREATE TABLE IF NOT EXISTS sourcename(id integer primary key Autoincrement,source_id text,SBName text,editName text);");
//        Toast.makeText(mContext, mContext.getResources().getString(R.string.str_set_sourcename_createdb), Toast.LENGTH_SHORT).show();
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int old, int newversion) {
        if (newversion > old) {
            db.execSQL("DROP TABLE "+TABLE_NAME);
            onCreate(db);
        }
    }

    public List<String> querySourceName(SQLiteDatabase db,String clumName) {
        List<String> sourceNamelist = new ArrayList<String>();
        Cursor cursor = db.rawQuery("SELECT "+clumName+" FROM "+TABLE_NAME, null);
        while (cursor.moveToNext()) {
            String name = cursor.getString(cursor.getColumnIndex(clumName));
            sourceNamelist.add(name);
        }
        cursor.close();
        return sourceNamelist;
    }
    
    public void updateSourceName(SQLiteDatabase db, String[] editNames) {
        db.execSQL("UPDATE "+TABLE_NAME+" SET editName = ? WHERE source_id = ?", editNames);
    }

    public void insertSourceName(SQLiteDatabase db, String[] strings) {
        db.execSQL("INSERT INTO "+TABLE_NAME+" (source_id,SBName,editName) VALUES (?,?,?)", strings);
    }
    
    public void deletSourceName(SQLiteDatabase db){
        db.execSQL("DELETE * FROM "+TABLE_NAME);
    }
    
    public static boolean getFlage(){
        return mFlag;
    }
    
    public static void setFlage(boolean flage){
        mFlag = flage;
    }
}

​