indexedDB基本使用方法（增删改查）

头像
风一样的六六哥
    阅读 7 分钟
    1
    效果展示

    image.png

    <!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>indexedDB</title>
</head>
<style>
    fieldset {
        margin-top: 50px;
        padding: 30px;
    }
</style>

<body>
    <h3>indexedDB web数据库 增删改查</h3>
    <div id="app">
        <fieldset>
            <button onclick="ctr('create')">添加</button>
            <input id="addInput" type="text">
        </fieldset>
        <fieldset>
            <button onclick="ctr('retrieve')">查找</button>
            <input id="findInput" type="text">
            <span id="viewFindResult"></span>
        </fieldset>
        <fieldset>
            <button onclick="ctr('update')">更新</button>
            <input id="updateInput" type="text">
        </fieldset>
        <fieldset>
            <button onclick="ctr('delete')">删除</button>
            <input id="delInput" type="text">
        </fieldset>
        <fieldset>
            <button onclick="ctr('clear')">清空</button>
        </fieldset>
        <div>
            <!-- <ol>
                <li><button></button></li>
            </ol> -->
            <ul id="list">暂无数据</ul>
        </div>
    </div>~~~~
    <script>
        let db, version = 1
        const addInputEle = document.getElementById("addInput");
        const updateInputEle = document.getElementById("updateInput");
        const delInputEle = document.getElementById("delInput");
        const findInputEle = document.getElementById("findInput");
        const viewFindResultEle = document.getElementById("viewFindResult");
        const listEle = document.getElementById("list");

        const request = indexedDB.open("user", version);
        //监听数据库错误
        request.onerror = function (e) {
            console.log("onerror", e);
        }

        //监听数据库更新
        request.onupgradeneeded = function (e) {
            console.log("onupgradeneeded", e);
            db = e.target.result;
            var transaction = event.target.transaction
            if (!db.objectStoreNames.contains("users")) {
                const objectStore = db.createObjectStore("users", {
                    keyPath: "username"
                });
                objectStore.createIndex('age', 'age', {
                    unique: true
                });;
                objectStore.createIndex('fullName', 'fullName', {
                    unique: false
                });;
            }
        }

        //监听数据库连接成功
        request.onsuccess = function (e) {
            console.log("onsuccess", e);
            db = e.target.result;
            objectStore = db.transaction(['users'], 'readwrite')
                .objectStore('users');
            viewAll(objectStore)
        }
        //操作数据库
        function ctr(method) {
            if (!db) {
                alert("数据库连接中")
            }
            objectStore = db.transaction(['users'], 'readwrite')
                .objectStore('users');
            switch (method) {
                case "create":
                    createData(objectStore);
                    break;
                case "retrieve":
                    retrieveData(objectStore);
                    break;
                case "update":
                    updateData(objectStore);
                    break;
                case "delete":
                    deleteData(objectStore);
                    break;
                case "clear":
                    clearData(objectStore);
                    break;
            }
        }
        //新增数据
        function createData(objectStore) {
            const username = addInputEle.value;
            if (!username) {
                alert("input为空")
                return;
            }
            const req = objectStore
                .add({
                    username,
                    age: parseInt(Math.random() * 10000000) + "",
                    fullName: 1
                });
            req.onsuccess = function (e) {
                console.log('数据新增成功', e);
                viewAll(objectStore);
            };

            req.onerror = function (e) {
                console.log('数据新增失败', e);
            }
        }
        //检索数据
        function retrieveData(objectStore) {
            const username = findInputEle.value;
            if (!username) {
                alert("input为空")
                return;
            }
            const req = objectStore.index("age")
                .get(username);
            req.onsuccess = function (e) {
                viewFindResultEle.innerText = e.target.result ? JSON.stringify(e.target.result) : "无此条记录";
                console.log('数据检索成功', e);
            };

            req.onerror = function (e) {
                console.log('数据检索失败', e);
            }
        }
        //更新数据
        function updateData(objectStore) {
            const username = updateInputEle.value;
            if (!username) {
                alert("input为空")
                return;
            }
            const req = objectStore
                .put({
                    username,
                    age: 9999999999
                });
            req.onsuccess = function (e) {
                console.log('数据更新成功', e);
                viewAll(objectStore)
            };

            req.onerror = function (e) {
                console.log('数据更新失败', e);
            }
        }
        //删除数据
        function deleteData(objectStore) {
            const username = delInputEle.value;
            if (!username) {
                alert("input为空")
                return;
            }
            const req = objectStore
                .delete(username);
            req.onsuccess = function (e) {
                console.log('数据删除成功', e);
                viewAll(objectStore)
            };

            req.onerror = function (e) {
                console.log('数据删除失败', e);
            }
        }
        //清空数据
        function clearData(objectStore) {
            const req = objectStore
                .clear();
            req.onsuccess = function (e) {
                console.log('数据清空成功', e);
                viewAll(objectStore)
            };

            req.onerror = function (e) {
                console.log('数据清空失败', e);
            }
        }

        //展示所有数据
        function viewAll(objectStore) {
            listEle.innerHTML = null;
            var flag = 0;
            objectStore.openCursor().onsuccess = function (e) {
                console.log("数据列表", e);
                const liEle = document.createElement("li");
                var cursor = e.target.result;
                if (cursor) {
                    flag++;
                    liEle.innerText = JSON.stringify(cursor.value);
                    listEle.appendChild(liEle);
                    cursor.continue();
                } else {
                    if (flag == 0) {
                        listEle.innerText = "暂无数据";
                    } else {
                        flag = 0;
                    }
                }
            };
        }
    </script>
</body>

</html>
    前端html5indexeddbjavascript
    风一样的六六哥
    50 声望3 粉丝

    今是昨非，来者可追~

    « 上一篇
    webpack5升级指南（踩坑记录）
    下一篇 »
    jsconfig.json到底是做什么的

    引用和评论

    推荐阅读
    头像
    husky9以上+lint-staged不生效

    风一样的六六哥阅读 791

    头像
    腾讯新闻中心首页改版啦

    小蚊酱赞 11阅读 9.3k评论 7

    头像
    网页设计的垂直居中

    寒青赞 39阅读 4.6k评论 3

    头像
    CSS团队协作规范

    寒青赞 36阅读 3.8k

    头像
    前端如何入门 Go 语言

    robin赞 26阅读 7.7k评论 8

    头像
    100个React最佳实践小技巧

    夕水赞 17阅读 2.5k评论 4

    头像
    不使用 JS 纯 CSS 获取屏幕宽高

    南城FE赞 15阅读 2.1k评论 3

    0 条评论
    得票最新