插入数据成功java
ActiveOhos使用方法git
2.1. 为应用添加sqlitelibrary-debug.har包依赖github
在应用模块中调用HAR,经常使用的添加依赖为:依赖本地HARsql
第一步:将sqlitelibrary-debug.har复制到entry\libs目录下便可(因为build.gradle中已经依赖的libs目录下的*.har,所以不须要再作修改)。数据库
查看工程目录中build.gradle下的*.har是否存在app
第二步:除了依赖har以外还须要添加外部依赖用来实现类的引入,引入方式以下,引入完以后同步便可使用。ide
若是使用注解处理器的模块为“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包导入项目中。gradle
dependencies { compile files("orm_annotations_java.jar的路径ui
,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的路径")}
好比:
以上操做无误 以后就能够进行编码了!
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 来配合开发,代码以下:
MainAbilitySlice import 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