你得把出错信息打出来呀!不然如何看?
ResultSet rs=stmt.executeQuery("select *"+"from student");
"select *"+"from student" ->"select * from student"
ResultSet rs=stmt.executeQuery("select *"+"from student");
"select *"+"from student" ->"select * from student"
解决方案 »
- 如何取消IE"确认允许此网页访问剪贴板吗"
- 在java里使用mkdir新建文件夹的问题
- 深夜求助,请大家帮忙
- <iframe src="...">中取地址的问题
- 一个数据库问题,一个背包问题,一个javascript问题!!!帮忙解决下啊!!(急)
- 请教高手一个监听的问题?
- 求助,ibatis动态表及参数传入问题,在线等
- 百分求jsp网站源码
- java.sql.SQLSyntaxErrorException: ORA-00904: "ANNUUNCEMENNID": 标识符无效
- 怎么用sql server for jdbc的驱动?
- 各位大侠,今天一定要帮我这个忙,在线等,!!!!!给高分!!
- 使用jfreechart生成图片的中文问题!!!!!急!!!!急!!!!急!!!!(送100分)
at org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:94)
at org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:428)
at org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:170)
at org.apache.jasper.compiler.Parser.parseDirective(Parser.java:388)
at org.apache.jasper.compiler.Parser.parseElements(Parser.java:795)
at org.apache.jasper.compiler.Parser.parse(Parser.java:122)
at org.apache.jasper.compiler.ParserController.parse(ParserController.java:199)
at org.apache.jasper.compiler.ParserController.parse(ParserController.java:153)
at org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:227)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:369)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:473)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:190)
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:2422)
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:163)
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.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用JSP访问数据库</title></head>
<body>
<%@ page language="java"
import="java.sql.*"
import ="java.util.*"
import ="java.io.*"
import="java.text.*"
buffer="20kb"
%>
<%
Connection conn=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:student","","");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select *"+"from student");
%>
<table border="1">
<tr>
<th>学号</th>
<th>姓名</th>
<th>性别</th>
<th>年龄</th>
</tr>
<%
while(rs.next())
{
out.println("<tr>\n<td>"+rs.getString("no")+"</td>");
out.println("<td>"+rs.getString("name")+"</td>");
out.println("<td>"+rs.getString("sex")+"</td>");
out.println("<td>"+rs.getString("age")+"</td>\n</tr>");
}
//out.print("</table>");
rs.close();
}
catch(IOException ioe){
out.println(ioe.getMessage());
}
catch(SQLException sqle){
out.println(sqle.getMessage());
}
catch(ClassNotFoundException cnfe){
out.println(cnfe.getMessage());
}
catch(Exception e){
out.println(e.getMessage());
}
finally{
try{
if(conn!=null)
{
conn.close();
}
}
catch(SQLException sqle)
{
out.println(sqle.getMessage());
}
}
%>
</table>
</body>
</html>
page指令 应该是<%@ page import=" " contentType=" " %>
import="java.sql.*"
import ="java.util.*"
import ="java.io.*"
import="java.text.*"
buffer="20kb"改成
<%@ page language="java" import="java.sql.*, java.util.*, java.io.*, java.text.*" buffer="20kb" %>
========================
/student2.jsp(5,0) Unterminated <%@ page tag错误提示写的多明白阿,没有结束的<%@ page 标签