webSQL 操作

var webStorage = {};
webStorage.webSql = function () {

    var _this = this;

    //数据库
    var _dataBase;

    //打开数据库连接或者创建数据库
    this.openDatabase = function () {

        if (!!_dataBase) {
            return _dataBase;
        }
        _dataBase = openDatabase("table", "1.0", "注释", 1024 * 1024, function () { });
        return _dataBase;

    }




    //创建数据表
    this.createTable = function () {

        var dataBase = _this.openDatabase();
        // 创建表
        dataBase.transaction(function (tx) {
            tx.executeSql(
        "create table if not exists table (id INTEGER PRIMARY KEY ASC, uid INTEGER)",
        [],
        function () { /*alert('创建table表成功');*/ },
        function (tx, error) {
            alert('创建table表失败:' + error.message);
        });

    }

    //添加数据
    this.insert = function (data) {
		
        var dataBase = _this.openDatabase();
            dataBase.transaction(function (tx) {
                tx.executeSql(
                    "insert into table (uid) values(?)",
                    [data.userid],
                    function () {
                    	alert('data insert success');						
                    },
                    function (tx, error) {
                        alert('添加数据失败: ' + error.message);
                    });
            });
    }

    /*查找为查看聊天信息的总数*/
    this.getcount = function(){
        var dataBase = _this.openDatabase();
        dataBase.transaction(function (tx) {
            tx.executeSql(
                "select count(*) as num from table",
                [],
                function (tx, result) {
                    alert("select data success");
                },
                function (tx, error) {
                    alert('查询table总数失败: ' + error.message);
                });
        });
    }

    
    //最近聊天数据表更新数据
    this.update = function (id, time) {

        var dataBase = _this.openDatabase();
        dataBase.transaction(function (tx) {
            tx.executeSql(
        "update table set uid= ? where id= ?",
        [id, id],
         function (tx, result) {

         },
        function (tx, error) {
            alert('更新失败1: ' + error.message);
        });
        });
    }

    //删除数据
    this.del = function (id) {
        var dataBase = _this.openDatabase();
        dataBase.transaction(function (tx) {
            tx.executeSql(
        "delete from  table where id= ?",
        [id],
         function (tx, result) {
         },
        function (tx, error) {
            alert('删除失败: ' + error.message);
        });
        });
    }

    //删除数据表
    this.dropTable = function () {
        var dataBase = _this.openDatabase();
        dataBase.transaction(function (tx) {
            tx.executeSql('drop  table  table');
        });
    }


}