<%@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=0i<aField.lengthi++){
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())
%>
结合函数命名、js代码逻辑：
validate_required 函数，验证一个字段是否为空
validate_form 函数，验证一个表单
field、alerttxt 、thisform 这些都是参数名称，没有特指（因为js中变量是弱类型的），需要结合上下文才知道
field 表示一个值，field 域的意思，
alerttxt 提示文本
function validate_required(field,alerttxt){
with (field) // 判断 field 对象是否存在
{
if (value==null||value=="") // 判断field 是否为空，
{
// field 为空，打印出提示文本alerttxt
alert(alerttxt)
return false // 返回false，表示验证失败
}
else {
// field 不为空，表示验证成功
return true
}
}
}
thisform，一个参数，根据名称，应该是传入了一个form，即表单
with (thisform) // 判断 thisform 对象是否存在{
// thisform 存在
// 存在，调用validate_required方法，验证email对象，验证失败打印"Email must be filled out!"
if (validate_required(email,"Email must be filled out!")==false)
{email.focus()return false}
通过你的提问，应该还是初学者，js的语法还不熟悉，并且使用不够熟练，应该多多练习！
