Type mismatch: cannot convert from int to ResultSet?急!!!,谢谢
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ include file="conn1.jsp"%>
<%
String keyword=request.getParameter("keyword");
String sql="select * from tab where ID="+keyword;
ResultSet rs=st.executeUpdate(sql);
out.println("数据库操作成功,查询结果如下:");
out.println("<table width=50% border=3> ");
out.println("<tr><td>"+"ID"+"</td><td>"+"name"+"</td><td>"+"auther"+"</td><td>"+"publisher"+"</td><td>"+"time"+"</td></tr>");
while(rs.next()) {
String col1 =rs.getString(1);
String col2 =rs.getString(2);
String col3 =rs.getString(3);
String col4 =rs.getString(4);
String col5 =rs.getString(5);
out.println("<tr><td>"+col1+"</td><td>"+col2+"</td><td>"+col3+"</td><td>"+col4+"</td><td>"+col5+"</td></tr>");
}
out.println("</table>");
{%> <%}
%>
<%
rs.close();
st.close();
con.close();
%>
<html>
<form name="form" method="post" action="query.jsp">
<input type="submit" name="summit" value="返回" >
</html>
出错现象:
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 4 in the jsp file: /result.jsp
Generated servlet error:
Type mismatch: cannot convert from int to ResultSet
不知道为什么?