创建数据库和创建表
public class sql extends SQLiteOpenHelper {
public sql(@Nullable Context context, @Nullable String name, @Nullable SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table bbb(id integer primary Key autoincrement,name varchar(30))");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
rk11_19:是随机起的数据库的名
sql sql = new sql(this, "rk11_19", null, 1);
db = sql.getReadableDatabase();
数据库的增删改查
public void insert(View view) {
String sql="insert into bbb values(?,?)";
db.beginTransaction();
for (int i = 1; i <=10 ; i++) {
db.execSQL(sql,new Object[]{
null,"第"+i+"个"});
}
db.setTransactionSuccessful();
db.endTransaction();
}
public void rem(View view) {
String sql=<