为什么会出现这样的错误?
org.apache.jasper.JasperException: Unable to compile class for JSP
No Java compiler was found to compile the generated source for the JSP.
This can usually be solved by copying manually $JAVA_HOME/lib/tools.jar from the JDK
to the common/lib directory of the Tomcat server, followed by a Tomcat restart.
If using an alternate Java compiler, please check its installation and access path
代码如下:
<%@ page contentType="text/html;charset=8859_1"%>
<%
java.sql.Connection sqlCon;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
java.lang.String strCon;
java.lang.String strSQL;
int intPageSize;
int intRowCount;
int intPageCount;
int intPage;
java.lang.String strPage;
int i;
intPageSize=2;
strPage=request.getParameter("page");
if(strPage==null)
{
intPage=1;
}
else{
intPage=java.lang.Integer.parseInt(strPage);
if(intPage<1)intPage=1;
}
java.sql.DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
strCon="jdbc:odbc:gg";
String user="sa";
String password="";
sqlCon=java.sql.DriverManager.getConnection(strCon,user,password);
sqlStmt=
sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
strSQL="select * from TABLE2";
sqlRst=sqlStmt.executeQuery(strSQL);
sqlRst.last();
intRowCount=sqlRst.getRow();
intPageCount=(intRowCount+intPageSize-1)/intPageSize;
if(intPage>intPageCount)intPage=intPageCount;
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<title>JSP数据库操作例程-数据分页显示-JDBC 2.0-Oracle</title>
</head>
<body>
<table border="1" cellspacing="0" cellpadding="0">
<tr>
<th>forumID</th>
<th>Name</th>
<th>Description</th>
</tr>
<%
if(intPageCount>0){
sqlRst.absolute((intPage-1)*intPageSize+1);
i=0;
while(i<intPageSize&&!sqlRst.isAfterLast()){
%>
<tr>
<td><%=sqlRst.getString(1)%></td>
<td><%=sqlRst.getString(2)%></td>
<td><%=sqlRst.getString(3)%></td>
</tr>
<%
sqlRst.next();
i++;
}
}
%>
</table>
第<%=intPage%>页 共<%=intPageCount%>页 <%if(intPage<intPageCount){%><a
href="page.jsp?page=<%=intPage+1%>">下一页</a><%}%> <%if(intPage>i){%><a
href="page.jsp?page=<%=intPage-1%>">上一页</a>%>
</body>
</html>
<%
sqlRst.close();
sqlStmt.close();
sqlCon.close();
%>
Tomcat与SQLSERVER的连接是没有问题的(用其它代码测试连接成功)。