[問題] 有關資料庫連線的問題

看板Web_Design作者 (fover or ever)時間18年前 (2006/06/24 00:44), 編輯推噓1(102)
留言3則, 3人參與, 最新討論串1/1
我最近在嘗試做資料庫連線,可是不知道發生什麼問題,在此將錯誤訊息貼上,希望各位大大能幫忙解決+ 大大幫忙 type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: Exception in JSP: /showdata.jsp:14 11: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 12: Connection con = DriverManager.getConnection("jdbc:odbc:Member"); 13: Statement smt = con.createStatement(); 14: String name = new String(request.getParameter("Mname")); 15: String sql = "SELECT * FROM Member WHERE MemberName='"+ name +"'"; 16: String color; 17: ResultSet rs = smt.executeQuery(sql); Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) root cause java.lang.NullPointerException java.lang.String.<init>(Unknown Source) org.apache.jsp.showdata_jsp._jspService(showdata_jsp.java:56) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs. -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 218.168.80.131

06/24 01:04, , 1F
request.getParameter("Mname") ←確定有值嗎?
06/24 01:04, 1F

06/24 01:07, , 2F
這是顯示資料網頁 另有一個輸入資料網頁
06/24 01:07, 2F

06/24 01:25, , 3F
一樓的已經告訴你答案了... [茶]
06/24 01:25, 3F
文章代碼(AID): #14d1fSXy (Web_Design)