HarmonyOS基础技术赋能之对象关系映射数据库的使用 原创 精华

 @Entity(tableName = "user")
public class User extends OrmObject {
// 此处将userId设为了自增的主键。注意只有在数据类型为包装类型时，自增主键才能生效。
  @PrimaryKey(autoGenerate = true)
  private Integer userId;
  private String userName;
  private int userAge;
  private String userRole;

  public User() {
  }

  // 需添加各字段的getter和setter方法。
  ……
  ……
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.

// context入参类型为ohos.app.Context，注意不要使用slice.getContext()来获取context，请直接传入slice，否则会出现找不到类的报错。
DatabaseHelper helper = new DatabaseHelper(this); 
OrmContext context = helper.getOrmContext("BookStore", "BookStore.db", BookStore.class); 
1.
2.
3.

//先在onstart()方法中创建OrmContext对象，context入参类型为ohos.app.Context，注意不要使用slice.getContext()来获取context，请直接传入slice，否则会出现找不到类的报错。
DatabaseHelper helper = new DatabaseHelper(this); 
OrmContext context = helper.getOrmContext("BookStore", "BookStore.db", BookStore.class); 
// 然后重新增删改查方法 query()/insert()/update()/delete()
@Override
public ResultSet query(Uri uri, String[] columns, DataAbilityPredicates predicates) {
  if(ormContext == null){
    HiLog.error(LABEL_LOG,"failed to query, ormContext is null");
    return null;
  }
  //查询数据库
  OrmPredicates ormPredicates = DataAbilityUtils.createOrmPredicates(predicates, User.class);
  ResultSet resultSet = ormContext.query(ormPredicates,columns);
  if (resultSet == null){
    HiLog.info(LABEL_LOG,"resultSet is null");
  }
  return resultSet;
}

@Override
public int insert(Uri uri, ValuesBucket value) {
  // 参数校验
  if (ormContext == null) {
    HiLog.error(LABEL_LOG, "failed to insert, ormContext is null");
    return -1;
  }

  // 构造插入数据
  User user = new User();
  user.setUserId(value.getInteger("userId"));
  user.setUserName(value.getString("userName"));
  user.setUserAge(value.getInteger("userAge"));
  user.setUserRole(value.getString("userRole"));

  // 插入数据库
  boolean isSuccessed;
  isSuccessed = ormContext.insert(user);
  if (!isSuccessed) {
    HiLog.error(LABEL_LOG, "failed to insert");
    return -1;
  }
  isSuccessed = ormContext.flush();
  if (!isSuccessed) {
    HiLog.error(LABEL_LOG, "failed to insert flush");
    return -1;
  }
  DataAbilityHelper.creator(this, uri).notifyChange(uri);
  //返回的id，为数据表自增主键id
  int id = Math.toIntExact(user.getRowId());
  HiLog.debug(LABEL_LOG, "success to insert id="+id);
  return id;
}

@Override
public int delete(Uri uri, DataAbilityPredicates predicates) {
  if (ormContext == null) {
    HiLog.error(LABEL_LOG, "failed to delete, ormContext is null");
    return -1;
  }

  OrmPredicates ormPredicates = DataAbilityUtils.createOrmPredicates(predicates,User.class);
  int result = ormContext.delete(ormPredicates);
  DataAbilityHelper.creator(this, uri).notifyChange(uri);
  // result>0 表示删除成功，result<=0 表示删除失败
  if(result>0){
    HiLog.debug(LABEL_LOG, "UserDataAbility  success to delete value="+result);
  }else {
    HiLog.debug(LABEL_LOG, "UserDataAbility  failed to delete value="+result);
  }

  return result;
}

@Override
public int update(Uri uri, ValuesBucket value, DataAbilityPredicates predicates) {
  if (ormContext == null) {
    HiLog.error(LABEL_LOG, "failed to update, ormContext is null");
    return -1;
  }

  OrmPredicates ormPredicates = DataAbilityUtils.createOrmPredicates(predicates,User.class);
  int result = ormContext.update(ormPredicates, value);
  // result>0 表示更新成功，result<=0 表示更新失败
  if(result>0){
    HiLog.info(LABEL_LOG, "UserDataAbility success to update value:" + result);
  }else {
    HiLog.info(LABEL_LOG, "UserDataAbility failed to update value:" + result);

  }
  DataAbilityHelper.creator(this, uri).notifyChange(uri);
  return result;
}
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.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.

//创建DataAbilityHelper
DataAbilityHelper helper = DataAbilityHelper.creator(this);

//插入数据
//其中Uri uri = Uri.parse(String Uri);里面的配置字符串Uri就是用于读取关系映射数据库的路径，来自于创建DataAbility后，在config.json中的Uri标签,本案例中的String Uri= “dataability://com.isoftstone.ormdatebase.UserDataAbility”

helper.insert(uri, valuesBucket);

//删除数据
helper.delete(uri,predicates);

//修改数据
helper.update(uri, valuesBucket, predicates)

//查询数据
ResultSet resultSet = helper.query(uri, columns, predicates)

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

@Database(entities = {User.class}, version = 1)
public abstract class BookStore extends OrmDatabase {

}
1.
2.
3.
4.

@Entity(tableName = "user")
public class User extends OrmObject {
  @PrimaryKey(autoGenerate = true)
  private Integer userId;
  private String userName;
  private int userAge;
  private String userRole;

