javascript 完全正确的数据库indexedDB

//indexedDB
var dbName = 'whx', version = '1', dbTableName = 'bbg', request, db, conCls, updateKey, fun = new Fun();
function openDbs(){//请求数据库
    fun.elem('codeId').innerHTML += '打开数据库<br />';
    
    request.onupgradeneeded = function(e){
        fun.elem('codeId').innerHTML += '新的版本号<br />';
        var t = e.target.result;
        if(!t.objectStoreNames.contains(dbTableName)){
            var dbB = t.createObjectStore(dbTableName, {
                keyPath : 'id',
                autoIncrement : true
            });
            dbB.createIndex('id','id',{unique : false});
            fun.elem('codeId').innerHTML += '创建新表<br />';
        }
    }
    
    request.onsuccess = function(e){
        fun.elem('codeId').innerHTML += '旧的版本号<br />';
        db = e.target.result;//数据库对象
        fun.elem('codeId').innerHTML += '保存数据库对象<br />';
    }
    
    request.onerror = function(){
        fun.elem('codeId').innerHTML += '打开数据库失败<br />';
    }
    
    fun.display('consTxtId','none');//add content in table
    fun.value('sltId','','set');//add content in table
    fun.display('dbConId','block');//db btn
}

function close(){//关闭
    db.close();
    fun.elem('codeId').innerHTML += '关闭数据库<br />';
    db.onclose = function(){//没用...
        alert('close read');
    }
}

function deleteDb(){//删除
    indexedDB.deleteDatabase(dbName);
    fun.elem('codeId').innerHTML += '删除数据库<br />';
}

function showTb(){//查看表内容
    var setTable = db.transaction(dbTableName,'readwrite');//设置表权限
    fun.elem('codeId').innerHTML += '设置表权限<br />';
    
    var getTable = setTable.objectStore(dbTableName);//获取表对象
    fun.elem('codeId').innerHTML += '获取表对象<br />';
    
    var cursor = getTable.openCursor();//创建游标
    fun.elem('codeId').innerHTML += '创建游标<br />';
    
    fun.elem('codeId').innerHTML += '获取表信息<br />';
    
    fun.value('sltId','','set');
    
    cursor.onsuccess = function(e){
        var cursorObj = e.target.result;//获取游标对象
        console.log(cursorObj);
        if(cursorObj != null){
            fun.elem('sltId').innerHTML += "id : " + cursorObj.value.id + ", content : " + cursorObj.value.content + " <span onclick='conUpdate("+cursorObj.key+")'>修改</span> || <span onclick='conDelete("+cursorObj.key+")'>删除</span><br /><br />";
            if(cursorObj.key == 2){
                //console.log(cursorObj.value);
            }
            cursorObj.continue();//游标移动下一个条
        }
    }
    
    cursor.onerror = function(){
        fun.elem('codeId').innerHTML += '创建游标失败<br />';
    }
}

function addCon(con){//添加
    var setTable = db.transaction(dbTableName,'readwrite');//设置表权限
    fun.elem('codeId').innerHTML += '设置表权限<br />';
    
    var getTable = setTable.objectStore(dbTableName);//获取表对象
    fun.elem('codeId').innerHTML += '获取表对象<br />';
    
    var conSet = getTable.add(con);
    conSet.onsuccess = function(){
        showTb();
        fun.elem('codeId').innerHTML += '添加内容成功<br />';
    }
}

function updateCon(key,con){//修改
    var setTable = db.transaction(dbTableName,'readwrite');//设置表权限
    fun.elem('codeId').innerHTML += '设置表权限<br />';
    
    var getTable = setTable.objectStore(dbTableName);//获取表对象
    fun.elem('codeId').innerHTML += '获取表对象<br />';
    
    var update = getTable.put({content : con.content, id : key});
    update.onsuccess = function(){
        showTb();
        fun.elem('codeId').innerHTML += "修改key:"+key+"内容成功<br />";
    }
}

function deleteCon(key){//删除
    var setTable = db.transaction(dbTableName,'readwrite');//设置表权限
    fun.elem('codeId').innerHTML += '设置表权限<br />';
    
    var getTable = setTable.objectStore(dbTableName);//获取表对象
    fun.elem('codeId').innerHTML += '获取表对象<br />';
    
    var dlt = getTable.delete(key);
    dlt.onsuccess = function(){
        showTb();
        fun.elem('codeId').innerHTML += "删除key:"+key+"内容成功<br />";
    }
}


//------------------------------------------------btn-------------------------------------------
fun.elem('openDbId').onclick = function(){//request indexedDb btn
    if('indexedDB' in window){
        request = indexedDB.open(dbName,version);
        openDbs();
    }else{
        alert('当前浏览器不支持indexedDB!');
    }
}

fun.elem('ddId').onclick = function(){//delete database btn
    fun.value('codeId','','set');
    fun.display('dbConId','none');
    deleteDb();
    close();
}

fun.elem('closeId').onclick = function(){//close database btn
    fun.value('codeId','','set');
    fun.display('dbConId','none');
    close();
}

fun.elem('tbId').onclick = function(){//tables btn
    showTb();
}

fun.elem('aitId').onclick = function(){//add content in table btn
    if(fun.elem('consTxtId').style.display == 'block'){
        conCls = '';
        fun.display('consTxtId','none');
        fun.value('conMsgId','','set');
    }else{
        conCls = 'add';
        fun.value('conMsgId','添加 : ','set');
        fun.display('consTxtId','block');
    }
}

fun.elem('confirmAddId').onclick = function(){//confirm btn
    if(fun.elem('conId').value == ''){
        alert('内容为空');
    }else{
        var con = {content : fun.elem('conId').value};
        if(conCls != undefined){
            if(conCls == "add"){
                addCon(con);
            }
            if(conCls == "update"){
                if(updateKey != undefined){
                    updateCon(updateKey,con);
                }
            }
            fun.display('consTxtId','none');
            fun.elem('conId').value = '';
        }
    }
}

//content  btn
function conUpdate(key){//修改 btn
    conCls = 'update';
    updateKey = key;
    fun.value('conMsgId','修改 : ','set');
    fun.display('consTxtId','block');
}
function conDelete(key){//删除 btn
    deleteCon(key);
}
</script>