教教小弟吧``刚刚接触Jsp

[CrazyAzreal]

想实现对数据修改.添加.但不知为什么为出错源代码为
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.lang.*"%>
<%@ page import="java.sql.*"%>
<%
Connection conn=null;
Statement sql=null;
ResultSet rs=null;

try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();

//out.print("success1");
}
catch (ClassNotFoundException e)
{}
try
{
String url="jdbc:mysql://localhost:3306/aaa";
conn=DriverManager.getConnection(url,"root","123456");


sql=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//修改
rs=sql.executeUpdate("UPDATE myt SET name='jaw' where sex='2'");

conn.close();
}
catch (SQLException e){}
%>
表名為myt.有三個字段.就这样修改一条记录不行吗？?为什么还会出以下错误:


type Exception report

message

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

exception

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 4 in the jsp file: /ccc.jsp
Generated servlet error:
Type mismatch: cannot convert from int to ResultSet


org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:389)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:288)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:267)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:255)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:556)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:296)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

请教教..

[infowain]

sql.executeUpdate("UPDATE myt SET name='jaw' where sex='2'");
前面不要写rs =

[infowain]

http://www.tot.name/show/3/7/20050314150037.htm

[redsun1209]

sql.executeUpdate("UPDATE myt SET name='jaw' where sex='2'")返回的是一个整型，表示这个修改影响了几行。
可以用：
int column_count = sql.executeUpdate("UPDATE myt SET name='jaw' where sex='2'");

[dyhjjk]

executeUpdate语句执行返回的结果是整型的。ResultSet多用于查询语句
偶也是刚学 你调下应该没有问题！

[universe01]

问题解决了.
凑热闹!

[CrazyAzreal]

or..thanks..结贴