func.js

培训考试系统代码

/**
 * 判断由字符串from和to代表的两个日期的先后关系．
 * @param from 满足yyyy-MM-dd HH:mm日期格式的字符串
 * @param to 满足yyyy-MM-dd HH:mm日期格式的字符串
 * @return -1 : from > to
 * @return  0 : from = to
 * @return  1 : from < to
 * @return  2 : 无法比较（由于两者至少有一个为空）
 */
function checkDateTime(from ,to)
{
    if(from==""||to=="")return 2;
    var rValue = 0 ;
    for(var i=0 ;i<16 ;i++)
    {
        if(from.charAt(i) < to.charAt(i))
        {
            rValue = 1 ;
            break ;
        }
        else if(from.charAt(i) > to.charAt(i))
        {
            rValue = -1 ;
            break ;
        }
    }
    return rValue ;
}

function checkDate(from ,to)
{
    if(from==""||to=="")return 2;
    var rValue = 0 ;
    for(var i=0 ;i<10 ;i++)
    {
        if(from.charAt(i) < to.charAt(i))
        {
            rValue = 1 ;
            break ;
        }
        else if(from.charAt(i) > to.charAt(i))
        {
            rValue = -1 ;
            break ;
        }
    }
    return rValue ;
}

function strReplace( entry, bad, good )
{
    temp = "" + entry; // temporary holder
    while( temp.indexOf(bad) > -1 )
    {
        pos= temp.indexOf( bad );
        temp = "" + ( temp.substring(0, pos) + good +
                      temp.substring( (pos + bad.length), temp.length) );
    }
    return temp;
}
/**
 * 去除字符串str头尾的空格
 * @param str 字符串
 * @return str去除头尾空格后的字符串。
 */
function trim(str)
{
    if(str == null) return "" ;

    // 去除前面所有的空格
    while( str.charAt(0)  == ' ' )
    {
        str = str.substring(1,str.length);
    }
    // 去除后面的空格
    while( str.charAt(str.length-1)  == ' ' )
    {
        str = str.substring(0,str.length-1);
    }
    return str ;
}
function mySubmit()
{
    searchSQL();
    document.forms[0].submit();
}
function searchSQL()
{
    var eForm     = document.forms[0];

    var iNumElems = eForm.elements.length;
    var selectSQL ="Select distinct ";
    var whereSQL =" Where " ;
    var tableName="";
    if(eForm.tablename==null ||eForm.tablename.value=="")
    {
        alert("您必须有tablename属性");
        return;
    }
    else
    {
        var temp  = eForm.tablename.value.split("~");
        for(var i=0; i<temp.length-1; i++)
        {
            tableName = tableName + temp[i] +" , ";
        }
        tableName = " From " + tableName + temp[temp.length-1];
        //alert(tableName);
    }

    if(eForm.selectcolumn==null ||eForm.selectcolumn.value=="")
    {
        selectSQL += " * " ;
    }
    else
    {
        var temp  = eForm.selectcolumn.value.split("~");
        for(var i=0; i<temp.length-1; i++)
        {
            selectSQL +=  temp[i] +" , ";
        }
        selectSQL += temp[temp.length-1];
       
        //  alert(selectSQL);
    }

    //


    for (var i=0; i<iNumElems; i++)
    {
        var eElem = eForm.elements[i];


           if ("text" == eElem.type || "TEXTAREA" == eElem.tagName||"hidden"==eElem.type)
        {
            var tvalue =trim(eElem.value);
           if(tvalue !="" && eElem.columnName !=null)
            {
                if(eElem.classType=="NUM")
                {
                    if(tvalue.indexOf(">")<0&&tvalue.indexOf("<")<0)
                    {


                        whereSQL += eElem.columnName +" =" +tvalue +" and "
                    }
                    else
                    {
                     whereSQL += eElem.columnName  +tvalue +" and "
                    }
                }
             else if(eElem.classType=="DATE")
            {
                if(eElem.fromcolumnName != null)
                {
                    whereSQL += eElem.fromcolumnName +" >"+"to_date('"
                              +tvalue+"','YYYY-MM-DD hh24:mi:ss') and ";
                }
                else if( eElem.tomcolumnName != null)
                {
                    whereSQL += eElem.tocolumnName +" <"+"to_date('"
                              +tvalue+"','YYYY-MM-DD hh24:mi:ss') and ";

                }
            }
            else
            {
                if(tvalue.indexOf("*")<0)
                {

                    whereSQL += eElem.columnName +" ='" +tvalue +"' and "
                }
                else
                {
                    whereSQL += eElem.columnName +" like '" +
                                strReplace(tvalue, "*", "%" )+"' and "
                }

            }
            // alert( whereSQL);
        }
        }
    else if ("checkbox" == eElem.type || "radio" == eElem.type)
    {
        var tvalue =trim(eElem.value);
        if (eElem.checked)
        {
            if(eElem.classType=="NUM")
            {
                if(tvalue.indexOf(">")<0&&tvalue.indexOf("<")<0)
                {

                    whereSQL += eElem.columnName +" =" +tvalue +" and "
                }
                else
                {
                   whereSQL += eElem.columnName  +tvalue +" and "
                }
            }
            else
            {
                if(tvalue.indexOf("*")<0)
                {

                    whereSQL += eElem.columnName +" ='" +tvalue +"' and "
                }
                else
                {
                    whereSQL += eElem.columnName +" like '" +
                                strReplace(tvalue, "*", "%" )+"' and "
                }
            }
        }
    }
    else if ("SELECT" == eElem.tagName)
    {
        var tvalue =trim(eElem.options[eElem.selectedIndex].value);
        if (tvalue !="")
        {
            if(eElem.classType=="NUM")
            {
                if(tvalue.indexOf(">")<0&&tvalue.indexOf("<")<0)
                {

                    whereSQL += eElem.columnName +" =" +tvalue +" and "
                }
                else
                {
                whereSQL += eElem.columnName  +tvalue +" and "
                }
            }
            else
            {
                if(tvalue.indexOf("*")<0)
                {

                    whereSQL += eElem.columnName +" ='" +tvalue +"' and "
                }
                else
                {
                    whereSQL += eElem.columnName +" like '" +
                                strReplace(tvalue, "*", "%" )+"' and "
                }

            }
            //alert( whereSQL);
        }
    }
}

if(eForm.relation!=null && eForm.relation.value!="")
{
    var temp  = eForm.relation.value.split("~");
    for(var i=0; i<temp.length-1; i++)
    {
        whereSQL +=  temp[i] +" and ";
    }
    whereSQL += temp[temp.length-1];
    //alert("relation:" +whereSQL);
}

if(whereSQL.length -4 ==whereSQL.lastIndexOf("and"))
{
    whereSQL = whereSQL.substring(0,whereSQL.lastIndexOf("and"));
}

   selectSQL  = selectSQL + tableName + whereSQL;
   document.forms[0].searchSQL.value=selectSQL;
}