fbplrs.java

这个程序是花了好几十万请人开发的

package javabean;

import java.util.Vector;
import java.sql.*;

public class FbplRs 
{

	private Statement stmt=null;
	private ResultSet rs=null;
	private Connection con=null;
		
	private ConnectionPool pool;
	
	public FbplRs(){
		pool=ConnectionPool.getInstance();               //初始化连接池
	}
			
	public Vector getTitleId(String sql,int numPages,int currentPage) throws SQLException
	{
	  
	  int count=numPages;
	    
	  Vector vec=new Vector();
	  try 
	  {	    
	  
	  con=pool.getConnection();
	  stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
	  rs=stmt.executeQuery(sql);
	  rs.absolute(numPages*(currentPage-1)+1);
	  
	  while(count>0)
	  {
		  Commance show=new Commance();	  
		  show.setUid(rs.getString("UUID"));
		  show.setDate(rs.getString("PUBDATE"));
		  show.setContent(rs.getString("CONTENT"));
		  show.setKind(rs.getString("KIND"));
		  vec.add(show);
		  if(!rs.next()) break;	
		  count--;
	   }
	   rs.close();
	  }  
	  catch (SQLException e) { return null;}	
	  
	  con.close();
	  return vec;	  
	}
}