用JSP连接mysql数据库

 

请教高手怎么用JSP连接mysql数据库 <script type="text/javascript"> </script> <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script> width="110" scrolling="no" height="32" frameborder="0" name="google_ads_frame" src="http://pagead2.googlesyndication.com/cpa/ads?client=ca-pub-7152686823194984&cpa_choice=CAAQleSfnAIaCLEYkAnqpyd8KOWkwXU&oe=x-gbk&dt=1167917273968&lmt=1167917273&format=110x32_as_rimg&output=html&url=http%3A%2F%2Fwww.china1024.com%2Fnews_content.jsp%3Fnews_id%3D593&region=_google_cpa_region_&ref=http%3A%2F%2Fwww.google.com%2Fsearch%3Fq%3D%2520The%2520server%2520encountered%2520an%2520internal%2520error%2520%28%29%2520that%2520prevented%2520it%2520from%2520fulfilling%2520this%2520request.%26hl%3Dzh-CN%26lr%3D%26nxpt%3D20.845128700058805917072&cc=100&u_h=768&u_w=1024&u_ah=738&u_aw=1024&u_cd=32&u_tz=480&u_his=1&u_java=true&u_nplug=15&u_nmime=57" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true"> 发布作者：jackie

我下载了本站的留言本1.0，可是在连接数据库时总是不成功，（我用的是tomcat5.5.9,MySQL Server 5.0,jdk1.5.0_06,这三个确定都可以正常使用）运行的时候显示 type Exception report message  description The server encountered an internal error () that prevented it from fulfilling this request. exception  org.apache.jasper.JasperException: /ly.jsp(34,0) The value for the useBean class attribute wu.jdbc is invalid. org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:39) org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:405) org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:146) org.apache.jasper.compiler.Generator$GenerateVisitor.visit(Generator.java:1223) org.apache.jasper.compiler.Node$UseBean.accept(Node.java:1116) org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2163) org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2213) org.apache.jasper.compiler.Node$Visitor.visit(Node.java:2219) org.apache.jasper.compiler.Node$Root.accept(Node.java:456) org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2163) org.apache.jasper.compiler.Generator.generate(Generator.java:3270) org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:189) org.apache.jasper.compiler.Compiler.compile(Compiler.java:286) org.apache.jasper.compiler.Compiler.compile(Compiler.java:267) org.apache.jasper.compiler.Compiler.compile(Compiler.java:255) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:556) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:293) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) 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.9 logs.

日期：2005-12-05

<script type="text/javascript"> </script> <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script> width="728" scrolling="no" height="90" frameborder="0" name="google_ads_frame" src="http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-7152686823194984&dt=1167917274015&lmt=1167917273&format=728x90_as&output=html&url=http%3A%2F%2Fwww.china1024.com%2Fnews_content.jsp%3Fnews_id%3D593&ad_type=text&ref=http%3A%2F%2Fwww.google.com%2Fsearch%3Fq%3D%2520The%2520server%2520encountered%2520an%2520internal%2520error%2520%28%29%2520that%2520prevented%2520it%2520from%2520fulfilling%2520this%2520request.%26hl%3Dzh-CN%26lr%3D%26nxpt%3D20.845128700058805917072&cc=64&u_h=768&u_w=1024&u_ah=738&u_aw=1024&u_cd=32&u_tz=480&u_his=1&u_java=true&u_nplug=15&u_nmime=57" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true">

→网友评论：

(站长    2005-12-05)

useBean class attribute wu.jdbc is invalid.  可能是你的类没有放在正确的地方吧？ 你编译jdbc.java成jdbc.class 然后把他放到web-inf/class下面了吗？

(jackie    2005-12-05)

编译是编译了，可是里面的数据库IP不知道怎么设置 到底是放在web-inf/class下面还是web-inf/class/wu下面

(站长    2005-12-06)

IP地址就是你装数据库的机器的ip地址 应该是放在web-inf/class/wu下面的

(jackie    2005-12-06)

type Exception report message  description The server encountered an internal error () that prevented it from fulfilling this request. exception  org.apache.jasper.JasperException org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:370) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) root cause  java.lang.NullPointerException org.apache.jsp.ly_jsp._jspService(org.apache.jsp.ly_jsp:90) 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:322) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) 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.9 logs. -------------------------------------------------------------------------------- 这又是怎么回事啊

还是数据库连接失败的 (站长    2005-12-06)

在tomcat后台不知道报什么错误？ 比如是没有jdbc驱动 数据库用户密码不对？ 或者表不存在这些错误

(jackie    2005-12-06)

晕啊，jdbc驱动都下了啊，环境变量也设定了，数据库用户名和密码肯定没有错的，今天运行又有了这个错误，再帮我看一下吧 HTTP Status 500 -  -------------------------------------------------------------------------------- type Exception report message  description The server encountered an internal error () that prevented it from fulfilling this request. exception  javax.servlet.ServletException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream ** BEGIN NESTED EXCEPTION **  java.io.IOException MESSAGE: Unexpected end of input stream STACKTRACE: java.io.IOException: Unexpected end of input stream at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1096) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:626) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562) at com.mysql.jdbc.Connection.<init>(Connection.java:491) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.apache.jsp._06_005f03_jsp._jspService(org.apache.jsp._06_005f03_jsp:65) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) ** END NESTED EXCEPTION ** org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781) org.apache.jsp._06_005f03_jsp._jspService(org.apache.jsp._06_005f03_jsp:100) 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:322) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) root cause  java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream ** BEGIN NESTED EXCEPTION **  java.io.IOException MESSAGE: Unexpected end of input stream STACKTRACE: java.io.IOException: Unexpected end of input stream at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1096) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:626) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562) at com.mysql.jdbc.Connection.<init>(Connection.java:491) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.apache.jsp._06_005f03_jsp._jspService(org.apache.jsp._06_005f03_jsp:65) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) ** END NESTED EXCEPTION ** com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:699) com.mysql.jdbc.Connection.createNewIO(Connection.java:1562) com.mysql.jdbc.Connection.<init>(Connection.java:491) com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346) java.sql.DriverManager.getConnection(DriverManager.java:525) java.sql.DriverManager.getConnection(DriverManager.java:171) org.apache.jsp._06_005f03_jsp._jspService(org.apache.jsp._06_005f03_jsp:65) 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:322) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) 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.9 logs.

还是得到数据库连接的错误 (站长    2005-12-07)

是有防火墙吗？ 或者是mysql让没有让该用户在其他ip访问的权限？ 能看出来是mysql jdbc驱动获取getConnection（）报出来的错误

我估计是你机器的防火墙的问题吧？ (站长    2005-12-07)