【简单的留言本】用HTML新增的数据库实现

【简单的留言本】用HTML新增的数据库实现

使用数据库实现的WEB留言本

var datatable = null;

var db = openDatabase('Mydata','','My Database',102400);

function init() {

datatable = document.getElementById("datatable");

showAllData();

}

function removeAllData() {

for(var i = datatable.childNodes.length-1;i>=0;i--){

datatable.removeChild(datatable.childNodes[i]);

}

var tr = document.createElement('tr');

var th2 = document.createElement('th');

var th3 = document.createElement('th');

var th4 = document.createElement('th');

th2[xss_clean] = "姓名";

th3[xss_clean] = "留言";

th4[xss_clean] = "时间";

tr.appendChild(th2);

tr.appendChild(th3);

tr.appendChild(th4);

datatable.appendChild(tr);

}

function showData(row) {

var tr = document.createElement('tr');

var td1 = document.createElement('td');

td1[xss_clean] = row.name;

var td2 = document.createElement('td');

td2[xss_clean]= row.message;

var td3 = document.createElement('td');

var t = new Date();

t.setTime(row.time);

td3[xss_clean] = t.toLocaleDateString()+""+t.toLocaleTimeString();

tr.appendChild(td1);

tr.appendChild(td2);

tr.appendChild(td3);

datatable.appendChild(tr);

}

function showAllData() {

db.transaction(function (tx) {

tx.executeSql('CREATE TABLE IF NOT EXISTS MsgData(name TEXT,message TEXT,time INTEGER)',[]);

tx.executeSql('SELECT * FROM MsgData',[],function (tx,rs) {

removeAllData();

for(var i =0 ;i

showData(rs.rows.item(i));

}

});

});

}

function addData(name,message,time) {

db.transaction(function (tx) {

tx.executeSql('INSERT INTO MsgData VALUES(?,?,?)',[name,message,time],function (tx,rs) {

alert("成功保存数据！");

},function (tx,rs) {

alert(error.source+"::" + error.message);

});

});

}

function saveData() {

var name = document.getElementById('name').value;

var memo = document.getElementById('memo').value;

var time = new Date().getTime();

//alert(time);

addData(name,memo,time);

showAllData();

}

使用数据库实现的Web留言本

姓名：

留言：

________________________________________