script代码

  • 格式:doc
  • 大小:25.00 KB
  • 文档页数:2

$=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+="

";

}
tablevar+="

编号学号姓名院系操作
"+dr.id+""+dr.Sno+""+dr.Sname+""+dr.Sdepar
tment+"
";
list.innerHTML=tablevar;
}
function del(id){
if(confirm("确定删除吗?")){
db.transaction(function(tx){
tx.executeSql("delete from test where id=?",[id])
});
}
loadAllInfo();
}