数据库语法

//创建数据库
@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL("create table user(id integer primary key autoincrement ,name varchar(10), age varchar(10))");
}

======================================

sql = new SQL(this);
db = sql.getReadableDatabase();
//添加
db.execSQL("insert into user values(id = ?,name = ?,age = ?)",new String[]{id,name,age});

//删除

db.delete("user","name = ?",new String[]{arr.get(position).getName()});

//查找全部

Cursor cursor = db.query("user",null,null,null,null,null,null);
// while (cursor.moveToNext()){ // int id = cursor.getInt(cursor.getColumnIndex("id")); // String name = cursor.getString(cursor.getColumnIndex("name")); // String age = cursor.getString(cursor.getColumnIndex("age")); // User user = new User(id,name,age); // arr.add(user); // ua.notifyDataSetChanged(); // }