[TOC] ## 概述 一個帶有 SQL 語法的 IndexedDB 包裝器。 ## demo ``` // 創建數據庫 var dbName ='JsStore_Demo'; var tblProduct = { name: 'Product', columns: { // Here "Id" is name of column id:{ primaryKey: true, autoIncrement: true }, itemName: { notNull: true, dataType: "string" }, price: { notNull: true, dataType: "number" }, quantity : { notNull: true, dataType: "number" } } }; var database = { name: dbName, tables: [tblProduct] } // 初始化數據庫 const isDbCreated = await connection.initDb(database); if(isDbCreated === true){ console.log("db created"); // here you can prefill database with some data } else { console.log("db opened"); } // 生成數據 var value = { itemName: 'Blue Jeans', price: 2000, quantity: 1000 } var insertCount = await connection.insert({ into: 'Product', values: [value] }); console.log(`${insertCount} rows inserted`); // 讀數據 // results will be array of objects var results = await connection.select({ from: 'Product', where: { id: 5 } }); alert(results.length + 'record found'); // 更新數據 var rowsUpdated = await connection.update({ in: 'Product', where: { itemName: { like: '%black%' } }, set: { quantity: 2000 } }); alert(rowsUpdated + ' rows updated'); // 刪除數據 var rowsDeleted = await connection.remove({ from: 'Product', where: { id: 10 } }); alert(rowsDeleted + ' record deleted'); ```