【Android】SQLite 数据库基本操作

1.使用DBHelper实现数据库的打开与创建

public class DBHelper extends SQLiteOpenHelper{
   
    private final static String DB_NAME="notecontent.db";
    private final static int DB_version=2;
    public DBHelper(Context context){
        super(context,DB_NAME,null,DB_version);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {

        db.execSQL("CREATE TABLE IF NOT EXISTS notecontent"+
                "(_id INTEGER PRIMARY KEY AUTOINCREMENT,date VARCHAR,detail NVARCHAR,"+
                "recordurl VARCHAR,picurl VARCHAR,ba