$=function(obj){ return document.getElementById(obj); } var db=window.openDatabase("mydatabase","1.0","数据库描述信息",20000); if(db){ alert("数据库创建成功!"); } db.transaction(function(tx){ tx.executeSql("drop table test"); }); db.transaction(function(tx){ tx.executeSql("create table test(id integer primary key,Sno text,Sname text,Sdepartment text)"); }); function saveInfo(){ var theSno=document.getElementById("txtSno").value; var theSname=document.getElementById("txtSname").value; var theSdepartment=document.getElementById("txtSdepartment").value; db.transaction(function(tx){ tx.executeSql("insert into test(Sno,Sname,Sdepartment) values(?,?,?)",[theSno,theSname,theSdepartment],onSuccess); }); } function onSuccess(){ alert("操作成功!"); loadAllInfo(); } function loadAllInfo(){ db.transaction(function(tx){ tx.executeSql("select * from test",[],showAll); }); } function showAll(tx,rs){ var list=$("list"); var tablevar="
"; tablevar+="
编号
学号
姓名
院系
操作
"; for(var i=0;ivar dr=rs.rows.item(i);
tablevar+="
"+dr.id+"
"+dr.Sno+"
"+dr.Sname+"
"+dr.Sdepar tment+"
";
} tablevar+="
"; list.innerHTML=tablevar; } function del(id){ if(confirm("确定删除吗?")){ db.transaction(function(tx){ tx.executeSql("delete from test where id=?",[id]) }); } loadAllInfo(); }