java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.
qbstk 2009-03-18 09:36:50 错误如下:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.
出错代码如下
public static void delCategory(int id) {
Connection conn = null ;
ResultSet rs = null ;
String sql = null ;
try {
conn = DB.getConn() ;
//删除id = id的节点
sql = "delete from category where id = " + id ;
DB.executeQuery(conn, sql) ;
//删除pid=id的节点和其下所有子节点
//返回该id下的所有子节点
rs = DB.executeQuery(conn, "select * from category where pid = " + id ) ;
while(rs.next()){
//对每个子节点进行递归
int pid = rs.getInt("id") ;
delCategory(pid) ;
}
} catch (SQLException e) {
e.printStackTrace();
} finally{
DB.closeRs(rs) ;
DB.closeConn(conn) ;
}
}
数据库中会更新,因为要用到resultSet,所以只能用executeQuery不能用executeupdate
请高手帮忙啊!