链接m数据库 没有的话会自动新建
执行新建user表的语句
SQLiteDatabase db = openOrCreateDatabase("m", Context.MODE_PRIVATE,null);
String SQL = "CREATE TABLE user ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, phone TEXT, email TEXT);";
db.execSQL(SQL);
插入数据
SQLiteDatabase db = openOrCreateDatabase("m", Context.MODE_PRIVATE,null);
ContentValues cv = new ContentValues();
cv.put("name",time);
cv.put("phone","13800138000");
cv.put("email","!@#$%^&*()_+");
db.insert("user",null,cv);
删除表
DROP TABLE IF EXISTS 表名