自己编写的登陆页面，数据库验证出错

13277068981

自己写了一个登陆验证页面，用户名用数字，登陆验证正常，当登陆名为字母或中文的时候出现如下图的报错
Model.prototype.logoBtnClick = function(event) {
                var name = this.comp("username").val();
                var pass = this.comp("password").val();
                var userdata = this.comp("userData");
                               
                if ($.trim(this.comp('username').val()) === "" || $.trim(this.comp('password').val()) === "") {
                        this.comp("messageDialog").show({
                                "title" : "温馨提示",
                                "message" : "忘记输入用户名或密码?"
                        });
                }else{
                 userdata.setFilter("userFilter", 'username ='+name);
                 userdata.refreshData();         
                    if(userdata.count()>0){
                       var p = userdata.val("password");
                       justep.Util.hint(p);
                       if(p == pass){
                           justep.Util.hint(userdata.val("username"));
                       }else{                    


报错如下：     


八月 10, 2017 2:15:55 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet WeX5_Baas_Servlet threw exception
com.justep.baas.action.ActionException: Action[wgtest/wguser/queryWguser]执行失败，SQL执行失败，SQL:SELECT * FROM wguser WHERE ((username = weigang ) )  LIMIT 0,20
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)

liangyongfei

1.   userdata.setFilter("userFilter","username ='"+name+"'");

复制代码

过滤  条件需要用单引号引住才行！

13277068981

非常感谢大神的帮助，确如大神所说。