今天远程配个tomcat5,jdk、tomcat5装好后,我拼凑个简单测试页面如下:
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*,oracle.jdbc.*"%>
<HTML>
<HEAD>
<TITLE></TITLE>
</HEAD>
<BODY>
OracleDriver
<P>
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.168.0.187:1521:orcl";
String user="scott";
String pwd="tiger";
Connection conn=DriverManager.getConnection(url,user,pwd);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from emp";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<%=getString(2)%><br>
<%
}
%>
<%
rs.close();
stmt.close();
conn.close();
%>
</BODY>
</HTML> 结果一运行报错:
description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 19 in the jsp file: /bbsindex.jspStacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:93)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:435)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:298)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:265)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)我java方面实在才疏学浅,看不出哪里问题,请哪位指导下
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*,oracle.jdbc.*"%>
<HTML>
<HEAD>
<TITLE></TITLE>
</HEAD>
<BODY>
OracleDriver
<P>
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.168.0.187:1521:orcl";
String user="scott";
String pwd="tiger";
Connection conn=DriverManager.getConnection(url,user,pwd);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from emp";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<%=getString(2)%><br>
<%
}
%>
<%
rs.close();
stmt.close();
conn.close();
%>
</BODY>
</HTML> 结果一运行报错:
description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 19 in the jsp file: /bbsindex.jspStacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:93)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:435)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:298)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:265)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)我java方面实在才疏学浅,看不出哪里问题,请哪位指导下
%=rs.getString(2)%> <br>
这样写不对啊,应该是rs.getString(2)吧
该换了!