Jsp link the mysql Call me java mysql written procedures wrote jsp consumption has been a problem, however, let us look back to how things (using the x and tomcat) : [code] "%Page contentType=" text/html;charset=gb2312' "%>; "%Page import=" java.sql.* "%>; "Html>; "Body>; <% Class.forName ( "com.mysql.jdbc.Driver"). NewInstance (); String url= "jdbc:mysql://localhost:3306/db1"; Connection conn= DriverManager.getConnection (government payments are capped, "cowboy", "123"); Statement stmt=conn.createStatement (); String query= "select user_id from user"; ResultSet rs=stmt.executeQuery (query); While (rs.next ()) { String s=rs.getString ( "1"); Out.print (s+ "" br>; "); } %>; "/body>; "/html>; [/code] Being given to Exception Org.apache.jasper.JasperException : org/aspectj/lang/Signature At org.apache.jasper.servlet.JspServletWrapper.service (JspServletWrapper.java:254) At org.apache.jasper.servlet.JspServlet.serviceJspFile (JspServlet.java:295) At org.apache.jasper.servlet.JspServlet.service (JspServlet.java:241) At javax.servlet.http.HttpServlet.service (HttpServlet.java:853) At org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:247) At org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:193) At org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:256) At org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:643) At org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) At org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) At org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:191) At org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:643) At org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) At org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) At org.apache.catalina.core.StandardContext.invoke (StandardContext.java:2415) At org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:180) At org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:643) At org.apache.catalina.valves.ErrorDispatcherValve.invoke (ErrorDispatcherValve.java:171) At org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:641) At org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172) At org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:641) At org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) At org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) At org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:174) At org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:643) At org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) At org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) At org.apache.catalina.connector.warp.WarpRequestHandler.handle (Unknown Source) At org.apache.catalina.connector.warp.WarpConnection.run (Unknown Source) At java.lang.Thread.run (Thread.java:536) Root cause Javax.servlet.ServletException : org/aspectj/lang/Signature At org.apache.jasper.runtime.PageContextImpl.handlePageException (PageContextImpl.java:536) At org.apache.jsp.testmysql_jsp._jspService (testmysql_jsp.java:66) At org.apache.jasper.runtime.HttpJspBase.service (HttpJspBase.java:137) At javax.servlet.http.HttpServlet.service (HttpServlet.java:853) At org.apache.jasper.servlet.JspServletWrapper.service (JspServletWrapper.java:210) At org.apache.jasper.servlet.JspServlet.serviceJspFile (JspServlet.java:295) At org.apache.jasper.servlet.JspServlet.service (JspServlet.java:241) At javax.servlet.http.HttpServlet.service (HttpServlet.java:853) At org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:247) At org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:193) At org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:256) At org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:643) At org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) At org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) At org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:191) At org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:643) At org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) At org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) At org.apache.catalina.core.StandardContext.invoke (StandardContext.java:2415) At org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:180) At org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:643) At org.apache.catalina.valves.ErrorDispatcherValve.invoke (ErrorDispatcherValve.java:171) At org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:641) At org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172) At org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:641) At org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) At org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) At org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:174) At org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:643) At org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) At org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) At org.apache.catalina.connector.warp.WarpRequestHandler.handle (Unknown Source) At org.apache.catalina.connector.warp.WarpConnection.run (Unknown Source) At java.lang.Thread.run (Thread.java:536) I saw the inside tomcat/work inside testmysql_jsp.java wrong behavior : [code]if (PageContext> null) pageContext.handlePageException (t) ;[/code] Let us take a look at how to solve, thank [/quote]-->--> Jsp link the mysql Your landlord { String s=rs.getString ( "1"); Out.print (s+ "" br>; "); } Rs.getString ( "1") It is not to be Rs.getString (1); This is not the one you refer to a database of this field !!!!! Jsp link the mysql Haha, I seem to have the wrong Fan all the time. [ Closed window ]