jsp里更新数据库问题,急~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
jsp里更新数据库
原代码以下:
<%
String pw1=request.getParameter("pw1");
String pw2=request.getParameter("pw2");
String adname= (String) session.getValue("adname");
//String pwsql="select * from admin where admin_name='"+adname+"'";
String pwsql="update admin set admin_password ='" + pw1 +"' where admin_name='" +adname+"'";
ResultSet rspwc=stmt.executeUpdate(pwsql);
rspwc.next();
%>
编译后错误提示:
Generated servlet error:
[javac] Compiling 1 source file
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\footballweb\ad_pwc_jsp.java:105: incompatible types
found : int
required: java.sql.ResultSet
ResultSet rspwc=stmt.executeUpdate(pwsql);
究竟什么问题呢?我记得每次做修改数据库都遇到这问题,更新是不是用stmt.executeUpdate这句吗?数据库用sql2000,tomcat用4.1