论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2007-05-24 11:02 |只看该作者 |倒序浏览

开发环境：tomcat5.0.20+oracle10g+JDK1.5.08
用网上常用的JDBC连接ORACLE的例子进行测试连接,代码如下:
<%@ page c%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("oracle.jdbc.driver.OracleDriver"

.newInstance();
String url="jdbc

racle:thin

192.168.102.26:1521

rcl";
String user="pfms";
String password="oracle10g";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from scott.dept";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
<%=rs.getString(1)%> - <%=rs.getString(2)%> <br>
<%}%>
<%out.print("数据库操作成功，恭喜你"

;%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
错误提示如下：
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: /webRoot/index.jsp(1,11) equal symbol expected
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

org.apache.jasper.JasperException: /webRoot/index.jsp(1,11) equal symbol expected
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:39)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:405)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:86)
org.apache.jasper.compiler.Parser.parseAttribute(Parser.java:193)
org.apache.jasper.compiler.Parser.parseAttributes(Parser.java:143)
org.apache.jasper.compiler.Parser.parseAttributes(Parser.java:156)
org.apache.jasper.compiler.ParserController.getPageEncodingForJspSyntax(ParserController.java:434)
org.apache.jasper.compiler.ParserController.determineSyntaxAndEncoding(ParserController.java:377)
org.apache.jasper.compiler.ParserController.doParse(ParserController.java:169)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:100)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:155)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:295)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:276)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:264)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:563)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:305)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

[ 本帖最后由 james_yan 于 2007-5-24 11:04 编辑 ]

文库|博客

fswyb

白手起家

论坛徽章:: 0

2楼 [报告]

发表于 2007-10-23 15:10 |只看该作者

<%@ page c%> 这个有问题。应该是
<%@ page contentType="text/html;charset=gb2312"%>

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

返回列表

Chinaunix › 论坛 › 数据库技术 › Oracle › [求助]jsp连接oracle出错了

[求助]jsp连接oracle出错了 [复制链接]