【HELP】MySQL连接一般,java测试中正常,移植至JSP中却出错
【HELP】MySQL连接正常,java测试中正常,移植至JSP中却出错
java里主函数测试正常
贴上报错信息:
求解为什么这样。。。
------解决思路----------------------
把这段代码直接放在main方法里执行还报错?
------解决思路----------------------
ResultSet results = db.query(text);
text参数未获得数据。。。。
java里主函数测试正常
//在主函数中测试正常,可以输出结果
public static void main(String args[]){
DBHelper db = new DBHelper();
ResultSet results = db.query("你");
//shouwResults方法为循环输出含有查询结果的ResultSet对象
db.showResults(results);
}
贴上报错信息:
org.apache.jasper.JasperException: An exception occurred processing JSP page /result.jsp at line 17
14: <%
15:
16: DBHelper db = new DBHelper();
17: ResultSet results = db.query(text);
18: try{
19: java.sql.ResultSetMetaData rsmd = results.getMetaData();
20: int j = rsmd.getColumnCount();
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause
java.lang.NullPointerException
DAO.DBHelper.query(DBHelper.java:51)
org.apache.jsp.result_jsp._jspService(result_jsp.java:86)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
求解为什么这样。。。
------解决思路----------------------
把这段代码直接放在main方法里执行还报错?
------解决思路----------------------
ResultSet results = db.query(text);
text参数未获得数据。。。。