一个ASP（JScript）简单SQL语句构建“类”

　　<%@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!=undefinedCondition!=){ 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!=undefinedTableName!=){
strTemp = SELECT + Fields.toString() + FROM + TableName;
if(Condition!=undefined){ strTemp += WHERE + Condition;}
if(PkeySort!=undefinedPK!=undefined){ strTemp += ORDER BY + PK + + PkeySort;}
State = true;
}else{
strTemp = getError(0); // 要求输入表名
}
return strTemp;
break;
case 2:
if(TableName!=undefinedTableName!=){
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!=undefinedTableName!=){
&nb