[問題] jsp網頁問題

看板Web_Design作者 (哈哈!~~靖)時間17年前 (2009/03/15 17:59), 編輯推噓3(305)
留言8則, 4人參與, 最新討論串1/1
現在是在登入管理頁面 打入帳密之後 出現了錯誤 org.apache.jasper.JasperException: An exception occurred processing JSP page /test/Untitled-1.jsp at line 29 26: if (!MM_fldUserAuthorization.equals("")) MM_pSQL += "," + MM_fldUserAuthorization; 27: MM_pSQL += " FROM two.two WHERE admin-name=\'" + MM_valUsername.replace('\'', ' ') + "\' AND admin-pass=\'" + request.getParameter("textfield2").toString().replace('\'', ' ') + "\'"; 28: PreparedStatement MM_statementUser = MM_connUser.prepareStatement(MM_pSQL); 29: ResultSet MM_rsUser = MM_statementUser.executeQuery(); 30: boolean MM_rsUser_isNotEmpty = MM_rsUser.next(); 31: if (MM_rsUser_isNotEmpty) { 32: // username and password match - this is a valid user Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 我一直找不出來是哪裡錯 我是用Dreamwear8 寫jsp 網頁連資料庫 現在在登入管理 卡住了 有誰可以幫我 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 124.11.230.99

03/15 18:38, , 1F
你PreparedStatement的用法錯了 去看看API吧
03/15 18:38, 1F

03/15 21:09, , 2F
我不太懂@@
03/15 21:09, 2F

03/15 23:12, , 3F
貼的好亂 不知道從哪裡看起...
03/15 23:12, 3F

03/16 20:35, , 4F
0如果是拆成三行來寫咧?
03/16 20:35, 4F

03/16 20:35, , 5F
PreparedStatement MM_statementUser;
03/16 20:35, 5F

03/16 20:36, , 6F
MM_statementUser =
03/16 20:36, 6F

03/16 20:36, , 7F
MM_connUser.prepareStatement(MM_pSQL);
03/16 20:36, 7F

03/16 20:36, , 8F
ResultSet MM_rsUser = MM_statementUser.executeQuery();
03/16 20:36, 8F
文章代碼(AID): #19lD5-lJ (Web_Design)