|
- class sqlxls {
- ctor(dbPath,...){
- var arg={...};
- import access;
- this.db,this.err = access( dbPath);
- for(i=1;#arg;1){
- this[arg[i]]=creSql
- }
- };
-
- createTable = function(shname){
- if( ! this.db.existsTable(shname) ){
- var creSql="CREATE TABLE " ++ shname++" ("
- var tempvalue=0;
- for(i=1;#arg-1;1){
- creSql=creSql++arg[i]++" char(20),"
- tempvalue=i;
- }
- creSql=creSql++arg[tempvalue+1]++" char(20))";
- this.db.exec(creSql);
- }
- }
-
- add = function(shname,...){
- var arg2={...}
- var sql1="insert into " ++ shname ++" ("
- var tempvalue=0;
- for(i=1;#arg-1;1){
- sql1=sql1++arg[i]++",";
- tempvalue=i;
- }
- sql1=sql1++arg[tempvalue+1]++") values("
- var sql2=''
- tempvalue=0;
- for(i=1;#arg-1;1){
- if(arg2[i]!=null){
- sql2=sql2++'\''++arg2[i]++'\','
- }else {
- sql2=sql2++"null"++','
- }
-
- tempvalue=i;
- }
- if(arg2[tempvalue+1]!=null){
- sql2=sql2++'\''++arg2[tempvalue+1]++'\')'
- }else {
- sql2=sql2++"null"++')'
- }
- addSql=sql1++sql2;
- this.db.exec(addSql);
- //this.db.close();
- }
-
- del = function(shname,from,to,...){
- var arg2={...};
- sql1="Update "++shname++" Set ";
- var tempvalue=0;
- for(i=1;#arg-1;1){
- sql1=sql1++arg[i]++"="++"null"++",";
- tempvalue=i;
- }
- sql1=sql1++arg[tempvalue+1]++"="++"null";
- var sql2=" Where "
- tempvalue=0;
- if( from=to ){
- if(arg2[to]!=null){
- sql2=sql2++arg[to]++"="++"'"++arg2[to]++"'";
- }else {
- sql2=sql2++arg[to]++"="++"null";
- }
- }elseif(from<to){
- for(i=from;to-1;1){
- if(arg2[i]!=null){
- sql2=sql2++arg[i]++"="++"'"++arg2[i]++"'"++' and ';
- }else {
- sql2=sql2++arg[i]++"="++"null"++' and ';
- }
- tempvalue=i;
- }
- if(arg2[tempvalue+1]!=null){
- sql2=sql2++arg[tempvalue+1]++"="++"'"++arg2[tempvalue+1]++"'";
- }else {
- sql2=sql2++arg[tempvalue+1]++"="++"null";
- }
- }
- upsql=sql1++sql2;
- this.db.exec(upsql)
- //this.db.close();
- }
-
- update=function(shname,from,to,...){
- var arg2={...};
- sql1="Update "++shname++" Set ";
- var tempvalue=0;
- for(i=1;#arg-1;1){
- if(arg2[i]!=null){
- sql1=sql1++arg[i]++"="++"'"++arg2[i]++"'"++",";
- }else {
- sql1=sql1++arg[i]++"="++"null"++",";
- }
- tempvalue=i;
- }
- if(arg2[tempvalue+1]!=null){
- sql1=sql1++arg[tempvalue+1]++"="++"'"++arg2[tempvalue+1]++"'";
- }else {
- sql1=sql1++arg[tempvalue+1]++"="++"null";
- }
- var sql2=" Where "
- tempvalue=0;
- if( from=to ){
- if(arg2[to]!=null){
- sql2=sql2++arg[to]++"="++"'"++arg2[to]++"'";
- }else {
- sql2=sql2++arg[to]++"="++"null";
- }
- }elseif(from<to){
- for(i=from;to-1;1){
- if(arg2[i]!=null){
- sql2=sql2++arg[i]++"="++"'"++arg2[i]++"'"++' and ';
- }else {
- sql2=sql2++arg[i]++"="++"null"++' and ';
- }
- tempvalue=i;
- }
- if(arg2[tempvalue+1]!=null){
- sql2=sql2++arg[tempvalue+1]++"="++"'"++arg2[tempvalue+1]++"'";
- }else {
- sql2=sql2++arg[tempvalue+1]++"="++"null";
- }
- }
- upsql=sql1++sql2;
- this.db.exec(upsql)
- //this.db.close();
- }
-
- query=function(shname,from,to,...){
- var arg2={...};
- sql1="Select * From "++shname;
- var sql2=" Where "
- var tempvalue=0;
- if(from=to){
- if(arg2[to]!=null){
- sql2=sql2++arg[to]++"="++"'"++arg2[to]++"'";
- }else {
- sql2=sql2++arg[to]++"="++"null";
- }
- }elseif(from<to){
- for(i=from;to-1;1){
- if(arg2[i]!=null){
- sql2=sql2++arg[i]++"="++"'"++arg2[i]++"'"++' and ';
- }else {
- sql2=sql2++arg[i]++"="++"null"++' and ';
- }
- tempvalue=i;
- }
- if(arg2[tempvalue+1]!=null){
- sql2=sql2++arg[tempvalue+1]++"="++"'"++arg2[tempvalue+1]++"'";
- }else {
- sql2=sql2++arg[tempvalue+1]++"="++"null";
- }
- }
- upsql=sql1++sql2;
- import console;
- tempvalue=0;
- var temp=arg[1]++"|";
- for(i=2;#arg-1;1){
- temp=temp++arg[i]++"|"
- tempvalue=i;
- }
- temp=temp++arg[tempvalue+1];
- console.log(temp);
- for(rs,fields in this.db.each(upsql,1,3) ){
- tempvalue=0;
- temp=rs(arg[1]).value++"|";
- for(i=2;#arg-1;1){
- if(rs(arg[i]).value!=null){
- temp=temp++rs(arg[i]).value++"|"
- }else {
- temp=temp++"null"++"|"
- }
- tempvalue=i;
- }
- if(rs(arg[tempvalue+1]).value!=null){
- temp=temp++rs(arg[tempvalue+1]).value;
- }else {
- temp=temp++"null";
- }
- console.log(temp);
- }
- //this.db.close();
- }
- }
- var xls = sqlxls("/考试成绩.xls" //第1个参数:文件路径全名;后面参数为字段名
- ,"学号","姓名","性别","班级","语文","数学","英语");
-
- xls.createTable("成绩单");//参数:表名,创建数据表
- xls.add("成绩单","2013001","瑞安","男","2013(01)","86","99","89");//第1个参数:表名;后面参数为字段值
- xls.add("成绩单","2013002","平阳","女","2013(01)","66","68","68");//第1个参数:表名;后面参数为字段值
- xls.add("成绩单","2013003","乐清","女","2013(02)","66","68","68");//第1个参数:表名;后面参数为字段值
- xls.add("成绩单","2013004","永嘉","女","2013(02)","66","68","68");//第1个参数:表名;后面参数为字段值
- xls.add("成绩单","2013005","永嘉","女","2013(02)","68","76","85");//第1个参数:表名;后面参数为字段值
- xls.add("成绩单","2013005","永嘉","男","2013(02)","68","76","85");//第1个参数:表名;后面参数为字段值
- xls.update("成绩单",2,3,"2013001","瑞安","男","2013(02)","2","2","2");//第1个参数:表名;第2个参数:从第几列开始匹配;第3个参数:片配到此列;后面参数为全部字段值
- xls.del("成绩单",4,4,"2013001","瑞安","女","2013(01)");//第1个参数:表名;第2个参数:从第几列开始匹配;第3个参数:片配到此列;后面参数为全部字段值(除第2个和第3个参数指定范围外,其它字段值可以省略)
- xls.query("成绩单",3,4,"2013001","瑞安","女","2013(02)");//第1个参数:表名;第2个参数:从第几列开始匹配;第3个参数:片配到此列;后面参数为全部字段值(除第2个和第3个参数指定范围外,其它字段值可以省略)
-
复制代码 |
评分
-
查看全部评分
|