关于android:软通动力HarmonyOS三方件开发指南6ActiveOhossqlite组件

ActiveOhos性能介绍
1.1. 组件介绍
基于HarmonyOS据库进行sqlite数据库操作，创立连贯时比拟繁琐，本组件简化了sqlite数据库的连贯，并且对HarmonyOS原生的API进行封装增强，使sqlite数据库的读写更加不便。
1.2. 手机模拟器上运行成果

插入数据胜利

ActiveOhos应用办法
2.1. 为利用增加sqlitelibrary-debug.har包依赖

在利用模块中调用HAR，罕用的增加依赖为：依赖本地HAR

第一步：将sqlitelibrary-debug.har复制到entry\libs目录下即可（因为build.gradle中曾经依赖的libs目录下的*.har，因而不须要再做批改）。

查看工程目录中build.gradle下的*.har是否存在

第二步：除了依赖har之外还须要增加内部依赖用来实现类的引入，引入形式如下，引入完之后同步即可应用。

如果应用注解处理器的模块为“com.huawei.ohos.hap”，则须要在模块 “build.gradle”文件的“ohos”节点中增加以下配置：

compileOptions{   annotationEnabled true}

如果应用注解处理器的模块为“com.huawei.ohos.library”，则须要在模块“build.gradle”文件的“dependencies”节点中配置注解处理器。查看“orm_annotations_java.jar”、“orm_annotations_processor_java.jar” 、“javapoet_java.jar” 3个jar包在HUAWEI SDK中的对应目录，并将这三个jar包导入我的项目中。

dependencies { compile files("orm_annotations_java.jar的门路

,orm_annotations_processor_java.jar的门路,javapoet_java.jar的门路)

annotationProcessor files("orm_annotations_java.jar的门路

,orm_annotations_processor_java.jar的门路,javapoet_java.jar的门路)}

如果应用注解处理器的模块为“java-library”，则须要在模块 “build.gradle”文件的“dependencies”节点中配置注解处理器，并导入“ohos.jar”。

