一个ASP(JScript)简单SQL语句构建“类”,同时支持客户端和服务器端执行的

类别:Asp 点击:0 评论:0 推荐:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<%
var QuestStringBuilder = function(){
    // 1->查询语句, 2->更新语句, 3->删除语句, 4->插入语句
    var QuestType = 0;
    var Fields = [];
    var Values = [];
    var Condition;
    var PK;
    var PkeySort;
    var TableName;
    var State = false;
    var CLogic = " AND ";
    var COperator = "=";
    this.addField = function(Field,Value){
        Fields.push(processField(Field));
        Values.push(processValue(Value));
    };
    this.addCField = function(CField,CValue){
        var sTemp = [];
        if(Condition!=undefined&&Condition!=""){ sTemp.push(Condition); }
        if(COperator!="LIKE"){
            sTemp.push(processField(CField)+COperator+processValue(CValue));
        }else{
            sTemp.push(processField(CField)+" LIKE '%"+CValue+"%'");            
        }
        Condition = sTemp.join(CLogic);
        if(Condition==""){ Condition=sTemp.toString();}
    };
    this.Table = function(s){TableName = s;};
    this.PKey = function(s){PK = processField(s);};
    this.PKeyAsc = function(){PkeySort="ASC";};
    this.PKeyDesc = function(){PkeySort="DESC";};
    this.getSelect = function(){
        QuestType = 1;
        return result();
    };
    this.getUpdate = function(){
        QuestType = 2;
        return result();
    };
    this.getDelete = function(){
        QuestType = 3;
        return result();
    };
    this.getInsert = function(){
        QuestType = 4;
        return result();
    };
    this.clear = function(){
        Fields = [];
        Values = [];
        PK = undefined;
        PkeySort = undefined;
        TableName = undefined;
        State = false;
    };
    this.ActionState = function(){ return State;};
    this.ChangeLogic = function(s){ CLogic = " "+s.toUpperCase()+" ";};
    this.ChangeOperator = function(s){COperator = s.toUpperCase();};
    var result = function(){
        var strTemp;
        if(Fields.length==0) Fields.push("*");
        switch(QuestType){
            case 1:
                if(TableName!=undefined&&TableName!=""){
                    strTemp = "SELECT " + Fields.toString() + " FROM " + TableName;
                    if(Condition!=undefined){ strTemp += " WHERE " + Condition;}
                    if(PkeySort!=undefined&&PK!=undefined){ strTemp += " ORDER BY " + PK + " " + PkeySort;}
                    State = true;
                }else{
                    strTemp = getError(0); // 要求输入表名
                }
                return strTemp;
                break;
            case 2:
                if(TableName!=undefined&&TableName!=""){
                    strTemp = "UPDATE " + TableName + " SET " + process(Fields,Values) ;
                    if(Condition!=undefined){
                        State = true;
                        strTemp += " WHERE " + Condition;
                    }else{
                        strTemp = getError(1);
                    }
                }else{
                    strTemp = getError(0); // 要求输入表名
                }                
                return strTemp;
                break;
            case 3:
                if(TableName!=undefined&&TableName!=""){
                    strTemp = "DELETE FROM " + TableName ;
                    if(Condition!=undefined){
                        State = true;
                        strTemp += " WHERE " + Condition;
                    }else{
                        strTemp = getError(1);
                    }
                }else{
                    strTemp = getError(0); // 要求输入表名
                }                
                return strTemp;
                break;
            case 4:
                if(TableName!=undefined&&TableName!=""){
                    strTemp = "INSERT INTO " + TableName ;
                    if(Fields.length!=0){
                        State = true;
                        strTemp += "(" + Fields.toString() + ") VALUES(" + Values.toString() + ")";
                    }else{
                        strTemp = getError(2);
                    }
                }else{
                    strTemp = getError(0); // 要求输入表名
                }                
                return strTemp;
                break;
        }
    };
    var processValue = function(unknow){
        var inputType = typeof(unknow);
        switch(inputType){
            case "string":
                return "'"+unknow+"'";
                break;
            case "number":
                return unknow;
                break;
            case "boolean":
                return unknow;
                break;
        }
    };
    var processField = function(unknow){
        return "["+unknow+"]";
    };
    var process = function(aField,aValue){
        var aTemp = [];
        for(i=0;i<aField.length;i++){
            aTemp.push(aField[i]+"="+aValue[i]);
        }
        return aTemp.toString();
    }
    var getError = function(intError){
        if(typeof(intError)=="number"){
            switch(intError){
                case 0:
                    State = false;
                    return "Need Quest TableName, Please using method Table input one TableName!";
                    break;
                case 1:
                    State = false;
                    return "Need One Condition! Please using method addCField add Condition!";
                    break;
                case 2:
                    State = false;
                    return "Need Insert values!";
                    break;
            }
        }
    };
};
var sql = new QuestStringBuilder();
sql.Table("MyTable");
sql.addField("Test","1");
sql.addField("test1",23);
sql.addCField("id",93);
sql.PKey("id");
sql.PKeyDesc();
//sql.clear();
Response.Write(sql.getDelete()+"<br>"+sql.ActionState());
%>

刚刚写完的,因为刚做了一个asp.net的项目(使用Access数据库),做了一个简单的SQL语句构建类,所以也写了个asp版的。它看上去对多表查询支持不是很好,但只要把表名换成视图名,就可以达到较好的效果。没有怎么写注释,麻烦大家自己看看了,或有兴趣的,可以改进一下。

本文地址:http://com.8s8s.com/it/it7616.htm