我用JSP连接ORacle出错了，请各位大侠们指点一下。。。

[candy_hn]

Apache Tomcat/4.0.4 - HTTP Status 500 - Internal Server Error

--------------------------------------------------------------------------------

type Exception report

message Internal Server Error

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

exception

org.apache.jasper.compiler.ParseException: /test1.jsp(5,15) Attribute value should be quoted
at org.apache.jasper.compiler.JspReader.parseToken(JspReader.java:522)
at org.apache.jasper.compiler.JspReader.parseAttributeValue(JspReader.java:568)
at org.apache.jasper.compiler.JspReader.parseTagAttributes(JspReader.java:681)
at org.apache.jasper.compiler.Parser$Directive.accept(Parser.java:224)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1145)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1103)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1099)
at org.apache.jasper.compiler.ParserController.parse(ParserController.java:214)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:210)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:548)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:176)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:188)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
at java.lang.Thread.run(Thread.java:484)

[whyxx]

来晚了

[candy_hn]

import java.sql.*
有这个的。

[javahui]

test1.jsp没有通过编译，某一个属性值需要用引号引起来。

[candy_hn]

程序如下：

<%@page info="database handler"%>
<%@page contentType="text/html;charset=gb2312"%>
<%@page language="Java" import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page import="java.sql.*"%>
<%@page import=%>
<%@page import="javax.servlet.*"%>
<%@page import="javax.servlet.http.*"%>
<html>
<body>
<%
try
{
Connection con;
Statement stmt;
ResultSet rs;
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@172.16.10.21:1521:ZX_TEST";
con=DriverManager.getConnection(url,"qms","qms");
out.println("dfd");
stmt=con.createStatement();
rs=stmt.executQuery("SELECT xm,xb from ZX_TEST");
out.println("<table border=1 width=400>");
while(rs.next())
{
String col1=rs.getString(1);
String col2=rs.getString(2);
out.println("<tr><td>"+col1+"</td><td>"+col2+"</td></tr>");

}
out.println("</table>");
}
catch(Exception e){
out.println(e);
}
%>
</body>
</html>

[candy_hn]

麻烦帮忙看看，谢谢

[wellsoon]

<%@page import=%>

这行代码是错的。

把它删除。

[candy_hn]

我删掉了。出现了这个错误
Generated servlet error:
E:\Program Files\Apache Tomcat 4.0\work\Standalone\localhost\star\test1$jsp.java:103: Method executQuery(java.lang.String) not found in interface java.sql.Statement.
rs=stmt.executQuery("SELECT xm,xb from ZX_TEST");
^
1 error

[candy_hn]

rs=stmt.executeQuery("SELECT xm,xb from ZX_TEST");
是我拼写错误，改正后，还是有错误，能帮忙看看吗？谢谢。

错误信息：

java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999040)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

[网络咖啡]

executQuery应该为executeQuery

[candy_hn]

我已经搞定了。是String url="jdbc:oracle:thin:@172.16.10.21:1521:orcl"写错了
感谢各位的热心帮助。。。

[你敢扫一扫吗]

你缺少一个包，在HEAD里面import javax.sql.*；