html5中sql 使用

来源：互联网发布：手机网络管理软件编辑：程序博客网时间：2024/06/06 12:29

html5中sql 使用

<!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title></title>    <script src="sql.js"></script></head><body onload="init()">    <table>        <tr><td>姓名:</td><td><input type="text" id="name"></td></tr>        <tr><td>留言:</td><td><input type="text" id="memo"></td></tr>        <tr>            <td></td>            <td><input type="button" value="保存" onclick="saveData()"></td>        </tr>    </table><hr/><table id="datatable" border="1"></table>    <p id="msg"></p></body></html>

js

/** * Created by 宋贤 on 2015/10/15. */var datatable=null;var db=openDatabase("MyData","","My Database",1024*100);function init(){    datatable=document.getElementById("datatable");    showAllData();}function removeAll(){    for(var i=datatable.hasChildNodes.length-1;i>=0;i--){        datatable.removeChild(datatable.childNodes[i]);    }    var tr=document.createElement("tr");    var th1=document.createElement("th");    var th2=document.createElement("th");    var th3=document.createElement("th");    th1.innerHTML="姓名";    th2.innerHTML="留言";    th3.innerHTML="时间";    tr.appendChild(th1);    tr.appendChild(th2);    tr.appendChild(th3);    datatable.appendChild(tr);}function showData(row){    var tr=document.createElement("tr");    var td1=document.createElement("td");    td1.innerHTML=row.name;    var td2=document.createElement("td");    td2.innerHTML=row.message;    var td3=document.createElement("td");    var t=new Date();    t.setTime(row.time);    td3.innerHTML= 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){            removeAll();            console.log("ss");            for(var i=0;i<rs.rows.length;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,error){            alert(error.source+"::"+error.message);        });    });}function saveData(){    var name=document.getElementById("name").value;    var memo=document.getElementById("memo").value;    var time=new Date().getTime();    addData(name,memo,time);    showAllData();}

0 0