  public User() {
  }

  public Integer getUserId() {
    return userId;
  }

  public void setUserId(Integer userId) {
    this.userId = userId;
  }

  public String getUserName() {
    return userName;
  }

  public void setUserName(String userName) {
    this.userName = userName;
  }

  public int getUserAge() {
    return userAge;
  }

  public void setUserAge(int userAge) {
    this.userAge = userAge;
  }

  public String getUserRole() {
    return userRole;
  }

  public void setUserRole(String userRole) {
    this.userRole = userRole;
  }

  @Override
  public String toString() {
    return "User{" +
        "userId=" + userId +
        ", userName='" + userName + '\'' +
        ", userAge=" + userAge +
        ", userRole='" + userRole + '\'' +
        '}';
  }
}
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.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.

public class UserDataAbility extends Ability {
  private static final String DATABASE_NAME ="BookStore.db";
  private static final String DATABASE_NAME_ALIAS = "BookStore";
  private static OrmContext ormContext = null;
  private static final HiLogLabel LABEL_LOG = new HiLogLabel(3, 0xD001100, "Demo");

  @Override
  public void onStart(Intent intent) {
    super.onStart(intent);

    DatabaseHelper helper = new DatabaseHelper(this);
    ormContext = helper.getOrmContext(DATABASE_NAME_ALIAS, DATABASE_NAME, BookStore.class);
    User user1 = new User();
    user1.setUserName("ZhangSan");
    user1.setUserAge(22);
    user1.setUserRole("teacher");
    ormContext.insert(user1);
    User user2 = new User();
    user2.setUserName("LiSi");
    user2.setUserAge(23);
    user2.setUserRole("programmer");
    ormContext.insert(user2);
    ormContext.flush();
  }

  @Override
  public ResultSet query(Uri uri, String[] columns, DataAbilityPredicates predicates) {
    if(ormContext == null){
      HiLog.error(LABEL_LOG,"failed to query, ormContext is null");
      return null;
    }
    //查询数据库
    OrmPredicates ormPredicates = DataAbilityUtils.createOrmPredicates(predicates, User.class);
    ResultSet resultSet = ormContext.query(ormPredicates,columns);
    if (resultSet == null){
      HiLog.info(LABEL_LOG,"resultSet is null");
    }
    return resultSet;
  }

  @Override
  public int insert(Uri uri, ValuesBucket value) {
    // 参数校验
    if (ormContext == null) {
      HiLog.error(LABEL_LOG, "failed to insert, ormContext is null");
      return -1;
    }

    // 构造插入数据
    User user = new User();
    user.setUserId(value.getInteger("userId"));
    user.setUserName(value.getString("userName"));
    user.setUserAge(value.getInteger("userAge"));
    user.setUserRole(value.getString("userRole"));

    // 插入数据库
    boolean isSuccessed;
    isSuccessed = ormContext.insert(user);
    if (!isSuccessed) {
      HiLog.error(LABEL_LOG, "failed to insert");
      return -1;
    }
    isSuccessed = ormContext.flush();
    if (!isSuccessed) {
      HiLog.error(LABEL_LOG, "failed to insert flush");
      return -1;
    }
    DataAbilityHelper.creator(this, uri).notifyChange(uri);
    //返回的id，为数据表自增主键id
    int id = Math.toIntExact(user.getRowId());
    HiLog.debug(LABEL_LOG, "success to insert id="+id);
    return id;
  }

