<%@page import=java.sql.*%> 改成 <%@page import="java.sql.*"%>PrintWriter out=response.getWriter; 改成 PrintWriter out=response.getWriter();ResultSet rst=sta.execute("select * from ss;"); 改成 ResultSet rst=sta.execute("select * from ss");
解决方案 »
- oracle空格有哪些些代码，如：chr(13)换行，chr(10)回车
- SQL语句本身含有单引号的语句拼接问题
- ORA-04031:无法分配4096字节的共享内存("shared pool
- 现在做的一个项目需要通过SQL*Loader进行程序导入问题,分数不够可以再加！或者当面酬谢也行！
- 关于oracle DB LINKS的问题（高手帮看一下）
- 如何获得服务器的时间？
- developer的问题?
- 如何修改ORACLE9i数据库的字符集？
- 请问我下面的存储过程为什么不对？？？？
- zhaoyongzhu进来领分4
- ROWID这样使用为何不起作用？帮忙看看，进来有分
- ASP通过ADO远程连接ORACLE如何读取CLOB内容
程序如下：<%@page import="java.sql.*"%>
<%@page import="javax.servlet.*"%>
<%@page import="javax.servlet.http.*"%>
<%@page import="java.util.*"%>
<html>
<head><title>jsp</title></head>
<body>
<center>hahaha</center><hr>
<%!
String url="jdbc:oracle:thin:@localhost:1521:she";
String user="system";
String pwd="sheweijiang";
PrintWriter out=response.getWriter();
%>
<%
Class.forName("oracle.jdbc.OracleDriver").Instance();
Connection con=DriverManager.getConnection(url,user,pwd);
Stament sta=con.creatStament();
sta.setAutoCommit(ture);
ResultSet rst=sta.execute("select * from ss");
while(rst.next()){
out.println(rst.getInt("id"));
}
%>
</body>
</html>报错如下：
exception org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.
An error occurred between lines: 11 and 16 in the jsp file: /123.jspGenerated servlet error:
D:\Program Files\Apache Tomcat 4.0\work\Standalone\localhost\_\$123$jsp.java:20: Class org.apache.jsp.PrintWriter not found.
PrintWriter out=response.getWriter();
^
An error occurred between lines: 11 and 16 in the jsp file: /123.jspGenerated servlet error:
D:\Program Files\Apache Tomcat 4.0\work\Standalone\localhost\_\$123$jsp.java:20: Undefined variable or class name: response
PrintWriter out=response.getWriter();
^
An error occurred between lines: 17 and 26 in the jsp file: /123.jspGenerated servlet error:
D:\Program Files\Apache Tomcat 4.0\work\Standalone\localhost\_\$123$jsp.java:86: Method Instance() not found in class java.lang.Class.
Class.forName("oracle.jdbc.OracleDriver").Instance();
^
An error occurred between lines: 17 and 26 in the jsp file: /123.jspGenerated servlet error:
D:\Program Files\Apache Tomcat 4.0\work\Standalone\localhost\_\$123$jsp.java:88: Class org.apache.jsp.Stament not found.
Stament sta=con.creatStament();
^
An error occurred between lines: 17 and 26 in the jsp file: /123.jspGenerated servlet error:
D:\Program Files\Apache Tomcat 4.0\work\Standalone\localhost\_\$123$jsp.java:88: Method creatStament() not found in interface java.sql.Connection.
Stament sta=con.creatStament();
^
5 errors, 1 warning at org.apache.jasper.compiler.Compiler.compile(Compiler.java:285)
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.valves.CertificatesValve.invoke(CertificatesValve.java:246)
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:595)