简单的JSP出错

zt0213 2015-08-28 01:55:34
<%@ 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)
...全文
86 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
枫醉秋 2015-08-28
  • 打赏
  • 举报
回复
猜测肯定是缺少oracle的驱动包
枫醉秋 2015-08-28
  • 打赏
  • 举报
回复
把错误信息贴全
  • 打赏
  • 举报
回复
看下你的jsp的14行
ITjavaman 2015-08-28
  • 打赏
  • 举报
回复
改一下编码UTF-8

58,452

社区成员

发帖
与我相关
我的任务
社区描述
Java Eclipse
社区管理员
  • Eclipse
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