关于恢复数据库SQL2000出现的问题！！高手帮忙解决下 谢谢

[java5love]

我用的是JSP+JAVABEAN实现恢复这个功能，但有时候能够恢复 有时候却提示错误：][SQL Server]未能找到存储过程 'kill51'

高手帮忙解决下 谢谢

JAVABEAN里代码为：
public void cut(String datebasename)throws Exception
{
Connection con=DriverManager.getConnection("jdbc:odbc:sun1","sa","");
Statement stmt=con.createStatement();
ResultSet rs=null;
rs=stmt.executeQuery("select spid from sysprocesses where dbid=db_id('"+datebasename+"')");
while(rs.next())
{
stmt.execute("kill" + rs.getInt("spid"));
}
}
public void rdata(String datebasename,String bakfile)throws Exception
{
Connection con=DriverManager.getConnection("jdbc:odbc:sun1","sa","");
Statement stmt=con.createStatement();
stmt.executeUpdate("restore database "+datebasename+" from disk='"+bakfile+"'");
}

[java5love]

高手指教下啊 谢!

[CrazyGou]

stmt.execute("kill" + rs.getInt("spid"));
====
stmt.execute("kill " + rs.getInt("spid"));

[java5love]

????什么意思

[szsymz]

stmt.execute("kill" + rs.getInt("spid"));
====
stmt.execute("kill " + rs.getInt("spid"));

-------------------------
kill 后的空格

[java5love]

又报这样的错误了:javax.servlet.ServletException: ResultSet is closed

[java5love]

顶下 望大家指导 谢谢

[java5love]

当然有啊。。上面只是一部分代码。。

[java5love]

自己顶。

[java5love]

顶啊 大侠们教下我

[BlackSwallow]

你的javabean里少了这样一句话:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

[java5love]

顶起来

[knight_qmh]

Statement stmt=con.createStatement();
Statement stmt2=con.createStatement();
ResultSet rs=null;
rs=stmt.executeQuery("select spid from sysprocesses where dbid=db_id('"+datebasename+"')");
while(rs.next())
{
stmt2.execute("kill" + rs.getInt("spid"));
}