程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> .NET網頁編程 >> ASP.NET >> 關於ASP.NET >> .net 通過後台js上傳表數據

.net 通過後台js上傳表數據

編輯:關於ASP.NET

     Upload.aspx:

    <%@ LANGUAGE='JAVASCRIPT' %>
    <!-- #include file = "../adojvs.inc"-->
    <!-- #include file = "../conn.inc"-->
    <%

    // 執行SQL語句
    //2012-12-6 Gu Laicheng
    function RunSQL(MySQL)
    {
    var ret="";

    var rs1 = Server.CreateObject("ADODB.Recordset");
    rs1.CursorType = adOpenKeyset;
    rs1.LockType = adLockBatchOptimistic;

    // Response.Write("<br/>" + MySQL + "");
    try {
    rs1.Open(MySQL,conn);
    }
    catch (ex) {
    var ErrStr,ErrStr0,ErrStr1="==>"+new Date()+"<br/>";
    ErrStr0 = "Error:"+ex+"<br/>"+MySQL;
    var o = conn.Errors;
    for (var i=0;i<o.Count;i++)
    {
    ErrStr1 += o.Item(i).Number + ":" + o.Item(i).Description+", "+o.Item(i).SQLState+";"+o.Item(i).Source ;
    }
    ErrStr =ErrStr0+"<br/>"+ErrStr1;

    o.Clear();
    Response.Write("<br/>" + ErrStr + "");
    }

    if(rs1.State==1)
    {
    if (!(rs1.BOF && rs1.EOF))
    {
    ret = rs1(0).value;
    }
    rs1.Close();
    }
    return ret;
    }

    var Class = {
    create: function() {
    return function(n) {
    this.initialize.apply(this, arguments);
    }
    }
    }

    var TABLE = Class.create();

    TABLE.prototype = {
    initialize:function(TabName){
    this.TabName = TabName;
    this.Fields=[];
    this.FieldCount = 0;
    this.values=[];
    this.types=[];
    this.MySQL="";
    this.flag;
    },
    F:function(s)
    {
    var a=s.split(",");
    for(var i=1;i<a.length;i++)
    {
    this.Fields[i-1]=a[i];
    }
    this.FieldCount = a.length-1;
    },
    V:function(s)
    {
    var a=s.split(",");
    this.flag=a[0];
    for(var i=1;i<a.length;i++)
    {
    this.values[i-1]=a[i];
    }
    if(a[0]==1) this.Replace();
    if(a[0]==2) this.Insert();
    if(a[0]==3) this.Update();
    if(a[0]==4) this.Delete();
    },
    Replace:function()
    {
    if(this.values[0]==0)
    this.Insert();
    else
    this.Update();
    },
    Insert:function()
    {
    var fs="",vs="";
    var j=0; //i,j可能並不同步,有些列值可能為空,表示不插入其值,要保證sql的語法正確
    for(var i=0;i<this.FieldCount;i++)
    {
    if(this.values[i] == "NULL") continue;
    if(j == 0)
    {
    fs += this.Fields[i];
    vs += "'"+this.values[i]+"'";
    } else
    {
    fs += ","+this.Fields[i];
    vs += ",'"+this.values[i]+"'";
    }
    j++;
    }
    this.MySQL="insert into "+this.TabName+" ("+fs+") values ("+vs+")";
    },
    Update:function()
    {
    this.MySQL="update "+this.TabName+" set ";
    for(var i=1;i<this.FieldCount;i++)
    {
    if(this.values[i] == "NULL")
    {
    if(i != 1) this.MySQL += ",";
    this.MySQL += this.Fields[i]+"=null ";
    } else
    {
    if(i != 1) this.MySQL += ",";
    this.MySQL += this.Fields[i]+"='"+this.values[i]+"'";
    }
    }
    this.MySQL += " where "+this.Fields[0]+"='"+this.values[0]+"'";
    },
    Delete:function()
    {
    this.MySQL="delete from "+this.TabName+" where ";
    var j=0; //i,j可能並不同步,有些列值可能為空,表示不以其為條件,要保證sql的語法正確
    for(var i=0;i<this.FieldCount;i++)
    {
    if(this.values[i]=="") continue;
    if(this.values[i] == "NULL")
    {
    if(j != 0) this.MySQL += " and ";
    this.MySQL += this.Fields[i]+" is null ";
    } else
    {
    if(j != 0) this.MySQL += " and ";
    this.MySQL += this.Fields[i]+"='"+this.values[i]+"'";
    }
    j++;
    }
    }
    };

     


    var fso, ts, s;
    var ForReading = 1, ForWriting = 2;

    var name;// = "c:webyafulwisadtt.csv";
    name = Server.MapPath("t.csv");
    var fso = new ActiveXObject("Scripting.FileSystemObject");
    if (fso.FileExists(name))
    {
    Response.Write(" 文件 "+name+" 存在!");
    ts = fso.OpenTextFile(name, ForReading, true);
    // ts.SkipLine();

    var data=new TABLE(Request.QueryString("a")+"");

    s = ts.ReadLine();
    data.F(s);
    Response.Write("<br/>"+data.FieldCount);
    Response.Write("<br/>" + s.replace(/,/g,"t") + "");
    Response.Write("<br/>" + data.Fields + "");

    while (!ts.AtEndOfStream)
    {
    s = ts.ReadLine();
    // Response.Write("<br/>" + s.replace(/,/g,"t") + "");
    data.V(s);
    Response.Write("<br/>" + data.MySQL + "");
    RunSQL(data.MySQL);
    }
    ts.Close();
    }
    else
    {
    Response.Write(" 文件 "+name+" 不存在,請核對後查詢!");
    }
    %>

    1. 上一頁:
    2. 下一頁:
    Copyright © 程式師世界 All Rights Reserved