我运行下面这一段程序时出错
<%@page contentType="text/html;charset=gb2312"language="java"%>
<%@page import="java.sql.*"errorPage="" %>
<jsp:useBean id="gettime" scope="page" class="beans.gettime"/>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:eccl";
String user="SYSTEM";
String password="manager";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String IP=(request.getRemoteAddr()).toString();
String Date=gettime.gettime();
String sql="Insert into tb_counter(IP,COUNTER,DATETIME) values('"+IP+"','1','"+Date+"')";
ResultSet rs=stmt.executeUpdate(sql);
rs.close();
stmt.close();
conn.close();
response.sendRedirect("ics.html");
%>
错误是:
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 4 in the jsp file: /ics_deal.jsp
Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\counter\org\apache\jsp\ics_005fdeal_jsp.java:65: incompatible types
found : int
required: java.sql.ResultSet
ResultSet rs=stmt.executeUpdate(sql);
^
1 error
IP,DATETIME在数据库里都是VAR2的请问要如何修改?谢谢!
<%@page contentType="text/html;charset=gb2312"language="java"%>
<%@page import="java.sql.*"errorPage="" %>
<jsp:useBean id="gettime" scope="page" class="beans.gettime"/>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:eccl";
String user="SYSTEM";
String password="manager";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String IP=(request.getRemoteAddr()).toString();
String Date=gettime.gettime();
String sql="Insert into tb_counter(IP,COUNTER,DATETIME) values('"+IP+"','1','"+Date+"')";
ResultSet rs=stmt.executeUpdate(sql);
rs.close();
stmt.close();
conn.close();
response.sendRedirect("ics.html");
%>
错误是:
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 4 in the jsp file: /ics_deal.jsp
Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\counter\org\apache\jsp\ics_005fdeal_jsp.java:65: incompatible types
found : int
required: java.sql.ResultSet
ResultSet rs=stmt.executeUpdate(sql);
^
1 error
IP,DATETIME在数据库里都是VAR2的请问要如何修改?谢谢!
RS是针对select出来的结果集
stmt.executeUpdate(sql);
stmt.close();
conn.close();
int i = stmt.executeUpdate(sql);
再通过i来判断数据库有没有执行这个操作,
if(i>0)
{
out.println("成功!");
}
else
{
out.println("失败!");
}
至于原因楼主已经说明了.