作者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