简单的JSP出错
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1" import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>测试查询</title>
</head>
<body>
<h2>Oracle查询测试</h2>
<table>
<tr><td>工号</td><td>姓名</td><td>在职状态</td></tr>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@192.168.17.10:1521:windb", "**", "***");
Statement statement = connection.createStatement();
String sql = "select A0190,A0101,A0191 from A01 where deptpath like '%IT%' ";
ResultSet rs = statement.executeQuery(sql);
while(rs.next()){
out.println("<tr>");
out.println("<td>" + rs.getString(0) +"</td>");
out.println("<td>"+ rs.getString(1) + "</td>");
out.println("<td>"+ rs.getString(2) + "</td>");
out.println("</tr>");
rs.close();
statement.close();
connection.close();
}
%>
</table>
</body>
</html>
----------------
上面是照葫芦画瓢写的简单的jsp,但是会报错。
------------------
HTTP Status 500 - An exception occurred processing JSP page /Test.jsp at line 14
type Exception report
message An exception occurred processing JSP page /Test.jsp at line 14
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /Test.jsp at line 14
11: <table>
12:
13: <%
14: Class.forName("oracle.jdbc.driver.OracleDriver");
15: Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@192.168.17.10:1521:windb", "lshr", "lshr2014");
16: Statement statement = connection.createStatement();
17: String sql = "select A0190,A0101,A0191 from A01 where deptpath like '%IT%' ";
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:575)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:462)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)