JSQL 基于客户端的成绩统计实现方法_javascript技巧

复制代码 代码如下:

Marks Count #marks input { width: 100px; }

Marks Count Add one line Save Changes By Chinese Math English Desc Asc Order

Name: Sex: Chinese: Math: English:

var marks = [ { name: 'Lisi', sex: 'Female', chinese: '88', math: '90', english: '92' }, { name: 'Wangwu', sex: 'Female', chinese: '92', math: '80', english: '82' }, { name: 'Lilei', sex: 'Female', chinese: '93', math: '88', english: '87' }, { name: 'HanMeimei', sex: 'Male', chinese: '97', math: '92', english: '100' }, { name: 'Wangjuan', sex: 'Male', chinese: '92', math: '93', english: '90' } ];

function addto(index,name,sex,chinese,math,english) { "insert into marks (nodename,innerHTML) values ('span','Name:')".ForDOM().execute(); ("insert into marks (nodename,type,id,value) values ('input','text','name[" + (index) + "]','" + name + "')").ForDOM().execute(); "insert into marks (nodename,innerHTML) values ('span','Sex:')".ForDOM().execute(); ("insert into marks (nodename,type,id,value) values ('input','text','sex[" + (index) + "]','" + sex + "')").ForDOM().execute(); "insert into marks (nodename,innerHTML) values ('span','Chinese:')".ForDOM().execute(); ("insert into marks (nodename,type,id,value) values ('input','text','chinese[" + (index) + "]','" + chinese + "')").ForDOM().execute(); "insert into marks (nodename,innerHTML) values ('span','Math:')".ForDOM().execute(); ("insert into marks (nodename,type,id,value) values ('input','text','math[" + (index) + "]','" + math + "')").ForDOM().execute(); "insert into marks (nodename,innerHTML) values ('span','English:')".ForDOM().execute(); ("insert into marks (nodename,type,id,value) values ('input','text','english[" + (index) + "]','" + english + "')").ForDOM().execute(); ("insert into marks (nodename) values ('br')").ForDOM().execute(); };

for(var i=0; i addto(i+2,marks[i].name,marks[i].sex,marks[i].chinese,marks[i].math,marks[i].english); };

function insertline() { var count = "select count(*) as Count from marks where id like 'name%'".ForDOM().query(); var index = count[0].Count + 1; addto(index,"","","","",""); };

function dellastline() { var count = "select count(*) as Count from marks where id like 'name%'".ForDOM().query(); var index = count[0].Count; ("delete from marks where id like '%["+ index +"]'").ForDOM().execute(); };

"create table savedmarks".execute();

function savemarks() { var names = ("select value from marks where id like 'name%'").ForDOM().query(); var sexs = ("select value from marks where id like 'sex%'").ForDOM().query(); var chineses = ("select value from marks where id like 'chinese%'").ForDOM().query(); var maths = ("select value from marks where id like 'math%'").ForDOM().query(); var englishs = ("select value from marks where id like 'english%'").ForDOM().query(); "delete from savedmarks".execute(); for(var i=0;i ("insert into savedmarks (name,sex,chinese,math,english) values ('"+ names[i].value +"','" + sexs[i].value + "'," + chineses[i].value + "," + maths[i].value + "," + englishs[i].value + ")").execute(); }; //alert(savedmarks); };

function orderby(field,asc) { savemarks(); var marks = ("select * from savedmarks order by " + field + " " + asc).query(); "delete from marks".ForDOM().execute(); for(var i=0; i addto(i+2,marks[i].name,marks[i].sex,marks[i].chinese,marks[i].math,marks[i].english); }; }; function order() { var byfield = document.getElementById("byfield").value; var ascdesc = document.getElementById("ascdesc").value; orderby(byfield,ascdesc); };

主要用到四个JS库，其中YESBRAIN.js是基库，JSQL.js是接口。JSQL-Memory.js和JSQL-DOM分别是JSQL对 javascript Objects Array 和 Html DOM 的 SQL 实现。

jsql javascript

JSQL 基于客户端的成绩统计实现方法_javascript技巧

Marks Count

Articles Liés