[問題] 有關資料庫連線的問題
我最近在嘗試做資料庫連線,可是不知道發生什麼問題,在此將錯誤訊息貼上,希望各位大大能幫忙解決+
大大幫忙
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
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