dependencies { compile files("ohos.jar的门路","orm_annotations_java.jar的门路

","orm_annotations_processor_java.jar的门路","javapoet_java.jar的门路")

annotationProcessor files("orm_annotations_java.jar的门路

","orm_annotations_processor_java.jar的门路","javapoet_java.jar的门路")}

比方：

以上操作无误之后就能够进行编码了！

ActiveOhos开发实现

3.1. 主页面的布局文件

定义四个按钮别离实现增删改查，定义四个Button实现申请点击事件

<?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:btn_insert"        ohos:height="match_content"        ohos:width="80fp"        ohos:text_color="red"        ohos:text="插入"        ohos:text_size="20fp"        ohos:weight="100fp"/>    <Button        ohos:id="$+id:btn_query"        ohos:height="match_content"        ohos:width="100fp"        ohos:text_color="blue"        ohos:text="查问"        ohos:text_size="20fp"        ohos:weight="100fp"/>    <Button        ohos:id="$+id:btn_update"        ohos:height="match_content"        ohos:width="100fp"        ohos:text_color="green"        ohos:text="更新"        ohos:text_size="20fp"        ohos:weight="100fp"/>    <Button        ohos:id="$+id:btn_delete"        ohos:height="match_content"        ohos:width="100fp"        ohos:text_color="black"        ohos:text="删除"        ohos:text_size="20fp"        ohos:weight="100fp"/>    <ListContainer        ohos:id="$+id:listText"        ohos:height="match_parent"        ohos:width="match_parent"/></DirectionalLayout>        ohos:width="match_content"        ohos:background_element="$graphic:background_ability_main"        ohos:layout_alignment="horizontal_center"        ohos:text="get申请"        ohos:text_size="50"        ohos:top_margin="80vp"        /></DirectionalLayout>

3.2. 例子代码如下

组件中有两种连贯数据的形式，别离是OrmContext，RdbStore ，其中应用OrmContext连贯形式时，须要定义一个实体类（User）来和数据库对应表名及字段，一个数据库类 BookStore 来配合开发，代码如下：

MainAbilitySliceimport com.example.myapplication.BookStore;import com.example.myapplication.ResourceTable;import com.example.myapplication.User;import com.example.sqlitelibrary.DBManage;import com.example.sqlitelibrary.DBOrmContext;import com.example.sqlitelibrary.utils.Log;import ohos.aafwk.ability.AbilitySlice;import ohos.aafwk.content.Intent;import ohos.agp.components.Button;import ohos.agp.components.Component;import ohos.data.DatabaseHelper;import ohos.data.orm.OrmContext;import ohos.data.orm.OrmPredicates;import ohos.data.rdb.RdbStore;import ohos.data.rdb.ValuesBucket;import java.util.ArrayList;import java.util.List;public class MainAbilitySlice extends AbilitySlice implements Component.ClickedListener {        private DatabaseHelper helper;    private RdbStore store;    private  OrmContext context;    @Override    public void onStart(Intent intent) {        super.onStart(intent);        super.setUIContent(ResourceTable.Layout_ability_main);        helper = new DatabaseHelper(this);        DBManage dbManger = new DBManage("user.db","user");        context = dbManger.getConnectionContext(helper, BookStore.class);//         DBManage dbManger = new DBManage("user.db");//         store = dbManger.getConnectionStore(helper,"user");        Button btnInsert = (Button) findComponentById(ResourceTable.Id_btn_insert);        Button btnQuery = (Button) findComponentById(ResourceTable.Id_btn_query);        Button btnDelete = (Button) findComponentById(ResourceTable.Id_btn_delete);        Button btnUpdate = (Button) findComponentById(ResourceTable.Id_btn_update);        btnInsert.setClickedListener(this::onClick);        btnQuery.setClickedListener(this::onClick);        btnDelete.setClickedListener(this::onClick);        btnUpdate.setClickedListener(this::onClick);    }    @Override    public void onActive() {        super.onActive();    }    @Override    public void onForeground(Intent intent) {        super.onForeground(intent);    }    @Override    public void onClick(Component component) {//        RdbStoreManage rdbStoreMange = new RdbStoreManage();//        ValuesBucket values = new ValuesBucket();//        values.putInteger("id", 1);//        values.putString("name", "zhangsan");//        values.putInteger("age", 18);//        values.putDouble("salary", 100.5);//        values.putByteArray("blobType", new byte[] {1, 2, 3});//        rdbStoreMange.setSql(store, "insert into user values(zhangsan, 18, 100.5, byte[1,2,3])");//        long id = rdbStoreMange.insert(store,"user", values);//        System.out.println(id);        DBOrmContext dbOrmContext = new DBOrmContext();        switch (component.getId()) {            case ResourceTable.Id_btn_insert: //插入数据                //第一次应用user对应的表的时候，如果有这张表就间接应用，没有就创立表                User user = new User();                user.setFirstName("Zhang");                user.setLastName("San");                user.setAge(29);                user.setBalance(100.51);                boolean b = dbOrmContext.insert(context, user);                Log.i("插入胜利");                System.out.println(b);                break;            case ResourceTable.Id_btn_query: //条件查问                List<User> users = new ArrayList<>();                OrmPredicates query = context.where(User.class).equalTo("lastName", "San");                users = dbOrmContext.query(context, query);                break;            case ResourceTable.Id_btn_delete: //条件删除                OrmPredicates delete = context.where(User.class).equalTo("lastName", "San");                int delete1 = dbOrmContext.delete(context, delete);                System.out.println(delete1);                break;            case ResourceTable.Id_btn_update: //条件更新                ValuesBucket valuesBucket = new ValuesBucket();                valuesBucket.putInteger("age", 31);                valuesBucket.putString("firstName", "Zhang");                valuesBucket.putString("lastName", "San");                valuesBucket.putDouble("balance", 300.51);                OrmPredicates update = context.where(User.class).equalTo("userId", 1);                int update1 = dbOrmContext.update(context, valuesBucket, update);                System.out.println(update1);                break;        }        dbOrmContext.flush(context);    }}user.java@Entity(tableName = "user", ignoredColumns = {"ignoreColumn1", "ignoreColumn2"},        indices = {@Index(value = {"firstName", "lastName"}, name = "name_index", unique = true)})public class User extends OrmObject {    // 此处将userId设为了自增的主键。留神只有在数据类型为包装类型时，自增主键能力失效。    @PrimaryKey(autoGenerate = true)    private Integer userId;    private String firstName;    private String lastName;    private int age;    private double balance;    private int ignoreColumn1;    private int ignoreColumn2;

// 开发者自行添加字段的getter和setter 办法

我的项目源代码地址：https://github.com/isoftstone...

欢送交换：HWIS-HOS@isoftstone.com

原文链接：https://developer.huawei.com/...
原作者：软通能源HOS