if (!window.indexedDB) {
    window.indexedDB = window.mozIndexedDB || window.webkitIndexedDB || window.msIndexDB;      //webkit是chrome
}

var openDBRequest = indexedDB.open("person",3);        //第二个参数为版本
var openDBRequest = indexedDB.open("dev");

request.onupgradeneeded = function(event){     //数据库版本发生变化时先调用这个函数，然后再执行onsuccess
    alert(event.oldVersion);
    database = request.result;
    if (database.objectStoreNames.contains(‘user‘)) { 
        database.deleteObjectStore(‘user‘);
      }
    var store = database.createObjectStore("user", {keyPath: "uuid", autoIncrement: true});    //此处表示将uuid作为主键
　　//keyPath 后面的值一定是要存在的属性名，用于标志唯一字段，如果重复则不添加进去，可以是字符串、数值类型等 
　　//此值也是索引中的 Primary key(keyPath : "uuid")
    store.createIndex("idIndex", "id", {unique: true});   //创建索引 (此处的id改为uuid)
　　//idIndex 为索引的名称，id 为 索引中的KeyPath，即将id属性中的值作为索引
　　//注：如果写成id的话（与上面的keyPath不一至，将不会创建索引，这里将不会创建索引）
    var user1 = {uuid :1001, username: "caoxiaobo", password: "123456", age: 23,other:"test"};
    var user2 = {uuid :1002, username: "adminuser", password: "123456", age: 24};
    var user3 = {uuid :1003, username: "test1user", password: "123456", age: 25}
    var req = store.put(user1);
    store.put(user2);
    store.put(user3);
    req.onsuccess = function(){
          //...
    }
}

var deleteRequest = indexedDB.deleteDatabase(‘test‘);
deleteRequest.onsuccess = function(){
    alert("删除成功");
}
db.deleteObjectStore(‘books‘);        //删除数据表

//查询数据
function getData() {
    //事务的创建
    var tx = database.transaction(["user"], "readonly");    //readwrite readonly
    var store = tx.objectStore("user");
    var request = store.get(1001);
    request.onsuccess = function() {
        var user = request.result;
        //var user = event.target.result;
        console.log(JSON.stringify(user));
    };
}

//游标查询所有
function getAllData() {
    //事务的创建
    var tx = database.transaction(["user"], "readonly");    //readwrite readonly
    var store = tx.objectStore("user");
    var openCursor = store.openCursor();
    openCursor .onsuccess = function() {
        var cursor= request.result;
        //var cursor = event.target.result;
        if(cursor){
               console.log(JSON.stringify(cursor.value));
               cursor.continue();
        } 
    };
}

//游标+索引查询
function getDataByIndexAndCursor() {
    var tx = database.transaction(["user"], "readonly");    //readwrite readonly
    var store = tx.objectStore("user");
    var index = store.index("nameIndex");
    var request = index.openCursor(IDBKeyRange.lowerBound("123"));
    //var request = index.openCursor(IDBKeyRange.bound("a","v", false, true));    //区分大小写 
    request.onsuccess = function() {
        var cursor = request.result;
        if (cursor) {
            console.log(JSON.stringify(cursor.value));
            cursor.continue();
        }
    }
}
//获取记录数
function count() {
    var tx = database.transaction(["user"], "readonly");  
    var store = tx.objectStore("user");
    var request = store.count();
    request.onsuccess = function() {
        var count = request.result;
        console.log(count);
    }
}
//按索引查询
var findByIndex = function() {
    var mode = IDBTransaction.READ_ONLY;
    var tx = database.transaction(["user"], "readonly");
    var store = tx.objectStore(["user"]);
    var index = store.index("idIndex");
    var request = index.get(1001);
    console.log(request);
    request.onsuccess = function() {
        var data = request.result;
        console.log(JSON.stringify(data));
    }
}
//添加数据
function addData(){
    var tx = database.transaction(["user"],"readwrite");
    var store = tx.objectStore("user");
    var user4 = {id:1004, username: "caoxiaobo", password: "123456", age: 23,other:"test"};
    var user5 = {id:1005, username: "adminuser", password: "123456", age: 24};
    var user6 = {id:1006, username: "test1user", password: "123456", age: 25};
    store.put(user4);
    store.put(user5);
    store.put(user6);
}

//删除数据
function delData(){
    var tx = database.transaction(["user"],"readwrite");
    var store = tx.objectStore("user");
    store.delete(1004);
    store.delete(1005);
    store.delete(1006);
}

//清空数据
function clearData(){
    var tx = database.transaction(["user"],"readwrite");
    var store = tx.objectStore("user");
    store.clear( );
}

//修改数据
function updata(){
    var tx = database.transaction(["user"],"readwrite");
    var store = tx.objectStore("user");
    var request = store.get(1008);
    request.onsuccess = function(event) {
        var user = event.target.result;
        user.username = "cxb1008";
        user.age = 28;
        store.put(user);
    }
}