移动开发-数据库

• 创建、删除数据库表

创建、设置主键

private static String CREATE_TABLE = "create table if not exists " +
            "person(idCard VARCHAR(18) primary key ,name VARCHAR(20),role VARCHAR(20))";

db.execSQL(CREATE_TABLE);

删除

@Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("drop table if exists " + TABLE_NAME);
        db.execSQL("drop table if exists " + TABLE_NAME1);
        db.execSQL("drop table if exists " + TABLE_NAME2);
        onCreate(db); }

• 插入记录

db.execSQL("insert into person(idCard,name) values (?,?)",new String[]{"1234","李明"});
db.execSQL("insert into card(idCard,account,pwd,money,type) values (?,?,?,?,?)",new String[]{"1234","1","1",""+10000.0,"借记卡"});

//执行insert操作插入记录
db.insert(tableName,null,values);

//新建SQLiteOpenHelper子类的对象
        final DataBaseHelper helper=new DataBaseHelper(Detail2Activity.this);

helper.insert(tablename, values);

• 删除记录

 db.delete(tableName, "account=?", new String[]{a});

 //新建SQLiteOpenHelper子类的对象
        final DataBaseHelper helper=new DataBaseHelper(Detail2Activity.this);

helper.del1(Tablename, (int) temp);

• 修改记录

 db.update(tableName,v,"account=?", new String[]{a});

//新建SQLiteOpenHelper子类的对象
        final DataBaseHelper helper=new DataBaseHelper(Detail2Activity.this);

helper.update2("card",a,v); 

• 查询记录

Cursor c=db.query(tableName, null, null,null,null,null,null);

Cursor c=db.query(tableName, new String[]{"pwd"} , "account=?",new String[]{i},null,null,null);

public Cursor cha4(String tableName,String selection,String a,String type,String biao){
        if(db==null)
            db=getWritableDatabase();
        //执行query操作查询记录
        Cursor c=db.query(tableName, null, selection,
                new String[]{a,type,biao},null,null,
                null);
        return c;
    }

 public Cursor cha6(String tableName,String selection,String a,String t){
        if(db==null)
            db=getWritableDatabase();
        //执行query操作查询记录
        Cursor c=db.query(tableName, null , selection,
                new String[]{a,t},null,null,
                "inTime");
        return c;
    }