sqltranslator.js

ajax.net,一个应用AJAX.NET框架的例子

var mw = {util: {}};

mw.util.SqlTranslator = function()
{
    var me = this;
    
    me.translateToXPath = function(p_sqlString, p_outArguments)
    {
        var match = p_sqlString.match(/select \* from (\S{1,})((\swhere\s(.{1,}))|)/i);
        var tableName = match[1];
        var filter = match[4];
        var xpath = tableName;
        if (filter)
        {
            xpath += "[";
            xpath += filter;
            xpath += "]";
        }
        else
        {
            xpath =  tableName;
        }
        if (p_outArguments)
        {
            p_outArguments.tableName = tableName;
            p_outArguments.xpath = xpath;
        }
        return xpath;
    }
    
    return me;
}