小程序链接远程mysql_小程序如何通过远程服务器连接本地数据库？使用JDBC

问题描述

报HTTP Status 500

相关代码

// 请把代码文本粘贴到下方(请勿用图片代替代码)

org.apache.jasper.JasperException: An exception occurred processing JSP page /form.jsp at line 15

12: Connection conn = null;

13: Statement st = null;

14:

15: Class.forName("com.mysql.jdbc.Driver;);

16: conn = DriverManager.getConnection(jdbc:mysql://xxxxxxx/xx?user=xxx&password=xxxx);

17: st = conn.createStatement();

18:

Stacktrace:

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:594)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)

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:731)

org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

Root Cause

javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:916)

org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845)

org.apache.jsp.form_jsp._jspService(form_jsp.java:145)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:453)

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:731)

org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

Root Cause

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1928)

org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1771)

org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:126)

org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63)

java.lang.Class.forName0(Native Method)

java.lang.Class.forName(Class.java:264)

org.apache.jsp.form_jsp._jspService(form_jsp.java:98)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:453)

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:731)

org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

你期待的结果是什么？实际看到的错误信息又是什么？

该如何解决？