//dojox storage var car = {type: "Nissan", color: "white", price: 20000, optional:"air-conditioner, stereo"}; dojox.storage.put("complexKey", car); var car = dojox.storage.get("complexKey"); if(car){ alert(car.type); }
//dojox sql //Create a table dojox.sql("CREATE TABLE IF NOT EXISTS EMPLOYEE (" + "SN VARCHAR(50) NOT NULL, " + "name VARCHAR(300) NOT NULL," +" card VARCHAR(20) NOT NULL) ");
function submit(){ var sn = dojo.byId("SN"); var name = dojo.byId("name"); var card = dojo.byId("card"); if(sn.value=="" || name.value=="") { alert("Please enter your SN or name!"); return; } //insert data dojox.sql("INSERT INTO EMPLOYEE (SN, name,card) VALUES (?, ?, ?)", sn.value, name.value, card.value); sn.value=""; name.value=""; card.value=""; } function clearAll(){ var sn = dojo.byId("SN"); var name = dojo.byId("name"); var card = dojo.byId("card"); sn.value=""; name.value=""; card.value="";
dojox.sql("DELETE FROM EMPLOYEE"); } function show(){ var results = dojox.sql("SELECT SN,name,card FROM EMPLOYEE"); if(results){ for(var i=0;i alert('row '+(i+1)+':'+results[i].SN+'-'+results[i].name+'-'+results[i].card); } } }
//dojox sql //Create a table dojox.sql("CREATE TABLE IF NOT EXISTS EMPLOYEE (" + "SN VARCHAR(50) NOT NULL, " + "name VARCHAR(300) NOT NULL," +" card VARCHAR(20) NOT NULL) ");
当用户键入sn name card三个输入框并提交时,调用submit(),获得输入的数据并插入刚建好的表中。
function submit(){ var sn = dojo.byId("SN"); var name = dojo.byId("name"); var card = dojo.byId("card"); if(sn.value=="" || name.value=="") { alert("Please enter your SN or name!"); return; } //insert data dojox.sql("INSERT INTO EMPLOYEE (SN, name,card) VALUES (?, ?, ?)", sn.value, name.value, card.value); sn.value=""; name.value=""; card.value=""; }
3,显示插入的数据。很简单,见代码: function show(){ var results = dojox.sql("SELECT SN,name,card FROM EMPLOYEE"); if(results){ for(var i=0;i alert('row '+(i+1)+':'+results[i].SN+'-'+results[i].name+'-'+results[i].card); } } }