1.基于idb-js进行二次封装

1.1.安装

  1. npm install idb-js --save

1.2.引入

  1.  import Idb from 'idb-js'  //  引入Idb

1.3.db配置

idb_lab_testing_config.js代码如下

  1. export default {
  2.   dbName: "lab_testing",
  3.   version: 1,
  4.   tables: [
  5.     {
  6.       tableName: "qc_trf",
  7.       option: { keyPath: "id" },
  8.       indexs: [
  9.         {
  10.           key: "id",
  11.           options:{
  12.             unique: true
  13.           }
  14.         },
  15.         {
  16.           key: "trfId",
  17.           options:{
  18.             unique: true
  19.           }
  20.         },
  21.         {
  22.           key: "bno"
  23.         },
  24.         {
  25.           key: "workingNo"
  26.         },
  27.         {
  28.           key: "season"
  29.         },
  30.         {
  31.           key: "article"
  32.         },
  33.         {
  34.           key: "children"
  35.         }
  36.       ]
  37.     },
  38.     {
  39.       tableName: "qc_test_code",
  40.       option: { keyPath: "id" },
  41.       indexs: [
  42.         {
  43.           key: "id",
  44.           options:{
  45.             unique: true
  46.           }
  47.         },
  48.         {
  49.           key: "testCode"
  50.         }
  51.         ],
  52.     }
  53.   ]
  54. };

1.4.封装

  1. /**
  2.  * IndexedDB数据库操作
  3.  * @author max teng
  4.  * @version 2021-11-19 11:11:11
  5.  */
  6. import Idb from 'idb-js'
  7. import idb_lab_testing_config from './idb_lab_testing_config.js'
  9. var IndexedDBUtil = {}
  10. IndexedDBUtil.init = Idb(idb_lab_testing_config)
  12. /**
  13.  * 关闭数据库
  14.  */
  15. IndexedDBUtil.IdbClose = function (){
  16.     IndexedDBUtil.init.then(
  17.       db => {
  18.           db.close_db();
  19.       }
  20.     )
  21. }
  22. /**
  23.  * 新增数据
  24.  * @param {Object} tableName 表名
  25.  * @param {Object} data 新增数据
  26.  */
  27. IndexedDBUtil.IdbInsert = function (tableName,data){
  28.     IndexedDBUtil.init.then(
  29.       db => {
  30.           db.insert({
  31.             tableName: tableName,
  32.             data: data
  33.           });
  34.       },
  35.       err => {
  36.         console.log(err);
  37.       }
  38.     )
  39. }
  40.  /**
  41.   * 删除达成条件的数据
  42.   * @param {Object} tableName 表名
  43.   * @param {Object} conditionFun Lambda表达式，删除数据匹配条件 
  44.   */
  45. IndexedDBUtil.IdbDelete = function (tableName,conditionFun){
  46.     IndexedDBUtil.init.then(
  47.       db => {
  48.         db.delete({
  49.           tableName: tableName,
  50.           condition: conditionFun,
  51.           success: (res) => {
  52.             console.log("删除成功");
  53.           }
  54.         });
  55.       },
  56.       err => {
  57.         console.log(err);
  58.       }
  59.     )
  60. }
  61.  /**
  62.   * 更新数据
  63.   * @param {Object} tableName 表名
  64.   * @param {Object} conditionFun  Lambda表达式，更新数据匹配条件 
  65.   * @param {Object} handleFun Lambda表达式，更新数据修改方式
  66.   */
  67. IndexedDBUtil.IdbUpdate = function (tableName,conditionFun,handleFun){
  68.     IndexedDBUtil.init.then(
  69.       db => {
  70.         db.update({
  71.           tableName: tableName,
  72.           condition: conditionFun,
  73.           handle: handleFun,
  74.           success: r => {
  75.             console.log("修改成功", r);
  76.           },
  77.           error: msg => console.log(msg)
  78.         });
  79.       },
  80.       err => {
  81.         console.log(err);
  82.       }
  83.     )
  84. }
  85. /**
  86.  * 根据游标查询
  87.  * @param {Object} tableName 表名
  88.  * @param {Object} conditionFun Lambda表达式，查询数据匹配条件 
  89.  */
  90. IndexedDBUtil.IdbQuery = function (tableName,conditionFun){
  91.     let _that = this;
  92.     return new Promise(function(resolve, reject) {
  93.          IndexedDBUtil.init.then(
  94.           db => {
  95.                 db.query({
  96.                     tableName: tableName,
  97.                     condition: conditionFun,
  98.                     success: res => {
  99.                         resolve(res)
  100.                     }
  101.                 });
  102.           }
  103.         )
  104.     })
  105. }
  106.  /**
  107.   * 查询表所有的数据
  108.   * @param {Object} tableName 表名
  109.   */
  110. IndexedDBUtil.IdbQueryAll = function (tableName){
  111.     return new Promise(function(resolve, reject) {
  112.         IndexedDBUtil.init.then(
  113.           db => {
  114.             db.queryAll({
  115.               tableName: tableName,
  116.               success: res => {
  117.                   resolve(res)
  118.               }
  119.             });
  120.           },
  121.           err => {
  122.             console.log(err);
  123.           }
  124.         )
  125.     });
  126. }
  127.  /**
  128.   * @param {Object} tableName 表名
  129.   * @param {Object} indexName 索引字段
  130.   * @param {Object} target 查询值
  131.   */
  132. IndexedDBUtil.IdbQueryByIndex = function (tableName,indexName,target){
  133.     return new Promise(function(resolve, reject) {
  134.         IndexedDBUtil.init.then(
  135.           db => {
  136.             db.query_by_index({
  137.               tableName: tableName,
  138.               indexName: indexName,
  139.               target: target,
  140.               success: res => {
  141.                   resolve(res)
  142.               }
  143.             });
  144.           },
  145.           err => {
  146.             console.log(err);
  147.           }
  148.         )
  149.     })
  150. }
  151. export default IndexedDBUtil