Android SQLite Sql语句帮助类

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


/**
 * Created by dht on 2018/3/13.
 */


public class DBHelper extends SQLiteOpenHelper {


    private static final String db_name = "db_flower";//数据库名字
    private static final int db_version = 1;//数据库版本号
    private static final String create_user = "CREATE TABLE user("+
            "us_id INTEGER PRIMARY KEY AUTOINCREMENT," +
            "us_user TEXT," +
            "us_pwd TEXT," +
            "time VARCHAR)";


    private static final String create_flower = "CREATE TABLE flower("+
            "fl_id INTEGER PRIMARY KEY AUTOINCREMENT,"+
            "fl_photo TEXT,"+
            "fl_info VARCHAR,"+
            "fl_time VARCHAR,"+
            "us_id INTEGER)";


    private SQLiteDatabase db;


    /**
     * 创建数据库
     * @param context
     */
    public DBHelper(Context context) {
        super(context, db_name, null, db_version);
    }


    @Override
    public void onCreate(SQLiteDatabase db) {
        this.db = db;
        db.execSQL(create_user);
        db.execSQL(create_flower);
    }


    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {


    }


    public void insert(String sql,Object[] args){
        db = getWritableDatabase();
        db.execSQL(sql,args);
    }


    public Cursor rawQuery(String sql,String[] args){
        db = getWritableDatabase();
        Cursor c = db.rawQuery(sql,args);
        return c;
    }


    public void update(String name,ContentValues values,String where,String[] args){
        db = getWritableDatabase();
        db.update(name,values,where,args);
    }


    public void delete(String name,String where,String[] args){
        db = getWritableDatabase();
        db.delete(name,where,args);
    }


    public void close(){
        if(db!=null){
            db.close();
        }
    }
}