begin
SELECT COUNT(*) INTO v_totalCount FROM news_detail;
end getNewsCount;
//获取新闻总数(执行存储过程)
public int getTotalCountProc(){
int totalCount=0;
CallableStatement proc=null;
String sql="{call getNewsCount(?)}";
getConnection();
try {
proc=conn.prepareCall(sql);
proc.registerOutParameter(1, Types.INTEGER);
proc.execute();
totalCount=proc.getInt(1);
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(proc!=null)
try {
proc.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return totalCount;
}