该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
import java.sql.*;
import myForum.connectiontools.*;
public class TryClass{
private Connection con;
private PreparedStatement ps;
private CallableStatement cs;
private ResultSet rs;
private String sql;
private ConnectionTool conn=new ConnectionTool();
public synchronized boolean delSort(int id){
try{
con = conn.getConnection();
con.setAutoCommit(false);
String sql="delete from forumRes where topicid in( select topicid from forumTopic where topicsort="+id+")";
ps = con.prepareStatement(sql);
int i=ps.executeUpdate();
System.out.println (1);
//String sql1 = ;
System.out.println (2);
System.out.println (3);
int j = ps.executeUpdate("delete from forumTopic where topicsort="+id);
//ps.execute("delete from forumTopic where topicsort="+id);
System.out.println (4);
//sql = "delete from forumSort where sortid="+id;
//int k = ps.executeUpdate(sql);
if(i>=0){
con.commit();
System.out.println ("successful");
return true;
}
else{
con.rollback();
return false;
}
}catch(Exception e){
con.rollback();
System.out.println ("delSort().."+e);
return false;
}
finally{
try{
con.setAutoCommit(true);
if(ps!=null){
ps.close();
}
if(con!=null){
con.close();
}
}catch(Exception ex){
System.out.println ("delSort()...finally.."+ex);
}
}
}
public static void main(String args[]){
new TryClass().delSort(5);
}
}
这段代码会有这个异常,请大虾指教谢谢
delSort()..java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid call Statement method: {0}