<% statement statement =dbbeanid.getconn().createstatement(); resultset rs = statement.executequery( select * from + tablename); //get column count int columncount =rs.getmetadata().getcolumncount(); //store rows to rowdata while(rs.next()){ out.println(); for(int i =0;i

严重: servlet.service() for servlet jsp threw exception
com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near 'from_buses' at line 1
at sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method)
at sun.reflect.nativeconstructoraccessorimpl.newinstance(unknown source)
at sun.reflect.delegatingconstructoraccessorimpl.newinstance(unknown source)
at java.lang.reflect.constructor.newinstance(unknown source)
at com.mysql.jdbc.util.handlenewinstance(util.java:406)
at com.mysql.jdbc.util.getinstance(util.java:381)
at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:1030)
at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:956)
at com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3515)
at com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3447)
at com.mysql.jdbc.mysqlio.sendcommand(mysqlio.java:1951)
at com.mysql.jdbc.mysqlio.sqlquerydirect(mysqlio.java:2101)
at com.mysql.jdbc.connectionimpl.execsql(connectionimpl.java:2548)
at com.mysql.jdbc.connectionimpl.execsql(connectionimpl.java:2477)
at com.mysql.jdbc.statementimpl.executequery(statementimpl.java:1422)
at org.apache.jsp.browsetable_jsp._jspservice(browsetable_jsp.java:102)
at org.apache.jasper.runtime.httpjspbase.service(httpjspbase.java:70)
at javax.servlet.http.httpservlet.service(httpservlet.java:717)
at org.apache.jasper.servlet.jspservletwrapper.service(jspservletwrapper.java:377)
at org.apache.jasper.servlet.jspservlet.servicejspfile(jspservlet.java:313)
at org.apache.jasper.servlet.jspservlet.service(jspservlet.java:260)
at javax.servlet.http.httpservlet.service(httpservlet.java:717)
at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:290)
at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206)
at org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:233)
at org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:191)
at org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:127)
at org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:102)
at org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:109)
at org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:298)
at org.apache.coyote.http11.http11processor.process(http11processor.java:852)
at org.apache.coyote.http11.http11protocol$http11connectionhandler.process(http11protocol.java:588)
at org.apache.tomcat.util.net.jioendpoint$worker.run(jioendpoint.java:489)
at java.lang.thread.run(unknown source)
回复讨论(解决方案) 似乎是因为from后面少了空格
select * from + tablename);
-----------------------------------
select * from  + tablename);