下面是我写的一个方法
public int selectCount(int pageSize){
int pageNumber=0;
try{
int number=0;
String sql="select count(*) from orderInfo";
ps=con.prepareStatement(sql);//调试时这出错,
//错误报告:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
rs=ps.executeQuery();
if(rs.next()){
number=rs.getInt(1);
}
if(number%pageSize==0){
pageNumber=number/pageSize;
}else{
pageNumber=number/pageSize+1;
}
}catch(Exception e){
e.printStackTrace();
}finally{
ConnectionManager.closeResultSet(rs);
ConnectionManager.closeStatement(ps);
ConnectionManager.closeConnection(con);
}
return pageNumber;
}
我已经加了驱动,跟这个方法同一类的其他方法又没问题。帮忙看一下,谢谢!
public int selectCount(int pageSize){
int pageNumber=0;
try{
int number=0;
String sql="select count(*) from orderInfo";
ps=con.prepareStatement(sql);//调试时这出错,
//错误报告:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
rs=ps.executeQuery();
if(rs.next()){
number=rs.getInt(1);
}
if(number%pageSize==0){
pageNumber=number/pageSize;
}else{
pageNumber=number/pageSize+1;
}
}catch(Exception e){
e.printStackTrace();
}finally{
ConnectionManager.closeResultSet(rs);
ConnectionManager.closeStatement(ps);
ConnectionManager.closeConnection(con);
}
return pageNumber;
}
我已经加了驱动,跟这个方法同一类的其他方法又没问题。帮忙看一下,谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货