  @Override
  public int delete(Uri uri, DataAbilityPredicates predicates) {
    if (ormContext == null) {
      HiLog.error(LABEL_LOG, "failed to delete, ormContext is null");
      return -1;
    }

    OrmPredicates ormPredicates = DataAbilityUtils.createOrmPredicates(predicates,User.class);
    int result = ormContext.delete(ormPredicates);
    DataAbilityHelper.creator(this, uri).notifyChange(uri);
    // result>0 表示删除成功，result<=0 表示删除失败
    if(result>0){
      HiLog.debug(LABEL_LOG, "UserDataAbility  success to delete value="+result);
    }else {
      HiLog.debug(LABEL_LOG, "UserDataAbility  failed to delete value="+result);
    }

    return result;
  }

  @Override
  public int update(Uri uri, ValuesBucket value, DataAbilityPredicates predicates) {
    if (ormContext == null) {
      HiLog.error(LABEL_LOG, "failed to update, ormContext is null");
      return -1;
    }

    OrmPredicates ormPredicates = DataAbilityUtils.createOrmPredicates(predicates,User.class);
    int result = ormContext.update(ormPredicates, value);
    // result>0 表示更新成功，result<=0 表示更新失败
    if(result>0){
      HiLog.info(LABEL_LOG, "UserDataAbility success to update value:" + result);
    }else {
      HiLog.info(LABEL_LOG, "UserDataAbility failed to update value:" + result);

    }
    DataAbilityHelper.creator(this, uri).notifyChange(uri);
    return result;
  }


}
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.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.

public class MainAbilitySlice extends AbilitySlice implements ClickedListener {
  private String uriString = "dataability:///com.isoftstone.ormdatebase.UserDataAbility";
  private static final HiLogLabel LABEL_LOG = new HiLogLabel(3, 0xD001100, "Demo");
  private DataAbilityHelper helper;
  @Override
  public void onStart(Intent intent) {
    super.onStart(intent);
    super.setUIContent(ResourceTable.Layout_ability_main);
    helper = DataAbilityHelper.creator(this);
    Button queryAll = (Button) findComponentById(ResourceTable.Id_query_all);
    Button queryByCondition = (Button) findComponentById(ResourceTable.Id_query_by_condition);
    Button insert = (Button) findComponentById(ResourceTable.Id_insert);
    Button update = (Button) findComponentById(ResourceTable.Id_update);
    Button delete = (Button) findComponentById(ResourceTable.Id_delete);
    queryAll.setClickedListener(this);
    queryByCondition.setClickedListener(this);
    insert.setClickedListener(this);
    update.setClickedListener(this);
    delete.setClickedListener(this);
  }
  @Override
  public void onClick(Component component) {
    switch (component.getId()){
      case ResourceTable.Id_query_all:
        try {
          queryAll();
        } catch (Exception e) {
          e.printStackTrace();
        }
        break;
      case ResourceTable.Id_query_by_condition:
        try {
          queryByCondition();
        } catch (Exception e) {
          e.printStackTrace();
        }
        break;
      case ResourceTable.Id_insert:
        try {
          insert();
        } catch (Exception e) {
          e.printStackTrace();
        }
        break;
      case ResourceTable.Id_update:
        try {
          update();
        } catch (Exception e) {
          e.printStackTrace();
        }
        break;
      case ResourceTable.Id_delete:
        try {
          delete();
        } catch (Exception e) {
          e.printStackTrace();
        }
    }
  }
  public void queryAll() throws DataAbilityRemoteException {
    // 构造查询条件
    DataAbilityPredicates predicates = new DataAbilityPredicates();
    String[] columns = new String[]{"userId", "userName", "userAge", "userRole"};
    Uri uri = Uri.parse(uriString);
    ResultSet resultSet = helper.query(uri, columns, predicates);
    // 处理结果
    resultSet.goToFirstRow();
    do {
      // 在此处理ResultSet中的记录;
      HiLog.info(LABEL_LOG,
          "userId=" + resultSet.getString(0)
              + "; userName=" + resultSet.getString(1)
              + "; userAge=" + resultSet.getString(2)
              + "; userRole=" + resultSet.getString(3));
    } while (resultSet.goToNextRow());
  }
  public void queryByCondition() throws DataAbilityRemoteException {
    // 构造查询条件
    DataAbilityPredicates predicates = new DataAbilityPredicates();
    predicates.equalTo("userRole", "programmer");
    String[] columns = new String[]{"userId", "userName", "userAge", "userRole"};
    Uri uri = Uri.parse(uriString);
    ResultSet resultSet = helper.query(uri, columns, predicates);
    // 处理结果
    resultSet.goToFirstRow();
    do {
      // 在此处理ResultSet中的记录;
      HiLog.info(LABEL_LOG,
          "userId=" + resultSet.getString(0)
              + "; userName=" + resultSet.getString(1)
              + "; userAge=" + resultSet.getString(2)
              + "; userRole=" + resultSet.getString(3));
    } while (resultSet.goToNextRow());
  }
  public void insert() throws DataAbilityRemoteException {

    DataAbilityHelper helper = DataAbilityHelper.creator(this);
    Uri uri = Uri.parse(uriString);
    ValuesBucket valuesBucket = new ValuesBucket();
    valuesBucket.putString("userName", "WangWu");
    valuesBucket.putInteger("userAge", 18);
    valuesBucket.putString("userRole", "police");
    helper.insert(uri, valuesBucket);
  }
  public void update() throws DataAbilityRemoteException {
    // 构造插入数据
    DataAbilityHelper helper = DataAbilityHelper.creator(this);

    // 构造更新条件
    DataAbilityPredicates predicates = new DataAbilityPredicates();
    predicates.equalTo("userName", "WangWu");

    // 构造更新数据
    ValuesBucket valuesBucket = new ValuesBucket();
    valuesBucket.putString("userName", "ZhaoLiu");
    valuesBucket.putInteger("UserAge", 26);
    valuesBucket.putString("userRole", "doctor");
    Uri uri = Uri.parse(uriString);
    int update = helper.update(uri, valuesBucket, predicates);
  }
  public void delete() throws DataAbilityRemoteException {
    DataAbilityHelper helper = DataAbilityHelper.creator(this);
    Uri uri = Uri.parse(uriString);
    // 构造删除条件
    DataAbilityPredicates predicates = new DataAbilityPredicates();
    predicates.equalTo("userName", "ZhaoLiu");
    helper.delete(uri,predicates);
  }
}
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.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.

<?xml version="1.0" encoding="utf-8"?>
<DirectionalLayout
  xmlns:ohos="http://schemas.huawei.com/res/ohos"
  ohos:height="match_parent"
  ohos:width="match_parent"
  ohos:orientation="vertical" >

