我试图使用Java中的预处理语句来终止一个MS SQL Server(8)进程。但是我一直收到异常:com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: Incorrect syntax near '@P0'。
有什么想法吗?
public void killBlockingProcess(int spid) {
PreparedStatement ps = null;
try {
ps = connection.prepareStatement("kill ?");
ps.setInt(1, spid);
boolean res=ps.execute();
}
catch (Exception ex) {
logger.error(this + ",killBlockingProcess: " + ex.getMessage());
}
finally
{
try {ps.close(); } catch (Exception exp){}
}
}