我是jsp的初学者,我做一段与sql server通过odbc连接的实例,出错了,谁能帮我看看
源文件
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Connection con;
Statement sql;
resultset rs;
try{
Class.forname("sun.jdbc.odbc.JdbcodbcDriver");}
catch(ClassnotFoundException e){}
try{
con=DriverManager.getConnection("jdbc:odbc:sun","sa","zhx");
sql=con.createStatement();
rs=sql.executeQuery("select * from titles");out.print("<table width=100% border=0 cellspacing=0 cellpadding=0>");
out.print("<tr>");
out.print("<td>"+ 序号 +"</td>");
out.print("<td>"+ 测试 +"</td>");
out.print("<td>"+ 测试 +"</td>");
out.print("<td>"+ 测试+"</td>");
out.print("<td>"+ 测试+"</td>");
out.print("</tr>");
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+rs.getstring(2)+"</td>");
out.print("<td>"+rs.getstring(3)+"</td>");
out.print("<td>"+rs.getint("royalty")+"</td>");
out.print("<td>"+rs.getint("ytd_sales")+"</td>");
out.print("<td>"+ 12+"</td>");
out.print("</tr>");
}
out.print("</table>");
con.close;
}
catch(SQLException e1){}
%>
</body>
</html>
错误提示
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to load class for JSP
org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:591)
org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:137)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:305)
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.ClassNotFoundException: org.apache.jsp.a_jsp
java.net.URLClassLoader$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.net.URLClassLoader.findClass(Unknown Source)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:158)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:71)
org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:589)
org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:137)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:305)
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.
--------------------------------------------------------------------------------Apache Tomcat/5.5.9
源文件
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Connection con;
Statement sql;
resultset rs;
try{
Class.forname("sun.jdbc.odbc.JdbcodbcDriver");}
catch(ClassnotFoundException e){}
try{
con=DriverManager.getConnection("jdbc:odbc:sun","sa","zhx");
sql=con.createStatement();
rs=sql.executeQuery("select * from titles");out.print("<table width=100% border=0 cellspacing=0 cellpadding=0>");
out.print("<tr>");
out.print("<td>"+ 序号 +"</td>");
out.print("<td>"+ 测试 +"</td>");
out.print("<td>"+ 测试 +"</td>");
out.print("<td>"+ 测试+"</td>");
out.print("<td>"+ 测试+"</td>");
out.print("</tr>");
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+rs.getstring(2)+"</td>");
out.print("<td>"+rs.getstring(3)+"</td>");
out.print("<td>"+rs.getint("royalty")+"</td>");
out.print("<td>"+rs.getint("ytd_sales")+"</td>");
out.print("<td>"+ 12+"</td>");
out.print("</tr>");
}
out.print("</table>");
con.close;
}
catch(SQLException e1){}
%>
</body>
</html>
错误提示
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to load class for JSP
org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:591)
org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:137)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:305)
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.ClassNotFoundException: org.apache.jsp.a_jsp
java.net.URLClassLoader$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.net.URLClassLoader.findClass(Unknown Source)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:158)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:71)
org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:589)
org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:137)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:305)
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.
--------------------------------------------------------------------------------Apache Tomcat/5.5.9
<%@ page contentType="text/html;charset=gb2312"%>
<html>
<body bgcolor=cyan>
<font size=1>
<p>这是一个简单的jsp页面
<%int i,sum=0;
for(i=1;i<=100;i++)
{sum=sum+i;
}%>
<p>
1到100的连续和是:<br>
<%=sum%>
</font>
<body>
</html>
Generated servlet error:
Syntax error, insert "AssignmentOperator ArrayInitializer" to complete Expression
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:397)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:288)
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.
--------------------------------------------------------------------------------Apache Tomcat/5.5.9
你的JSP页面代码中像resultset应改为"ResultSet", forname应该为"forName",...如果你刚开始学Java, 建议随时查阅jdk的帮助, 对没有把握的调用查对核实后再写代码.
也不要借助IDE的代码提示功能, 那样对你入门没好处, 因为不少API还是要靠大脑记住的, 特殊应用场合的API等用到的时候再去查.