作者hill9 (fover or ever)
看板Web_Design
標題[問題] 有關資料庫連線的問題
時間Sat Jun 24 00:47:30 2006
我最近在嘗試做資料庫連線，可是不知道發生什麼問題，在此將錯誤訊息貼上，希望各位大大能幫忙解決+
大大幫忙
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
1F：→ ckw:request.getParameter("Mname") ←確定有值嗎? 06/24 01:04
2F：→ hill9:這是顯示資料網頁 另有一個輸入資料網頁 06/24 01:07
3F：推 PsMonkey:一樓的已經告訴你答案了... [茶] 06/24 01:25