//ResultSet rs=db.executeQuery(sql);插入不应该返回resultset
解决方案 »
- js如何获得struts2迭代标签的值
- jsp报String literal is not properly closed by a double-quote
- 毕业设计,求救
- 困惑,ip和域名到底怎样的对应关系?望高手指点!!!!!
- Tomcat+struts为什么不能上传2G以上的文件?
- JSP页面将string转换为int型然后求积
- 试用期,帮忙: 在线考试 如何使每道题的ABCD选项为一组radio,我做的是所有B顶为一组,所有A项为一组.急
- 数据库中的集合函数(max,min等)是不是不能操作中间结果
- 日期类型转化问题?(在线等)
- 求助:接收网络信息问题
- 哪里有tomcat5.0.19下载,找的好苦呀
- 用花生壳如何建立自己的网站?
public int executeUpdate(String sql)
throws SQLException
Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement. Parameters:
sql - an SQL INSERT, UPDATE or DELETE statement or an SQL statement that returns nothing
Returns:
either the row count for INSERT, UPDATE or DELETE statements, or 0 for SQL statements that return nothing
Throws:
SQLException - if a database access error occurs or the given SQL statement produces a ResultSet object
rs = null;
int num=0;
try {
conn = DriverManager.getConnection(sConnStr, "Julianne", "237726");
Statement stmt = conn.createStatement();
num = stmt.executUpdate(sql);
}
catch (SQLException ex) {
System.err.println("sqlException" + ex.getMessage());
}
return num;
}
拼写错误 ↑ 'e' expeced执行非SELECT语句时是不返回ResultSet的。如果操作所影响的行数不是必要数据,就没必要取出来再付给某个变量了。