html点击数据库中,HTML5中逆天的本地数据库操作

function initDatabase() {

var db = getCurrentDb();//初始化数据库

if(!db) {alert("您的浏览器不支持HTML5本地数据库");return;}

db.transaction(function (trans) {//启动一个事务，并设置回调函数

//执行创建表的Sql脚本

trans.executeSql("create table if not exists Demo(uName text null,title text null,words text null)", [], function (trans, result) {

}, function (trans, message) {//消息的回调函数alert(message);});

}, function (trans, result) {

}, function (trans, message) {

});

}

$(function () {//页面加载完成后绑定页面按钮的点击事件

initDatabase();

$("#btnSave").click(function () {

var txtName = $("#txtName").val();

var txtTitle = $("#txtTitle").val();

var txtWords = $("#txtWords").val();

var db = getCurrentDb();

//执行sql脚本，插入数据

db.transaction(function (trans) {

trans.executeSql("insert into Demo(uName,title,words) values(?,?,?) ", [txtName, txtTitle, txtWords], function (ts, data) {

}, function (ts, message) {

alert(message);

});

});

showAllTheData();

});

});

function getCurrentDb() {

//打开数据库，或者直接连接数据库参数：数据库名称，版本，概述，大小

//如果数据库不存在那么创建之

var db = openDatabase("myDb", "1.0", "it's to save demo data!", 1024 * 1024); ;

return db;

}

//显示所有数据库中的数据到页面上去

function showAllTheData() {

$("#tblData").empty();

var db = getCurrentDb();

db.transaction(function (trans) {

trans.executeSql("select * from Demo ", [], function (ts, data) {

if (data) {

for (var i = 0; i < data.rows.length; i++) {

appendDataToTable(data.rows.item(i));//获取某行数据的json对象

}

}

}, function (ts, message) {alert(message);var tst = message;});

});

}

function appendDataToTable(data) {//将数据展示到表格里面

//uName,title,words

var txtName = data.uName;

var txtTitle = data.title;

var words = data.words;

var strHtml = "";

strHtml += "

";

strHtml += "

"+txtName+"";

strHtml += "

" + txtTitle + "";

strHtml += "

" + words + "";

strHtml += "

";

$("#tblData").append(strHtml);

}

用户名：
标题：
留言：

---