  <Button
    ohos:id="$+id:query_all"
    ohos:width="match_content"
    ohos:height="match_content"
    ohos:text="QueryAll"
    ohos:text_size="19fp"
    ohos:text_color="#FFFFFF"
    ohos:top_margin="30vp"
    ohos:top_padding="8vp"
    ohos:bottom_padding="8vp"
    ohos:right_padding="70vp"
    ohos:left_padding="70vp"
    ohos:background_element="$graphic:background_button"
    ohos:center_in_parent="true"
    ohos:align_parent_bottom="true"
    ohos:bottom_margin="40vp"
    ohos:layout_alignment="center"
    />
  <Button
    ohos:id="$+id:query_by_condition"
    ohos:width="match_content"
    ohos:height="match_content"
    ohos:text="queryByCondition"
    ohos:text_size="19fp"
    ohos:text_color="#FFFFFF"
    ohos:top_padding="8vp"
    ohos:bottom_padding="8vp"
    ohos:right_padding="70vp"
    ohos:left_padding="70vp"
    ohos:background_element="$graphic:background_button"
    ohos:center_in_parent="true"
    ohos:align_parent_bottom="true"
    ohos:bottom_margin="40vp"
    ohos:layout_alignment="center"
    />
  <Button
    ohos:id="$+id:insert"
    ohos:width="match_content"
    ohos:height="match_content"
    ohos:text="Insert"
    ohos:text_size="19fp"
    ohos:text_color="#FFFFFF"
    ohos:top_padding="8vp"
    ohos:bottom_padding="8vp"
    ohos:right_padding="70vp"
    ohos:left_padding="70vp"
    ohos:background_element="$graphic:background_button"
    ohos:center_in_parent="true"
    ohos:align_parent_bottom="true"
    ohos:bottom_margin="40vp"
    ohos:layout_alignment="center"
    />
  <Button
    ohos:id="$+id:update"
    ohos:width="match_content"
    ohos:height="match_content"
    ohos:text="Update"
    ohos:text_size="19fp"
    ohos:text_color="#FFFFFF"
    ohos:top_padding="8vp"
    ohos:bottom_padding="8vp"
    ohos:right_padding="70vp"
    ohos:left_padding="70vp"
    ohos:background_element="$graphic:background_button"
    ohos:center_in_parent="true"
    ohos:align_parent_bottom="true"
    ohos:bottom_margin="40vp"
    ohos:layout_alignment="center"
    />
  <Button
    ohos:id="$+id:delete"
    ohos:width="match_content"
    ohos:height="match_content"
    ohos:text="Delete"
    ohos:text_size="19fp"
    ohos:text_color="#FFFFFF"
    ohos:top_padding="8vp"
    ohos:bottom_padding="8vp"
    ohos:right_padding="70vp"
    ohos:left_padding="70vp"
    ohos:background_element="$graphic:background_button"
    ohos:center_in_parent="true"
    ohos:align_parent_bottom="true"
    ohos:bottom_margin="40vp"
    ohos:layout_alignment="center"
    />


</DirectionalLayout>
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.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.

<?xml version="1.0" encoding="utf-8"?>
<shape
    xmlns:ohos="http://schemas.huawei.com/res/ohos"
    ohos:shape="rectangle">
    <corners
        ohos:radius="100"/>
    <solid
        ohos:color="#007DFF"/>
</shape>
1.
2.
3.
4.
5.
6.
7.
8.
9.

{
  "app": {
    "bundleName": "com.isoftstone.ormdatebase",
    "vendor": "isoftstone",
    "version": {
      "code": 1000000,
      "name": "1.0"
    },
    "apiVersion": {
      "compatible": 4,
      "target": 5,
      "releaseType": "Release"
    }
  },
  "deviceConfig": {},
  "module": {
    "package": "com.isoftstone.ormdatebase",
    "name": ".MyApplication",
    "deviceType": [
      "phone"
    ],
    "distro": {
      "deliveryWithInstall": true,
      "moduleName": "entry",
      "moduleType": "entry"
    },
    "abilities": [
      {
        "skills": [
          {
            "entities": [
              "entity.system.home"
            ],
            "actions": [
              "action.system.home"
            ]
          }
        ],
        "orientation": "unspecified",
        "name": "com.isoftstone.ormdatebase.MainAbility",
        "icon": "$media:icon",
        "description": "$string:mainability_description",
        "label": "$string:app_name",
        "type": "page",
        "launchType": "standard"
      },
      {
        "visible": true,
        "permissions": [
          "com.isoftstone.ormdatebase.DataAbilityShellProvider.PROVIDER"
        ],
        "name": "com.isoftstone.ormdatebase.UserDataAbility",
        "icon": "$media:icon",
        "description": "$string:userdataability_description",
        "type": "data",
        "uri": "dataability://com.isoftstone.ormdatebase.UserDataAbility"
      }
    ]
  }
}
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.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.

apply plugin: 'com.huawei.ohos.hap'
ohos {
    compileSdkVersion 5
    defaultConfig {
        compatibleSdkVersion 4
    }
    compileOptions{
        annotationEnabled true
    }
}

dependencies {
    implementation fileTree(dir: 'libs', include: ['*.jar', '*.har'])
    testCompile 'junit:junit:4.12'
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.