ASP(JScript)构建SQL语句“类”
来源:CSDN 时间:2008-04-30 07:12:00
实现功能QuestType 1->查询语句, 2->更新语句, 3->删除语句, 4->插入语句
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<%
var QuestStringBuilder = function(){
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());
%>
标签:类,sql,asp
0
投稿
猜你喜欢
ASP同一站点下gb2312和utf-8页面传递参数乱码的终极解决方法
2011-02-20 11:00:00
将ASP记录集输出成n列的表格形式显示的方法
2011-04-08 10:51:00
SQL语句删除2条重复数据一条保留一条
2012-07-11 15:51:44
asp的command对象的使用
2008-06-23 13:03:00
推荐给大家看的设计书
2009-02-23 12:17:00
如何使用数据绑定控件实现不换页提交数据?
2010-05-16 15:17:00
空行不空格式排版组织原理
2010-05-03 14:46:00
如何做一个文本书写器?
2010-07-12 18:58:00
CSS nuggets CSS金矿
2009-10-28 18:59:00
FrontPage XP设计教程3——网页的布局
2008-10-11 12:20:00
常见系统中文字体的英文名
2008-03-03 12:44:00
图像替换新技术:状态域方法[译]
2009-08-06 16:41:00
网站数据库,是选SQL Server还是Access好
2008-05-23 13:19:00
解密SQL Server数据库系统的编译
2009-03-16 17:33:00
ASP编写计数器的优化方法
2009-01-21 19:46:00
Mysql入门系列:MYSQL日志文件维护
2008-11-24 13:10:00
SQL Server 2005中数据库镜像的四个问题
2009-02-19 16:48:00
从trim原型函数看js正则表达式的性能
2008-12-11 13:55:00
分享我们的select控件设计过程
2009-06-16 18:04:00
asp,php 和 jsp 比较 之我见
2007-08-10 13:35:00