DataAbility进行数据库操作的简单使用 原创 精华

// 数据库操作类RdbStore
private RdbStore rdbStore;
// 表名称
private final String TABLENAME = "student";

@Override
public void onStart(Intent intent) {
    super.onStart(intent);
    HiLog.info(LABEL_LOG, "DataAbility onStart");

    initDatabase(this);
}

// 初始化数据库
private void initDatabase(Context context){
		StoreConfig config = StoreConfig.newDefaultConfig("Student.db");
		RdbOpenCallback callback = new RdbOpenCallback() {
				@Override
				public void onCreate(RdbStore rdbStore) {
						rdbStore.executeSql("create table if not exists " + TABLENAME + "(id integer primary key autoincrement, name text not null, age integer not null, salary real)");
				}

				@Override
				public void onUpgrade(RdbStore rdbStore, int i, int i1) {

				}
		};

		DatabaseHelper helper = new DatabaseHelper(context);
		rdbStore = helper.getRdbStore(config, 1, callback);
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.

// 查询数据
@Override
public ResultSet query(Uri uri, String[] columns, DataAbilityPredicates predicates) {
    RdbPredicates rdbPredicates = DataAbilityUtils.createRdbPredicates(predicates, TABLENAME);
    ResultSet resultSet = rdbStore.query(rdbPredicates, columns);
    return resultSet;
}

// 插入数据
@Override
public int insert(Uri uri, ValuesBucket value) {
    long res = rdbStore.insert(TABLENAME, value);
    return (int)res;
}

// 删除数据
@Override
public int delete(Uri uri, DataAbilityPredicates predicates) {
    RdbPredicates rdbPredicates = DataAbilityUtils.createRdbPredicates(predicates, TABLENAME);
    int res = rdbStore.delete(rdbPredicates);
    return res;
}

// 修改数据
@Override
public int update(Uri uri, ValuesBucket value, DataAbilityPredicates predicates) {
    RdbPredicates rdbPredicates = DataAbilityUtils.createRdbPredicates(predicates, TABLENAME);
    int res = rdbStore.update(value, rdbPredicates);
    return res;
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.

// 访问DataAbility的唯一路径
private Uri uri;
// DataAbility数据操作类
private DataAbilityHelper helper;

@Override
public void onStart(Intent intent) {
    super.onStart(intent);
    super.setUIContent(ResourceTable.Layout_ability_main);
		helper = DataAbilityHelper.creator(this);
    uri = Uri.parse("dataability:///com.example.myapplication.DataAbility");
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.

// 增加
private boolean addData(){
    ValuesBucket bucket = new ValuesBucket();
    bucket.putString("name", "jack");
    bucket.putInteger("age", 23);
    bucket.putDouble("salary", 3456.0);

    try {
        int rowNum = helper.insert(uri, bucket);
        return rowNum > 0 ? true : false;
    } catch (Exception e) {

    }
    return false;
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.

// 删除
private boolean deleteData(){
    try {
        DataAbilityPredicates predicates = new DataAbilityPredicates();
        predicates.equalTo("id", 1);
        int rowNum = helper.delete(uri,predicates);
        return rowNum > 0 ? true : false;
    } catch (Exception e) {

    }
    return false;
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.

// 修改
private boolean changeData(){
    ValuesBucket bucket = new ValuesBucket();
    bucket.putString("name", "rose");
    bucket.putInteger("age", 45);
    bucket.putDouble("salary", 1234.9);

    try {
        DataAbilityPredicates predicates = new DataAbilityPredicates();
        predicates.equalTo("id", 2);
        int rowNum = helper.update(uri, bucket, predicates);
        return rowNum > 0 ? true : false;
    } catch (Exception e) {

    }
    return false;
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.

// 查询
private ResultSet queryData(){
    String[] strings = {
            "id","name","age","salary"
    };

    DataAbilityPredicates predicates = new  DataAbilityPredicates();
    predicates.greaterThan("id", 0);
    try {
        ResultSet resultSet = helper.query(uri, strings, predicates);
        return resultSet;
    } catch (Exception e) {

    }
    return null;
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.