网页资讯视频图片知道文库贴吧地图采购
进入贴吧全吧搜索
java吧 关注：1,193,819贴子：12,612,622
  • 20回复贴，共1页

我的myeclipse连接不上数据库了

只看楼主收藏回复

谁来帮帮忙啊，可花钱，头要炸了
IP属地:山西来自Android客户端1楼2018-01-19 16:20回复
    要么就是驱动有问题，要么就是用户名密码有问题，再看看报错信息，你这什么都没有怎么解决？
    IP属地:湖北2楼2018-01-19 16:33
    收起回复
      跟myeclipse没关系啊
      IP属地:广东来自iPhone客户端3楼2018-01-19 16:34
      回复
        年轻人，不要急躁
        IP属地:陕西来自Android客户端4楼2018-01-19 16:34
        回复
          有人加我QQ458790265帮忙解决一下嘛，class.forname一直报错
          IP属地:山西来自手机贴吧5楼2018-01-19 16:37
          回复
            有人加我QQ458790265帮忙解决一下嘛，class.forname一直报错
            IP属地:山西来自手机贴吧6楼2018-01-19 16:37
            回复
              你把问题贴出来，大家帮你找。
              IP属地:广东7楼2018-01-19 16:38
              收起回复
                <%@ page contentType="text/html;charset=UTF-8" language="java" %>
                <%@ page import="java.sql.*"%>
                <html>
                <head>
                <meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
                <title>JSP访问数据库</title>
                </head>
                <body>
                <h3>从数据库读取职工表:</h3>
                <hr>
                <table border="1">
                <tr><td>sus</td><td>姓名</td><td>性别</td></tr>
                <%
                String driverName="com.mysql.jdbc.Driver";
                String userName="root";
                String userPassword="950826";
                String dbName="student";
                String tableName="sense";
                String url="jdbc:mysql://localhost:3306/"+dbName+"?characterEncoding=utf-8";
                String sql="select * from "+tableName;
                Class.forName(driverName);
                Connection con=DriverManager.getConnection(url,userName,userPassword);
                Statement s=con.createStatement();
                ResultSet rst=s.executeQuery(sql);
                while(rst.next())
                {
                out.println("<tr>");
                out.println("<td>"+rst.getString("susheid")+"</td>");
                out.println("<td>"+rst.getString("name")+"</td>");
                out.println("<td>"+rst.getString("chuangid")+"</td>");
                out.println("</tr>");
                }
                out.println("</table>");
                rst.close();
                %>
                </body>
                </html>
                这是我的代码
                IP属地:山西8楼2018-01-19 16:43
                回复
                  HTTP Status 500 - An exception occurred processing JSP page /qinshi.jsp at line 22
                  type Exception report
                  message An exception occurred processing JSP page /qinshi.jsp at line 22
                  description The server encountered an internal error that prevented it from fulfilling this request.
                  exception
                  org.apache.jasper.JasperException: An exception occurred processing JSP page /qinshi.jsp at line 2219: String url="jdbc:mysql://localhost:3306/"+dbName+"?characterEncoding=utf-8";20: String sql="select * from "+tableName;21: 22: Class.forName(driverName);23: Connection con=DriverManager.getConnection(url,userName,userPassword);24: Statement s=con.createStatement();25: ResultSet rst=s.executeQuery(sql);Stacktrace:org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)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
                  javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driverorg.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:916)org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845)org.apache.jsp.qinshi_jsp._jspService(qinshi_jsp.java:116)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)
                  root cause
                  java.lang.ClassNotFoundException: com.mysql.jdbc.Driverorg.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720)org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571)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.qinshi_jsp._jspService(qinshi_jsp.java:85)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)
                  note The full stack trace of the root cause is available in the Apache Tomcat/7.0.56 logs.
                  这是报错500
                  IP属地:山西9楼2018-01-19 16:44
                  回复
                    没找到这个包com.mysql.jdbc.Driver
                    IP属地:广东10楼2018-01-19 16:54
                    收起回复
                      Class.forName() java可以这么用，jsp不能啊。
                      老老实实import
                      ,然后在jsp页面里追加import
                      IP属地:上海11楼2018-01-19 17:29
                      回复
                        你为啥喜欢把java代码都写在jsp里面？（虽然可以写，但是有什么好处？）
                        IP属地:浙江来自Android客户端12楼2018-01-20 12:12
                        回复
                          不知道你为啥把代码一定写在jsp页面里边
                          IP属地:湖南来自Android客户端13楼2018-01-20 14:23
                          回复
                            楼上很有道理 代码就别放这么多jsp里了 看着难受
                            IP属地:浙江来自Android客户端14楼2018-01-20 19:54
                            回复
                              看着好难受的代码。
                              IP属地:广东15楼2018-02-01 11:16
                              回复

                                扫二维码下载贴吧客户端

                                下载贴吧APP
                                看高清直播、视频！
                                • 20回复贴，共1页
                                发表回复
                                发贴请遵守贴吧协议及“七条底线”贴吧投诉
                                内  容:
                                  查看全部
                                发 表
                                保存至快速回贴